<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED NOTABUG - Calc gives wrong results" href="https://bugs.documentfoundation.org/show_bug.cgi?id=120149#c10">Comment # 10</a> on <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED NOTABUG - Calc gives wrong results" href="https://bugs.documentfoundation.org/show_bug.cgi?id=120149">bug 120149</a> from <a class="email" href="mailto:zieritz.andreas@gmail.com" title="Andreas Zieritz <zieritz.andreas@gmail.com>"> Andreas Zieritz</a> <pre>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?</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>