Issue 127648 - Spreadsheet sort issue
Summary: Spreadsheet sort issue
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: 4.1.5
Hardware: PC Windows, all
: P5 (lowest) Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-01-08 14:16 UTC by David Newnham
Modified: 2019-07-23 22:17 UTC (History)
1 user (show)

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

Attachments
Aviation register spreadsheet (124.06 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-01-08 14:16 UTC, David Newnham 		no flags Details
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 David Newnham 2018-01-08 14:16:21 UTC 
Created attachment 86313 [details]
Aviation register spreadsheet

Using Open Office 4.1.5.
Using "Spreadsheet".
Fault: Using "Data", "Sort" and sorting by Column E and then F.
Sort groups the sort in two parts with similar data in each part. First part of the sort goes to line 646
Second part of sort goes from line 647 to end of spreadsheet (line 2046).
Offending Spreadsheet "3RCA_Fed_DB2.ods" is attached.
Comment 1 oooforum (fr) 2018-01-08 16:50:16 UTC 
Column E has its cells formated in text.
So for me, the sort is correct.
Comment 2 David Newnham 2018-01-08 17:05:08 UTC 
Yes, column E does have its data classified as text. NOTE that text "973" in column E appears in two groups within the sort, therefore there is an issue in that "sort" is NOT grouping all data of one type together!
Comment 3 David Newnham 2018-01-08 17:06:51 UTC 
(In reply to David Newnham from comment #2)
> Yes, column E does have its data classified as text. NOTE that text "973" in
> column E appears in two groups within the sort, therefore there is an issue
> in that "sort" is NOT grouping all data of one type together!
Comment 4 oooforum (fr) 2019-07-22 12:34:42 UTC 
Did you sort your document with MS-Excel?
You have got same result.
As I said before, your cells in E are in text format.