[Libreoffice-bugs] [Bug 130583] switch() gives "wrong data type" error on reordering value-result pairs

[bugzilla-daemon at bugs.documentfoundation.org]

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

m.a.riosv <miguelangelrv at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |miguelangelrv at libreoffice.o
                   |                            |rg

--- Comment #3 from m.a.riosv <miguelangelrv at libreoffice.org> ---
It is not a matter of sort but data type.
In E:
=SWITCH(D3;"5";"a";1;"b";"2";"c";"3+4";"d") = b
"5" it's a number like D3

=SWITCH(D3&"";"1*";"a";1;"b";"2";"c";"3+4";"d") = b
D3&"" converts D3 in a text number.

looks the issue is searching for numbers (expression) on text (value1)

-- 
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/20200212/6db33b07/attachment.htm>