Method and system in an electronic spreadsheet for handling user-defined options in a copy/cut-paste operation

摘要

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, for handling user-defined options during a copy/cut - paste operation when the source range of cells comprises one or a plurality of cells with user-defined options and when the destination environment does not necessarily defines the same user-defined options as the ones defined in the source environment. The method of handling user-defined options during a copy and paste or a cut and paste operation comprises the steps of: defining one or a plurality of combinations, each combination comprising one or a plurality of options; defining a source cell range and a destination cell range; defining an operation to execute, either copy and paste, or cut and paste; for each defined option combination comprising one or a plurality of options, if at least one cell in the source cell range comprises a reference to said one or plurality of options, computing the content of each cell within the source cell range according to said one or plurality of options; creating a version instance of the destination cell range; copying the source range of cells into said version instance. when the last option combination is copied, clearing the source cell range if the operation is cut and paste. IMAGE