Created attachment 112958 [details]
In the Function Wizard,If Function usage.
In the function wizard,IF Function usage is =IF(Logical expression,TRUE if,
In CALC Help,IF Function usage is =IF(Test;Thenvalue;OtherwiseValue).
I think I should be standardized to comma.
ex.1) Pootle 4.4Help.
IF(Test; ThenValue; OtherwiseValue) --> IF(Test, ThenValue , OtherwiseValue)
ex.2) Pootle 4.4Help.
<item type="input">=IF(A1>5;100;"too small")</item> If the value in A1 is higher than 5, the value 100 is entered in the current cell; otherwise, the text “too small” (without quotes) is entered.
<item type="input">=IF(A1>5,100,"too small")</item> If the value in A1 is higher than 5, the value 100 is entered in the current cell; otherwise, the text “too small” (without quotes) is entered.
Created attachment 112959 [details]
In CALC Help,IF Function usage.
Let me confirm, it's not only IF function description problem, but "ANY" calc functions have same policy-mismatching, so we need to change policy to use comma "," instead of semicolon (";") in HELP, right?
Hi. Naruhiko Ogasawara.
I think also "ANY" calc functions change policy to use comma "," instead of semicolon (";") in HELP.
Is this report related to your localization only? In English locale, I see semicolons in both UI and help and I think they are correct as semicolon is the default argument separator in Calc.
NEEDINFO per comment 4.
I had to try it LBO5.0.0Beta1.
(ex IF function wizard - and press 'HELP')
A.locate setting english(US)
UI: if(Test,The_value,Otherwise_value) (comma)
Help: Syntax IF(Test; ThenValue; OtherwiseValue) (semicolone)
*Description of Syntax does not match. alao japan.
B.locate setteing german
UI: WENN( prufung; Dann_Wert; Sonst_Wert) (semicolone)
Help: Syntax WENN(prufung; DannWert; SonstWert) (semicolone)
C.locate setteing France
UI: SI(Test; Valeur;si_vrai;Valeur_si_faux) (semicolone)
Help: SI(test;alors_baleur;sinon_baleur) (semicolone)
Created attachment 116126 [details]
english(US) UI IF function wizard
Created attachment 116127 [details]
english(US) UI-help IF function wizard
OK, I see your point now. You are right that the default argument separator for English locale setting is comma, whereas syntaxes in English Help use semicolons. (So my previous comment was wrong.)
I guess there used to be semicolon as default for all locales (and the Help was written for it), but then it has been changed to comma in the English locale to correspond with Excel (?).
Anyway, in my opinion the change of help would be so huge and would have so bad side effects (need for translations) that it is not worth even think about it:))
Dear Bug Submitter,
This bug has been in NEEDINFO status with no change for at least
6 months. Please provide the requested information as soon as
possible and mark the bug as UNCONFIRMED. Due to regular bug
tracker maintenance, if the bug is still in NEEDINFO status with
no change in 30 days the QA team will close the bug as INVALID
due to lack of needed information.
For more information about our NEEDINFO policy please read the
wiki located here:
If you have already provided the requested information, please
mark the bug as UNCONFIRMED so that the QA team knows that the
bug is ready to be confirmed.
Thank you for helping us make LibreOffice even better for everyone!
The bugreport is clarified now - set to NEW.
Changed summary to reflect that there is a general inconsistency in argument separators between UI and Help.
See also this related thread:
*** Bug 98609 has been marked as a duplicate of this bug. ***
*** Bug 89166 has been marked as a duplicate of this bug. ***
The actual function parameter separator used depends on the locale and the settings under Tools-Options-Calc-Formula. However, the (default English) Calc help uses semicolon and that also works, regardless of which separator is actually set. Also, the help is not necessarily translated into all locales and a semicolon is much less confusing than any other separator. So rather stick with the semicolon in help than having examples that for some locales or settings don't work just because the help isn't translated. Letting the help reflect the actual separator used will likely not be implemented, specifically not with the help being also available as a wiki version.
I'm closing this as wontfix.