Ask Your Question
0

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

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

bencomp 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 close merge delete

Comments

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
2

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
0

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

Comments

1

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 143 times

Last updated: May 09 '15