https://bugs.documentfoundation.org/show_bug.cgi?id=120149
--- Comment #10 from Andreas Zieritz <[email protected]> ---
Apparently there are 2 things going on here.
1.) Decimal delimiters
2.) Type of content
Apparently the contents of the cells are strings. The only way to see that is
checking View/Value Highlighting.
But then my first question is, why can I do calculation with strings at all? As
the calculations do show, I can divide the contents of the cell by 10, and do
the same logical test to those results. And voila - the result suddenly is
correct.
In my opinion, a string '+' of 10 + 10 should be 1010, and not 20, as it
actually does. So those operations do not behave like string operations, but
numeric ones.
But when it comes to > they do behave like string operations.
The other thing is that you should have a look at "Data/Text to columns...",
because I really would not understand what this function would do.
But ok, if I do open this function, I can choose e.g. column B. Column type
however gives me no choice to choose anything useful (standard, text, date).
Maybe I am missing something here.
Last thing: Wouldn't it be nice if LibreOffice used the Windows Decimal
Delimiter setting for Windows builds?
--
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
