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

• US 7,178,098 B2
• Filed: 04/19/2001
• Issued: 02/13/2007
• Est. Priority Date: 07/13/2000
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Bauchot, Frederic, Harari, Albert, Sirot, Benoit
• Primary Examiner(s): Alam; Shahid
• Assistant Examiner(s): Stevens; Robert
• Application Number:
  US09/838,424
• Publication Number:
  US 20020007380A1
• Time in Patent Office: 2,126 Days
• Field of Search: 715/503, 715/504, 715/538, 715/530
• US Class Current: 715/212
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

An example of a solution provided here comprises defining one or more combinations of options, defining an operation to execute (e.g. copy and paste, or cut and paste), computing the content of each cell within the source cell range according to the options, creating a version instance of the destination cell range, and copying the source range of cells into the version instance. Each of the options is defined as a boolean variable, which can be set as “True” or “False,” and impact the content of a cell within an electronic spreadsheet.

Claims

1. A method, implemented on a computer system, of handling user-defined options during a copy and paste operation or a cut and paste operation within a multi dimensional electronic spreadsheet comprising a plurality of cells identified by a cell address along each dimension, said method comprising the steps of:

processing a first user input, wherein the first user input defines one or a plurality of option combinations, each option combination comprising a plurality of options, wherein each option in the plurality of options has an associated identifier and an associated value;

accessing, in the computer system, the multidimensional electronic spreadsheet, wherein the multidimensional electronic spreadsheet includes at least one cell that references an identifier of at least one option of the plurality of options;

processing a second user input, wherein the second user input selects a first source cell range of the multidimensional electronic spreadsheet and a destination cell range of the multidimensional electronic spreadsheet;

processing a third user input identifying an operation to execute, wherein the operation to execute is either a copy and paste operation, or a cut and paste operation; and

performing the identified operation, wherein performing the identified operation comprises;

analyzing the first source cell range, for each defined option combination, to determine if at least one cell in the first source cell range comprises a reference to one or more options of the plurality of options of the defined option combination; and

for each option combination in which the first source cell range has at least one cell that references one or more options of the plurality of options of the defined option combination, performing the following operations;

computing a content of each cell within the first source cell range to thereby generate a second source cell range, wherein contents of the at least one cell are computed according to the referenced one or more options of the plurality of options based on a corresponding value associated with the referenced one or more options defined in a current option combination;

creating a version instance of the destination cell range in the multidimensional electronic spreadsheet; and

copying the second source range of cells into the version instance.

2. The method according to claim 1, wherein processing the first user input comprises assigning a name for each defined option combination, and wherein a version instance associated with the option combination is named using the defined option combination name.

3. The method according to claim 1, further comprising the preliminary steps of:

defining each option of the plurality of options as a Boolean variable in an options data structure; and

referencing at least one option of the plurality of options in one or a plurality of cells of the multidimensional electronic spreadsheet.

4. The method of claim 3, wherein referencing at least one option of the plurality of options in one or a plurality of cells of the multidimensional electronic spreadsheet comprises:

selecting a cell from the plurality of cells of the multidimensional electronic spreadsheet; and

outputting an interactive user interface for applying one or more options of the plurality of options to the selected cell, wherein the interactive user interface includes a field for specifying an option to apply to the selected cell and a field for identifying a logical operation for applying the specified option to the selected cell.

5. The method of claim 4, wherein the logical operation is selected from the set of logical operations including an Add logical operation meaning that the specified option is applied with an additive effect, a Multiply logical operation meaning that the specified option is applied with a multiplicative effect, and an Or logical operation meaning that the specified option is applied with an exclusive effect.

6. The method according to claim 1, wherein one or more of the first user input, the second user input, or the third user input are received in the computer system by means of an interactive user interface.

7. The method according to claim 6, wherein the interactive user interface comprises:

a dialog box displayed on a screen of the computer system.

8. The method of claim 1, further comprising:

outputting an interactive user interface through which the first user input is received, wherein the interactive user interface including a first portion for displaying a listing of defined options that are able to be referenced in cells of the multidimensional electronic spreadsheet, and a second portion for specifying option combinations by specifying values for a plurality of the defined options in the first portion.

9. The method of claim 1, wherein each of the options is defined as a Boolean variable whose value can be set as “

True”

or “

False,” and

wherein values of the options impact contents of cells within the multidimensional electronic spreadsheet when the cells reference the options.

10. The method of claim 9, wherein if an option has a value of “

True,”

the option is represented as a numerical “

1”

in contents of cells within the multidimensional electronic spreadsheet that reference the option, and wherein if an option has a value of “

False,”

the option is represented as a numerical “

0”

in contents of cells within the multidimensional electronic spreadsheet that reference the option.

11. A system, comprising:

a processor; and

a memory coupled to the processor, wherein the memory contains instructions which when executed by the processor, cause the processor to;

