US 12,456,006 B2
Copy-paste triggered formula generation
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,745.
Prior Publication US 2022/0229975 A1, Jul. 21, 2022
Int. Cl. G06F 17/00 (2019.01); G06F 40/18 (2020.01); G06F 40/205 (2020.01); G06F 40/237 (2020.01)
CPC G06F 40/18 (2020.01) [G06F 40/205 (2020.01); G06F 40/237 (2020.01)] 15 Claims
OG exemplary drawing
 
1. A system, comprising:
an interface configured to:
copy a text string value of a first cell of a paste-from data set into a first cell of a paste-to data set, wherein:
the paste-from data set and the paste-to data set are arranged in rows and columns;
a portion of the paste-to data set in a same row and to the left of the first cell of the paste-to data set is related to the first cell of the paste-to data set; and
a portion of the paste-from data set in the same row as the first cell of the paste-from data set is related to the first cell of the paste-from data set; and
a processor configured to:
determine whether there is an exact text string match between any cell value from the portion of the paste-from data set and any cell value from the portion of the paste-to data set;
in response to a determination that there is not an exact text string match:
select a selected cell of the portion of the paste-from data set, wherein the selected cell comprises a second text string value;
determine a lexicon from the portion of the paste-to data set; and
determine whether there is an efficient formula for the selected cell, wherein the efficient formula generates the second text string value using the lexicon; and
in response to a determination that there is the efficient formula, provide the efficient formula to a formula cell of the paste-to data set; and
a memory coupled to the processor and configured to provide the processor with instructions.