https://bugs.freedesktop.org/show_bug.cgi?id=70797
Priority: medium
Bug ID: 70797
Assignee: [email protected]
Summary: Direct function mapping between Excel 2010+ & Calc for
CHISQ.TEST, Floor.precise, Ceiling.precise,
CHISQ.INV.RT, CHISQ.DIST.RT, and more
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.1.1.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 88030
--> https://bugs.freedesktop.org/attachment.cgi?id=88030&action=edit
New-Excel2010-functions-causing-error-in-Calc.xlsx
Excel 2010 introduced a couple of functions, aiming to improve precision of
existing functions and to replace them in the long run. Of some of these new
functions, LibreOffice has equivalents and direct mapping between Excel and
Calc is possible (see
(http://wiki.openoffice.org/wiki/Calc/Drafts/Treatment_of_new_Excel_2010_functions),
but this mapping is not yet implemented.
I tested some of these functions for those direct mapping is possible. How to
reproduce:
Please have a look at attached Excel sheet (workbook
"Functions-requiring-arrays" and workbook "Functions-requiring-two-values") and
import it in Calc. Just change the source values and Calc will recalculate the
formulas showing errors on all new Excel 2010 functions.
I tested the import/export with:
CHITEST (O.K.,old function)
CHISQ.TEST (-> ERROR, although direct mapping possible)
Floor (O.K.,old function)
Floor.precise (-> ERROR, although direct mapping possible)
Ceiling (O.K.,old function)
Ceiling.precise (-> ERROR, although direct mapping possible)
CIINV (O.K.,old function)
CHISQ.INV.RT (-> ERROR, although direct mapping possible)
CHIDIST (O.K.,old function)
CHISQ.DIST.RT (-> ERROR, although direct mapping possible)
There are some other new functions in Excel 2010 which I did not test. You find
them listed here:
http://wiki.openoffice.org/wiki/Calc/Drafts/Treatment_of_new_Excel_2010_functions
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
