Method and system in an electronic spreadsheet for processing different cell protection modes

• US 6,592,626 B1
• Filed: 09/20/1999
• Issued: 07/15/2003
• Est. Priority Date: 03/05/1999
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Bauchot, Fréde̅ric, Harari, Albert
• Primary Examiner(s): Herndon, Heather R.
• Assistant Examiner(s): Stone, Jonathan D
• Application Number:
  US09/399,452
• Time in Patent Office: 1,394 Days
• Field of Search: 707/503, 707/504, 707/530, 707/511, 707/539, 715/503, 715/504, 715/530, 715/511, 715/539
• US Class Current: 715/217
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

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 easily swapping the protection mode of a cell between a protected mode and an unprotected mode, while preserving the mathematical formulas used in the protected mode The electronic spreadsheet includes a cell content manager with an interface for handling the content of user specified cells according to the read-only, protected mode where a cell is usually filled by a formula, and the read-write, unprotected mode with a free update of the cell by the spreadsheet user. Preferred display methodology is also described for representing the current mode of a given cell.

Claims

1. A method within a data processing system for manipulating cell contents of a protected cell in a spreadsheet file having a plurality of standard cells, said method comprising:

enabling a developer to convert at least one standard cell of said spreadsheet file to a swappable cell only when said spreadsheet file is not sealed, wherein said swappable cell includes a safe mode in which cell contents are protected from modification and a free mode in which cell contents are not protected from modification;

in response to a request by said developer to convert said at least one standard cell to a swappable cell;

adding an entry in a swap table;

copying cell contents of said swappable cell to said entry; and

setting said swappable cell to said safe mode;

enabling a user to toggle said swappable cell between said safe mode and said free mode only when said spreadsheet file is sealed;

in response to a request by said user to toggle said swappable cell from said safe mode to said free mode;

replacing cell contents of said swappable cell with a value; and

setting said swappable cell to said free mode; and

in response to a request by said user to toggle said swappable cell from said free mode to said safe mode;

copying contents of said entry from said swap table to said swappable cell; and

setting said swappable cell to said safe mode,

such that said user can temporarily modify contents of a protected cell.

2. The method according to claim 1 further comprising retaining said cell contents of said swappable cell when said swappable cell is swapped from said safe mode into said free mode.

3. The method according to claim 1, wherein said in response to a request by said developer to convert said at least one standard cell to a swappable cell further includes determining whether or not said at least one standard cell has an entry within said swap table.

4. The method according to claim 1, wherein said in response to a request by said user to toggle said swappable cell from said safe mode to said free mode further includes protecting said swappable cell.

5. The method according to claim 1, wherein said in response to a request by said user to toggle said swappable cell from said free mode to said safe mode further includes unprotecting said swappable cell.

6. The method according to claim 1, wherein said swap table comprises an entry for each swappable cell, wherein said entry includes a safe content field for storing cell contents of a swappable cell, an identifier field for storing a cell identifier of said swappable cell for, and a mode field for storing indicating whether said swappable cell is in said safe mode or said free mode.

7. A data processing system that supports different protection modes in a spreadsheet having a plurality of standard cells, said data processing system comprising:

means for enabling a developer to convert at least one standard cell of said spreadsheet file to a swappable cell only when said spreadsheet file is not sealed, wherein said swappable cell includes a safe mode in which cell contents are protected from modification and a free mode in which cell contents are not protected from modification;

in response to a request by said developer to convert said at least one standard cell to a swappable cell;

means for adding an entry in a swap table;

means for copying cell contents of said swappable cell to said entry; and

means for setting said swappable cell to said safe mode;

means for enabling a user to toggle said swappable cell between said safe mode and said free mode only when said spreadsheet file is sealed;

in response to a request by said user to toggle said swappable cell from said safe mode to said free mode;

means for replacing cell contents of said swappable cell with a value; and

means for setting said swappable cell to said free mode; and

in response to a request by said user to toggle said swappable cell from said free mode to said safe mode;

means for copying contents of said entry from said swap table to said swappable cell; and

means for setting said swappable cell to said safe mode,

such that said user can temporarily modify contents of a protected cell.

8. The data processing system according to claim 7, wherein said system further includes means for retaining said cell contents of said swappable cell when said swappable cell is swapped from said safe mode into said free mode.

9. The data processing system according to claim 7, wherein in response to a request by said developer to convert said at least one standard cell to a swappable cell further includes determining whether or not said at least one standard cell has an entry within said swap table.

10. The data processing system according to claim 7, wherein said cell enabler enables said at least one cell only while said spreadsheet is unsealed.

11. The data processing system according to claim 7, wherein said in response to a request by said user to toggle said swappable cell from said free mode to said safe mode further includes unprotecting said swappable cell.

12. The data processing system according to claim 7, wherein said swap table comprises an entry for each swappable cell, wherein said entry includes a safe content field for storing cell contents of a swappable cell, an identifier field for storing a cell identifier of said swappable cell for, and a mode field for storing indicating whether said swappable cell is in said safe mode or said free mode.

13. A program product for manipulating cell contents of a protected cell in a spreadsheet having a plurality of standard cells, said program product comprising:

program code means for enabling a developer to convert at least one standard cell of said spreadsheet file to a swappable cell only when said spreadsheet file is not sealed, wherein said swappable cell includes a safe mode in which cell contents are protected from modification and a free mode in which cell contents are not protected from modification;

in response to a request by said developer to convert said at least one standard cell to a swappable cell;

program code means for adding an entry in a swap table;

program code means for copying cell contents of said swappable cell to said entry; and

program code means for setting said swappable cell to said safe mode;

program code means for enabling a user to toggle said swappable cell between said safe mode and said free mode only when said spreadsheet file is sealed;

in response to a request by said user to toggle said swappable cell from said safe mode to said free mode;

program code means for replacing cell contents of said swappable cell with a value; and

program code means for setting said swappable cell to said free mode; and

in response to a request by said user to toggle said swappable cell from said free mode to said safe mode;

program code means for copying contents of said entry from said swap table to said swappable cell; and

program code means for setting said swappable cell to said safe mode,

such that said user can temporarily modify contents of a protected cell.

14. The program product according to claim 13, wherein said program product further includes program code means for retaining said cell contents of said swappable cell when said swappable cell is swapped from said safe mode into said free mode.

15. The program product according to claim 13, wherein said in response to a request by said developer to convert said at least one standard cell to a swappable cell further includes program code means for determining whether or not said at least one standard cell has an entry within said swap table.

16. The program product according to claim 13, wherein said in response to a request by said user to toggle said swappable cell from said safe mode to said free mode further includes program code means for protecting said swappable cell.

17. The program product according to claim 13, wherein said in response to a request by said user to toggle said swappable cell from said free mode to said safe mode further includes program code means for unprotecting said swappable cell.

18. The program product according to claim 13, wherein said swap table comprises an entry for each swappable cell, wherein said entry includes a safe content field for storing cell contents of a swappable cell, an identifier field for storing a cell identifier of said swappable cell for, and a mode field for storing indicating whether said swappable cell is in said safe mode or said free mode.