Issue 96927

Summary:	'Range contains column labels' needs to be easier to get at
Product:	Calc	Reporter:	padmavyuha <padmavyuha>
Component:	ui	Assignee:	AOO issues mailing list <issues>
Status:	CLOSED DUPLICATE	QA Contact:
Severity:	Trivial
Priority:	P3	CC:	damjan, issues, oooforum, weigel
Version:	OOO300m9
Target Milestone:	---
Hardware:	Mac
OS:	Mac OS X, all
Issue Type:	ENHANCEMENT	Latest Confirmation in:	---
Developer Difficulty:	---

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 ***