Method and system for detecting and selectively correcting cell reference errors
US6317758A · kind A · utility
43Cited by
6References
34Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Feb 20, 1998 |
| Grant date | Nov 13, 2001 |
| Priority date | — |
| Expiry date | Feb 20, 2018 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F40/18
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
In a computer implemented spreadsheet, a method for detecting and selectively correcting cell reference errors after a cell is copied includes identifying at least one destination cell containing a formula with a reference error; and converting the address of at least one reference in the formula of the at least one destination cell from a relative address to an absolute address. A system for carrying out the claimed method includes a spreadsheet application module, a cell module, an error detection and correction module, a user dialog module, a dependency display module, a fix memory, and a rejection memory.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.