Patent ID: 7665013

Claim:
A 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, and each bound array corresponding to an associated range of the cells of the spreadsheet, and comprising a bound array name distinct from any column name or row name of the spreadsheet, wherein the at least one cell of the bound array is referred to from the referencing array formula using the bound array name of the bound array; means for identifying a formula within a referencing array cell comprising a reference to a cell outside a bound array; and means, responsive to said identifying of a formula within a referencing array cell including a reference to a cell outside a bound array, for automatically indicating an array bound error in said formula, said array bound error comprising the reference to the cell outside the bound array.