[Libreoffice-bugs] [Bug 141936] New: LibreOffice Calc sorts incorrectly (EDITING)

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=141936

            Bug ID: 141936
           Summary: LibreOffice Calc sorts incorrectly (EDITING)
           Product: LibreOffice
           Version: 7.0.3.1 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: ozsolarwind at iinet.net.au

Description:
When sorting (Data -> Sort...) by a single column Calc incorrectly orders other
columns.  

Steps to Reproduce:
1. Sort the attached spreadsheet by Station Name. 
2. Values in the Latitude and Longitude columns sort incorrectly 
3.

Actual Results:
Station Name    Technology      Latitude        Longitude
wind_-28.0000-114.3750  Wind    -32     115.625
wind_-28.5000-114.3750  Wind    -28.5   114.375
wind_-29.0000-115.0000  Wind    -33     115.625
wind_-30.5000-115.0000  Wind    -30     115
wind_-31.0000-115.6250  Wind    -28     115
wind_-31.5000-115.6250  Wind    -34     115.625
wind_-32.5000-115.6250  Wind    -28.5   115
wind_-33.5000-115.0000  Wind    -33.5   115
wind_-33.5000-115.6250  Wind    -28     114.375
wind_-34.0000-115.0000  Wind    -34     115
wind_-34.0000-115.6250  Wind    -29     115
wind_-34.5000-115.0000  Wind    -34.5   115
wind_-34.5000-115.6250  Wind    -34.5   115.625
wind_-34.5000-116.2500  Wind    -32.5   115.625
wind_-34.5000-118.7500  Wind    -30.5   115
wind_-34.5000-119.3750  Wind    -34.5   119.375
wind_-35.0000-116.2500  Wind    -35     116.25
wind_-35.0000-116.8750  Wind    -35     116.875
wind_-35.0000-117.5000  Wind    -35     117.5
wind_-35.0000-118.1250  Wind    -35     118.125


Expected Results:
Station Name    Technology      Latitude        Longitude
wind_-28.0000-114.3750  Wind    -28     114.375
wind_-28.5000-114.3750  Wind    -28.5   114.375
wind_-29.0000-115.0000  Wind    -29     115
wind_-30.5000-115.0000  Wind    -30.5   115
wind_-31.0000-115.6250  Wind    -31     115.625
wind_-31.5000-115.6250  Wind    -31.5   115.625
wind_-32.5000-115.6250  Wind    -32.5   115.625
wind_-33.5000-115.0000  Wind    -33.5   115
wind_-33.5000-115.6250  Wind    -33.5   115.625
wind_-34.0000-115.0000  Wind    -34     115
wind_-34.0000-115.6250  Wind    -34     115.625
wind_-34.5000-115.0000  Wind    -34.5   115
wind_-34.5000-115.6250  Wind    -34.5   115.625
wind_-34.5000-116.2500  Wind    -34.5   116.25
wind_-34.5000-118.7500  Wind    -34.5   118.75
wind_-34.5000-119.3750  Wind    -34.5   119.375
wind_-35.0000-116.2500  Wind    -35     116.25
wind_-35.0000-116.8750  Wind    -35     116.875
wind_-35.0000-117.5000  Wind    -35     117.5
wind_-35.0000-118.1250  Wind    -35     118.125



Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Version: 7.0.3.1
Build ID: 00(Build:1)
CPU threads: 2; OS: Linux 5.8; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Ubuntu package version: 1:7.0.3-0ubuntu0.20.10.1
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210427/1f192787/attachment.htm>