RE: [libreoffice-users] Do You Share ODF Documents With MS Office Users?

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:gbplinux@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+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