OASIS Open Document Format for Office Applications (OpenDocument) TC

 View Only
  • 1.  openformula-test-20060221 uploaded

    Posted 10-04-2026 20:51
    Submitter's message
    Greetings!

    I am posting openformula-test-20060221.odt, an original submission by Dave Wheeler to the ODF TC. It may be helpful in answering some of the questions before the TC.

    Hope everyone is at the start of a great week!

    Patrick
    -- Patrick Durusau
    Document Name: openformula-test-20060221

    Description
    Test cases for openformula functions
    Download Latest Revision
    Public Download Link

    Submitter: Patrick Durusau
    Group: OASIS Open Document Format for Office Applications (OpenDocument) TC
    Folder: Miscellaneous
    Date submitted: 2026-10-05 00:50:53



    ---------------------------------
    Patrick Durusau
    Patrick Durusau (Personal)
    ---------------------------------


  • 2.  RE: openformula-test-20060221 uploaded

    Posted 10-05-2026 10:07

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