|
|
|
|
|
by speleding
3132 days ago
|
|
I agree with that. Modern software development has version control, unit tests, package managers, etc. Ideally we get support for some of those concepts in something that feels like a spreadsheet to the end user. (I'm not sure if it could ever be retrofitted to Excel) |
|
Some huge financial spreadsheets have sanity checks computations. With conditional coloring (turn this cell red if the sanity check fails) these can feel a lot like unit tests. However, these are mostly for business logic - so it's hard to see how a vendor could provide them.
In other words, it's not that excel doesn't have version control and unit tests - it's that the people who wrote excel spreadsheet sheets don't understand version control or unit tests.