Issue 96927 - 'Range contains column labels' needs to be easier to get at
Summary: 'Range contains column labels' needs to be easier to get at
Status: CLOSED DUPLICATE of issue 22758
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOO300m9
Hardware: Mac Mac OS X, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-12-05 06:24 UTC by padmavyuha
Modified: 2024-01-25 17:53 UTC (History)
4 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description padmavyuha 2008-12-05 06:24:47 UTC 
In the Calc menubar Data::Sort... leads to the Sort dialogue, with 2 panels,
Sort Criteria and Options.
It is very frustrating that:
a) 'Range contains column labels' is switched OFF by default
b) you have to change panels to get to it once the dialogue is up, and
c) as of v3.1 (AFAICT) there's still no access to this functionality through the
API so it's not possible to turn this feature on using macros, shortcuts etc.

In MS Excel this feature is ON by default, and is accessible on the same panel
as the Sort Criteria, making it much easier to use/choose.

I'd certainly appreciate (b) & (c) in the list above - changing (a) would
confuse users now, unless (b) happened too.
Comment 1 Stefan Weigel 2008-12-12 20:42:39 UTC 
padmavyuha, please have a look at issue #22758 and at
http://wiki.services.openoffice.org/wiki/User:Stefanw/Werkstatt/Testcases_Sorting

After having fixed issue #22758, do you still think it is necessary to ease
access to the option in the dialog?
Comment 2 oooforum (fr) 2024-01-24 14:34:58 UTC 
No news from OP: closed
Comment 3 damjan 2024-01-24 18:26:41 UTC 
a) We now auto detect column labels based on strings vs numbers, and formatting differences between 1st and 2nd row. It works well.
b) There should be little need to change panels now to toggle the "Range contains column labels" setting.
c) I think there is an API that can be used for sorting: https://wiki.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Sorting#Table_Sort_Descriptor

I think it's better to resolve this as a duplicate of bug 22758, than an obsolete issue.

*** This issue has been marked as a duplicate of issue 22758 ***