Bug 114145 - FILESAVE XLSX 3D area chart shrinks along the x axis and the Z axis label disappear by Calc
Summary: FILESAVE XLSX 3D area chart shrinks along the x axis and the Z axis label dis...
Status: RESOLVED DUPLICATE of bug 111825
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
6.1.0.0.alpha0+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-11-29 15:43 UTC by Gabor Kelemen (allotropia)
Modified: 2017-11-29 18:09 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Example file made with Excel 2013 (19.72 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2017-11-29 15:43 UTC, Gabor Kelemen (allotropia)
Details
The example file saved by LO6 alpha (16.74 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2017-11-29 15:44 UTC, Gabor Kelemen (allotropia)
Details
The two files in Calc and Excel side by side (119.83 KB, image/png)
2017-11-29 15:45 UTC, Gabor Kelemen (allotropia)
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Gabor Kelemen (allotropia) 2017-11-29 15:43:47 UTC
Created attachment 138074 [details]
Example file made with Excel 2013

It is possible to create 3D area chart with LibreOffice Calc, but if we want to stretched along X or Y axis the diagram is deformed unlike the excel diagrams. If we create a 3D area chart with MSO Excel and open with LibreOffice Calc the chart shrinks along the X category axis. Another problem at this chart is the Z axis label, which disappears after we open the file in LibreOffice Calc.

Steps to reproduce:

1. Create a new spreadsheet in Microsoft Excel.
2. Add values to a few cells in a column.
3. Select the cell range that contains the data.
4. Create a simple 3D area chart in Microsoft Excel.
5. Open the file in LibreOffice Calc and compare it with Excel.

Actual results:
The chart shrinks along the X axis. The chart in Calc doesn’t show the Z axis label, which disappears after we open the file in LibreOffice Calc.

Expected results:
3D area charts should not shrink along the X axis. If we stretched a chart in Calc along X or Y axis the diagram shouldn’t be deformed by LibreOffice Calc. The chart should display the Z axis labels.
Comment 1 Gabor Kelemen (allotropia) 2017-11-29 15:44:26 UTC
Created attachment 138075 [details]
The example file saved by LO6 alpha
Comment 2 Gabor Kelemen (allotropia) 2017-11-29 15:45:49 UTC
Created attachment 138076 [details]
The two files in Calc and Excel side by side
Comment 3 Regina Henschel 2017-11-29 18:09:32 UTC
Yes, such import problems I have seen too.

We need only one report to track the problem, therefore setting to duplicate.

*** This bug has been marked as a duplicate of bug 111825 ***