Bug 97366 - [HELP] "Use the functions without _ADD to get results based on international standards." is wrong. OR the description of CONVERT
Summary: [HELP] "Use the functions without _ADD to get results based on international ...
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: HelpGaps-NewFeatures
  Show dependency treegraph
Reported: 2016-01-25 18:19 UTC by Dennis Roczek
Modified: 2017-09-01 10:49 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Dennis Roczek 2016-01-25 18:19:12 UTC
"The functions whose names end with _ADD return the same results as the corresponding Microsoft Excel functions. Use the functions without _ADD to get results based on international standards. For example, the WEEKNUM function calculates the week number of a given date based on international standard ISO 8601, while WEEKNUM_ADD returns the same week number as Microsoft Excel."

from https://help.libreoffice.org/Calc/Add-in_Functions,_List_of_Analysis_Functions_Part_Two#CONVERT_ADD is party wrong. When removing _ADD from CONVERT_ADD (resulting in CONVERT) I get a currency changer. At least says this the ONLINEHELP at https://help.libreoffice.org/Calc/Mathematical_Functions#CONVERT

What is wrong? I think the latter from the description in the wizard...
Comment 1 Buovjaga 2016-01-28 16:49:55 UTC
Let's set to NEW.
Comment 2 Eike Rathke 2017-09-01 10:49:54 UTC
The specific CONVERT case has been fixed in master with http://cgit.freedesktop.org/libreoffice/help/commit/?id=5c2654302e9e4dcf45f802e8d31e53f55251c367
See also bug 69539.
For other the current "The functions whose names end with _ADD or _EXCEL2003" is correct.