Description: In Calc, with a column of ranked numbers like 23,15,6,3,11,43,25,7, and so on. The intention is to make rank 1 to 10 more noticeable, by setting the numbers a bigger font, using conditional format. When the format was set it was all good. When the file is saved, closed and opened again, the font size from the conditional format is lost. Steps to Reproduce: 1.Generate a column of numbers 2.Set conditional format: numbers <10 a bigger size of font 3.Save the file, close it. 4.Open it again, see the bigger fonts disappear. Actual Results: Fonts are of a uniformed size. Expected Results: Bigger fonts shall be like before file is closed. Reproducible: Always User Profile Reset: Yes OpenGL enabled: Yes Additional Info: Version: 5.4.2.2 (x64) Build ID: 22b09f6418e8c2d508a9eaf86b2399209b0990f4 CPU threads: 16; OS: Windows 6.1; UI render: GL; Locale: en-GB (en_GB); Calc: group Disabling OpenGL doesn't make difference. User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:52.0) Gecko/20100101 Firefox/52.0
This happens with file saved in .xlsx format. But not in .ods format.
Created attachment 137683 [details] Example ODS to be saved as XLSX Repro. Arch Linux 64-bit, KDE Plasma 5 Version: 6.0.0.0.alpha1+ Build ID: 1aba1955f161cc112dab80b6b3e78ec7761616fc CPU threads: 8; OS: Linux 4.13; UI render: default; VCL: kde4; Locale: fi-FI (fi_FI.UTF-8); Calc: group Built on November 10th 2017
Already in Arch Linux 64-bit LibreOffice 3.3.0 OOO330m19 (Build:6) tag libreoffice-3.3.0.4
That was an oversight by me when I wrote the new dxf based conditional format XLSX export. Should be fixed now.
I can't fix the attached document as that already contains some problematic content in the styles section due to another bug. However after fixing the other bug any new document and any document that does not contains CJK and CTL without Latin font information in the default style should work now. Additionally, all conditional format styles that have an explicit font set should work all the time.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=952cbfd2de0801081665a8ff05600eb7ea1cf82f related tdf#113646, keep cjk, ctl font items in sync It will be available in 6.2.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "libreoffice-6-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=aa79f08a2ef5b9390b7e9ad91b3fe2da200bfe32&h=libreoffice-6-1 related tdf#113646, keep cjk, ctl font items in sync It will be available in 6.1.0.2. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=14c2ca1b4efad2dcdc40e6d5c218cedd487857aa tdf#113646, export font size for dxf records It will be available in 6.2.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "libreoffice-6-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=91eec155eb9433343c7e549907960855b6e91e7b&h=libreoffice-6-1 tdf#113646, export font size for dxf records It will be available in 6.1.0.2. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Hi, Mr. Mohrhard, Thank you for making the fix! I'm using Calc instead of Excel more and more often. I will give 6.1.0.2 a try and see it works! Thank you! Best Regards, Chen Haijun
Gizem Ozgun committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/c10df6edb8a48b4a57f73ccb6155d051a8cfb5d0 tdf#113646 Add missing test for exporting conditional format font size. It will be available in 7.2.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.