Bug Hunting Session
Bug 103419 - Description of SWITCH function is missing info, has confusing wording
Summary: Description of SWITCH function is missing info, has confusing wording
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
Version:
(earliest affected)
5.2.0.0.alpha0+
Hardware: All All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: HelpGaps-NewFeatures
  Show dependency treegraph
 
Reported: 2016-10-22 21:38 UTC by Mihkel Tõnnov
Modified: 2017-04-22 00:17 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 Mihkel Tõnnov 2016-10-22 21:38:04 UTC
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
Comment 1 Mihkel Tõnnov 2016-10-22 21:41:33 UTC
The SWITCH function was added in bug #97831 - added as "see also".
Comment 2 Mihkel Tõnnov 2016-10-22 21:44:26 UTC
Help page request for SWITCH, among others, at bug #99517.
Comment 3 Joel Madero 2016-10-23 19:44:27 UTC
Seems like a perfectly valid suggestion.