https://bugs.documentfoundation.org/show_bug.cgi?id=103419
Bug ID: 103419
Summary: Description of SWITCH function is missing info, has
confusing wording
Product: LibreOffice
Version: 5.2.0.0.alpha0+
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description of the SWITCH function in Calc is confusing, and also omits any
mention of the optional default ("else") value, cf.
https://support.office.com/en-us/article/SWITCH-function-47ab33c0-28ce-4530-8a45-d532ec4aa25e
I just tested that specifying a default value actually works as expected, it is
just not documented/mentioned in the function description as it should be.
Current wording: "Checks 1 or more values and returns a result corresponding to
the first value equal to the given expression."
Better wording: "Tests an expression against a list of values and returns the
result corresponding to the first value equal to the expression. Optionally, a
default value may be set, to be returned if none of the values match the
expression."
A new field should be added for the default value in the Functions wizard.
Description for "expression" field should be slightly changed as well.
Currently: "Value that will be compared against value1-valueN."
Better: "Value that will be compared against value1...value30." (to remove
possible ambiguity of the dash/minus sign)De
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
