https://bugs.documentfoundation.org/show_bug.cgi?id=163318
Bug ID: 163318
Summary: Sorting on a column of ZIP codes doesn't work.
Product: LibreOffice
Version: 24.2.6.2 release
Hardware: x86 (IA32)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: LibreOffice
Assignee: [email protected]
Reporter: [email protected]
Description:
Starting with a mailing list with ZIP codes out of numerical order, doing a
sort on the ZIP column results in ZIP codes in a different order, but still out
of numerical order.
Steps to Reproduce:
1.Create a mailing list with ZIP codes out of numerical order.
2.Data -> Sort -> Sort Criteria Column Zip - Ascending
3.OK
Actual Results:
I had a full mailing list with 8 columns, but I included only 20 lines of the
City, State, and Zip columns:
City State Zip
Cascade ID 83611
Phoenix AZ 85006
Mesa AZ 85201
Prescott AZ 86304
Vicksburg MS 49097-8432
Maricopa AZ 85139
Mesa AZ 85207-1612
Scottsdale AZ 85250
Scottsdale AZ 85251
Gilbert AZ 85295-4866
Gilbert AZ 85297-2901
Litchfield Park AZ 85340-3032
Benson AZ 85602-7615
Sahuarita AZ 85629-9512
Willcox AZ 85643-7542
Tucson AZ 85704
Flagstaff AZ 86001
Oceanside CA 92057-8232
Sonora CA 95370-9525
Expected Results:
City State Zip
Vicksburg MS 49097-8432
Cascade ID 83611
Phoenix AZ 85006
Maricopa AZ 85139
Mesa AZ 85201
Mesa AZ 85207-1612
Scottsdale AZ 85250
Scottsdale AZ 85251
Gilbert AZ 85295-4866
Gilbert AZ 85297-2901
Litchfield Park AZ 85340-3032
Benson AZ 85602-7615
Sahuarita AZ 85629-9512
Willcox AZ 85643-7542
Tucson AZ 85704
Flagstaff AZ 86001
Prescott AZ 86304
Oceanside CA 92057-8232
Sonora CA 95370-9525
Reproducible: Always
User Profile Reset: Yes
Additional Info:
1. Vicksburg, MS should have been the first entry (row 2)
2. Mesa, AZ should have been in row 6
3. Prescott, AZ should have been in row 18.
Version: 24.2.6.2 (X86_64) / LibreOffice Community
Build ID: ef66aa7e36a1bb8e65bfbc63aba53045a14d0871
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
