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

asked 2012-08-19 21:02:12 +0200

This post is a wiki. Anyone with karma >750 is welcome to improve it.

updated 2012-08-21 17:00:49 +0200

ptn4egl
3 ● 1 ● 1 ● 5

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?