Extension of formulas and formatting in an electronic spreadsheet
View Patent ↗Formats are extended automatically to cells in an electronic spreadsheet. Previously blank, newly edited cell(s) are determined to be an extension or within a list of cells based on having a consistent data type, and the like. Next, formatting of the list of cells is examined for consistency. If consistent formatting exists, it is applied to the previously blank, newly edited cell(s). List of cells may include rows, columns, and the like.
1. A method for automatically extending a format to include a cell in an electronic spreadsheet, comprising the computer implemented steps of:
determining that a previously blank newly edited cell is an extension to or within a list of cells;
automatically determining that the list of cells has a consistent format; and
automatically extending the consistent format to include the previously blank newly edited cell.
2. The method of claim 1 , wherein the step of determining that a previously blank newly edited cell is an extension of or within a list of cells comprises:
determining that a plurality of previous cells have a consistent data type; and
determining that the previously blank newly edited cell also has the consistent data type.
3. The method of claim 2 , wherein the plurality of previous cells are above the previously blank newly edited cell in a column.
4. The method of claim 2 , wherein the plurality of previous cells are beside the previously blank newly edited cell in a row.
5. The method of claim 1 , wherein the step of determining that a previously blank newly edited cell is an extension of a list of cells comprises:
determining that the previously blank newly edited cell is an extension of or within the list, wherein the list comprises a plurality of previous cells above the previously blank newly edited cell in a column, each cell having a first consistent data type; and
if it is determined that the previously newly edited cell is not an extension of or within the column, determining that the previously blank newly edited cell is an extension of or within the list, wherein the list comprises a plurality of previous cells beside the previously blank newly edited cell in a row, each cell having a second consistent data type.
6. The method of claim 5 , wherein the step of determining that the list of cells has a consistent format comprises determining that the list has a consistent column format; and
wherein the step of automatically extending the consistent format to include the previously blank newly edited cell comprises applying the consistent column format to the previously blank newly edited cell if the cell has only default formatting, wherein the default formatting excludes conditional formatting previously applied to the cell.
7. The method of claim 5 , wherein the step of determining that the list of cells has a consistent format comprises:
determining that the list does not have a consistent column format, and
determining that the list has a consistent row format; and
wherein the step of automatically extending the consistent format to the previously blank newly edited cell comprises applying the consistent row format to the previously blank newly edited cell if the cell has only default formatting, wherein the default formatting excludes conditional formatting previously applied to the cell.
8. A computer readable medium having stored thereon computer-executable instructions which, when executed by a computer, cause the computer to perform a method for automatically extending a format to include a cell in an electronic spreadsheet, comprising the steps of:
determining that a previously blank newly edited cell is an extension to or within a list of cells;
automatically determining that the list of cells has a consistent format; and
automatically extending the consistent format to include the previously blank newly edited cell.
9. The computer readable medium of claim 8 , wherein the step of determining that a previously blank newly edited cell is an extension to a list of cells comprises:
determining that the previously blank newly edited cell is an extension of or within a colunm list comprising a plurality of previous cells above the previously blank newly edited cell, each having a first consistent data type; and
determining that the previously blank newly edited cell is an extension of or within a row list comprising a plurality of previous cells beside the previously blank newly edited cell, each having a second consistent data type.
10. The computer readable medium of claim 9 , wherein the step of determining that the list of cells has a consistent format comprises:
determining that the column list does not have a consistent column format; and
determining that the row list has a consistent row format; and
wherein the step of automatically extending the consistent format to the previously blank newly edited cell comprises applying the consistent row format to the previously blank newly edited cell if the cell has only default formatting excluding conditional formatting.