https://bugs.documentfoundation.org/show_bug.cgi?id=174020
Bug ID: 174020
Summary: function CHISQDIST is wrongly exported to xlsx
Product: LibreOffice
Version: 26.2.0.0 alpha0+ master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 209130
--> https://bugs.documentfoundation.org/attachment.cgi?id=209130&action=edit
Example file to test export to .xlsx
For LibreOffice, the CHISQDIST function is equivalent to the ODF function
CHISQDIST. However Excel has no CHISQDIST function but maps this ODF function
to CHISQ.DIST. Thus LibreOffice needs to write `_xlfn.CHISQ.DIST` instead of
the current `CHISQDIST`.
Open attached .ods file. Recalculate hard to be sure that the shown values are
indeed as calculated in LibreOffice.
Export the file to .xlsx format.
Open the exported file in a current Excel. Error: Excel cannot calculate the
formula in cell A2.
--
You are receiving this mail because:
You are the assignee for the bug.
