https://bugs.documentfoundation.org/show_bug.cgi?id=145059
Bug ID: 145059
Summary: FILESAVE XLSX Changing the conditional formatting of
autofiltered color loses the ffilter condtion
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 175648
--> https://bugs.documentfoundation.org/attachment.cgi?id=175648&action=edit
Example file from Excel
When an XLSX spreadsheet contains autofiltered data set to a color defined by a
conditional format, and the conditional formatting is changed to another color,
saving the file as XLSX loses the color filtering in Excel.
Steps to reproduce:
1. Open attached file, it contains some conditionally formatted text.
2. Set the autofilter on column A to filter for blue text color
3. Change conditional formatting of condition “Cell value starts with “c”
from the blue style to Bad style, which has red font color.
4. Save the file as XLSX, reload in Excel
Actual results:
Excel does not see the autofilter condition as active.
Expected results:
Excel should see the condition as active, upon changing the “Cell value starts
with “c” formats font color back to the blue color it should show it as
selected.
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.
