https://bugs.documentfoundation.org/show_bug.cgi?id=94214
Bug ID: 94214
Summary: Function FINV exported as "COM.MICROSOFT.F.INV"
although it is spec'ed in OpenFormula
Product: LibreOffice
Version: 5.0.1.2 release
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
There are 4 related functions in Excel and LibreOffice, all of them specified
in Open Formula 1.2:
1) Excel's "FDIST" is OpenFormula's "LEGACY.FDIST", shown in the UI as "FDIST"
(XL and LO).
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#LEGACY_FDIST
2) Excel's "_xlfn.F.DIST" is OpenFormula's "FDIST", shown in the UI as "F.DIST"
(XL and LO).
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#FDIST
3) Excel's "FINV" is OpenFormula's "LEGACY.FINV", shown in the UI as "FINV" (XL
and LO).
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#LEGACY_FINV
4) Excel's "_xlfn.F.INV" is OpenFormula's "FINV", shown in the UI as "F.INV"
(XL and LO).
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#FINV
However: LibreOffice writes the UI function "F.INV" (4) as
"COM.MICROSOFT.F.INV" instead of "FINV", which is inconsistent to "F.DIST" (2)
written out as "FDIST", and not according to the OF spec.
This may be considered nitpicking... :) But may become a compatibility issue
with other spreadsheet applications claiming to supprt OF 1.2.
--
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
