Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenSat, 09 May 2015 12:51:32 +0200Are standard functions in Calc defined by the Open Document Spreadsheet definition?https://ask.libreoffice.org/en/question/50426/are-standard-functions-in-calc-defined-by-the-open-document-spreadsheet-definition/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?Fri, 08 May 2015 16:18:14 +0200https://ask.libreoffice.org/en/question/50426/are-standard-functions-in-calc-defined-by-the-open-document-spreadsheet-definition/Comment by Lupp for <p>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. <br/>
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?</p>
https://ask.libreoffice.org/en/question/50426/are-standard-functions-in-calc-defined-by-the-open-document-spreadsheet-definition/?comment=50449#post-id-50449As 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.Sat, 09 May 2015 12:51:32 +0200https://ask.libreoffice.org/en/question/50426/are-standard-functions-in-calc-defined-by-the-open-document-spreadsheet-definition/?comment=50449#post-id-50449Answer by Regina for <p>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. <br/>
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?</p>
https://ask.libreoffice.org/en/question/50426/are-standard-functions-in-calc-defined-by-the-open-document-spreadsheet-definition/?answer=50441#post-id-50441Almost all functions are defined in the standard ODF 1.2 part 2 http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html 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.
Sat, 09 May 2015 01:12:18 +0200https://ask.libreoffice.org/en/question/50426/are-standard-functions-in-calc-defined-by-the-open-document-spreadsheet-definition/?answer=50441#post-id-50441Answer by rautamiekka for <p>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. <br/>
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?</p>
https://ask.libreoffice.org/en/question/50426/are-standard-functions-in-calc-defined-by-the-open-document-spreadsheet-definition/?answer=50429#post-id-50429I'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. Fri, 08 May 2015 17:16:16 +0200https://ask.libreoffice.org/en/question/50426/are-standard-functions-in-calc-defined-by-the-open-document-spreadsheet-definition/?answer=50429#post-id-50429Comment by Regina for <p>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. </p>
https://ask.libreoffice.org/en/question/50426/are-standard-functions-in-calc-defined-by-the-open-document-spreadsheet-definition/?comment=50442#post-id-50442The 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.Sat, 09 May 2015 01:20:07 +0200https://ask.libreoffice.org/en/question/50426/are-standard-functions-in-calc-defined-by-the-open-document-spreadsheet-definition/?comment=50442#post-id-50442