CPC G06F 40/18 (2020.01) [G06F 40/284 (2020.01)] | 17 Claims |
1. A method, comprising:
receiving a user input string for a data cell;
determining, using a processor, a lexicon from data related to the data cell;
determining a possible formula from the lexicon, wherein the possible formula is in a spreadsheet language, and wherein the possible formula comprises a substring of the user input string not matched to the data related to the data cell, wherein the determining of the possible formula from the lexicon comprises:
setting a first substring of the user input string that exactly matches a first value of the lexicon as a longest value;
determining a second substring of the user input string that exactly matches a second value of the lexicon; and
replacing the first substring with the second substring as the longest value in response to a determination that the second substring is longer than the first substring;
providing the possible formula for display to a formula cell as a displayed possible formula;
receiving an indication to select the displayed possible formula; and
in response to receiving the indication to select the displayed possible formula, applying the possible formula to the data cell.
|