4 ms·
> Making wide changes becomes hard/impossible To add to this - no revision control. OK, maybe you can store your spreadsheets in a RCS, but can you get diffs
by Karellen 3y ago
> Making wide changes becomes hard/impossible
To add to this - no revision control.
OK, maybe you can store your spreadsheets in a RCS, but can you get diffs of the changes, so you can confirm the revision you're about to push is what you meant to do? Can you review the history of diffs, so you can see how the system has changed over time? If multiple people make changes, can you do a merge? Do you even have a separate "working copy" where you can try stuff out, or are you just editing the production copy with no safety harness?
- mananaysiempre 3y agoOnly thinking of this now, but a flat OpenDocument shreadsheet (“FODS”, a single XML file, unlike the usual XMLs-in-ZIP flavor) should actually be amenable to text-based version control.
- michaelmior 3y ago> no revision control I'm not claiming this is a sufficient solution, but Google Sheets does keep a version history and you can see changes. Doesn't solve the problem of working copies and merging though.
- fendy3002 3y agoTry to compare version histories on hundred thousands row of google sheet. It's not a pleasant experience.
- michaelmior 3y agoAbsolutely. I'm just mentioning it because sometimes I forget that it even exists and it is better than nothing at all.