Bug 145019 - formula bar font and cell font display differences
Summary: formula bar font and cell font display differences
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.2.1.2 release
Hardware: All macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-10-09 15:45 UTC by [REDACTED]
Modified: 2021-10-14 13:37 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description [REDACTED] 2021-10-09 15:45:32 UTC 
Description:
Chinese in any cell and the formula bar shows the Chinese, the font is not consistent, select any one of the cells with Chinese, and then click the formula bar, the formula bar shows and the cell is not the same Chinese font, and the text in the cell will jump a little; if the text in the cell language is English, the formula bar shows no difference in the font, but the text in the cell will still jump a little.

Steps to Reproduce:
1.Enter any Chinese in the cell and set any font
2.Click on the formula bar
3.You can immediately see that the text font displayed in the formula bar is significantly different from the text font in the cell, and the text in the cell jumps up

Actual Results:
I have tried many times and it always looks like this

Expected Results:
This is a bug in libreOffice, please fix it as soon as possible


Reproducible: Always


User Profile Reset: No



Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Mac OS X (All)
OS is 64bit: no

Version: 7.2.1.2_aarch64 / LibreOffice Community
Build ID: 87b77fad49947c1441b67c559c339af8f3517e22
CPU threads: 8; OS: Mac OS X 11.6; UI render: default; VCL: osx
Locale: zh-CN (zh_Hans.UTF-8); UI: en-US
Calc: threaded
Comment 1 [REDACTED] 2021-10-09 15:52:05 UTC 
This bug is not related to the format of the saved file, whether it is xlsx or ods, the same problem exists
Comment 2 Roman Kuznetsov 2021-10-10 19:08:31 UTC 
I don't think font in LibreOffice's UI should be the same as font in cell anyway.

But, I don't have Chinese UI/fonts for checking. 

Mark, could you please look at it?
Comment 3 [REDACTED] 2021-10-14 13:37:16 UTC 
After several attempts, if these settings are made for libreoffce, the problem of abnormal display of fonts in this calc cell does not exist anymore, and the problem is likely to be a bug in the font used

language settings->languages->Asian:none,

Select the font for the latest release of Apple, SF Mono,

In the course of several tests, it was found that if the Simplified Chinese language pack was installed, it would aggravate the problem, and if the Simplified Chinese language pack was not installed, the problem would be much better.

The above tests were verified on the latest version 7.2.2 of libreoffce