process a first user input, wherein the first user input defines one or a plurality of option combinations, each option combination comprising a plurality of options, wherein each option in the plurality of options has an associated identifier and an associated value;

access, in the computer system, a multidimensional electronic spreadsheet, wherein the multidimensional electronic spreadsheet includes at least one cell that references an identifier of at least one option of the plurality of options;

process a second user input, wherein the second user input selects a first source cell range of the multidimensional electronic spreadsheet and a destination cell range of the multidimensional electronic spreadsheet;

process a third user input identifying an operation to execute, wherein the operation to execute is either a copy and paste operation, or a cut and paste operation; and

perform the identified operation, wherein performing the identified operation comprises;

analyzing the first source cell range, for each defined option combination, to determine if at least one cell in the first source cell range comprises a reference to one or more options of the plurality of options of the defined option combination; and

for each option combination in which the first source cell range has at least one cell that references one or more options of the plurality of options of the defined option combination, performing the following operations;

computing a content of each cell within the first source cell range to thereby generate a second source cell range, wherein contents of the at least one cell are computed according to the referenced one or more options of the plurality of options based on a corresponding value associated with the referenced one or more options defined in a current option combination;

creating a version instance of the destination cell range in the multidimensional electronic spreadsheet; and

copying the second source range of cells into the version instance.

12. The system according to claim 11, wherein the instructions further cause the processor to assigning a name for each defined option combination, and wherein a version instance associated with the option combination is named using the defined option combination name.

13. The system according to claim 11, wherein the instructions further cause the processor to:

define each option of the plurality of options as a Boolean variable in an options data structure; and

reference at least one option of the plurality of options in one or a plurality of cells of the multidimensional electronic spreadsheet.

14. The system of claim 13, wherein the instructions cause the processor to reference at least one option of the plurality of options in one or a plurality of cells of the multidimensional electronic spreadsheet by:

selecting a cell from the plurality of cells of the multidimensional electronic spreadsheet; and

outputting an interactive user interface for applying one or more options of the plurality of options to the selected cell, wherein the interactive user interface includes a field for specifying an option to apply to the selected cell and a field for identifying a logical operation for applying the specified option to the selected cell.

15. The system of claim 14, wherein the logical operation is selected from the set of logical operations including an Add logical operation meaning that the specified option is applied with an additive effect, a Multiply logical operation meaning that the specified option is applied with a multiplicative effect, and an Or logical operation meaning that the specified option is applied with an exclusive effect.

16. The system according to claim 11, wherein one or more of the first user input, the second user input, or the third user input are received in the computer system by means of an interactive user interface.

17. The system of claim 11, wherein the instructions further cause the processor to:

output an interactive user interface through which the first user input is received, wherein the interactive user interface including a first portion for displaying a listing of defined options that are able to be referenced in cells of the multidimensional electronic spreadsheet, and a second portion for specifying option combinations by specifying values for a plurality of the defined options in the first portion.

18. The system of claim 11, wherein each of the options is defined as a Boolean variable whose value can be set as “

True”

or “

False,” and

wherein values of the options impact contents of cells within the multidimensional electronic spreadsheet when the cells reference the options.

19. The system of claim 18, wherein if an option has a value of “

True,”

the option is represented as a numerical “

1”

in contents of cells within the multidimensional electronic spreadsheet that reference the option, and wherein if an option has a value of “

False,”

the option is represented as a numerical “

0”

in contents of cells within the multidimensional electronic spreadsheet that reference the option.

20. A computer usable medium having instructions recorded thereon, wherein the instructions, when executed on a computing device, cause the computing device to:

process a first user input, wherein the first user input defines one or a plurality of option combinations, each option combination comprising a plurality of options, wherein each option in the plurality of options has an associated identifier and an associated value;

access, in the computer system, a multidimensional electronic spreadsheet, wherein the multidimensional electronic spreadsheet includes at least one cell that references an identifier of at least one option of the plurality of options;

process a second user input, wherein the second user input selects a first source cell range of the multidimensional electronic spreadsheet and a destination cell range of the multidimensional electronic spreadsheet;

process a third user input identifying an operation to execute, wherein the operation to execute is either a copy and paste operation, or a cut and paste operation; and

perform the identified operation, wherein performing the identified operation comprises;

analyzing the first source cell range, for each defined option combination, to determine if at least one cell in the first source cell range comprises a reference to one or more options of the plurality of options of the defined option combination, and

for each option combination in which the first source cell range has at least one cell that references one or more options of the plurality of options of the defined option combination, performing the following operations;

computing a content of each cell within the first source cell range to thereby generate a second source cell range, wherein contents of the at least one cell are computed according to the referenced one or more options of the plurality of options based on a corresponding value associated with the referenced one or more options defined in a current option combination;

creating a version instance of the destination cell range in the multidimensional electronic spreadsheet; and

copying the second source range of cells into the version instance.