Is it really not possible to write unit tests for a spreadsheet with Office Script?
> and have a formula accidentally replaced by a static number on line 87456
Surely this specific case could be validated externally with a script too.
> and have a formula accidentally replaced by a static number on line 87456
Surely this specific case could be validated externally with a script too.
But there is no built-in tool you can use to say to excel "this column must always be a number, don't ever allow it to be autodetected as a date" or "this column must always have a formula, if the formula doesn't exist or is a static number, alert the user".
You can lock cells, but who bothers doing that in the real world.
If some user wants to view it, then the script can create a valid Excel file.