Bug 127655 - [UI] Wrong font in formula bar (input line)
Summary: [UI] Wrong font in formula bar (input line)
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.5.2 release
Hardware: All Windows (All)
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Formula-Bar
  Show dependency treegraph
 
Reported: 2019-09-20 07:29 UTC by Korrawit Pruegsanusak
Modified: 2022-08-22 23:37 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
test file in ods (9.86 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-09-20 07:30 UTC, Korrawit Pruegsanusak
Details
screenshot of wrong font in formula line (18.62 KB, image/png)
2019-09-20 07:31 UTC, Korrawit Pruegsanusak
Details
correct font when clicking formula line (15.14 KB, image/png)
2019-09-20 07:32 UTC, Korrawit Pruegsanusak
Details
animated gif file demonstrating the bug (114.06 KB, image/gif)
2019-09-20 07:42 UTC, Korrawit Pruegsanusak
Details
animated gif file version 5.2.7.2 - no bug (196.13 KB, image/gif)
2022-06-12 14:37 UTC, Korrawit Pruegsanusak
Details
animated gif version 5.3 and 5.4 -- half of the bug (150.16 KB, image/gif)
2022-06-12 14:45 UTC, Korrawit Pruegsanusak
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Korrawit Pruegsanusak 2019-09-20 07:29:14 UTC
Description:
Wrong font is shown in formula bar (a.k.a. input line)

Steps to Reproduce:
1. Open the attached file. Cell A1 is Thai text with Arial font.

1.1 Clicking in formula line (input line) makes the font in input line correct (see picture)
1.2 Not change anything, just press Enter on the keyboard
1.3 Now the cursor is in cell A2
1.4 Click on cell A1; the text in formula line is switched back to wrong font

Actual Results:
The text in formula line is shown with another font "Purisa" (see picture)

Expected Results:
The text in formula line is shown with "Arial" font


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Version: 6.3.1.2 (x64)
Build ID: b79626edf0065ac373bd1df5c28bd630b4424273
CPU threads: 2; OS: Windows 10.0; UI render: default; VCL: win; 
Locale: th-TH (th_TH); UI-Language: en-US
Calc: threaded
Comment 1 Korrawit Pruegsanusak 2019-09-20 07:30:45 UTC
Created attachment 154311 [details]
test file in ods
Comment 2 Korrawit Pruegsanusak 2019-09-20 07:31:21 UTC
Created attachment 154312 [details]
screenshot of wrong font in formula line
Comment 3 Korrawit Pruegsanusak 2019-09-20 07:32:00 UTC
Created attachment 154313 [details]
correct font when clicking formula line
Comment 4 Korrawit Pruegsanusak 2019-09-20 07:42:52 UTC
Created attachment 154315 [details]
animated gif file demonstrating the bug
Comment 5 Korrawit Pruegsanusak 2019-09-20 07:44:06 UTC
And the font Purisa, if needed, can be downloaded from ftp://linux.thai.net/pub/thailinux/software/fonts-tlwg/fonts/otf-tlwg-0.7.1.zip
Comment 6 Roman Kuznetsov 2019-09-20 13:44:05 UTC
confirm behavior in

Version: 6.4.0.0.alpha0+ (x64)
Build ID: 06925c1230cd6269fa5189ac3f4d608c9edf68e9
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2019-09-17_00:45:28
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded
Comment 7 Xisco Faulí 2019-09-26 15:36:40 UTC
Not reproducible in

Version: 5.2.0.0.alpha1+
Build ID: 5b168b3fa568e48e795234dc5fa454bf24c9805e
CPU Threads: 4; OS Version: Linux 4.15; UI Render: default; 
Locale: ca-ES (ca_ES.UTF-8)
Comment 8 Xisco Faulí 2019-12-11 16:19:15 UTC
I can't reproduce it in

Version: 6.5.0.0.alpha0+
Build ID: b9d6ea1dd7541c4bd866571f9e3f0aa894687c07
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: x11; 
Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US
Calc: threaded

@Korrawit Pruegsanusak,  Could you please try to reproduce it with a master build from http://dev-builds.libreoffice.org/daily/master/ ?
You can install it alongside the standard version.
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the master build
Comment 9 Korrawit Pruegsanusak 2019-12-11 19:17:26 UTC
Thanks. Anyway, I still reproduce on this Daily Build:
> LibreOfficeDev_6.5.0.0.alpha0_Win_x64
> Win-x86_64@tb77-TDF
> 2019-12-11_04.59.45
> Build ID: 67ee8818e68a2793d89331dd715989c468fe5680
> CPU threads: 2; OS: Windows 10.0 Build 17763; UI render: GL; VCL: win; 
> Locale: th-TH (th_TH); UI-Language: en-US
> Calc: CL

The following step should be added to reproduce this bug:

0. Install all fonts from this link ftp://linux.thai.net/pub/thailinux/software/fonts-tlwg/fonts/otf-tlwg-0.7.1.zip
This could be OTF or TTF fonts, located at the same FTP folder ftp://linux.thai.net/pub/thailinux/software/fonts-tlwg/fonts/

You may need to restart your machine, with resetting LibO user profile.

1. Continue with the step on the bug description (comment 0)


**General description of this problem**
1. This bug is that: LibreOffice selects the wrong font to display in the formula bar in the not-editing stage.
When the formular bar is in editing stage, LibO seems to use Arial font, if I understand correctly, which is what supposed to be.
The wrong font doesn't limit to Purisa font; sometimes LibO uses another font in the above zip file. I still can't figure which font LibO will use.

2. If the CTL option is enabled and set to Thai, or is disabled, this bug appears.
If the CTL option is enabled and set to anything but Thai (such as Hindi or Telugu), font will not flip between editing and non-editing stage. Instead, LibO will use the wrong font in both editing and non-editing stage.
Comment 10 Buovjaga 2020-04-27 16:58:24 UTC
Correcting status to NEW as this was confirmed by Roman.
Comment 11 Buovjaga 2020-04-28 19:02:43 UTC
Narrowed this down to bibisect-win32-5.3, so it seems to be the move to HarfBuzz.
Comment 12 QA Administrators 2022-04-29 03:44:42 UTC Comment hidden (obsolete)
Comment 13 Korrawit Pruegsanusak 2022-06-12 13:52:42 UTC
Still reproducible using the following version; and I've resetted my user profile already.

Version: 7.3.3.2 (x64) / LibreOffice Community
Build ID: d1d0ea68f081ee2800a922cac8f79445e4603348
CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
Comment 14 Korrawit Pruegsanusak 2022-06-12 14:26:40 UTC
Reproducible with:
Version: 6.0.5.2
Build ID: 54c8cbb85f300ac59db32fe8a675ff7683cd5a16
CPU threads: 4; OS: Windows 10.0; UI render: GL; 
Locale: en-US (en_US); Calc: CL

So I set the version field accordingly.

In this 6.0 version, the behavior is same as in attachment 154315 [details]. The font switches between correct and wrong font when clicking formular bar.
Comment 15 Korrawit Pruegsanusak 2022-06-12 14:37:57 UTC
Created attachment 180689 [details]
animated gif file version 5.2.7.2 - no bug

In version 5.2.7.2, the behavior and the font were correct.
The font in the formula bar is the default system font and it was not switching.
Comment 16 Korrawit Pruegsanusak 2022-06-12 14:45:35 UTC
Created attachment 180690 [details]
animated gif version 5.3 and 5.4 -- half of the bug

In version 5.3.7.2 and 5.4.1.2, the bug was introduced.
The font in formula bar is wrong, as it is not the default system font as in version 5.2. Anyway, the font is not switching as in version 6.

So, the bug was introduced in version 5.3 (wrong font, no font switching), and it was worse in version 6 and later (wrong font and font switching when click).
Comment 17 Buovjaga 2022-06-12 15:55:21 UTC
Yep, Korrawit, see my comment 11 :)
Comment 18 ⁨خالد حسني⁩ 2022-08-17 01:28:23 UTC
The layout engine has no influence on font selection, and there is nothing HarfBuzz related here. Per comment 9, this is somehow related to the CTL font settings


I can’t reproduce this either (even after installing the fonts, and even on a fresh LO profile), so I suggest narrowing the Hardware fields to the OS where this has been reproduced (font selection and fallback are very OS-specific).
Comment 19 Buovjaga 2022-08-17 07:12:28 UTC
Still repro on Windows

Version: 7.5.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 7716a43e76fe26ba31393b31cfa967f5fcb6e747
CPU threads: 2; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: fi-FI (fi_FI); UI: en-US
Calc: threaded Jumbo