https://bugs.documentfoundation.org/show_bug.cgi?id=151009
Bug ID: 151009
Summary: Sorting, oCellRange.Sort(oSortDesc()), 3 columns by
column#2 but column#3 sorted
Product: LibreOffice
Version: 7.3.2.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Description:
Column#1 & 2 are numeric, column#3 alphanumeric. When sorting by column#2 using
a sort range of the 3 coulumns, column#3 is sorted. If the sort range is 2
columns, column2 is sorted.
Steps to Reproduce:
1.Create table with 3 columns, #1 numeric, #2 numeric and #3 alphanumeric in
columns D, E & C
2.Create macro using https://wiki.documentfoundation.org/Macros/Calc/ba023
3.Set oSortFields(0).Field = 4 rem column E
run macro
Actual Results:
5 4 A
1 5 B
2 1 C
3 2 D
4 3 E
Expected Results:
2 1 C
3 2 D
4 3 E
5 4 A
1 5 B
Reproducible: Always
User Profile Reset: No
Additional Info:
If you put the same data in columns A, B & C, the expected results are
obtained!
--
You are receiving this mail because:
You are the assignee for the bug.
