[Karellen]

> 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?

[michaelmior]

> 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]

Try to compare version histories on hundred thousands row of google sheet. It's not a pleasant experience.

[michaelmior]

Absolutely. I'm just mentioning it because sometimes I forget that it even exists and it is better than nothing at all.

[mananaysiempre]

Only 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.