Spread sheet calculation method and apparatus by extracting an area to be updated by a calculation formula
US5708827A · kind A · utility
Assignees
Inventors
Key dates
| Filing date | Sep 18, 1995 |
| Grant date | Jan 13, 1998 |
| Priority date | — |
| Expiry date | Sep 18, 2015 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F40/18
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
In a spread sheet calculation apparatus, a spread sheet data table stores spread sheet data such as a sales table, a calculation formula table stores calculation formulas defining the calculation of the spread sheet data and a display device displays the spread sheet data and the calculation formula. When a desired area on a display screen is designated by an input device to enter data, a calculation formula control unit searches for a calculation formula which relates to the designated area from the calculation formula table and executes the calculation formula. A spread sheet data control unit updates the data of related areas of the spread sheet data table. A reference area extracting unit extracts the area which is to be updated by the calculation formula, and a display attribute control unit changes a display attribute (for example, meshing) of the data of the corresponding area in the spread sheet data table. A calculation formula list display control unit displays a list of calculation formulas stored in the calculation formula table and changes a display form of the calculation formulas contributed to the update of the data.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.