Previously (maybe in Openoffice), one could sort several tables in the same spreadsheet, each being remembered when the pointer is located inside it's table. Ie, if have a table already sorted at a3:c22, and another at e3:f144, when in the range a3:c22, clicking "update range" (Data:"actualiser la plage" in french), that table will be resorted. As well if click "update range" when pointer in range e3:f144, that table would be resorted. Now (version 4.4.7.2), when "update range" is clicked, only the last sort done in the current spreadsheet is updated. The problem has existed for probably several years, maybe since the beginning of Libreoffice. (maybe 3.3.0 release, or inherited from OOo ?) In the past, I used to often have 2 or more sorted tables in the same (Libreoffice or Openoffice) spreadsheet. I have been using Libreoffice since the beginning, and Openoffice before. Note that I am using version 4.4.47.2 for Linux in french, compiled by Mageia. This is the latest version published by the current release of Mageia. (Mageia applies security fixes from more recent versions.) (Suggestion for testing most recent version of Libreoffice : Make them relocatable, with usual default location, to facilitate testing. Otherwise it is very cumbersome for those with limited free time to verify problems in other versions.)
Thank you for reporting the bug. it seems you're using a really old version of LibreOffice ,released more than 2 and a half years ago. Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.
The sorting information isstored as property of a data range. You can only have one anonymous data range per sheet. So if you want to use more sorting ranges on a single sheet, you have to name the respective ranges via menu Data > Define Range.
(In reply to Xisco Faulí from comment #1) > Thank you for reporting the bug. > it seems you're using a really old version of LibreOffice ,released more > than 2 and a half years ago. > Could you please try to reproduce it with the latest version of LibreOffice > from https://www.libreoffice.org/download/libreoffice-fresh/ ? > I have set the bug's status to 'NEEDINFO'. Please change it back to > 'UNCONFIRMED' if the bug is still present in the latest version. Not wanting to overwrite my installed Linux distro version, I don't recall how to install Libreoffice at another location. However, comment #2 indicates that it is a known problem, and gives a workaround. For anyone with the most recent version of Libreoffice installed, the problem is easily verified 1) Create 2 small tables of at least 2 lines each, without a range name, at non-overlapping locations. 2) Sort each in turn. 3) Insert a blank line in the middle of the table of each table. 4) Place the cursor inside the table NOT most recently sorted. 4) Invoke Data:refresh range 5) Note that only the table most recently sorted is sorted. The table with the active cursor is unchanged. Due to these factors, I'm changing the status back to 'UNCONFIRMED'
(In reply to Regina Henschel from comment #2) > The sorting information isstored as property of a data range. You can only > have one anonymous data range per sheet. So if you want to use more sorting > ranges on a single sheet, you have to name the respective ranges via menu > Data > Define Range. Thanks for the info, Regina. Very much appreciated. I have now named my data ranges, & everything works like a charm. It is definitely better to name ranges to avoid any ambiguity. However, it would be useful to save sort info for anonymous ranges. They could be identified internally by the label of the the top left cell. I'm changing the title to reflect this. Also lowering the priority from 'normal' to 'minor' as the problem is now less important
(In reply to andréb from comment #4) > However, it would be useful to save sort info for anonymous ranges. They > could be identified internally by the label of the the top left cell. > I'm changing the title to reflect this. > Also lowering the priority from 'normal' to 'minor' as the problem is now > less important I consulted a Calc developer and he thought this is not worth the effort that it would take to overhaul the code. Closing as WONTFIX.
*** Bug 159388 has been marked as a duplicate of this bug. ***