0 an electronic document in which information is arranged in rows and columns, and can be used to do financial calculations and plans: --
1 a piece of computer software used for showing rows and columns of numbers or other data, and for doing calculations with this data: --
This approach permits the user to retain their investment in their favourite spreadsheet, but asks them to learn additional rules and techniques.
When creating a spreadsheet, business rules end up being encoded in spreadsheet formulas.
To add relational information to a spreadsheet, we need to add a lifting formula that expresses how the table information corresponds to logic assertions.
How this combination of features affects spreadsheet programming warrants some discussion.
In effect, typed object instances normally appear in spreadsheets as rows within tables.
This is clearly an error-prone property of such spreadsheet applications.
Twenty names were then selected at random from the spreadsheet information.
Observe from the above examples that the spreadsheet metaphor was used to create the rules without the user having to specify any expression with variables.
