https://bugs.documentfoundation.org/show_bug.cgi?id=153206
Bug ID: 153206
Summary: Calc sort order wrong
Product: LibreOffice
Version: 7.4.4.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I enter a bunch of strings in cells, some are numbers, some aren’t, since they
contain a range expressed by "/". I mark the cells as text. Sorting them
gives strange result: most are in correct order, but some aren’t. Changing
sort order or settings does not make a difference.
Steps to Reproduce:
1. enter some numbers in cells, and some article number like number-letter
combinations
2. mark all as text (optional)
3. sort by clicking the relevant button or via the menu
One screenshot is from a Windows PC (the longer one), another from a Linux.
Actual Results:
see screenshots
Expected Results:
Since they are marked as text, I expect them to be sorted lexicographically.
Reproducible: Always
User Profile Reset: No
Additional Info:
Did not reset user profile, but seen on multiple computers.
--
You are receiving this mail because:
You are the assignee for the bug.