Apache OpenOffice (AOO) Bugzilla – Issue 7277
sorting should default to selected column
Last modified: 2013-08-07 15:14:39 UTC
When using the "sort ascending" or "sort descending" toolbar buttons, the sorting should happen based on the column where the selected cell is. This would make it much handier to sort on another column than the one set in the sort dialog.
I can't get your point. Could you please give a more detailed describtion of this problem.
I have the same request. Create a short table e.g.: A 1 2 3 D 6 5 4 C 9 7 8 B 0 0 0 Leave the cursor in column B Click quick-sort ascending The table is sorted on column A It doesn't matter where the cursor is in this table. Using a quick-sort always sorts on the first column of this table. This makes quick-sort a fairly limited tool.
Ok, now I understand, thank you for the clarification.
Hi Bettina, one4you
*** Issue 22767 has been marked as a duplicate of this issue. ***
Hello Niklas, I think we should consider this nice idea concerning sorting. Please give approval for this evaluated OO.o 2.0 flagged issue. If you confirm with the target OO.o 2.0, then please keep it on your owner (or the owner of the concerning developer) for implementation. In case you want this issue for 'OOo Later', then please reset the target milestone. If you decline the issue finally, please set the resolution to 'Wontfix' (but do not close). In case of 'OOo Later' or 'Wontfix' please reset it on Bettina's owner. Thank you.
This is not on the list of features that we're going to do for 2.0. We need to focus on the enhancements from the PCD document.
I really think this should go into 2.0. Without it quicksorting is pretty much broken/useless. That makes the spreadsheet pretty broken too, at least for how I use it.
It's worth pointing out that OO does not currently behave the way EXCEL does for sorting. The request described here would make OO follow Excel's interface. I think this is a good thing in general, since there's no reason to be different (and the current OO setup is vastly less usable). I really think this needs to go in ASAP.
I think this should definitely go into 2.0 as it is almost useles as it is now. This is a frequently used feature in excel and may be a good reason for many users to create a first bad impresion on OO2.0 as I did. And anyway it shouldn't be so complicated to implement as using Data->Sort I am able to sort on a specific column and this is the exact behaviour I expect from "sort ascending", "sort descending" shortcuts.
*** Issue 60429 has been marked as a duplicate of this issue. ***
Bug still alive in 2,0,0 and 2,0,1 it is very anoying, to use the fat dialog just for a quick sorting...
Also, it always sorts the heading, which should stay in line 1.
Many of us who are trying to make the switch from MS Office to OpenOffice rely on certain features. This is one feature that many MS Office users use, so it is important to have the same behaviour: as has already been described - a single click sort that sorts ascending or descending and doesn't sort the headers.
Mandatory improvements to the sorting functions are: (1) Calc must find out by itself, wether the first row is a header or is containing data. Yes that´s possible, Excel does so. Excel recognizes different data types between first row (text in every column) and the following rows (not text at least in one column). If all cells of the list, header and data rows, contain nothing but text, Excel recognizes different formatting in the first row. (2) Sorting must base on the column, where the active cell is. (3) Subsequent sorting of a list setting the active cell in different columns should result in a hierarchically sorted list corresponding to the sequence of columns, where the active cell was selected.
Bug still alive in 2,0,2 and 2,0,3 why is this bug only type enhancement? i think "defect" would be better. for an quick improvement two things will be perfect: - in the sorting-dialog the checkbox "range contains Headers" is saved (anywhere) between two sort-actions. please use this setting for quick-sort / button-sort. - don't use for sorting with the buttons just the first column, use the column with the selection in it. i don't think, these two bugfixes does take more than two hours...... please!
My assumption was that column sort behavior was similar to Excel. This caused me to misalign data (because sort was defaulting to first column). I had to go back and fixup the data, losing about a hour going back to original paper source to rekey the day. This is a painful bug! I haven't looked at OO code, but this seems like it should be a simple fix and the default behavior can cause significant data and time loss.
One can overcome this issue by replacing the "sort ascending" or "sort descending" toolbar buttons with a macro published here: http://codesnippets.services.openoffice.org/Calc/Calc.ImproveSortingCapabilities.snip However, we are still longing for a fix for this issue.
*** Issue 78706 has been marked as a duplicate of this issue. ***
Hi Niklas, these RFEs are in your ownership.
This seems like such a simple thing to fix, and so obviously an improvement, that I can't understand why nobody's attended to it. I can only guess that we haven't gotten the attention of the right person? Any suggestions?
this is a quite old issue. probably it was forgotten trough the years
Accepted
Created attachment 56626 [details] The patch file is about i7277#-v1.
Started
More important than the dialog are the toolbar buttons (SID_SORT_ASCENDING, SID_SORT_DESCENDING).
Created attachment 56692 [details] The patch file is about i7277#-v2.
Created attachment 56812 [details] The patch file is about i7277#-v3.
Hi Niklas,this issue have fixed, thanks for your advice. :)
I don't understand the IsBlockEmpty calls. If the range is empty, the position is not limited to within the range? For what case is that needed?
Created attachment 56825 [details] The patch file is about i7277#-v4.
Hello Niklas,possible I got the wrong for the problem.
taking the issue
I added the last patch to CWS "calc47".
Reassigning to QA for verification
Created attachment 58695 [details] TestCaseSpecification
verified in internal build cws_calc47
Proposal for an extended TestCaseSpecification: http://wiki.services.openoffice.org/wiki/User:Stefanw/Werkstatt/Testcases_Sorting#Sorting_default_to_selected_column
verified in DEV300_m38. Thanks, good job!
Created attachment 59039 [details] For the records: testcase for this issue
verified, fixed --> closed.