https://bugs.documentfoundation.org/show_bug.cgi?id=145058
Bug ID: 145058
Summary: FILESAVE XLSX Adding new sheet with conditional
formatting loses autofilter condition
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: libreoffice-bugs@lists.freedesktop.org
Reporter: kelem...@ubuntu.com
Blocks: 142076
Created attachment 175642
--> https://bugs.documentfoundation.org/attachment.cgi?id=175642&action=edit
Example file from Excel
When an XLSX file with autofilter set on a sheet gets a new sheet added and
data is filtered using conditional formatting, the autofilters condition gets
lost when saving the file as XLSX.
Starting from an ODS file this problem does not happen.
Steps to reproduce:
1. Open the attached file which has an autofilter on Sheet1 but no
conditions set
2. Add a new sheet
3. Fill the sheet with some data, and set up conditional formatting on this
new data. I set green text color to text starting with M and blue text color on
text starting with T in column B.
4. Set an autofilter to the green text color.
5. Save as XLSX and reload.
Actual results:
The autofilter dropdown does not indicate the green text color being applied to
the column B. This happens both in Calc and Excel.
Expected results:
The autofilter should indicate the filter condition on the second sheet as
well.
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.
