A spreadsheet system

Claim 2

A spreadsheet system comprising: a display means for displaying a spreadsheet; a means for inputting relations of a plurality of cells and cell values of said spreadsheet; a means for establishing a model including a relational node corresponding to the inputted relation, a cell node corresponding to the cell on which said relation is satisfied, an arc linking said relational node with said cell node, and a description describing a propagating direction of a change based on the input of said cell value through said arc; a means for marking on said calculation model one path or all of a plurality of paths through which the changes based on the input of said cell value are propagated; a means for determining one of said paths in accordance with predetermined rules; a means for performing a recalculation based on said input cell value in accordance with said determined path; and a means for reflecting the performed result of the recalculation of said spreadsheet.

Claim 3

A spreadsheet system comprising: a means for inputting relations of a plurality of cells and cell values of said spreadsheet; a means for establishing a calculation model including a relational node corresponding to the inputted relation, a cell node corresponding to the cell on which said relation is satisfied, an arc linking said relative node with said cell node, and a descriptor describing a propagating direction of a change based on the input of said cell value through said arc; a means for marking on said calculation model on path or all of a plurality of paths through which the change based on the input of said cell value are propagated; a means for determining one of said paths in accordance with predetermined rules; a means for performing a recalculation based on said input cell value in accordance with said determined path; a means for reflecting the performed result of the recalculation on said spreadsheet; a means for displaying that there exists one path or a plurality of paths on which the recalculation has not been performed; a means for receiving a recalculation request in accordance with the paths not performed; a means for determining one of said paths not performed in accordance with said rules; a means for performing the recalculation based on said cell value in accordance with the determined path not performed; and a means for reflecting the performed result of the new recalculation on said spreadsheet.

Claim 4

A spreadsheet system comprising: a means for inputting relations of a plurality of cells and cell values of said spreadsheet; a means for establishing a calculation model including a relational node corresponding to the inputted relation, a cell node corresponding to the cell on which said relation is satisfied, an arc linking said relative node with said cell node, and a descriptor describing a propagating direction of a change based on the input of said cell value through said arc; a means for marking on said calculation model on path or all of a plurality of paths through which the change based on the input of said cell value are propagated; a means for determining one of said paths in accordance with predetermined rules; a means for performing a recalculation based on said input cell value in accordance with said determined path; a means for reflecting the performed result of the recalculation on said spreadsheet; a means for displaying that there exists one path or a plurality of paths on which the recalculation has not been performed; a means for receiving a recalculation request in accordance with the paths not performed; a means for determining one of said paths not performed in accordance with said rules; a means for performing the recalculation based on said cell value in accordance with the determined path not performed; and a means for reflecting the performed result of the new recalculation on said spreadsheet.

Claim 5

A spreadsheet system according to Claim (1) or (2), wherein by using the relation concerning the cell which receives the performed result of the recalculation and the other cell values having said relation, the value to be employed of the cell receiving the performed result is developed, and this value is compared with said performed result, thereby making it possible to judge the unity of said recalculation.