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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
