https://bugs.documentfoundation.org/show_bug.cgi?id=145054
Bug ID: 145054
Summary: FILEOPEN XLSX Copying a sheet with autofilter by color
leaves unusable autofilter on the copy sheet
Product: LibreOffice
Version: 7.3.0.0 alpha0+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Keywords: filter:xlsx, implementationError
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Blocks: 142076
Created attachment 175630
--> https://bugs.documentfoundation.org/attachment.cgi?id=175630&action=edit
Screenshot of the original sheet in Calc
When an autofilter uses color filtering and the sheet is copied, the new sheet
has the same autofilter but it is unusable.
This does not happen when an ODS file is autofiltered by color and the sheet is
copied, for example in attachment 172482 from bug 142578 this works fine.
Steps to reproduce:
1. Open attachment 173243 from bug 143104
2. Sheet – Move or copy sheet
3. Make a copy of Sheet1 in the same spreadsheet
4. Try to open the autofilter on the newly created sheet
Actual results:
Autofilter does not work on the second sheet.
Expected results:
The autofilter should work properly on the second sheet too.
LibreOffice details:
Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: b1488cd6f008049a9aaff7350deeb73cbbd535b6
CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: hu-HU (en_US); UI: en-US
Calc: threaded
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=142076
[Bug 142076] [META] Color filtering in Autofilter bugs and enhancements
--
You are receiving this mail because:
You are the assignee for the bug.