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

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 120149
           Summary: Calc gives wrong results
           Product: LibreOffice
           Version: 6.1.1.2 release
          Hardware: x86-64 (AMD64)
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: zieritz.andreas at gmail.com

Description:
I've imported a text file to calc, changed the default decimal delimiter
settings, and tried to sort the list. Problem is that the listing is done
alphanumerical, not numerical (10, 100, 20 instead of 10, 20, 100).

Tried to find out what was going on and did some calculations.
90 / 10 = 9; 100 / 10 = 10
But 9 > 10 = false, 90 > 100 = true

Steps to Reproduce:
1. Open file
2. Check calculations in row N69
3.

Actual Results:
90 > 100 = TRUE

Expected Results:
90 > 100 = FALSE


Reproducible: Always


User Profile Reset: No



Additional Info:

-- 
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/c35f892e/attachment.html>