[Libreoffice-bugs] [Bug 140707] New: CALC Sort Failure

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 140707
           Summary: CALC Sort Failure
           Product: LibreOffice
           Version: 7.1.0.3 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: minor
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: rwilling at charter.net

Description:
Calc/Excel Sort Incompatibility
I have spreadsheet I use in my spreadsheet class that demonstrates the sort
functions of Excel and Calc. To save the original content before the sort, I
copy rows 2 through 6, cells A & B to D2. I then select cells D2 through D6 and
click on the Sort AZ icon. I get the warning about adjacent information like
Excel and hit enter. The problem is Calc includes Row 1 cells D1 & E1 in the
sort that causes the Title to be included in the sort. Excel does not do that.
It seems the different formatting between Rows 1 & 2 does not matter
The real problem is that this failure is inconsistent. Some list work and some
fail. Lists starting in D2 and E10 fail but A2, G2, J2 H10, A17 and D17
function correctly. Mind blowing! Problem is reproduceable.

Steps to Reproduce:
1.Create list with Titles in Row 1 Cells A & B & D
2.Create list in Rows 2-6 Cols A & B
3.Copy R2-6 A & B to D2
4.Sort D2-D6
5.Yes to Expand sort
6.Problem = Title in D1 included in sort even though not selected.
7.Copies at other locations may or not fail. Have sample to share

Actual Results:
6. Problem = Title in D1 included in sort even though not selected.

Expected Results:
Excel does not include title. Only sorts selected cells. Some locations in CALC
work correctly. Have CALC file to share via email.


Reproducible: Sometimes


User Profile Reset: No



Additional Info:
Should not included Title cells. Fails on my other computers.

-- 
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/20210227/74900acf/attachment.htm>