US 11,989,503 B2
Formula generation by example
William James Murphy, Boulder, CO (US); and Leonard Karpel, Boulder, CO (US)
Assigned to Workday, Inc., Pleasanton, CA (US)
Filed by Workday, Inc., Pleasanton, CA (US)
Filed on Jan. 20, 2021, as Appl. No. 17/153,741.
Prior Publication US 2022/0229974 A1, Jul. 21, 2022
Int. Cl. G06F 17/00 (2019.01); G06F 40/18 (2020.01); G06F 40/284 (2020.01)
CPC G06F 40/18 (2020.01) [G06F 40/284 (2020.01)] 17 Claims
OG exemplary drawing
 
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.