Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


I had a thorough look at the first sheet "Excel vs. Calc" of the comparison list. You find my comments in the columns N,O,P. For some functions, I could not find a lot, though.

It was much more tricky than I thought, because Microsoft had changed quite a bit for Office 2010/2013 (because they realized that the precision of earlier Excel version was not that good as compared to Calc or Gnumeric) and added lots of new variants to old functions, often with the suffix ".precise" or ".rt". Here, the question is how good they can be mapped to LibreOffice Calc. This document gives quite some information, although it is outdated and just a draft:

Also, some newer functions are not yet described in For some comparisons, also the OO.o page on functions was helpful:

Best regards,

Am 26.09.2013 23:05, schrieb Zeki Bildirici:

Finally i have completed the list. I've already sent it to Gerry who
helped me to review the first version. Also having your help will be
very good.

The list now contains the following sheets

- Excel vs Calc comparison list
- NEW FUNCTIONS OF CALC which is extracted by (thanks to) Eike from
the most recent build and are not present in the last published
appendix of calc guide
- CALC UNIQUE FUNCTIONS which are not available in Excel
- EXCEL UNIQUE FUNCTIONS which are not available in Calc (which can be
used to submit requests to bugzilla to have)

There may be similar functions like -i think- EFFECT and EFFECTIVE
neds to be spootted...

Best regards,

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


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.