Block properties and calculated columns in a spreadsheet application

• US 10,380,238 B2
• Filed: 12/30/2013
• Issued: 08/13/2019
• Est. Priority Date: 12/20/2004
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Inventors: Chirilov, Joseph N., Newland, Dennis R., Burke, Eoin J., Zhou, Hannah W., Haymond, John C., Niemisto, Juha P., Collie, Robert C., Coffen, Robert W., Moua, Thao
• Primary Examiner(s): Tsui, Wilson W
• Application Number:
  US14/143,298
• Publication Number:
  US 20140115434A1
• Time in Patent Office: 2,052 Days
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

Block properties and improved calculated columns properties are provided in a spreadsheet application. Once block properties are set for a group of spreadsheet cells or a spreadsheet list, the properties may be applied to the entire group of selected cells or list as opposed to requiring application of properties to individual cells. If rows or columns are added to the group of selected cells or list, properties applied to the group of cells or list are automatically applied to the new rows or columns. Block properties also provide for intelligent-behaving list borders where list borders are not corrupted by the movement or changing of columns or rows sharing edges with a list border. Calculated columns are a type of block property that extends the functionality of formulas throughout an entire column of an associated group of cells or list.

Claims

1. A method for formatting cells in a spreadsheet workbook, comprising:

receiving a selection of a group of cells in the spreadsheet workbook that includes more than one workbook row and column for application of a formatting property, wherein the selection of the group of cells defines a list border about a perimeter of the selected group of cells to establish the selected group of cells as a block unit, the list border encompassing the selected group of cells, and wherein the selection of the group of cells associates the list border with the block unit instead of a particular cell, row or column within the selected group of cells;

displaying the selected group of cells along with the list border encompassing the selected group of cells;

storing information about the selected group of cells including a position and a number of rows and a number of columns included in the selected group of cells;

applying the formatting property to all of the cells in the selected group of cells based on the selected group of cells being established as the block unit; and

moving one of a row or column that is at a perimeter position of the block unit to an interior position within the block unit while maintaining the displayed list border as encompassing the selected group of cells based on the selected group of cells being established as the block unit.

2. The method of claim 1, further comprising:

receiving a modification to the formatting property of a particular cell of the selected group of cells;

propagating the modification of the formatting property of the particular cell to other cells of the selected group of cells based on the selected group of cells being established as the block unit;

providing an alert to indicate that the modification applied to the particular cell has been propagated to the other cells wherein the alert includes a selectable user interface element to restore the formatting property to a pre-modified version of the formatting property for the other cells and maintain the modification for the particular cell, wherein providing the alert comprises displaying a selectable user interface element that is used to restore the modified formula to a spreadsheet formula that is contained in the other cells within the selected group of cells.

3. The method of claim 1, further comprising applying a second formatting property to the selected group of cells, the second formatting property comprising an alternate row or an alternate column formatting, wherein the alternate row or alternate row formatting is maintained regardless of the movement of the existing row or existing column of cells within the selected group of cells.

4. The method of claim 1, further comprising:

adding a new row of cells immediately above the list border or immediately below the list border; and

expanding the list border to encompass the new row of cells, wherein the combined selected group of cells and the new row of cells encompassed by the list border are defined as a modified selected group of cells that replaces the selected group of cells within the block unit.

5. The method of claim 4, further comprising:

adding a new column of cells has been added immediately proximate the list border; and

expanding the list border to encompass the new column of cells, wherein the combined modified selected group of cells and the new column of cells encompassed by the list border are defined as a second modified selected group of cells that replaces the modified selected group of cells within the block unit.

6. The method of claim 1, the method further comprising:

inserting a new row of cells into the selected group of cells; and

expanding the list border to accommodate the new row of cells, wherein the combined selected group of cells and the new row of cells accommodated by the list border are defined as a modified selected group of cells that replaces the selected group of cells within the block unit.

7. The method of claim 6, the method further comprising:

inserting a new column of cells into the selected group of cells; and

expanding the list border to accommodate the new column of cells, wherein the combined modified group of cells and the new column of cells accommodated by the list border are defined as a second modified selected group of cells that replaces the modified selected group of cells within the block unit.

8. The method of claim 1, further comprising applying a second formatting property to the selected group of cells while the border around the selected group of cells remains unchanged, wherein the second formatting comprises at least one of a backgrounding color formatting, a text size formatting, a text font formatting, a formula formatting, or a style formatting.

