Bug 40468 - FILEOPEN xls looses y-axis, wrong settings
Summary: FILEOPEN xls looses y-axis, wrong settings
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
Master old -3.6
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: target:3.5
Keywords: regression
Depends on:
Blocks:
 
Reported: 2011-08-29 12:29 UTC by Regina Henschel
Modified: 2017-06-02 13:21 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
file with chart and picture of the expected import result (92.50 KB, application/excel)
2011-08-29 12:29 UTC, Regina Henschel 		Details
Screenshots, See Comment 2 (70.36 KB, application/pdf)
2011-09-01 05:48 UTC, Rainer Bielefeld Retired 		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 Regina Henschel 2011-08-29 12:29:04 UTC 
Created attachment 50668 [details]
file with chart and picture of the expected import result

Open the attached file. It contains a chart and a picture, which shows, how the chart looks in Excel 2010.
Using LO3.4 the import is not nice. The x-axis has wrong tacks and the grid has wrong color. But in LO3.5"daily" it is worse, the whole y-axis is missing and the chart is too high.
The file has been created with Excel 2010 and from there saved in xls-format.
Comment 1 Regina Henschel 2011-08-29 13:18:13 UTC 
The y-axis has in Excel an explicit value of 1 for the major interval. On import this values is not set, but is 0. Therefore the y-axis is not drawn.
Comment 2 Rainer Bielefeld Retired 2011-09-01 05:48:35 UTC 
Created attachment 50810 [details]
Screenshots, See Comment 2

[Reproducible] with Server installation of Master "LibO-dev 3.5.0 – WIN7 Home Premium (64bit) English UI [(Build ID: a6adae1-4eb4f62-09af278)]". I also can confirm the workaround manually modifying y-axis settings.

Y-Axis was OK with Master Build ID: 
	d337f79-a24c961-2865670-9752b71-7f8fd43
	2fdd60d-fd28b6a-fd7bf20-aa369cb-28da3fb
	6a9633a-931d089-ecd263f-c9b55e9-b31b807
	82ff335-599f7e9-bc6a545-1926fdf
Comment 3 Rainer Bielefeld Retired 2011-09-01 05:53:28 UTC 
Was OK  with "LibreOffice 3.4.3 RC2 - WIN7 Home Premium (64bit) German UI [OOO340m1 (Build:302)]" and Master from July, so REGRESSION.

@Kohei:
Please feel free to reassign (or reset Assignee to default) if it’s not your area or if provided information is not sufficient. Please set Status to ASSIGNED if you accept this Bug.
Comment 4 Kohei Yoshida 2011-12-02 14:37:53 UTC 
Using the latest master build from this week, I no longer see this behavior.  I'll mark this fixed.
Comment 5 vihsa 2017-06-02 13:21:15 UTC 
only one chart is visible

Version: 5.5.0.0.alpha0+
Build ID: 066665644b398a882e6cded98af5bb060af41d76
TinderBox: Android-ARM@24-Bytemark-Hosting, Branch: Master, Time: 2017-06-01 00:30:43