Automatically adjusting spreadsheet formulas and/or formatting
First Claim
Patent Images
1. A computer-implemented method of automatically modifying a computerized information display, the method comprising:
- detecting, by a computing device, that a trigger has been activated, wherein the trigger indicates an updated row in a spreadsheet, and wherein the updated row is at a first indent level;
identifying, by the computing device, a set of peer rows of the updated row, wherein identifying the set of peer rows of the updated row comprises;
determining at least two existing rows of the spreadsheet other than the updated row that are also at the first indent level and are separated from each other by at least one row at a different indent level;
comparing at least one of row-level formatting, cell-level formatting, and formulas of the at least two existing rows to each other; and
in response to determining that at least one of the row-level-formatting, cell-level formatting, and formulas of the at least two existing rows match, designating the at least two existing rows as an identified set of peer rows of the updated row; and
modifying, by the computing device, the updated row based on at least one of a formula or formatting from the identified set of peer rows of the updated row.
2 Assignments
0 Petitions
Accused Products
Abstract
In some embodiments, a computer-implemented spreadsheet management method is provided that automatically copies formatting and formulas from appropriate peer rows to an updated row. In some embodiments, the method automatically determines which peer rows, if any, should be used as the source of copied formatting and formulas. In some embodiments, the method automatically fixes formulas that are affected by the updated row in order to maintain consistency throughout the spreadsheet.
19 Citations
18 Claims
-
1. A computer-implemented method of automatically modifying a computerized information display, the method comprising:
-
detecting, by a computing device, that a trigger has been activated, wherein the trigger indicates an updated row in a spreadsheet, and wherein the updated row is at a first indent level; identifying, by the computing device, a set of peer rows of the updated row, wherein identifying the set of peer rows of the updated row comprises; determining at least two existing rows of the spreadsheet other than the updated row that are also at the first indent level and are separated from each other by at least one row at a different indent level; comparing at least one of row-level formatting, cell-level formatting, and formulas of the at least two existing rows to each other; and in response to determining that at least one of the row-level-formatting, cell-level formatting, and formulas of the at least two existing rows match, designating the at least two existing rows as an identified set of peer rows of the updated row; and modifying, by the computing device, the updated row based on at least one of a formula or formatting from the identified set of peer rows of the updated row. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)
-
-
13. A nontransitory computer-readable medium having computer-executable instructions stored thereon that, in response to execution by one or more processors of a computing device, cause the computing device to perform actions for automatically modifying tabular data, the actions comprising:
-
detecting, by the computing device, that a trigger has been activated, wherein the trigger indicates an updated row in a spreadsheet, and wherein the updated row is at a first indent level; identifying, by the computing device, a set of peer rows of the updated row, wherein identifying the set of peer rows of the updated row comprises; determining at least two existing rows of the spreadsheet other than the updated row that are also at the first indent level and are separated from each other by at least one row at a different indent level; comparing at least one of row-level formatting, cell-level formatting, and formulas of the at least two existing rows to each other; and in response to determining that at least one of the row-level-formatting, cell-level formatting, and formulas of the at least two existing rows match, designating the at least two existing rows as an identified set of peer rows of the updated row; and modifying, by the computing device, the updated row based on at least one of a formula or formatting from the identified set of peer rows of the updated row. - View Dependent Claims (14, 15, 16, 17)
-
-
18. A computing device configured to display, store, and manage tabular data by performing actions comprising:
-
detecting that a trigger has been activated, wherein the trigger indicates an updated row in a spreadsheet, and wherein the updated row is at a first indent level; identifying a set of peer rows of the updated row, wherein identifying the set of peer rows of the updated row comprises; determining at least two existing rows of the spreadsheet other than the updated row that are also at the first indent level and are separated from each other by at least one row at a different indent level; comparing at least one of row-level formatting, cell-level formatting, and formulas of the at least two existing rows to each other; and in response to determining that at least one of the row-level-formatting, cell-level formatting, and formulas of the at least two existing rows match, designating the at least two existing rows as an identified set of peer rows of the updated row; and modifying the updated row based on at least one of a formula or formatting from the identified set of peer rows of the updated row.
-
Specification