Patent ID: 7143338

Claim:
A method for processing one or a plurality of absolute cell references or cell range references during a copy/cut and paste operation in a multi dimensional spreadsheet comprising a plurality of cells identified by addresses or names, said method comprising the steps of: selecting a source cell range to cut and paste or to copy and paste into a destination cell range; storing in a working buffer the content of each cell that belongs to said source cell range; clearing the content of each cell that belongs to a source cell range to cut; for each cell stored in the working buffer; if the content of the stored cell comprises one or a plurality of absolute references pointing to a cell or a cell range belonging to the source cell range: determining for each of said cells or cell ranges pointed by an absolute reference and belonging to the source cell range, a relative position within the source cell range; determining for each of said relative position within the source cell range, a corresponding absolute reference within the destination cell range; replacing within the stored cell, each absolute reference pointing to a cell or a cell range belonging to the source cell range by the corresponding absolute reference within the destination cell range; copying the content of each cell stored in the buffer to corresponding cells within the destination cell range.