Loading patent…
AssigneesHitchi, Ltd., Hitachi Chubu Software, Ltd.
InventorsYasushi Kaneko, Tadashi Yamamitsu, Tetsuya Kondo
Estimating the term…
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.
A spread sheet calculation method for displaying spread sheet data of a spread sheet table on a display device, designating a first area of the spread sheet data on a display screen by an input device for the purpose of updating the spread sheet data, executing a calculation defined by a calculation formula related to said first area in a calculation formula table defining the calculation of the spread sheet data and updating data of a second area related to said first area in the spread sheet data, said method comprising the steps of:
A spread sheet calculation apparatus for displaying spread sheet data of a spread sheet table on a display device, designating a first area of the spread sheet data on a display screen by an input device for the purpose of updating the spread sheet data, executing a calculation defined by a calculation formula related to said first designated area in a calculation formula table defining the calculation of the spread sheet data and updating data of a second area related to said first area in the spread sheet data, comprising:
A spread sheet calculation apparatus having a spread sheet data table for storing spread sheet data and a calculation formula table defining the calculation of the spread sheet data, comprising:
A spread sheet calculation method, comprising the steps of:
A spread sheet calculation apparatus, comprising:
Dependencies are inferred from the claim text.