Reproduce it this way: - In a sheet with many columns of data, select many cells in many columns, say A1:L10 - From menu, Data - Sort - Select more than 3 sort fields, say columns A, B, C, D, E, F, G - In the second tab, select Natural Search too - Perform the search -> OK - Modify the data - Select again A1:L10 - From menu, Data - Sort: the sort dialog has everything you have set - Perform the search -> OK - Save the spreadsheet - Close it - Open again the spreadsheet - Select again A1:L10 - From menu, Data - Sort: the sort dialog hasn't remembered all the stuff you had set: -- only 3 columns are remembered: A, B, C -- Natural Search option has been lost too
Did you try defining ranges? Check these: https://ask.libreoffice.org/en/question/14774/change-default-sort-options-in-calc/ https://ask.libreoffice.org/en/question/21210/change-default-sorting-settings/ https://ask.libreoffice.org/en/question/56410/feature-request-save-sort-in-calc/
Yes I tried defining ranges. Nothing changed, the bug is there, identical. Actually using range is only a way to select the cells
Sorts options are preserved associated with their respective ranges, but only till a certain extent, which seems to be 3 sort columns, and natural sort option isn't preserved either.
Ok, please attach an example file.
Created attachment 130601 [details] file with sort memory buggish The document has been saved after a sort option performed on columns (respectively) N O C D E and natural sort option set The sort is relative to the cells defined in an area named "prova" (the area is automatically selected when Data - Sort is run) However, opening the file and issuing Data - Sort, the dialog only shows a sort on columns (respectively) N O C, and natural sort option isnt' set
surely related to bug #105468
but in bug #105468 natural sort option is preserved
(In reply to Paolo Benvenuto from comment #5) > Created attachment 130601 [details] > file with sort memory buggish > > The document has been saved after a sort option performed on columns > (respectively) N O C D E and natural sort option set > > The sort is relative to the cells defined in an area named "prova" (the area > is automatically selected when Data - Sort is run) > > However, opening the file and issuing Data - Sort, the dialog only shows a > sort on columns (respectively) N O C, and natural sort option isnt' set Ok, I tested with the document and the options are not saved. Arch Linux 64-bit, KDE Plasma 5 Version: 5.4.0.0.alpha0+ Build ID: 63fd4c97118a943c84ba5a666cf8c9cc54b511c7 CPU Threads: 8; OS Version: Linux 4.8; UI Render: default; VCL: kde4; Locale: fi-FI (fi_FI.UTF-8); Calc: group Built on January 22th 2016 Arch Linux 64-bit Version 3.6.7.2 (Build ID: e183d5b)
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
present in 6.0.2.1
*** Bug 116502 has been marked as a duplicate of this bug. ***
6.0.6 version also has that bug. Is there Any development action for this problem??
Dear Paolo Benvenuto, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
I fixed the number of sorting keys being saved and displayed (https://gerrit.libreoffice.org/c/core/+/108987), but I am not sure about the sorting options. Atm, there is no xml definition for natural sort and the options regarding the boundary columns, and I am not sure if I can add these options without hurting the ods standard.
Andreas Heinisch committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/788c777c6cdf2254e8bba05321f4a9de309b15b5 tdf#105301 - increase the size of the sorting keys It will be available in 7.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
I close this once, since the missing sorting options are mentioned in bug 90296 too.
Verified in Version: 7.2.0.0.alpha0+ / LibreOffice Community Build ID: a5d68a4f959804f93ddda61a45cedaadb504e3f2 CPU threads: 4; OS: Linux 5.7; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded @Andreas Heinisch, thanks for fixing this issue!!
Andreas Heinisch committed a patch related to this issue. It has been pushed to "libreoffice-7-1": https://git.libreoffice.org/core/commit/1c89de1ffce80e228eafca327d4f90a5c5487e55 tdf#105301 - increase the size of the sorting keys It will be available in 7.1.2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/fb1aa71ca3f7bec3fa6a10c4c3dec37987b213a2 tdf#105301: sc: Add UItest It will be available in 7.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.