On 23/01/2013, Dennis E. Hamilton <[email protected]> wrote: > ODF 1.0/1.1 did not specify a standard for spreadsheet formulas. Formulas > were left implementation-specific. Microsoft did not support the > OpenOffice.org-specific 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 > software. >
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: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
