[Libreoffice-bugs] [Bug 120149] Calc gives wrong results

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #10 from Andreas Zieritz <zieritz.andreas at gmail.com> ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180927/6e13661b/attachment.html>