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
Accepted. Very annoying bug.
please could you add an example document with some sample data and the macro ( not just a snippet ) to reproduce this ? would make things much easier
Created attachment 68214 [details] Bug 53814 - example
(In reply to comment #3) > Created attachment 68214 [details] > Bug 53814 - example In attachment - text is true: 'After deleting „List2“, saved and closed/reopened LibreOffice/this sheet: sorting is OK'
ok, I see it, very strange that the presence of entries on sheet 2 that point back to the data on sheet1 to be sorted affect the sorting order. Thanks for the example, at least now it is easily reproduceable
meant to say I would take this too
Noel Power committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=44e8a8240a3a1cce747f1998e617f8dd4621a992 fix for fdo#53814 Revert "there should be no need any more for this check" The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Noel Power committed a patch related to this issue. It has been pushed to "libreoffice-3-6": http://cgit.freedesktop.org/libreoffice/core/commit/?id=cd9d51a36cc3106d4124855874af657615a93061&g=libreoffice-3-6 fix for fdo#53814 Revert "there should be no need any more for this check" It will be available in LibreOffice 3.6.4. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Noel Power committed a patch related to this issue. It has been pushed to "libreoffice-3-6-3": http://cgit.freedesktop.org/libreoffice/core/commit/?id=c450c73ab7c83a55209cc7de9381cc32eb6313ff&g=libreoffice-3-6-3 fix for fdo#53814 Revert "there should be no need any more for this check" It will be available already in LibreOffice 3.6.3. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Noel Power committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=71ada2fb20cdb1741767165948a2856b4198c700 regression test for fdo#53814 The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
*** Bug 55712 has been marked as a duplicate of this bug. ***
libreoffice-3-6~2012-10-12_13.47.16_LibO-Dev_3.6.4.0_Win_x86_install_en-US.msi Version 3.6.4.0+ (Build ID: 14a24950) The error is corrected, OK. Thank you very much :)
Hello I confirm that the bug has been resolved: I reproduce with Version 3.6.2.2 (Build ID: da8c1e6) and do not reproduce with Version 3.6.4.0+ (Build ID: a010c4e) My Bug 55712 has been marked as a duplicate of this bug. However I have to reopen it because 3.6.4 did not solve. Regards Pierre-Yves