CPC G06F 8/38 (2013.01) [G06F 8/34 (2013.01); G06F 40/18 (2020.01); G06F 40/186 (2020.01)] | 28 Claims |
1. A computer implemented method comprising:
determining at least one primary data source within a spreadsheet, wherein the at least one primary data source corresponds to a first worksheet of the spreadsheet;
determining at least one secondary data source, wherein the at least one secondary data source corresponds to a different second worksheet;
determining a relationship between records of the primary data source and records of the secondary data source, wherein determining the relationship between the records of the primary data source and the records of the secondary data source comprises automatically detecting the relationship based on:
one or more characteristics of the first worksheet and the second worksheet, or
content of the records of the primary data source and content of the records of the second data source;
generating, automatically and based on the determined relationship, a third worksheet comprising at least a portion of the records of the primary data source and at least a portion of the records of the secondary data source, wherein content of the third worksheet is synchronized with content of the first worksheet and content of the second worksheet, and wherein a first row of the third worksheet comprises:
at least one first cell selected from the primary data source; and
at least one different second cell selected from the second data source based on the determined relationship and the at least one first cell;
receiving user input modifying a record of the third worksheet; and
updating at least one record of the secondary data source corresponding to the record of the third worksheet based on the received user input and based on the determined relationship.
|