Bug 40468 - FILEOPEN xls looses y-axis, wrong settings
Summary: FILEOPEN xls looses y-axis, wrong settings
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
(earliest affected)
Master old -3.6
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Not Assigned
Whiteboard: target:3.5
Keywords: regression
Depends on:
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:

file with chart and picture of the expected import result (92.50 KB, application/excel)
2011-08-29 12:29 UTC, Regina Henschel
Screenshots, See Comment 2 (70.36 KB, application/pdf)
2011-09-01 05:48 UTC, Rainer Bielefeld Retired

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: 
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.

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

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