https://bugs.freedesktop.org/show_bug.cgi?id=53814
Bug #: 53814
Summary: Macros: sorting range in calc in 3.6 puts nulls ahead
of filled in rows
Classification: Unclassified
Product: LibreOffice
Version: 3.6.0.4 release
Platform: Other
OS/Version: All
Status: UNCONFIRMED
Status Whiteboard: BSA
Severity: normal
Priority: medium
Component: BASIC
AssignedTo: libreoffice-bugs@lists.freedesktop.org
ReportedBy: bugzi...@mlddarts.com
Problem description: I have a selected range and when I sort descending by the
2nd column it puts the NULL cells/rows at the top or the rows that contain data
as opposed to having them at the bottom.
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
Steps to reproduce:
Here is the code snipit that I've been using successfully in multiple versions
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]
Current behavior:
[blank cells]
[blank cells]
brian 4
tim 3
bob 2
larry 1
Expected behavior:
brian 4
tim 3
bob 2
larry 1
[blank cells]
[blank cells]
Platform (if different from the browser): Only tested on Linux i586, but heard
reports from one of my directors with the same problem with the same
version(3.6.0.4) on Windows
Browser: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/536.11 (KHTML, like Gecko)
Chrome/20.0.1132.57 Safari/536.11
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
