Bug 94537 - com.microsoft.foo functions are not correctly documented to the user.
Summary: com.microsoft.foo functions are not correctly documented to the user.
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.0.0.alpha0+ Master
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: HelpGaps-NewFeatures
  Show dependency treegraph
 
Reported: 2015-09-26 21:12 UTC by Regina Henschel
Modified: 2017-07-23 21:56 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Regina Henschel 2015-09-26 21:12:20 UTC
A lot of functions are added to become more compatible to Microsoft Excel. They are written to file in the kind of "of:com.microsoft.foo". These functions do not belong to ODF1.2 but they are extensions done by LibreOffice.
 
Section 2.3.1 list item D in ODF 1.2 part 2 say, "Applications should clearly document their extensions in their user documentation, both online and paper, in a manner so users would be likely to be aware when they are using a non-standard extension."

Such documentation is missing for the com.microsoft.foo kind of functions. For example the functions STDEVP and STDEV.P have identical help texts. The user gets no hint that STDEVP is written as 'STDEVP' and is defined in ODF1.2, and that STDEV.P is written as 'COM.MICROSOFT.STDEV.P' and is not defined in ODF1.2. That is a large interoperability problem.
Comment 1 Eike Rathke 2015-09-28 14:06:43 UTC
The OpenFormula extensions are documented in https://wiki.documentfoundation.org/Development/ODF_Implementer_Notes/List_of_LibreOffice_OpenFormula_Extensions

However, I agree we should have better / add more detailed information to the Function Wizard and/or online/wiki help.