Issue 54748 - Sorting should be intelligent about headings
Summary: Sorting should be intelligent about headings
Status: CLOSED DUPLICATE of issue 22758
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOO 2.0 Beta2
Hardware: All All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: niklas.nebel
QA Contact: issues@sc
URL:
Keywords: usability
Depends on:
Blocks:
 
Reported: 2005-09-18 07:03 UTC by jjc
Modified: 2013-08-07 15:12 UTC (History)
4 users (show)

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

Attachments
Example that can be used to compare Excel and Calc behaviour (13.50 KB, application/vnd.ms-excel)
2005-09-18 07:06 UTC, jjc 		no flags Details
patch for ignore sorting header when use sort button in toolbar. (660 bytes, patch)
2005-09-21 10:08 UTC, hin 		no flags Details | Diff
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 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