[Libreoffice-bugs] [Bug 132521] New: Data | Sort uses weird range

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 132521
           Summary: Data | Sort uses weird range
           Product: LibreOffice
           Version: 3.5.0 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: nadie.nada.nunca at mail.com

Description:
This has only happened with one particular file so far for me, but it's pretty
consistent. Whenever I try to sort my data in that sheet, Calc starts the range
in the fifth row unless I'm standing on a border of the data range. It also
ends in the wrong column. 

I've made a point of pressing Ctrl+Home every time I want to sort the data. 

It's not (I think) the contents of that fifth row, because the contents change
all the time as I sort the data. But it's always the fifth row. (Outside the
data range, the row appears completely empty, as it should be.)

This has been happening for years, but only now I took the time to anonymize
the data so that I could upload a sample file showing the bug.

Steps to Reproduce:
1. Open the attached sample file.
2. Click on a cell in the middle of the data range.
3. Use Data | Sort. 

Actual Results:
Calc auto-selects the wrong range, starting in the fifth row and ending before
the last column with data.

Expected Results:
Calc should select all rows and columns with data, including the header row.


Reproducible: Always


User Profile Reset: No



Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: yes

-- 
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/20200429/b21dd245/attachment.htm>