There is a google spreadsheet document, changed by multiple people. I want to check full history of changes of specific cell.
There is an option "show edit history" - but it's not useful, because in situation of restoring version from history it starts with moment of restoring and information "This edit was a result of a restored past version".
An alternative i've found is check every version in history and manually look at changes in cell (or use bisection during looking into history to found moment of change).
I would like to be able seeing full history of changes in specific cell - for example D18. How to achieve that?
I consider automatic exporting document to csv and store history in git -but it need another separate process and some kind of infrastructure. Maybe there is better way to track changes?
To record changes to one or more cells from now on, use my logChanges_ script.
If you are a programmer, you get past revisions through the Drive API using the Revisions resource, but that requires a bit of coding. See How to get older versions of Google Spreadsheet data for sample code.