Formatting data by example
First Claim
1. A method for formatting data based on edits, comprising:
- determining whether the edits have been made to a plurality of items within a first range of a document, wherein the plurality of items within the first range are related by a similar formatting, wherein the edits provide input examples of application of data formatting, and wherein the first range is located in a first column;
in response to determining that the edits have been made to the plurality of items within the first range of the document and that the edits provide the input examples of application of data formatting;
creating a data formatting rule based on the input examples for application to other items having the similar formatting within a second range of the document;
automatically applying the data formatting rule to the other items having the similar formatting within the second range of the document;
wherein when the first range is located in the first column, the second range is located in a second column offset at least one column from the first column; and
displaying the other items reflecting the application of the data formatting rule.
3 Assignments
0 Petitions
Accused Products
Abstract
Data formatting rules to convert data from one form to another form are automatically determined based on a user'"'"'s edits. A machine learning heuristic is applied to a user'"'"'s edits to determine a data formatting rule that may be applied to data. For example, a user may make edits that add/remove characters from data, concatenate data, extract data, rename data, and the like. The machine learning heuristic may be automatically triggered in response to an event (e.g. after a predetermined number of edits are made to a same type of data) or manually triggered (e.g. selecting a user interface option). The data formatting rule may be applied to other data and the results of the formatting reviewable by the user. Based on further edits/reviews, the data formatting rule may be updated. The data formatting rules may be stored for later use.
-
Citations
20 Claims
-
1. A method for formatting data based on edits, comprising:
-
determining whether the edits have been made to a plurality of items within a first range of a document, wherein the plurality of items within the first range are related by a similar formatting, wherein the edits provide input examples of application of data formatting, and wherein the first range is located in a first column; in response to determining that the edits have been made to the plurality of items within the first range of the document and that the edits provide the input examples of application of data formatting; creating a data formatting rule based on the input examples for application to other items having the similar formatting within a second range of the document; automatically applying the data formatting rule to the other items having the similar formatting within the second range of the document; wherein when the first range is located in the first column, the second range is located in a second column offset at least one column from the first column; and displaying the other items reflecting the application of the data formatting rule. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. A computer-readable storage medium, excluding a signal, storing computer-executable instructions for formatting data based on examples, comprising:
-
determining output examples from a first plurality of items within an output range of a spreadsheet document, wherein the output range is a column or a row, and wherein each item of the first plurality of items includes output data; determining input examples from a second plurality of items within an input range of the spreadsheet document, wherein the input range does not include the output range, and wherein each item of the second plurality of items includes input data, wherein the input examples are determined based on the output data and the input data sharing a relationship associated with an application of data formatting; automatically creating a data formatting rule based on the relationship between the output examples and the input examples; automatically applying the data formatting rule to other items within the output range of the spreadsheet document that do not include data prior to applying the data formatting rule; wherein the data formatting rule selects the input data from the input range and formats the input data according to the relationship to create formatted data to include in the other items; and displaying the other items reflecting the application of the data formatting rule. - View Dependent Claims (10, 11, 12, 13, 14)
-
-
15. A system for formatting data based on edits, comprising:
-
a network connection that is configured to connect to a network; a processor, memory, and a computer-readable storage medium, excluding a signal; an operating environment stored on the computer-readable storage medium and executing on the processor; a display; a spreadsheet application; a spreadsheet provided by the spreadsheet application, wherein the spreadsheet comprises items that are arranged in rows and columns; and a formatting manager operating in conjunction with the spreadsheet application that is configured to perform actions comprising; determining whether the edits have been made to a first plurality of items within a first range of the spreadsheet comprises one of a first column or a first row, wherein each item of the first plurality of items includes data, and wherein the edits provide input examples of a data formatting rule applied to the data of the first plurality of items; automatically applying the data formatting rule to a second plurality of items within a second range of the spreadsheet that include other data having a same data type as the data of the first plurality of items, wherein when the first range comprises the first column, the second range comprises one or more columns offset from the first column by at least one column, and wherein when the first range comprises the first row, the second range comprises one or more rows offset from the first row by at least one row; wherein an application of the data formatting rule formats the other data included in the second plurality of items to a format as defined by the edits made to the first plurality of items; and displaying the other data included in the second plurality of items on the display reflecting the application of the data formatting rule. - View Dependent Claims (16, 17, 18, 19, 20)
-
Specification