[libreoffice-l10n] Re: Excel and Calc Function Comparison List

Hi,

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: 
http://wiki.openoffice.org/wiki/Calc/Drafts/Treatment_of_new_Excel_2010_functions

Also, some newer functions are not yet described in 
https://help.libreoffice.org. For some comparisons, also the OO.o page 
on functions was helpful: 
http://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_Functions_listed_by_category

Best regards,
Gerry

Am 26.09.2013 23:05, schrieb Zeki Bildirici:
> Hi,
>
> 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,
> Zeki


--
To unsubscribe e-mail to: l10n+unsubscribe@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/l10n/
All messages sent to this list will be publicly archived and cannot be deleted