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 <inpost@gmail.com>
To: users+help@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+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
Context
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.