Method and system in an electronic spreadsheet for handling absolute references in a copy/cut and paste operation according to different modes
US7143338B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Mar 19, 2001 |
| Grant date | Nov 28, 2006 |
| Priority date | — |
| Expiry date | Dec 5, 2024 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F40/18
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
In an electronic spreadsheet, if an absolute cell or absolute cell range reference does not comprise the same information in a source environment and in a destination environment, errors may occur. Therefore, a buffer is created for temporarily storing a source cell range. Any material in the buffer not needed, is cleared. Any absolute reference content remaining that points to a source cell range, has a relative position within the source cell range determined. Then, a corresponding absolute reference within the destination cell range is determined. Prior to copying the buffer content into corresponding cells within a destination cell range, each absolute reference pointing to a source is replaced by a corresponding absolute reference with the destination cell range.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.