Sorting range in calc in 3.6 puts nulls ahead of filled in rows

[ptn4egl]

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?

[ptn4egl]

same exact behavior with 3.6.1.1 rc

[mariosv]

Is it the same through Menu/Data/Sort?

[ptn4egl]

no. And I’ve just discovered a new issue with this…So I’m doing this sort on multiple ranges all with the same parameters, and just changing the ocellRange. It does the odd behavior in all but the last block to sort. I an assigning the cellrange, sorting, assigning, sorting, etc, etc.

[mariosv]

Are you sure, they are blank cells?, no spaces, no null value.

[mmohrhard]

Please open a bug report for it. We changed some parts of the sort code for 3.6.

[ptn4egl]

Bug opened, and they might contain “” due to a formatting if statement

[mariosv]

Could you report bug link?

[qubit1]

Bug appears to be fdo#53814 - Macros: sorting range in calc in 3.6 puts nulls ahead of filled in rows

Current status: RESOLVED FIXED

Todo: Resolve Question as Bug Filed