Spreadsheets enable users to store and track values of a variable. To graph changes in values of a variable over time, a user typically stores in the spreadsheet values of the variable at different time points. Retaining all values in individual, visible cells of a spreadsheet can make the spreadsheet difficult to read and/or maintain.
Modern spreadsheet programs include features to track changes made to the cells of a spreadsheet, e.g., as a version history. The version history enables a user to revert to a prior version. Techniques of this disclosure enable programmatic access to historical values stored in the cells of a spreadsheet. The techniques eliminate the need for a user to explicitly store multiple values for a variable over a time period. Spreadsheets that implement the techniques enable users to generate a graph by programmatically accessing historical values of the variable in the spreadsheet.
Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 License.
Cohen, Tal, "Spreadsheets with programmatically accessible version history", Technical Disclosure Commons, (February 15, 2018)