Created attachment 162420 [details] Example file from Calc Attached file contains a header with a date field inserted and formatted with Liberation Serif font, Bold style and 13 pt font size. When saved to XLSX the bold style is not being read back (Excel sees it though) and the font is reset to TNR. Steps to reproduce: 1. Open attached document. 2. Save it as XLSX, reopen it. 3. Also open it in Calc. Actual results: Font name is TNR, font style is Normal in Calc. Font name is TNR, font style is Bold in Calc. Expected results: Liberation Serif font, Bold style in both. LibreOffice details: Version: 7.1.0.0.alpha0+ (x64) Build ID: acbe57481e0a10be287aad59201873a0799a94f0 CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: CL
Created attachment 162421 [details] The original file saved by Calc to xlsx
Created attachment 162422 [details] Screenshot of the original and exported document side by side in Calc
Created attachment 162423 [details] The exported file in Excel
More investigation reveals that the problem is happening if the font is left as default: if changed to anything else, the font name and style setting is exported correctly.
Created attachment 162588 [details] Example file with default font in header, and various header items
Created attachment 162589 [details] The example file before and after export
Liberation Serif is metric equivalent of Times New Roman, and it was developed for interoperability between (free fonts of the) free operating systems and (proprietary fonts of) Windows. Exporting it as Times New Roman is intended for greater interoperability, and it avoids broken header/footer resulted by bad font replacements. Note: it's possible, that in Writer there is/was no difference after a round trip, because Times New Roman was showed as Liberation (on Linux), as its default font replacement.
Created attachment 164238 [details] Expanded example file Changing this a bit in: Version: 7.1.0.0.alpha0+ (x64) Build ID: <buildversion> CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: CL (nightly from 08-10) Now the headers contain Liberation Serif / Sans / Mono fonts.
Created attachment 164239 [details] Expanded example file saved in Calc to XLSX
Created attachment 164242 [details] Screenshot of the original and exported document side by side in Excel and Calc - Serif font The left section of the header had Liberation Serif which became TNR in the export. The bold setting is now retained, just like the non-default 13 pt font size. Also: changing this to 10 pt explicitly (not just leaving it as-is) also leads to correct font size export.
Created attachment 164243 [details] Screenshot of the original and exported document side by side in Excel and Calc - Sans font The center section has Liberation Sans font set which also becomes TNR during export - instead of Arial.
Created attachment 164244 [details] Screenshot of the original and exported document side by side in Excel and Calc - Monospace font Third section has Liberation Mono font which becomes Courier New. This and the center sections had the default 10 pt font, which became 12 pt during export. So I see two issues: - Liberation Sans font becomes a Serif typed one during automatic font replacement (Which also happens in cell font, so let's not consider that in itself a bug, but a feature) - Default font value becomes 12 pt instead of 10 pt.
Let's limit this problem to the second part of comment #12: default Calc header font is 12 pt in the header editor but becomes 10 when saved as XLSX.
(In reply to NISZ LibreOffice Team from comment #13) > Let's limit this problem to the second part of comment #12: default Calc > header font is 12 pt in the header editor but becomes 10 when saved as XLSX. I create a new Calc spreadsheet and looked at font properties in Header. I saw Liberation Serif with 10pt. Are you sure that you have 12pt default Header font?
(In reply to NISZ LibreOffice Team from comment #13) > Let's limit this problem to the second part of comment #12: default Calc > header font is 12 pt in the header editor but becomes 10 when saved as XLSX. Now the font size for the center and right sections stays at 10 pt. Can you re-test? Arch Linux 64-bit Version: 7.3.0.0.alpha0+ / LibreOffice Community Build ID: a58b9010b38ca43d4b3a2b30fcd6bec28db1b344 CPU threads: 8; OS: Linux 5.13; UI render: default; VCL: kf5 (cairo+xcb) Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded Built on 31 August 2021
A new major release of LibreOffice is available since this bug was reported. Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.
I checked the main release version and the Master too, but the problem is still exist. When I open the ods attached file and save it xlsx. First time when I open it in Calc the Font isn't change. Font style is Bold. When I open the same file second the font changes to TNR and after this the font always stay in TNR. Font style changes the text to hungarian language of the bold style which is "félkövér". So I change the status to 'UNCONFIRMED'. Version: 7.3.2.2 (x64) / LibreOffice Community Build ID: 49f2b1bff42cfccbd8f788c8dc32c1c309559be0 CPU threads: 8; OS: Windows 10.0 Build 19042; UI render: Skia/Vulkan; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: CL Version: 7.4.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 83d0f2eebae41d431d9a5bfd1a918523977752d0 CPU threads: 8; OS: Windows 10.0 Build 19042; UI render: Skia/Vulkan; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: CL
Created attachment 185060 [details] I got the Bug & attached sreenshot Environment : Boss linux, Libre officeDev 7.6 calc, Attachment : I attatched a Screenshot, Result : Bug Reprodused, Status : Bug found Confirmed
(In reply to Sakthivel from comment #18) > Created attachment 185060 [details] > I got the Bug & attached sreenshot > > Environment : Boss linux, Libre officeDev 7.6 calc, > Attachment : I attatched a Screenshot, > Result : Bug Reprodused, > Status : Bug found Confirmed No, you don't reproduce.