diff options
| author | Steve Fanning <stevemfanning@yahoo.co.uk> | 2020-05-30 15:07:00 +0200 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2020-05-30 15:40:35 +0200 |
| commit | 1bbe7266ac2f34852e5ac083380c1cad368b9d4e (patch) | |
| tree | 32c71144a27ec12f50ed1ee4304f3a3ad0f6cd4d | |
| parent | 69ce0305af2d911457274e4889334b335640c5da (diff) | |
The change to the CHOOSE function needs to be re-worked (as advised by Eike Rathke). TDF #95124 has very recently fixed a bug in Calc's Function Wizard. CHOOSE() supports only 30 jump targets, and this should now be limited in the dialog. Update Help again to reflect this correction.
Change-Id: I5591e36dc69301b5a6a22a22d35d4ae27b5b2459
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95193
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
| -rw-r--r-- | source/text/scalc/01/04060109.xhp | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/source/text/scalc/01/04060109.xhp b/source/text/scalc/01/04060109.xhp index 98463df3f1..c35273cc37 100644 --- a/source/text/scalc/01/04060109.xhp +++ b/source/text/scalc/01/04060109.xhp @@ -436,11 +436,11 @@ <h2 id="hd_id3150430">CHOOSE</h2> <paragraph xml-lang="en-US" id="par_id3143270" role="paragraph"><ahelp hid="HID_FUNC_WAHL">Uses an index to return a value from a list of up to 30 values.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id3155425" role="code">CHOOSE(Index; Value1 [; Value2 [; ... [; Value254]]])</paragraph> + <paragraph xml-lang="en-US" id="par_id3155425" role="code">CHOOSE(Index; Value 1 [; Value 2 [; ... [; Value 30]]])</paragraph> <paragraph xml-lang="en-US" id="par_id3144755" role="paragraph"> - <emph>Index</emph> is a reference or number between 1 and 254 indicating which value is to be taken from the list.</paragraph> + <emph>Index</emph> is a reference or number between 1 and 30 indicating which value is to be taken from the list.</paragraph> <paragraph xml-lang="en-US" id="par_id3149939" role="paragraph"> - <emph>Value1, Value2, ..., Value254</emph> is the list of values entered as a reference to a cell or as individual values.</paragraph> + <emph>Value 1, Value 2, ..., Value 30</emph> is the list of values entered as a reference to a cell or as individual values.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph xml-lang="en-US" id="par_id3150625" role="paragraph"> <item type="input">=CHOOSE(A1;B1;B2;B3;"Today";"Yesterday";"Tomorrow")</item>, for example, returns the contents of cell B2 for A1 = 2; for A1 = 4, the function returns the text "Today".</paragraph> |