Created attachment 172482 [details] Example file from Calc Attached example file has conditional formatting set on cells with background color, and autofilter by color set on this color. When saved to XLSX the conditional formatting color is overwritten with the autofiltered background color. Steps to reproduce: 1. Open attached file 2. Save as XLSX, reload Actual results: The B1:B3 cells background color changes from pink to green, text color changes from red to black since it has changed in the Conditional Formatting dialog. Expected results: Conditional formatting style retained correctly. LibreOffice details: Version: 7.2.0.0.alpha1+ (x64) / LibreOffice Community Build ID: 187136265d26c014e842550c2f1fc5997736e4fa CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: default; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: CL
Created attachment 172483 [details] The original file saved by Calc
Created attachment 172484 [details] Screenshot of the original document in Calc with conditional formatting settings
Created attachment 172485 [details] Screenshot of the exported document in Calc with conditional formatting settings
Reproduced with Version: 7.2.0.0.alpha1+ / LibreOffice Community Build ID: 794eda02133699830913b37e094a07edeaeff22d CPU threads: 12; OS: Linux 5.10; UI render: default; VCL: gtk3 Locale: en-GB (en_GB.UTF-8); UI: en-US Calc: threaded
Still reproducible in Version: 7.3.0.0.alpha0+ / LibreOffice Community Build ID: b63c5ade3554a42def4bce94f9fd67ea66528214 CPU threads: 4; OS: Linux 5.10; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded
Vasily Melenchuk committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/b7a425d48cb282e20059e78ad5216da833dec803 tdf#142578: xlsx export: use continuous numbering for dfx nodes It will be available in 7.3.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Fix works, thx!
Vasily Melenchuk committed a patch related to this issue. It has been pushed to "libreoffice-7-2": https://git.libreoffice.org/core/commit/c1e156e16d3f2a0c1393332b3ad3a20a267ab936 tdf#142578: xlsx export: use continuous numbering for dfx nodes It will be available in 7.2.3. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.