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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
