Error correction mechanisms in spreadsheet packages
First Claim
Patent Images
1. A computer-implemented spreadsheet package comprising computer program code stored on a computer readable medium for, when executed on a computing device, processing spreadsheets comprising:
- means for enabling copying of a base formula to at least one adjacent cell of said spreadsheet to form a referencing array;
means for maintaining a list of bound arrays, at least one cell of a bound array being referred to from a referencing array formula;
means, responsive to a formula within a referencing array cell including a reference to a cell outside a bound array, for indicating an error in said formula; and
means for highlighting said bound arrays.
1 Assignment
0 Petitions
Accused Products
Abstract
A spreadsheet package allows a base formula to be copied to at least one adjacent cell to form a referencing array. The package maintains a list of bound arrays, at least one cell of a bound array being referred to from a referencing array formula. If a formula within a referencing array cell includes a reference to a cell outside a bound array, the package indicates an error in the formula.
-
Citations
24 Claims
-
1. A computer-implemented spreadsheet package comprising computer program code stored on a computer readable medium for, when executed on a computing device, processing spreadsheets comprising:
-
means for enabling copying of a base formula to at least one adjacent cell of said spreadsheet to form a referencing array; means for maintaining a list of bound arrays, at least one cell of a bound array being referred to from a referencing array formula; means, responsive to a formula within a referencing array cell including a reference to a cell outside a bound array, for indicating an error in said formula; and means for highlighting said bound arrays. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
11. A computer-implemented spreadsheet package comprising computer program code stored on a computer readable medium for, when executed on a computing device, processing spreadsheets comprising:
-
means for enabling copying of a base formula to at least one adjacent cell of said spreadsheet to form a referencing array; means for maintaining a list of bound arrays, at least one cell of a bound array being referred to from a referencing array formula, wherein said list of said bound arrays comprises at least one bound array name and an associated range defining a plurality of cells comprising said bound array; means, responsive to a formula within a referencing array cell including a reference to a cell outside a bound array, for indicating an error in said formula, wherein references from referencing array cell formulae into a bound array are defined relative to a bound array range and said indicating means is responsive to a relative bound array reference comprising a reference to a cell outside a bound array, for indicating an error in said formula; and means for calculating cell formulae, said means for calculating comprising means for identifying a reference to a bound array in a formula, means for determining if said reference is contained within the range of the plurality of cells associated with said identified bound array, and means, responsive to said reference being contained within said range for returning a value for said reference and responsive to said reference being outside said range for indicating an error in said reference. - View Dependent Claims (12, 13, 14, 15, 16)
-
-
17. A computer-implemented spreadsheet package comprising computer program code stored on a computer readable medium for, when executed on a computing device, processing spreadsheets comprising:
-
means for enabling copying of a base formula to at least one adjacent cell of said spreadsheet to form a referencing array; means for maintaining a list of bound arrays, at least one cell of a bound array being referred to from a referencing array formula, wherein said referencing array cell formulae include a plurality of references to respective bound array cells; and means, responsive to a formula within a referencing array cell including a reference to a cell outside a bound array, for indicating an error in said formula. - View Dependent Claims (18, 19, 20, 21, 22, 23, 24)
-
Specification