9. A computer-readable medium, excluding a signal, having stored thereon computer-executable instructions which when executed by a computer perform operations for applying formatting properties to a group of cells in a spreadsheet application document, comprising:

receiving a selection of a group of cells from a spreadsheet workbook, wherein the selection of the group of cells defines a list border about a perimeter of the selected group of cells to establish the selected group of cells as a block unit, the list border encompassing the selected group of cells, and wherein the selection of the group of cells associates the list border with the block unit instead of a particular cell, row or column within the selected group of cells;

displaying the selected group of cells along with the list border encompassing the selected group of cells;

storing information including a position and a number of rows and a number of columns for the selected group of cells; and

applying a formatting property to all of the cells in the selected group of cells based on the selected group of cells being established as the block unit; and

moving one of a row or column that is at a perimeter position of the block unit to an interior position within the block unit while maintaining the displayed list border as encompassing the selected group of cells based on the selected group of cells being established as the block unit.

10. The computer readable medium of claim 9, the computer readable medium having additional stored computer-executable instructions comprising:

adding a new row of cells immediately above the list border or immediately below the list border; and

expanding the list border to encompass the new row of cells, wherein the combined selected group of cells and the new row of cells encompassed by the list border are defined as a modified selected group of cells that replaces the selected group of cells within the block unit.

11. The computer readable medium of claim 10, wherein the computer readable medium includes additional stored computer-executable instructions comprising:

adding a new column of cells immediately proximate the list border; and

expanding the list border to encompass the new column of cells, wherein the combined modified selected group of cells and the new column of cells encompassed by the list border are defined as a second modified selected group of cells that replaces the modified selected group of cells within the block unit.

12. The computer readable medium of claim 9, the computer readable medium having additional stored computer-executable instructions comprising:

inserting a new row of cells into the selected group of cells; and

expanding the list border to accommodate the new row of cells, wherein the combined selected group of cells and the new row of cells accommodated by the list border are defined as a modified selected group of cells that replaces the selected group of cells within the block unit.

13. The computer readable medium of claim 12, wherein the computer readable medium includes additional stored computer-executable instructions comprising:

inserting a new column of cells into the selected group of cells; and

expanding the list border to accommodate the new column of cells, wherein the combined modified group of cells and the new column of cells accommodated by the list border are defined as a second modified selected group of cells that replaces the modified selected group of cells within the block unit.

14. The computer readable medium of claim 9, wherein the computer readable medium includes additional stored computer-executable instructions comprising:

applying a second formatting property to the selected group of cells while the border around the selected group of cells remains unchanged, wherein the second formatting comprises at least one of a backgrounding color formatting, a text size formatting, a text font formatting, a formula formatting, or a style formatting.

15. A system for interacting with a group of cells in a spreadsheet workbook, comprising:

a processor and a memory device;

the processor configured to perform operations, comprising;

receiving a selection of a group of cells in a spreadsheet workbook for application of a formatting property, wherein the selection of the group of cells defines a list border about a perimeter of the selected group of cells to establish the selected group of cells as a block unit, the list border encompassing the selected group of cells, and wherein the selection of the group of cells associates the list border with the block unit instead of a particular cell, row or column within the selected group of cells;

displaying the selected group of cells along with the list border encompassing the selected group of cells;

storing information about a position and identity of one or more workbook rows and columns making up the selected group of cells;

applying a formatting property to all of the cells in the selected group of cells based on the selected group of cells being established as the block unit; and

moving one of a row or column that is at a perimeter position of the block unit to an interior position within the block unit while maintaining the displayed list border as encompassing the selected group of cells based on the selected group of cells being established as a block unit.

16. The system of claim 15, the operations further comprising:

adding a new row of cells immediately above the list border or immediately below the list border; and

expanding the list border to encompass the new row of cells, wherein the combined selected group of cells and the new row of cells encompassed by the list border are defined as a modified selected group of cells that replaces the selected group of cells within the block unit.

17. The system of claim 16, the operations further comprising:

adding a new column of cells immediately proximate the list border; and

expanding the list border to encompass the new column of cells, wherein the combined modified selected group of cells and the new column of cells encompassed by the list border are defined as a second modified selected group of cells that replaces the modified selected group of cells within the block unit.

18. The system of claim 15, the operations further comprising:

inserting a new row of cells into the selected group of cells; and

expanding the list border to accommodate the new row of cells, wherein the combined selected group of cells and the new row of cells accommodated by the list border are defined as a modified selected group of cells that replaces the selected group of cells within the block unit.