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

Without purchasing (subscribing for the Office 365 Home option) for Microsoft Office 2013, there is 
the option to use the Excel Web Application on Skydrive.  That's free and Skydrive will accept ODF 
1.2 Spreadsheet documents with their OpenFormula formulas.

-----Original Message-----
From: e-letter [mailto:inpost@gmail.com] 
Sent: Thursday, January 24, 2013 01:02
To: dennis.hamilton@acm.org
Cc: James Knott; LibreOffice
Subject: 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


-- 
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