You want an older version to support all new features.
That's not possible unless you just change the ui on each version.
Re:Why Enterprise Software Sucks
by earthboundkid on Friday October 11, 2019 @11:33AM
(#21225344)
If you're going to break compatibility, at least fucking fix the dates.
Re:Why Enterprise Software Sucks
by tomatocracy on Saturday October 12, 2019 @02:58PM
(#21235387)
It’s not new features. Sometimes for no particular reason, a sheet which uses no new features isn’t backwards compatible.
In any event, it should be able to fail gracefully ie still load the sheet but not be able to calculate cells using new features and show a warning.
- lack of forwards compatibility. When someone sends you an Excel 2016 file and you’re stuck on Excel 2013 because your corporate hasn’t upgraded yet, it’s a total PITA.
- weird bugs. Sometimes spreadsheets can get corrupted in weird ways so that they crash Excel and there’s nothing you can do about it and no way to fix it. Sometimes these bugs only appear on certain versions of Excel
- lack of decent built in formula tracing (ie something which brings up a dialogue and you can click through each reference in a formula browsing back and forth and going up and down the dependency tree). There are a few third party add one that do this but it really should be built in.
- lack of a decent way to see what’s changed between two versions of a spreadsheet
I’d also say there’s an inordinate amount of abusing Excel to do database tasks out there. People have spreadsheets which take minutes to recalculate which could be done in less than a second even using Access, let alone a ‘proper’ DB.