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:inp...@gmail.com] Sent: Thursday, January 24, 2013 01:02 To: dennis.hamil...@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.hamil...@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+h...@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+h...@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