Issue 12522 - Change sort order by clicking on column headers
Summary: Change sort order by clicking on column headers
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC3
Hardware: PC Windows XP
: P4 Trivial with 3 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: rfe_eval_ok
Depends on: 17776
  Show dependency tree
Reported: 2003-03-20 19:59 UTC by jhansonxi
Modified: 2013-08-07 15:45 UTC (History)
3 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

. (11.84 KB, image/jpeg)
2003-03-21 08:43 UTC, marc.neumann
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description jhansonxi 2003-03-20 19:59:56 UTC
It would be easier to adjust record view order by clicking on column headers
to change between ascending/descending sort order.

Split from Issue# 12482
Comment 1 marc.neumann 2003-03-21 08:43:49 UTC
Created attachment 5184 [details]
Comment 2 marc.neumann 2003-03-21 08:47:58 UTC

May be we need a new arrow control in the column header like in the

Bye Marc
Comment 3 Frank Schönheit 2003-03-21 09:17:36 UTC
the main problem is that sorting a table is potentially expensive,
thus we once decided to not offer this functionality by default (it's
too easy to accidentially click onto the column header). I think this
still holds. But we could think about an option which enables such a
Comment 4 Frank Schönheit 2003-03-21 09:22:36 UTC
> May be we need a new arrow control in the column header like in the
> attachment.

This would not solve it completely, as we can have sorted by multiple
columns, so we would need multiple arrows, and a method to visualize
their relative order - sounds difficult to me.
Comment 5 jhansonxi 2003-03-21 19:37:36 UTC
With a local database connected through ODBC speed should not be an
issue.  So I agree that it should be an option somewhere if the DSB
insists on retrieving the data from the server each time a sort is

The column sort doesn't need to be that complicated.  Just a one
column simple sort is enough.  More complex sorts will have to use the
multi-column sort (Data > Sort...) anyways.  Just highlight the arrow
on the column that is being used for the simple sort and gray it out
if a complex sort is active.  It's really not any different than the
Sort Ascending/Descending button functionality.  It just makes the
interface much more intuitive.
Comment 6 Rainer Bielefeld 2003-08-20 12:46:05 UTC

for me this would be fine enhancement, so I voted.
I agree with Comments From Frank Schoenheit 2003-03-21 01:17, but
isn't life dangerous at all?    ;-)

I think this should be a "Quick-Sort-Option" independent from the
normal "multi-column-sort". "Multi-column-sort" should not be showed
in the column headers.

I'm glad to see in the attached screenshot that I am no alone with my
Ideas concerning "how should arrows be used to show sort order".

Please see discussion in issue 17776

Because this question still is actual i change version.

Comment 7 bettina.haberer 2004-01-29 13:42:27 UTC
Summary: Change sort order by clicking on column headers.
We will think about a solution after OO.o 2.0. This issue is considered for OO.o
Comment 8 hans_werner67 2004-02-02 12:12:33 UTC
change subcomponent to 'none'
Comment 9 jlebrech 2006-08-29 14:31:38 UTC
Maybe if you changed the Sort buttons to dropdowns and the dropdown menu would 
list the current selected columns to sort by then that would do the trick!
Comment 10 bettina.haberer 2010-05-21 14:44:19 UTC
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".