First time here? Check out the FAQ!
asked 2012-08-19 21:02:12 +0200
This post is a wiki. Anyone with karma >750 is welcome to improve it.
I have a selected range and when I sort descending by the 2nd column it puts the NULL cells/rows at the top of the rows that contain data.
This is new behavior noticed in 3.6, but not 3.4.2, 3.4.4, 3.5.2, 3.5.3, nor 3.5.4
Here is the code snipit that I've been using for 1 1/2 years:
oSortFields(0).Field = 1 oSortFields(0).SortAscending = FALSE oSortDesc(0).Name = "SortFields" oSortDesc(0).Value = oSortFields() oCellRange = oSheet.getCellRangeByName("c3:d8") oCellRange.Sort(oSortDesc())
So if I have cells like this
bob 2 tim 3 brian 4 larry 1 [blank cells] [blank cells]
And I then when I run the macro to sort the cells, this is what it does:
[blank cells] [blank cells] brian 4 tim 3 bob 2 larry 1
This is NOT the expected behavior. Should I file a bug or am I doing something wrong that works in nearly all of the previous versions?
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-08-19 21:02:12 +0200
Seen: 103 times
Last updated: Feb 22