No, it was a mistake. The ODF 1.0 and ODF 1.1 standards did not provide a specification for spreadsheet formulas, so what OpenOffice implemented was implementation-specific and the Office team decided, with some public consultation, to not attempt to match OpenOffice, but to work within the ODF Standard. Hence the formula support was also implementation-specific (they used a namespace that defined Excel formulas) and there was no interop between Office and OpenOffice.
However, now that there is ODF 1.2 and OpenFormula, you'll be happy to know that Office 2013 Preview supports OpenFormula in reading and saving ODS in Excel. You can test this by using SkyDrive with the Office Preview Web Apps. - Dennis -----Original Message----- From: Gordon Burgess-Parker [mailto:gbpli...@gmail.com] Sent: Tuesday, July 24, 2012 11:43 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Do You Share ODF Documents With MS Office Users? On 24/07/12 15:38, Chuck Davis wrote: > Cost them some money for new licenses but they upgraded their MS licenses > to read my > files. > You need to be aware that MS Office 2010, while it will read ods files, strips out ALL the formulae - just leaving the last value. Yeah, sure, MS Office "reads" odf format.....seems like a deliberate ploy to me. -- 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
