Issue 54748

Summary: Sorting should be intelligent about headings
Product: Calc Reporter: jjc
Component: editingAssignee: niklas.nebel
Status: CLOSED DUPLICATE QA Contact: issues@sc <issues>
Severity: Trivial    
Priority: P3 CC: hin.stone, issues, kyoshida, pagalmes.lists
Version: OOO 2.0 Beta2Keywords: usability
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Example that can be used to compare Excel and Calc behaviour
none
patch for ignore sorting header when use sort button in toolbar. none

Description jjc 2005-09-18 07:03:50 UTC 
If the sorting toolbar button is used to sort a column with a non-numeric cell
followed by multiple numeric cells, then Excel will intelligently deduce that
the first cell is a header, and will sort just the numeric cells. Calc blindly
sorts the entire column.

In one organization (NECTEC in Thailand), the helpdesk reported this as a
frequent complaint from users migrating from Excel to Calc.
Comment 1 jjc 2005-09-18 07:06:09 UTC 
Created attachment 29634 [details]
Example that can be used to compare Excel and Calc behaviour
Comment 2 hin 2005-09-21 10:05:58 UTC 
I have a patch to solve this requirement. Please consider this patch.

Regard,
Comment 3 hin 2005-09-21 10:08:32 UTC 
Created attachment 29749 [details]
patch for ignore sorting header when use sort button in toolbar.
Comment 4 frank 2005-09-21 10:36:34 UTC 
Hi Niklas,

please have a look at this one and re-target as needed.

Frank
Comment 5 niklas.nebel 2005-10-12 16:26:07 UTC 
The patch isn't all that intelligent. It just always assumes "with headers"
instead of "no headers", which is wrong in at least as many cases.
Comment 6 pagalmes.lists 2007-07-28 19:00:54 UTC 
duplicate with issue 22758 ?
Comment 7 niklas.nebel 2008-09-19 19:10:05 UTC 
Yes, duplicate.

*** This issue has been marked as a duplicate of 22758 ***
Comment 8 niklas.nebel 2008-09-19 19:12:32 UTC 
closing duplicate