[Libreoffice-bugs] [Bug 137135] New: [1] #VALUE Errors in IFS and SWITCH functions

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=137135

            Bug ID: 137135
           Summary: [1] #VALUE Errors in IFS and SWITCH functions
           Product: LibreOffice
           Version: 7.0.1.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: minor
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: vincent.glachant at gmail.com

Description:
Hi,

The Result of both IFS and SWITCH functions are #VALUE error for the second
result when the first result is an #VALUE error, even if the second result is
good and is the one that should be shown.

Steps to Reproduce:
1.Enter in a case:
2.=SWITCH(2;1;YEAR("");2;YEAR(41244);)
3.=SWITCH(2;1;IFS("tset";1);2;YEAR(41244))

Actual Results:
#VALUE

Expected Results:
2012 which is the RESULT of YEAR(41244)


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Version: 7.0.1.2 (x86)
Build ID: 7cbcfc562f6eb6708b5ff7d7397325de9e764452
CPU threads: 2; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default;
VCL: win
Locale: fr-FR (fr_FR); Langue IHM : fr-FR
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200929/7570f273/attachment-0001.htm>