[Libreoffice-commits] help.git: Branch 'libreoffice-6-3' - source/text

[Olivier Hallot (via logerrit)]

 source/text/scalc/01/func_switch.xhp |    2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit 8e34671f7dc259bac69350f8cf6d0ec0cbfad7c1
Author:     Olivier Hallot <olivier.hallot at libreoffice.org>
AuthorDate: Fri Jul 12 16:34:34 2019 +0200
Commit:     Eike Rathke <erack at redhat.com>
CommitDate: Thu Sep 5 16:38:51 2019 +0200

    Clarify Example for SWITCH
    
    
    But the function need a date in A3 instead of a number.
    So in my opinion the string should be:
    
    <input>=SWITCH(MONTH(A3),1,"January",2,"February",3,"March","No match")</input> returns "January" when A3 contains a date in January, "February" when A3 contains a date in February , etc...
    
    Change-Id: I2702d569f1c43080cd4c137a4d100111edc55863
    Reviewed-on: https://gerrit.libreoffice.org/75500
    Tested-by: Jenkins
    Reviewed-by: Sophie Gautier <gautier.sophie at gmail.com>
    Reviewed-by: Eike Rathke <erack at redhat.com>

diff --git a/source/text/scalc/01/func_switch.xhp b/source/text/scalc/01/func_switch.xhp
index 36178c1be..84a5b365a 100644
--- a/source/text/scalc/01/func_switch.xhp
+++ b/source/text/scalc/01/func_switch.xhp
@@ -33,7 +33,7 @@
     <paragraph role="paragraph" id="par_id331556245422283"><emph>default_result</emph>: any value or reference to a cell that is returned when there is no match.</paragraph>
     <paragraph role="paragraph" id="par_id871556243022881">If no <emph>value</emph> equals <emph>expression</emph> and no default result is given, a #N/A error is returned.</paragraph>
     <embed href="text/scalc/01/ful_func.xhp#func_head_example"/>
-    <paragraph role="paragraph" id="par_id851556243961783"><input>=SWITCH(MONTH(A3),1,"January",2,"February",3,"March","No match")</input> returns "January" when A3=1, February when A3=2 , etc...</paragraph>
+    <paragraph role="paragraph" id="par_id851556243961783"><input>=SWITCH(MONTH(A3),1,"January",2,"February",3,"March","No match")</input> returns "January" when A3 contains a date in January, "February" when A3 contains a date in February, etc.</paragraph>
     <section id="relatedtopics">
         <embed href="text/scalc/01/func_ifs.xhp#ifsfunct"/>
         <paragraph role="paragraph" id="par_id781556244709752"><link href="text/scalc/01/04060105.xhp#Section4" name="if">IF</link></paragraph>