Bug 111825 - Import from xlsx has wrong scaling of deep 3D column chart
Summary: Import from xlsx has wrong scaling of deep 3D column chart
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
: 114145 (view as bug list)
Depends on:
Blocks: OOXML-Chart
  Show dependency treegraph
 
Reported: 2017-08-15 21:04 UTC by Regina Henschel
Modified: 2023-03-20 11:14 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Deep 3D column chart (38.14 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2017-08-15 21:04 UTC, Regina Henschel
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Regina Henschel 2017-08-15 21:04:57 UTC
Created attachment 135564 [details]
Deep 3D column chart

The attached document has been created with Excel 2010. It contains a deep 3D column chart with a lot of non standard formatting. The sheet has a screenshot of the display in Excel.

Many design aspects are not yet implemented, although possible in ODF. But this bug report is only about the wrong scaling. That is a basic feature of charts and should be correct.

Especially:
The y-axis is too long.
The x-axis is too short and does not show all labels.
The z-axis is missing the labels.
Comment 1 Xisco Faulí 2017-08-16 00:42:47 UTC
Confirmed in

Version: 6.0.0.0.alpha0+
Build ID: ef2e6260fad38e26c8591ea88ded348db618270d
CPU threads: 4; OS: Linux 4.10; UI render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); Calc: group

Version: 4.3.0.0.alpha1+
Build ID: c15927f20d4727c3b8de68497b6949e72f9e6e9e

LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4
Comment 2 Regina Henschel 2017-11-29 18:09:32 UTC
*** Bug 114145 has been marked as a duplicate of this bug. ***
Comment 3 Gabor Kelemen (allotropia) 2017-11-30 15:16:57 UTC
See attachment #138076 [details] from the duplicate bug for an illustration of the problem.
Comment 4 QA Administrators 2018-12-03 03:59:03 UTC Comment hidden (obsolete)
Comment 5 Regina Henschel 2018-12-03 11:44:42 UTC
Tested with Version: 6.3.0.0.alpha0+ (x64)
Build ID: d71ea82055a6a304493c7eaa90809a348e23784d
CPU threads: 8; OS: Windows 10.0; UI render: GL; VCL: win; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2018-11-19_04:56:18
Locale: de-DE (en_US); UI-Language: en-US
Calc: threaded

z-axis labels exists.

y-axis is still to long.

x-axis labels are there, but have wrong orientation. The problem is, that "overlap" is not enabled and therefore the 0° orientation conflicts with "no overlap". Overlap happens here because the chart is smaller than in Excel.
Comment 6 QA Administrators 2021-03-19 04:40:49 UTC Comment hidden (obsolete)
Comment 7 Regina Henschel 2021-03-19 09:28:05 UTC
The y-axis is still too long.
The x-axis label have wrong orientation.

Errors still exist in Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 076da4cd9d61adf15942a7bfc350bd0d268f64f1
CPU threads: 8; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; VCL: win
Locale: de-DE (en_US); UI: en-US
Calc: CL
Comment 8 QA Administrators 2023-03-20 03:26:36 UTC Comment hidden (obsolete)
Comment 9 Regina Henschel 2023-03-20 11:14:31 UTC
The scaling is still wrong in Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 1309e6332d7ff2bd1f9b6bf87385b8b570e59158
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: default; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded