"openformula-test-20060221.odt"
That is in fact a spreadsheet. It seems upload of spreadsheets is still not allowed here.☹
I see these principle problems that would need to be addressed in a spreadsheet of test cases:
(1) Some calculations depend on the settings in table:calculation-settings (9.4.1, part 3), including case-sensitive and null-year, for example. There should be a hint for the user of the test suite about the expected settings.
(2) The decimal separator is locale dependent.
(3) Textual representation of boolean results are locale dependent.
(4) Date formats are locale dependent.
A basic set of tests would have to exclude locale dependent cases, I think. It might be necessary to bundle locale dependent tests in a separate test suite and notice the user of it, to switch to the specific locale if possible.
------------------------------
Regina Henschel
The Document Foundation
------------------------------