Dynamic pattern recognition in spreadsheets
AssigneeMicrosoft Technology Licensing, LLC
InventorsEyal GABER, Nerya COHEN, Shani KABARITI
Life of this patent
Estimating the term…
Abstract
A computing device and method for dynamic pattern recognition in a spreadsheet. The computing device comprises an electronic processor and a display device. The electronic processor executing instructions to receive a data set including a tabular sample input data and tabular sample output data, extract a pattern associated with the data set based on parameters in an autocomplete function, apply the pattern associated with the data set on a source data using the autocomplete function to determine a result data, and dynamically update the result data in response to a change in the source data and display the updated result data on the display device.
Claims20
A computing device comprising:
- an electronic processor configured to
- receive a data set including a tabular sample input data and tabular sample output data;
- extract a pattern associated with the data set based on parameters in an autocomplete function;
- apply the pattern associated with the data set on a source data using the autocomplete function to determine a result data;
- using the pattern, dynamically update the result data in response to a change in the source data;
- and
- communicate the updated result data to a display device.
A method for updating a spreadsheet based on dynamic pattern recognition, the method comprising:
- receiving a data set including a tabular sample input data and tabular sample output data;
- extracting, with a pattern extractor, a pattern associated with the data set;
- applying the pattern associated with the data set on a source data using an autocomplete function to determine a result data;
- using the pattern, dynamically updating the result data in response to a change in the source data;
- and
- communicating the updated result data to a display device.
A non-transitory computer-readable medium storing instructions that, when executed with an electronic processor of a user device, perform a set of functions, the set of functions comprising:
- receiving a data set including a tabular sample input data and tabular sample output data;
- extracting, with a pattern extractor, a pattern associated with the data set;
- applying the pattern associated with the data set on a source data using an autocomplete function to determine a result data;
- using the pattern, dynamically updating the result data in response to a change in the source data;
- and
- communicate the updated result data to a display device.
Dependencies are inferred from the claim text.