摘要 |
<p><P>PROBLEM TO BE SOLVED: To determine a row or a column of an index and a sample of spreadsheet data of an insertion destination even when a user does not explicitly specify it, and to validate cell reference present within the spreadsheet data of the insertion destination even after insertion. <P>SOLUTION: An index/sample row (column) determination part 12 determines a row with the maximum number of cells whose cell contents coincide with an index row of an insertion origin among the respective rows of the insertion destination as the index row, and determines the row right below it as a sample row. By inserting some copy rows for which the sample row is copied, the rows having the same data structure as the sample row are arranged as many as data rows of the insertion origin below the index row of the insertion destination. Then, the data rows of the insertion origin are inserted to the sample row and the respective rows copied below it. Insertion is performed between coincident indexes with each other. Also, when there is a computation expression including reference to the row below the sample row in the insertion origin, a reference destination of the reference is shifted down for the number of the inserted copy rows. <P>COPYRIGHT: (C)2013,JPO&INPIT</p> |