Method and system in an electronic spreadsheet for applying user-defined options
AssigneeInternational Business Machines Corporation
InventorsFrederic Bauchot, Albert Harari
Life of this patent
Estimating the term…
Loading patent…
AssigneeInternational Business Machines Corporation
InventorsFrederic Bauchot, Albert Harari
Estimating the term…
The present invention relates to the field of information processing by digital computers, and more particularly to a method and system, in an electronic spreadsheet, of applying one or a plurality of user-defined options within one or a plurality of cells. The method comprises the steps of: defining for each option a boolean variable with a first value and a second value, preferably a “true” or “false” value; for each of said one or plurality of cells: referencing one or a plurality of boolean variables; associating a logical or mathematical operation with each boolean variable; for each of said one or plurality of referenced boolean variables in each of said one or plurality of cells: specifying a default value, said default value being defined as the value of the cell when the referenced boolean variable is set to the first value, preferably when the boolean variable is set to the “false” value; specifying a delta value by applying to the specified cell default value, the operation associated with the referenced boolean variable when the boolean variable is set to the second value, preferably when the boolean variable is set to the “true” value; setting each boolean variable to the first value or to the second value; for each of said one or plurality of cells: computing said one or plurality of delta values.
A method of applying one or a plurality of options in one or a plurality of cells in a multi dimensional spreadsheet comprising a plurality of cells identified by a cell address along each dimension, said method comprising the steps of:
The method according to the preceding claim wherein the step of computing said one or plurality of delta values comprises the further step of:
The method according to the preceding claim wherein said step of associating a logical or mathematical operation with each boolean variable, comprises the preliminary step of:
The method according to any one of the preceding claims wherein said step of specifying a delta value comprises the further step of:
The method according to any one of the preceding claims comprising the further step of:
The method according to any one of the preceding claims wherein said steps of defining one or a plurality of boolean variables, associating a logical or mathematical operation with each boolean variable, setting each boolean variable to the first value or to the second value are executed by means of an interactive user interface.
The method according to any one of the preceding claims wherein said interactive user interface comprises a dialog box, displayed on a screen of a computer system.
A system comprising means adapted for carrying out the method according to any one of the preceding claims.
Dependencies are inferred from the claim text.