Created attachment 162592 [details] Example file from Calc Attached document is a simple Calc table with its header formatted using character color. When saving this file to XLSX, the text color is lost. Steps to reproduce: 1. In Calc go to Insert – Header and Footer 2. Insert some date, time and text to the Left/Center/Right area 3. With the Text attributes button -> Font Effects tab set a Font color to them 4. Save as XLSX Actual results: Font colors are lost on reopening the file. Expected results: Font colors are retained. LibreOffice details: Version: 7.1.0.0.alpha0+ (x64) Build ID: c48e4d795e37f23b71d647247590807ab9e52223 CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win Locale: en-US (hu_HU); UI: en-US Calc: CL
Created attachment 162593 [details] The original file saved by Calc to xlsx
Created attachment 162594 [details] Screenshot of the original and exported document side by side in Calc
Reproduced in Version: 7.1.0.0.alpha0+ Build ID: e2b50a956cd34179d4f1e7f87834a94188011843 CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded and Version: 5.2.0.0.alpha0+ Build ID: 3ca42d8d51174010d5e8a32b96e9b4c0b3730a53 Threads 4; Ver: 4.19; Render: default; Locale: en-US (en_US.UTF-8)
Attila Szűcs committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/2abaaf97e95bf6149378c6cd5e58cdb2ce78dc4b tdf#134459 XLSX export: fix missing font color in header/footer It will be available in 7.1.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.