provides a table
view of data, where rows represent individual records, and columns represent fields of the records. A field value can be computed from other field values by attaching a formula
to the field.
See Also edit
- often used to control spreadsheet programs
- Demand-driven computation
- AM: The way spreadsheets work (with formulae for a cell that reference other cells) made me think of developing a different kind of programming.
provides a table view of data, where rows represent individual records, and columns represent fields of the records. A field value can be computed from other field values by attaching a formula
to the field.
A spreadsheet in the physical world is a piece of paper with a grid
of boxes drawn on it, used to attempt to convey in some fashion a relationship between at least two vectors of information. These vectors are typically referred to as rows
of data, and the basic unit of information for the spreadsheet, the intersection of a row and column, is a cell
For instance, the vectors may represent columns of months/weeks/days/hours and rows of data (money spent, sales achieved per individual, etc.).
A spreadsheet presents data in table form, a general format that has probably been around since about the time humans started recording information. Because of this generality, spreadsheets are the most broadly used class of data analysis program. They are almost universally used by business managers for tracking and reporting business activity. The flexibility of spreadsheets often makes them the tool of choice, particularly for non-programmers, to develop quick solutions to daily data management problems.
If considered a user interface, spreadsheets are probably the second most popular user interface in computing history, surpassed only by the filesystem file-directory interface. In a sense, spreadsheets are the closest anything has come to bringing computer programming to the masses, as spreadsheet users over time become more adept at leveraging spreadsheet functionality to meet various computing needs.
The generality and easy initial learning curve of spreadsheets can lead to overuse of spreadsheets when other, and better, tools are available. See Spreadsheet Addiction
One of the early spreadsheet programs was Visicalc. It provided more than just an input grid for one to type in numbers and words. It also provided the means to associate calculations (known as formula) to specific cells, and even link ranges of cells to a specific formula.
The most popular spreadsheet under DOS was Lotus 123 programmed by Mitch Kapor.
When Dos was replaced by Windows 95, Excel
replaced Lotus 123 and Excel is to this day the most popular spreadsheet for Windows.
Spreadsheets coded in Tcl publicly available edit
- written in Tcl/Tk and C++
- A little spreadsheet
- A bigger spreadsheet
- MINISS - Mini Spread Sheet
- spreadsheet ,by Mark Smith
- a spreadsheet widget
- Tiny Excel-like app in plain Tcl/Tk
- tiny spreadsheet
- handles SYLK files written by Excel (and other compatible programs)
- Parsing Excel XLSX
- evaluate Excel xlsx xml spreadsheets.
Other spreadsheets with Tcl associations edit
- Microsoft Excel
- One of the most popular pieces of software in history.
- Modular OO Dynamic Spreadsheet.
- Siag Office
- tk# (aka tknum)
- XESS Tk interface
- see book at http://www.lulu.com/content/17717
- gh: As ed is the standard editor - sc is the spreadsheet calculator. See sc: the Venerable Spreadsheet Calculator ,Serge Hallyn ,2010-12-01.