G - Physics – 06 – F
Patent
G - Physics
06
F
G06F 17/30 (2006.01) G06F 17/24 (2006.01)
Patent
CA 2311866
The present invention relates to the field of information processing by digital computers, and more particularly to a method and system, in an electronic spreadsheet, for preserving some "summary" information of a cell named range when some spreadsheet elements (like rows, or columns, or pages) are added or removed from said cell named range. The method of processing a range summary cell in a multi dimensional spreadsheet comprising a plurality of cells identified by a cell address, comprises the steps of: ~ defining (509) a range summary cell (410) by specifying in a table (400): ~ a range summary cell address (411, 412, 413); ~ a cell range address (414) identifying an associated cell range; said range summary cell address (411, 412, 413) being function of the specified cell range address (414); In response to an user request (602) 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 (604) in the table (400), the cell range address (414) of the cell range associated with the range summary cell according to the user request; ~ updating (605) in the table, the range summary cell address (411, 412, 413) according to the updated cell range address (414); ~ moving (611) in the spreadsheet, the range summary cell according to the updated range summary cell address (411, 412, 413); ~ adding or deleting the spreadsheet element according to the user request; ~ updating in the table (400), the cell range address (414) after the addition or the deletion of the spreadsheet element; ~ updating in the table, the range summary cell address (411, 412, 413) according to the updated cell range address (414).
Bauchot Frederic
Harari Albert
International Business Machines Corporation
Wang Peter
LandOfFree
Method and system in an electronic spreadsheet for adding or... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Method and system in an electronic spreadsheet for adding or..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and system in an electronic spreadsheet for adding or... will most certainly appreciate the feedback.
Profile ID: LFCA-PAI-O-1705511