Formattable spreadsheet table elements with automatic updating

• US 20070050700A1
• Filed: 08/30/2005
• Published: 03/01/2007
• Est. Priority Date: 08/30/2005
• Status: Abandoned Application

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Gainer, David, Ellis, Charles, Jayanty, Paavany, Hoke, Tom, Chamberlain, Benjamin, Simkhay, Roy
• Application Number:
  US11/214,682
• Publication Number:
  US 20070050700A1
• Time in Patent Office: Days
• US Class Current: 715/220
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

Spreadsheets are subdivided into formattable table elements that may include multiple table cells so that the multiple table cells can be formatted as a single element. As such, a gradient format can be applied across the range of multiple table cells instead of to individual table cells. A format property can be applied to a spreadsheet table to provide alternating table element formats that are automatically updated when cells or formattable table elements are added, deleted, hidden, shown or moved. As a result, when a table modification is made, the alternating format of the table is updated before the table is rendered on a display.

Claims

1. A method, comprising:

rendering a spreadsheet table on a user interface, said spreadsheet table including at least one formattable table element that is formatted according to a specific format;

detecting a structural update in the spreadsheet table that affects the specific format of the formattable table element;

automatically reformatting the formattable table element to comply with the specific format for the formattable table element; and

rendering the spreadsheet table on the user interface to reflect the reformatted formattable table element and the structural update.

2. The method as recited in claim 1, wherein:

the at least one formattable table element further comprises a first formattable table element and a second formattable table element; and

the format of the first formattable table element takes precedence over the format of the second formattable table element when the reformatted table elements are rendered on the user interface.

3. The method as recited in claim 2, wherein:

the first formattable table element further comprises rows;

the second formattable table element further comprises columns; and

the format of the first formattable table element and the second formattable table element further comprise alternating stripes.

4. The method as recited in claim 1, wherein the formattable table element further comprises multiple table cells that are formattable as a single element.

5. The method as recited in claim 4, wherein the formatting of the formattable table element further comprises at least a gradient formatting, the gradient being applied across all of the multiple table cells in the formattable table element.

6. The method as recited in claim 1, wherein the formattable table element further comprises a formattable table element selected from the following formattable table elements:

a single row;

multiple rows;

a single column;

multiple columns;

a header row;

a totals row;

a single table cell;

multiple table cells.

7. One or more computer-readable media containing executable instructions that, when executed, implement the following steps:

rendering a first formattable table element in a spreadsheet table, the first formattable table element including multiple table cells formatted according to a particular format;

rendering a second formattable table element in the spreadsheet table, the second formattable table element including multiple table cells formatted according to a particular format;

receiving instructions to change a structure of the spreadsheet table that will affect at least one of the formattable table elements;

automatically reformatting each affected formattable table element according to the particular format associated with the affected formattable table element; and

rendering the spreadsheet table to reflect the reformatted formattable table elements and the change in the table structure.

8. The one or more computer-readable media as recited in claim 7, wherein the multiple table cells included in each formattable table element are formatted as a single element.

9. The one or more computer-readable media as recited in claim 8, wherein at least one of the formattable table elements further comprises at least a gradient formatting, the gradient being applied across all of the multiple table cells in the formattable table element.

10. The one or more computer-readable media as recited in claim 7, wherein the first formattable table element further comprises a header row.

11. The one or more computer-readable media as recited in claim 8, further comprising a third formattable table element configured as a totals row.

12. The one or more computer-readable media as recited in claim 7, wherein the formattable table elements are selected from the following list of formattable table elements:

a single row;

multiple rows;

a single column;

multiple columns;

a header row;

a totals row;

a single table cell;

multiple table cells.

13. The one or more computer-readable media as recited in claim 7, wherein the format of the first formattable table element is applied to a table cell that is included in the first formattable table element and the second formattable table element.

14. A system, comprising:

a user interface;

rendering means for rendering a spreadsheet table on the user interface, the spreadsheet table having a structure and including at least one formattable table element;

means for detecting an update in the table structure that affects at least one formattable table element;

table formatting means for automatically formatting each formattable table element included in the spreadsheet table when a table structure update is detected; and

wherein the rendering means is further configured to render the spreadsheet table to show the table structure update and the reformatted formattable table elements.

15. The system as recited in claim 14, wherein each of the at least one formattable table elements further comprises multiple table cells that are formatted as a single element when the formattable table element is formatted.

16. The system as recited in claim 15, wherein the multiple table cells are formatted according to a gradient format that is applied across the multiple table cells.

17. The system as recited in claim 14, wherein the at least one formattable table element includes at least one of the following formattable table elements:

a single row;

multiple rows;

a single column;

multiple columns;

a header row;

a totals row;

a single table cell;

multiple table cells.

18. The system as recited in claim 14, wherein the at least one formattable table element further comprises at least two formattable table elements that each contain at least one common table cell.

19. The system as recited in claim 18, wherein the formatting means is further configured to apply formatting according to a first formattable table element instead of formatting according to a second formattable table element when a precedence order of formatting indicates that the first formattable table element takes precedence over the second formattable table element.

20. The system as recited in claim 14, wherein the table structure update further comprises at least one of the following operations:

add formattable table element;

delete formattable table element;

hide formattable table element;

show formattable table element;

move formattable table element.