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.

Reply via email to