[Libreoffice-bugs] [Bug 138704] New: [FILEOPEN] Importing a xlsx file with AutoFilter leaves ghost range definition

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 138704
           Summary: [FILEOPEN] Importing a xlsx file with AutoFilter
                    leaves ghost range definition
           Product: LibreOffice
           Version: 6.4.7.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: iavs.leroy at gmail.com

Description:
Original AutoFilter range remains valid, although new AutoFilter range is set.
Need to copy and paste the data to a new spreadsheet to avoid the issue.

Steps to Reproduce:
1. Open a xlsx file that includes autofilters (in my case, answers from a MS
Forms in Calc)
2. Hide AutoFilter
3. Add some columns to the right (D:F in the sample file)
4. Add AutoFilter
5. Apply AutoFilter
6. Hide AutoFilter

Actual Results:
Steps 4, 5 and 6 do not take in account the new columns if done while cursor is
in the original columns.
Steps 4, 5 and 6 works if done while cursor is in the new columns.

Expected Results:
When hidding AutoFilter range must be automatically reseted.


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Version: 6.4.7.2 (x86)
Build ID: 639b8ac485750d5696d7590a72ef1b496725cfb5
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default;
VCL: win; 
Locale: es-MX (es_MX); UI-Language: en-US
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/20201207/14e7ccdc/attachment-0001.htm>