Bug 130796 - FILESAVE: Font changes when saving ODS file to XLSX
Summary: FILESAVE: Font changes when saving ODS file to XLSX
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
Keywords: filter:xlsx
Depends on:
Blocks: XLSX
  Show dependency treegraph
Reported: 2020-02-20 08:38 UTC by Kevin Suo
Modified: 2022-10-09 04:03 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:
Regression By:

Test ODS file (22.04 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-02-20 08:38 UTC, Kevin Suo

Note You need to log in before you can comment on or make changes to this bug.
Description Kevin Suo 2020-02-20 08:38:33 UTC
Created attachment 158023 [details]
Test ODS file

The attached ODS file is formatted (via default Style) to use "Noto Sans CJK SC" font for Chinese characters, and use "Liberation Serif" font for English characters. There is no direct formatting within the cells (i.e., I already did "CLear Direct Formatting" and applied again the default cell style to all the cells. When save as XLSX, the font for English chars changes to "Noto Sans CJK SC".

Steps to Reproduce:
1. Open the attached ODS file. Go to the default cell style and observe that the Western font is set as "Liberation Serif" and Chinese font is set as "Noto Sans CJK SC".
2. Save the attached ODS file as XLSX. 
3. Open the XLSX file with Calc.

Current Behaviour:
Font in the 2nd row is in changed to "Noto Sans CJK SC" for cells with a formula (e.g., cell B2).
Font in the 2nd row is changed to "Times New Roman" for cells without a formula (e.g., cell A2).

Font for 2nd row remains "Liberation Serif" when save as XLSX.

Build ID: cc9ef44fa58fe73e482582bf9756c316cb15d123
CPU 线程: 4; 操作系统: Linux 5.4; UI 渲染: 默认; VCL: gtk3; 
区域语言: zh-CN (zh_CN.UTF-8); UI 语言: zh-CN
Calc: threaded

Also reproduce on 6.3 branch.
Comment 1 m.a.riosv 2020-02-20 16:57:19 UTC
Not repro in windows10 with:
Version: (x64)
Build ID: 56f3c78975db08733f771c53643b5d1aa7c57567
CPU threads: 4; OS: Windows 10.0 Build 19564; UI render: GL; VCL: win; 
Locale: es-ES (es_ES); UI-Language: en-US Calc: CL
Version: (x64)
Build ID: cf96cb11e2a46c452a273ded1c66c556118983cf
CPU threads: 4; OS: Windows 10.0 Build 19564; UI render: Skia/Raster; VCL: win; 
Locale: es-ES (es_ES); UI-Language: en-US Calc: threaded
Comment 2 Buovjaga 2020-05-10 14:55:51 UTC
Repro on Win & Linux. Already in 4.4 and 3.3.

Version: (x64)
Build ID: 00db5933ded1884b2ac453552badae20fa943478
CPU threads: 4; OS: Windows 10.0 Build 18362; UI render: default; VCL: win; 
Locale: fi-FI (fi_FI); UI-Language: en-US
Calc: threaded

Arch Linux 64-bit
Build ID: e622420c0aa8116294e85c076ff2d8fc6131595f
CPU threads: 8; OS: Linux 5.6; UI render: default; VCL: kf5; 
Locale: en-US (fi_FI.UTF-8); UI: en-US
Calc: threaded
Built on 10 May 2020
Comment 3 QA Administrators 2022-10-09 03:49:35 UTC Comment hidden (obsolete)
Comment 4 Kevin Suo 2022-10-09 04:03:47 UTC
(In reply to QA Administrators from comment #3)

Still reproducible on
Version: / LibreOffice Community
Build ID: 09c076c3f29c28497f162d3a5b7baab040725d56
CPU threads: 8; OS: Linux 5.19; UI render: default; VCL: gtk3
Locale: zh-CN (zh_CN.UTF-8); UI: en-US
Build Platform: Fedora34@X64, Branch:master, bibisect-linux-64-7.4-CN
Calc: threaded