Created attachment 50623 [details] Simple spreadsheet previously sorted on the range A3:C7 When a file is reopened and the previous Sort range is reselected, Calc erroneously ticks the Options box "Range contains column labels". Steps to reproduce: 1) Create a spreadsheet containing columns of data with or without column labels 2) Select a range not including column labels 3) Use Data | Sort to sort the range 4) Save and close the file 5) Reopen the file 6) Select the same range as in step 2 7) Open the Data | Sort dialog again Actual Results: LibO correctly remembers the columns chosen to sort by, but incorrectly ticks the option "Range contains column labels", requiring the user to go to the Options tab to reset it. Notes: 1) The error does not occur when a new range is selected for sorting. It only occurs if the previously selected range is reselected after saving, closing and reopening the file. 2) This bug did not exist prior to LibO 3.4 Build: LibreOffice 3.4.1 OOO340m1 (Build:103) System: Windows 7 64-bit The attached file illustrates the bug. The file has previously been sorted by selecting the whole data range A3:C7 and sorted by column C. If this range is selected again, LibO correctly remembers it was sorted by column C but incorrectly assumes it contains column labels. If any other range is selected, LibO correctly assumes it does not contain column labels. The bug is independent of the range selected and column(s) sorted by if the above steps are followed from step 2 onwards.
This report of a regression in LibO 3.4 from 3.3 seems to have missed the triage process. It should be quite simple to fix.
[This is an automated message.] This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it started right out as NEW without ever being explicitly confirmed. The bug is changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases. Details on how to test the 3.5.0 beta1 can be found at: http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1 more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
It's rather annoying and still in 3.5.
I'll take a look at it.
Fixed.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=ed88b144ce24b9a733d4a9ab6614307c96537baa add all imported properties to ScDBData, fdo#40426
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=d58421c2cc5199e9892627b894eaab64265c82e7 add test case for fdo#40426
Markus Mohrhard committed a patch related to this issue. It has been pushed to "libreoffice-3-5": http://cgit.freedesktop.org/libreoffice/core/commit/?id=a0d2fd2096e267a29c5b8a07b0349e699e13ded5&g=libreoffice-3-5 add all imported properties to ScDBData, fdo#40426 It will be available in LibreOffice 3.5.2.