Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

On 23/01/2013, Dennis E. Hamilton <> wrote:
ODF 1.0/1.1 did not specify a standard for spreadsheet formulas.  Formulas
were left implementation-specific.  Microsoft did not support the formulas.  Instead, they used Excel-specific
formulas in ODF 1.1. On input of a not-supported formula expression, Excel
in Office 2007 and 2010 drops the formula and preserves the last-calculated
value.  Whether a wise choice or not, that is what's done.

As Regina says, Office 2013 supports ODF 1.2, including its OpenFormula
specification.  OpenFormula is also used by current implementations of
LibreOffice and Apache OpenOffice when their documents are saved as ODF 1.2,
so there is interoperability of formulas shared between ODF 1.2 implementing

To clarify (without m$ 2013 to view), when a spreadsheet in LO is
created in the (default) version 12, a user with m$2013 will be able
to see formulae, whereas earlier versions e.g. m$2012 will shown only
the results of the formulae calculations.

Therefore, users should be encouraged to create new spreadsheets in
the native LO odf and encourage recipients to either: (a) use LO or
buy m$2013 in order to view openformula formulae or (b) view formulae
results _only_ in earlier legacy m$ software.

For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.