| 摘要 |
Some "summary" information in a spreadsheet of a cell named range is preserved when some spreadsheet elements (like rows, or columns, or pages) are added or removed from the cell named range. A plurality of cells are identified by a cell address. A range summary cell is defined by specifying in a table a range summary cell address; a cell range address identifying an associated cell range; the range summary cell address is a function of the specified cell range address. In response to a user request for adding or deleting a spreadsheet element sharing a common cell address along at least one dimension with the cell range associated with the range summary cell updating in the table, the cell range address of the cell range associated with the range summary cell according to the user request; updating in the table, the range summary cell address according to the updated cell range address; moving in the spreadsheet, the range summary cell according to the updated range summary cell address; adding or deleting the spreadsheet element according to the user request; updating in the table, the cell range address after the addition or the deletion of the spreadsheet element; and updating in the table, the range summary cell address according to the updated cell range address.
|
