Patent ID: 6757867
Filing Date: 2004-06-29
Classification: G06F,Y10S

Abstract:
A method of processing a range summary cell in a multi-dimensional spreadsheet comprising a plurality of cells identified by a cell address along each dimension, said method comprising the steps of:defining one or a plurality of range summary cells by specifying in a table for each range summary cell: a range summary cell address; a cell range address identifying an associated cell range, wherein said range summary cell address comprises 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 one or a plurality of cell ranges associated in the table with the one or a plurality of range summary cells while preserving the one or plurality of range summary cells previously defined: for each cell range sharing a common cell address with said spreadsheet element along at least one common dimension, updating in the table the cell range address of the cell range associated with the range summary cell according to the user request; and for each range summary cell associated with said cell range: 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 maintaining a pre-determined positional relationship between the range summary cell and the associated cell range; adding or deleting the spreadsheet element according to the user request; for each said cell range sharing in the request a common cell address with said spreadsheet element along at least one common dimension, updating in the table, the cell range address after the addition or the deletion of the spreadsheet element; and for each range summary cell associated with said cell range: updating in the table, the range summary cell address according to the updated cell range address.