We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Are standard functions in Calc defined by the Open Document Spreadsheet definition? [closed]

asked 2015-05-08 16:18:14 +0200

bencomp gravatar image

updated 2021-06-06 11:51:29 +0200

Alex Kemp gravatar image

For the sake of document longevity, I was wondering if the functions in Calc are defined by any standards or that they are specific to the implementation of LibreOffice (and/or OpenOffice). If they are, it should not matter with what software (version) formulas in spreadsheets are written.
If they are not standard functions, or if not all functions are standardised, how can users ensure formula output is usable across ODS implementations and durable over the longer term?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-21 11:24:18.238313


As Regina told! But there are possibly flaws in the implementation that will be fixed some day changing the behaviour of a formula depending on the "erroneous" variant. There are also some specifications I would judge unclear. And there are some standard functions specified explicitly allowing for implementation dependent behaviour. You might need to study the relevant parts of the document Regina linked to.

Lupp gravatar imageLupp ( 2015-05-09 12:51:32 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2015-05-09 01:12:18 +0200

Regina gravatar image

Almost all functions are defined in the standard ODF 1.2 part 2 http://docs.oasis-open.org/office/v1.... Only few functions, e.g. EASTERSUNDAY, are special functions of LibreOffice/OpenOffice.

For a longtime archive you should not use .ods file format but PDF/A-1a.

edit flag offensive delete link more

answered 2015-05-08 17:16:16 +0200

I'm sure no standard has anything to do with the functions. Instead, the formulas are saved in the file as is and the program executes them.

edit flag offensive delete link more



The formulas are saved together with the current values, so when opening a document 'read-only' you see the values of the producer. In newer versions of LibreOffice you have a special option in Tools > Options > Calc > Formula to disable the recalculating on opening.

Regina gravatar imageRegina ( 2015-05-09 01:20:07 +0200 )edit

Question Tools

1 follower


Asked: 2015-05-08 16:18:14 +0200

Seen: 233 times

Last updated: May 09 '15