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: libreoffice-bugs@lists.freedesktop.org Reporter: nalong...@sbcglobal.net 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.