Bug 130178 - Graphic (chart) text distorted & axis labels missing (but not in Excel 2013)
Summary: Graphic (chart) text distorted & axis labels missing (but not in Excel 2013)
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.3.4 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-01-24 16:40 UTC by Randolph
Modified: 2020-01-29 22:38 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Problem File (784.83 KB, application/x-zip-compressed)
2020-01-24 16:41 UTC, Randolph 		Details
Example graphic viewed in Calc (64.50 KB, image/png)
2020-01-24 16:42 UTC, Randolph 		Details
Example graphic viewed in Excel 2013 (29.24 KB, image/png)
2020-01-24 16:43 UTC, Randolph 		Details
How to set up a font replacement (21.45 KB, image/png)
2020-01-25 19:54 UTC, m_a_riosv 		Details
Comparison with Excel (97.50 KB, image/png)
2020-01-29 21:48 UTC, Randolph 		Details
View All 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 Randolph 2020-01-24 16:40:18 UTC 
Description:
On opening a particular file, the text on the charts (graphics) is distorted to the extent of being unreadable, and on at least one graphic the axis labels are not visible. Apparently an incompatibility with Excel.

Steps to Reproduce:
1.Download file attached
2.Open in Calc
3.View images (eg line 80, 165)

Actual Results:
1) The titles on the images are badly distorted.
2) On the chart at line 80 the X-axis labels are not visible

Expected Results:
On opening with Excel 2013 graphics display as expected.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Version: 6.3.4.2 (x64)
Build ID: 60da17e045e08f1793c57c00ba83cdfce946d0aa
CPU threads: 4; OS: Windows 6.3; UI render: default; VCL: win; 
Locale: en-GB (en_GB); UI-Language: en-GB
Calc: CL
Comment 1 Randolph 2020-01-24 16:41:30 UTC 
Created attachment 157407 [details]
Problem File
Comment 2 Randolph 2020-01-24 16:42:19 UTC 
Created attachment 157408 [details]
Example graphic viewed in Calc
Comment 3 Randolph 2020-01-24 16:43:15 UTC 
Created attachment 157409 [details]
Example graphic viewed in Excel 2013
Comment 4 m_a_riosv 2020-01-25 19:54:24 UTC 
Created attachment 157427 [details]
How to set up a font replacement

The issue comes from the use 'Darwin' font in that title, I have not it installed, so the issue is there but not is a LibreOffice issue.

You need to install the font in your system.

Or using LibreOffice options for font replace, solves the issue for me.
You can see how on the attached screenshot.
Comment 5 Randolph 2020-01-29 21:47:59 UTC 
I can confirm that font substitution using the table + manual resizing can be used to correct the title. I see that there is a long-standing proposal to enhance this at https://bugs.documentfoundation.org/show_bug.cgi?id=103342

However the X-axis labels (in Century Schoolbook, a font I do have installed) still doesn't display correctly. See Example_graphic_comparison1.png
Comment 6 Randolph 2020-01-29 21:48:55 UTC 
Created attachment 157513 [details]
Comparison with Excel
Comment 7 m_a_riosv 2020-01-29 22:38:18 UTC 
This is a different matter, if you move the wall a bit up, out of the legend the whole values are showed.

Please open a new bug report for this.