Re: [libreoffice-users] how to tell m$ about ods formula behaviour failure

On 23/01/2013, Dennis E. Hamilton <dennis.hamilton@acm.org> 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: users+help@global.libreoffice.org
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