https://bugs.documentfoundation.org/show_bug.cgi?id=130583
m.a.riosv <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected]
| |rg
--- Comment #3 from m.a.riosv <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
