Created attachment 102140 [details] shows the font drop down field is empty when D4 is selected When testing attachment 102136 [details] from bug 80604, i noticed two font issues. Firstly cell D4 according to excel has the font aharoni assigned to it but LibO has it with a blank entry in the font drop down (LibO 3.3 - 4.4). Secondly in 4.1 and above, the chinese font used in the other cells of the spreadsheet is shown in the font drop down in chinese as well as in italics, as if its not installed. Tested on Windows and Linux
Created attachment 102141 [details] shows the font drop down field showing the font in chinese and in italics
hi Jay, For the first issue, it's not a bug. font drop down is showing back because the cell has both Chinese and westin chars in it. For the 2nd one, you attached a same image. I'll test again tomorrow, because im now using mobile phone.
Created attachment 102197 [details] font-screenshots.org (works for me) Ubuntu 14.04 x86, libreoffice 4.3.0.1. Cell D4 is not showing blank font in drop down. Other cells are showing italic font names because I do not have that font installed.
(In reply to comment #2) > For the first issue, it's not a bug. font drop down is showing back because > the cell has both Chinese and westin chars in it. Confirmed. D3 contains WenQuanYi Zen Hei and Arial; D4 contains WenQuanYi Zen Hei and Aharoni. (In reply to comment #3) > Other cells are showing italic font names because I do not have that font > installed. Also confirmed. Font name is 微软雅黑 which appears to be Microsoft YaHei.
Created attachment 102924 [details] shows the font drop down field showing the font in chinese and in italics My bad Kevin, didnt notice i upload the same image twice. :) Well i do have the font installed and its still showing in italics, because the font name is written in chinese characters, rather than english.
(In reply to comment #4) > Confirmed. D3 contains WenQuanYi Zen Hei and Arial; D4 contains WenQuanYi > Zen Hei and Aharoni. No, D3 contains "微软雅黑" and "Aharoni", while D4 is all formatted as "Aparajita". > Also confirmed. Font name is 微软雅黑 which appears to be Microsoft YaHei. 微软雅黑 = Microsoft YaHei. One is Chinese name, the other is english name, but it's the same font. I think if you have Microsoft YaHei installled already, it should not be italics in drop-down. Wired.
(In reply to comment #6)I > I think if you have Microsoft YaHei installled already, it should not be > italics in drop-down. In my system, I have that font installed, and the font dropdown is showing "微软雅黑“ not in italics. However, if I set the font names as "Microsoft Yahei", it will show as italics. Does this have some to do with locale settings or system language? Or, I think I is really a bug: If libreoffice can not find a font named "微软雅黑“, it should then lookup whether there is a font named "Microsoft Yahei" exists. (I mean, it should lookup both the english name and the local name. In linux, if you run fc-list, it will show Chinese fonts both in english and in Chinese) Also, I see some people applying font settings as "SimSun;宋体" or "微软雅黑;Microsoft Yahei" (Chinese name and English name seperated by ;). LibreOffice accepts this kind of font list also. This may be a workaround to avoid font problems.
(In reply to comment #7) > Also, I see some people applying font settings as "SimSun;宋体" or > "微软雅黑;Microsoft Yahei" (Chinese name and English name seperated by ;). > LibreOffice accepts this kind of font list also. This may be a workaround to > avoid font problems. Yes i've seen that in libreoffice as well, both english and chinese names next to each other.
(In reply to comment #6) > No, D3 contains "微软雅黑" and "Aharoni", while D4 is all formatted as > "Aparajita". Sorry, I was getting font substitution. Thanks for the correction Kevin. (In reply to comment #7) > Does this have some to do with locale settings or system language? That would be my guess. The TTF Name table often has multiple versions of a field (e.g., Fullname) on a per-locale basis. For Microsoft YaHei font v5.00 I have "Microsoft YaHei" in the English (US) version of this field and "微软雅黑" in the Chinese (PRC) version of this field.
I confirm the blank on D4 and italics on others, but is LO to blame? Win 7 64-bit Version: 4.4.0.0.alpha1+ Build ID: ad6d94009cf8ea526eb70bf1a07e5c6a21320f83 TinderBox: Win-x86@51-TDF, Branch:MASTER, Time: 2014-11-04_00:06:27
As beluga confirmed D4 was blank, i'm setting it to NEW.
Migrating Whiteboard tags to Keywords: (filter:xls)
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.1.6 or 5.2.3 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug-20170103
*** This bug has been marked as a duplicate of bug 107484 ***