[Libreoffice-bugs] [Bug 151009] Sorting, oCellRange.Sort(oSortDesc()), 3 columns by column#2 but column#3 sorted
https://bugs.documentfoundation.org/show_bug.cgi?id=151009 --- Comment #8 from Nick --- SUPER! Thanks. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 151009] Sorting, oCellRange.Sort(oSortDesc()), 3 columns by column#2 but column#3 sorted
https://bugs.documentfoundation.org/show_bug.cgi?id=151009 --- Comment #7 from Andreas Heinisch --- I updated the description in https://wiki.documentfoundation.org/Macros/Calc/ba023 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 151009] Sorting, oCellRange.Sort(oSortDesc()), 3 columns by column#2 but column#3 sorted
https://bugs.documentfoundation.org/show_bug.cgi?id=151009 BogdanB changed: What|Removed |Added CC||buzea.bog...@libreoffice.or ||g Resolution|FIXED |WORKSFORME -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 151009] Sorting, oCellRange.Sort(oSortDesc()), 3 columns by column#2 but column#3 sorted
https://bugs.documentfoundation.org/show_bug.cgi?id=151009 Nick changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |FIXED --- Comment #6 from Nick --- Many thanks!!! In more than my humble opinion, the documentations NEEDS to be changed to show the index is from the the specified range. As far as I know, any other index is specified from the sheet. Note that Tammy found the same problem I did by using the sheet index. Again, thank you. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 151009] Sorting, oCellRange.Sort(oSortDesc()), 3 columns by column#2 but column#3 sorted
https://bugs.documentfoundation.org/show_bug.cgi?id=151009 Andreas Heinisch changed: What|Removed |Added CC||andreas.heini...@yahoo.de --- Comment #5 from Andreas Heinisch --- The Field of the oSortFields variable is not counted from the beginning of a sheet, but counted relatively from the selected range. So, if you want to sort the data contained in column E, you don't have to specify the Field parameter from the beginning of the sheet, but from the beginning of the range: REM Range from D to F sText2 = "$D$1:$F$5" oCellRange = oSheet.getCellRangeByName(sText2) REM Sort by Column E descending (D has index 0, E has index 1, and F has index 2) oSortFields(0).Field = 1 oSortFields(0).SortAscending = TRUE oSortFields(0).FieldType = com.sun.star.util.SortFieldType.NUMERIC Imho, this needs some clarification in the documentation. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 151009] Sorting, oCellRange.Sort(oSortDesc()), 3 columns by column#2 but column#3 sorted
https://bugs.documentfoundation.org/show_bug.cgi?id=151009 Buovjaga changed: What|Removed |Added Status|UNCONFIRMED |NEW Ever confirmed|0 |1 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 151009] Sorting, oCellRange.Sort(oSortDesc()), 3 columns by column#2 but column#3 sorted
https://bugs.documentfoundation.org/show_bug.cgi?id=151009 --- Comment #4 from Nick --- Thanks for your input. You confirmed the bug I was reporting The macro Test1 sorts colmuns A, B & C by index 1 (column B) correctly. The macro Test2 is supposed to sort columns D, E & F by index 4 (column E) but it does not. Columns D, E & F are equal to columns A, B & C. So the question is "Why does sorting by index 1 for A, B and C work but sorting by index 4 for D, E & F which should produce the same result but it does not?" -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 151009] Sorting, oCellRange.Sort(oSortDesc()), 3 columns by column#2 but column#3 sorted
https://bugs.documentfoundation.org/show_bug.cgi?id=151009 --- Comment #3 from Tammy --- At first, I could reproduce the issue in which columns C, D, and E did not work in sorting the columns. When I changed the oSortFields(0).Field = 4 to oSortFields(0).Field = 1 for test 2 it seems to work to show the sorted column 2. Version: 7.4.2.3 (x64) / LibreOffice Community Build ID: 382eef1f22670f7f4118c8c2dd222ec7ad009daf CPU threads: 8; OS: Windows 10.0 Build 22000; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 151009] Sorting, oCellRange.Sort(oSortDesc()), 3 columns by column#2 but column#3 sorted
https://bugs.documentfoundation.org/show_bug.cgi?id=151009 Nick changed: What|Removed |Added Ever confirmed|1 |0 Status|NEEDINFO|UNCONFIRMED -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 151009] Sorting, oCellRange.Sort(oSortDesc()), 3 columns by column#2 but column#3 sorted
https://bugs.documentfoundation.org/show_bug.cgi?id=151009 --- Comment #2 from Nick --- Created attachment 182832 --> https://bugs.documentfoundation.org/attachment.cgi?id=182832=edit Test file and macros as requested I made an error in my original report. Sorting B in A, B, & C works but sorting E in D, E & F does not work. F is sorted. Hope this helps. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 151009] Sorting, oCellRange.Sort(oSortDesc()), 3 columns by column#2 but column#3 sorted
https://bugs.documentfoundation.org/show_bug.cgi?id=151009 Rafael Lima changed: What|Removed |Added Component|Base|BASIC -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 151009] Sorting, oCellRange.Sort(oSortDesc()), 3 columns by column#2 but column#3 sorted
https://bugs.documentfoundation.org/show_bug.cgi?id=151009 Rafael Lima changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED |NEEDINFO CC||rafael.palma.l...@gmail.com --- Comment #1 from Rafael Lima --- Can you share a sample file with the data you used for testing as well as with your implementation of the macro? -- You are receiving this mail because: You are the assignee for the bug.