Method and system in an electronic spreadsheet for managing and handling user-defined options

摘要

The present invention relates to the field of information processing by digital computers, and more particularly to a method and system of processing user defined boolean variables in a multi dimensional spreadsheet comprising a plurality of cells identified by a cell address along each dimension, said method comprising the steps of: defining one or a plurality of boolean variables in a table; referencing the one or plurality of boolean variables in one or a plurality of cells; activating one or plurality of boolean variables in the table; determining the content of the cell or plurality of cells depending on whether the one or plurality of boolean variables are activated or not in the table.