Hi :) MS Office uses ODF 1.1 not 1.2. The 1.1 had some troubles with retaining formulas. The answer in LibreOffice and other office programs is to use the 1.2 which they have mostly been using for many years now. The MSO answer is to buy their new MSO 2013.
I thought the original problem in this question was that saving in XlsX and then re-opening in LibreOffice caused problems. So the bug-report is about that and the advice was to avoid using that format. Originals in Ods and temporary copies for sharing in Xls (the older MSO format). That advice about which format to use for sharing is for sharing is generally applicable even when using MSO and sharing with another MSO user, Regards from Tom :) >________________________________ > From: e-letter <inp...@gmail.com> >To: users+h...@global.libreoffice.org; users@global.libreoffice.org >Sent: Wednesday, 23 January 2013, 10:07 >Subject: [libreoffice-users] how to tell m$ about ods formula behaviour failure > >Readers, > >Despite the opinion of the original poster >(https://bugs.freedesktop.org/show_bug.cgi?id=38113), the loss in >information is not the fault of LO, but m$, who claim not to support >such compatibility >(http://office.microsoft.com/en-za/excel-help/differences-between-the-opendocument-spreadsheet-ods-format-and-the-excel-xlsx-format-HA010355787.aspx). > >In the "differences" web page published by m$, it is also claimed that >formulas are supported. > >When a spreadsheet was created in LO (of course to the native ods >format, because we are not using LO as a free m$ clone and saving >documents to m$ formats, but instead using ods to promote odf, aren't >we??? ;) ), after opening in m$ excel 2010 (yes, m$ can open ods >spreadsheets, so use that format please!!!) , the formulas were lost, >leaving only the result values in the spreadsheet cells. > >Instead of reporting another erroneous LO bug, does someone know how >to forward this error with m4 excel 2010 to m$ bug reporting service? > >Thanks. > >-- >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
