[Libreoffice-commits] help.git: source/text
Steve Fanning (via logerrit)
logerrit at kemper.freedesktop.org
Sat May 30 13:40:54 UTC 2020
source/text/scalc/01/04060109.xhp | 6 +++---
1 file changed, 3 insertions(+), 3 deletions(-)
New commits:
commit 1bbe7266ac2f34852e5ac083380c1cad368b9d4e
Author: Steve Fanning <stevemfanning at yahoo.co.uk>
AuthorDate: Sat May 30 15:07:00 2020 +0200
Commit: Olivier Hallot <olivier.hallot at libreoffice.org>
CommitDate: Sat May 30 15:40:35 2020 +0200
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 at libreoffice.org>
diff --git a/source/text/scalc/01/04060109.xhp b/source/text/scalc/01/04060109.xhp
index 98463df3f..c35273cc3 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>
More information about the Libreoffice-commits
mailing list