Method and system in an electronic spreadsheet for handling user-defined options in a copy/cut - paste operation
First Claim
1. A method of handling user-defined options during a copy and paste or a cut and paste operation within a multi dimensional spreadsheet (200) 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 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.
1 Assignment
0 Petitions
Accused Products
Abstract
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.
163 Citations
9 Claims
-
1. A method of handling user-defined options during a copy and paste or a cut and paste operation within a multi dimensional spreadsheet (200) 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 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. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
Specification