Bug 123886 - libre calc does not sort
Summary: libre calc does not sort
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.1.5.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: regression
Depends on:
Blocks:
 
Reported: 2019-03-05 21:59 UTC by sam3232
Modified: 2019-03-12 17:30 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
test file (47.50 KB, application/x-ole-storage)
2019-03-07 13:49 UTC, sam3232
Details

Note You need to log in before you can comment on or make changes to this bug.
Description sam3232 2019-03-05 21:59:11 UTC
Description:
SORT in previous versions i could sort the entire file by going to data,sort then selecting the order of the fields to sort version 6.1.5.2(x64) does not sort correctly for instance when i try to sort by street name then address neither one sort correctly neither the addresses nor the street names get put into order i have used the previous versions with no problem

Steps to Reproduce:
1open a spreadsheet
2.highlight all fields of data
3.select DATA,SORT,SELECT THE FIELDS IN THE ORDER YOU WANT THEM TO BE SORTED, CLICK OK

Actual Results:
FIELD DO NOT SORT INTO ORDER

Expected Results:
FIELDS SHOULD HAVE SORTED EXAMPLE: BY STREET NAME FIELDS SHOULD BE ALPABETICAL THEN ADDRESS FIELDS SHOULD BE IN ORDER EITHER ASCENDING OR DESCENDING


Reproducible: Always


User Profile Reset: No



Additional Info:
I COULD NOT FIND INFORMATION IN HELP
Comment 1 raal 2019-03-06 14:56:36 UTC
Hello,

Thank you for filing the bug. Please send us a sample document, as this makes it easier for us to verify the bug. 
I have set the bug's status to 'NEEDINFO', so please do change it back to 'UNCONFIRMED' once you have attached a document.
(Please note that the attachment will be public, remove any sensitive information before attaching it.)
How can I eliminate confidential data from a sample document?
https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F
Thank you
Comment 2 sam3232 2019-03-07 13:49:30 UTC
Created attachment 149791 [details]
test file
Comment 3 raal 2019-03-09 08:31:25 UTC
works for me with Version: 6.3.0.0.alpha0+
Build ID: 732d630c3d2a168c725c18e4dd8df7a0a4f85566
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: x11; 

Sort key 1 = column D
Sort key 1 = column B

This is a big sheet and maybe I overlooked something. Please write exact steps what you are sorting and example of bad result.
Comment 4 Durgapriyanka 2019-03-12 16:24:21 UTC
Cannot reproduce. It does sort accordingly.

Version: 6.3.0.0.alpha0+
Build ID: b6b28931435e44aca92b8c0e1659f701e3ed1a87
CPU threads: 2; OS: Windows 6.1; UI render: default; VCL: win; 
TinderBox: Win-x86@42, Branch:master, Time: 2019-01-30_06:57:04
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded
Comment 5 sam3232 2019-03-12 16:50:00 UTC
problem seems to have resolved itself i feel that it was a problem with the file i was trying to sort