Bug 89147 - Calc comment text invisible when using missing font in .xls file
Summary: Calc comment text invisible when using missing font in .xls file
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Windows (All)
: medium minor
Assignee: Not Assigned
Keywords: regression
Depends on:
Blocks: Calc-Comments
  Show dependency treegraph
Reported: 2015-02-05 21:06 UTC by Bugzilla
Modified: 2016-12-31 19:24 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:

Spreadsheet which displays the bug and screen shots from working/not working versions (161.34 KB, application/x-zip-compressed)
2015-12-19 16:52 UTC, Bugzilla

Note You need to log in before you can comment on or make changes to this bug.
Description Bugzilla 2015-02-05 21:06:11 UTC
Some, but not all of my comments, are not being displayed in Calc
So am seeing empty boxes where I know there should be text.
Build ID: de093506bcdc5fafd9023ee680b8c60e3e0645d7
Locale: en_GB
Comment 1 raal 2015-02-06 14:33:10 UTC Comment hidden (obsolete)
Comment 2 Bugzilla 2015-02-07 13:39:32 UTC
Apologies , gone back to prior version Version: since I need this to work. I can now see all comments again.  One thing I have noticed is that it is recent comments (those created in 4.3.5) that do not apprear in Older comments are still visible.
Comment 3 QA Administrators 2015-09-04 02:55:36 UTC Comment hidden (obsolete)
Comment 4 QA Administrators 2015-10-14 19:48:30 UTC Comment hidden (obsolete)
Comment 5 Bugzilla 2015-12-19 16:52:07 UTC
Created attachment 121408 [details]
Spreadsheet which displays the bug and screen shots from working/not working versions

I think the newer comments are the ones that "vanish" in the newest version of Libre office.  Some comments you can see and some not. 

All the comments behave better under
Comment 6 Bugzilla 2015-12-19 16:55:23 UTC
OS Name	Microsoft Windows 10 Home
Version	10.0.10586 Build 10586
System Model	HP Pavilion g6 Notebook PC
Processor	AMD A8-4500M APU with Radeon(tm) HD Graphics, 1900 Mhz, 4 Core(s), 4 Logical Processor(s)
BIOS Version/Date	Insyde F.26, 21/02/2013
Comment 7 Buovjaga 2015-12-22 21:39:14 UTC
Ok, you are using .xls format. I see the comment boxes without text in your example file.

These boxes use the font MS Sans Serif, which is missing in my system. I confirm 4.3 displays the text with a replacement font just fine.

However, I could not reproduce this from scratch by inserting a comment and changing the font to be some made-up one, saving as .xls and reloading.

Win 7 Pro 64-bit, Version: (x64)
Build ID: 2b9802c1994aa0b7dc6079e128979269cf95bc78
Locale: fi-FI (fi_FI)

Build ID: 014633f83e44ae8ba33087b6f38e8e253e281969
CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; 
TinderBox: Win-x86@62-merge-TDF, Branch:MASTER, Time: 2015-12-15_06:21:44
Locale: fi-FI (fi_FI)
Comment 8 Xisco Faulí 2016-09-13 10:00:29 UTC
I guess this can be bibisected with this repository:
Adding keyword 'bibisectRequest'.
Comment 9 Aron Budea 2016-12-31 19:24:09 UTC
Looks correct in & / Windows 7. Wasn't correct in
Setting as WORKSFORME.