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.

Reply via email to