Bug 127777 - FILESAVE No support for exporting Axis position setting
Summary: FILESAVE No support for exporting Axis position setting
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Impress (show other bugs)
Version:
(earliest affected)
3.3.0 release
Hardware: All All
: medium normal
Assignee: Balázs Varga
URL:
Whiteboard: target:6.4.0 target:6.5.0 target:6.4.0.1
Keywords:
Depends on:
Blocks: OOXML-Chart
  Show dependency treegraph
 
Reported: 2019-09-26 08:59 UTC by NISZ LibreOffice Team
Modified: 2020-08-25 13:48 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Example file from PowerPoint with line chart and area chart using shifted axis position. (92.46 KB, application/vnd.openxmlformats-officedocument.presentationml.presentation)
2019-09-26 09:00 UTC, NISZ LibreOffice Team
Details
The original file saved by Impress (38.98 KB, application/vnd.openxmlformats-officedocument.presentationml.presentation)
2019-09-26 09:00 UTC, NISZ LibreOffice Team
Details
Screenshot of the original and exported document side by side in PowerPoint with line chart (106.33 KB, image/png)
2019-09-26 09:01 UTC, NISZ LibreOffice Team
Details
Screenshot of the original and exported document side by side in PowerPoint with area chart (104.44 KB, image/png)
2019-09-26 09:01 UTC, NISZ LibreOffice Team
Details
Screenshot of the distorted Column and Line chart (70.73 KB, image/png)
2019-11-18 09:05 UTC, Balázs Varga
Details

Note You need to log in before you can comment on or make changes to this bug.
Description NISZ LibreOffice Team 2019-09-26 08:59:10 UTC
Description:
In MSO it is possible to set a custom axis position to be On tick marks / Between tick marks. Some chart types are using Between tick marks as default (such as column, bar, line) while others use On tick marks, such as area.
Currently LibreOffice does not support writing this property to OOXML, although importing is supported since bug #127393.


Steps to Reproduce:
1.	Open attached file
2.	Save it as PPTX
3.	Reload or open it in PowerPoint


Actual Results:
The line charts lines and the area charts painted areas begin at the vertical axis.

Expected Results:
The lines and the painted areas begin shifted line in PowerPoint.


Reproducible: Always


User Profile Reset: No



Additional Info:
LibreOffice details:
Version: 6.4.0.0.alpha0+ (x86)
Build ID: 5440274a2a295fb2662ea415f25b89fc298930c8
CPU threads: 4; OS: Windows 6.3; UI render: GL; VCL: win; 
TinderBox: Win-x86@42, Branch:master, Time: 2019-09-26_01:04:59
Locale: hu-HU (hu_HU); UI-Language: en-US
Calc: CL
Comment 1 NISZ LibreOffice Team 2019-09-26 09:00:42 UTC
Created attachment 154521 [details]
Example file from PowerPoint with line chart and area chart using shifted axis position.
Comment 2 NISZ LibreOffice Team 2019-09-26 09:00:59 UTC
Created attachment 154522 [details]
The original file saved by Impress
Comment 3 NISZ LibreOffice Team 2019-09-26 09:01:32 UTC
Created attachment 154523 [details]
Screenshot of the original and exported document side by side in PowerPoint with line chart
Comment 4 NISZ LibreOffice Team 2019-09-26 09:01:57 UTC
Created attachment 154524 [details]
Screenshot of the original and exported document side by side in PowerPoint with area chart
Comment 5 Balázs Varga 2019-09-26 10:01:25 UTC
Confirmed in Version: 6.4.0.0.alpha0+

and

Version: 6.2.5.2 (x86)
Build az.: 1ec314fa52f458adc18c4f025c545a4e8b22c159
CPU szálak: 1; OS: Windows 6.1; Felületmegjelenítés: alapértelmezett; VCL: win; 
Területi beállítások: hu-HU (hu_HU); UI nyelve: hu-HU
Calc:
Comment 6 Commit Notification 2019-10-01 09:20:11 UTC
Balazs Varga committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/6027ec08fd5df2e09e34ff61b3777ad2cc8304b3

tdf#127777 OOXML chart export: fix X axis position setting "CrossBetween"

It will be available in 6.4.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 7 Commit Notification 2019-10-07 10:37:27 UTC
Balazs Varga committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/111c260ab2883b7906f1a66e222dbf4dc3c58c4f

tdf#127777 OOXML chart export: fix "CrossBetween" for not imported charts

It will be available in 6.4.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 8 Balázs Varga 2019-11-18 08:34:46 UTC
If we create a new column and line chart, the bar chart is partially displayed.

Steps to Reproduce:
1.	Create a new document with LibreOffice.
2.	Insert a new chart.
3.	Modify the chart type to Column and Line.

Actual Results:
The bar chart is partially displayed.

Reproducible: Always

Version: 6.4.0.0.alpha1+ (x64)
Build ID: 8a2e3c687248f5de979fa8020e1f925e7ae28cb7
CPU threads: 8; OS: Windows 10.0 Build 14393; UI render: GL; VCL: win; 
Locale: hu-HU (hu_HU); UI-Language: en-US
Calc: CL

Probably a regression from commit: 111c260ab2883b7906f1a66e222dbf4dc3c58c4f
(tdf#127777 OOXML chart export: fix "CrossBetween" for not imported charts)

Related patch: https://gerrit.libreoffice.org/#/c/82617/
Comment 9 Balázs Varga 2019-11-18 09:05:13 UTC
Created attachment 155909 [details]
Screenshot of the distorted Column and Line chart
Comment 10 Commit Notification 2019-11-18 14:04:59 UTC
Balazs Varga committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/071007d83d9d29fa7879b71b0e7b396da70963a5

tdf#127777 fix "CrossBetween" for not imported combined chart

It will be available in 6.5.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 11 Commit Notification 2019-11-19 06:53:06 UTC
Balazs Varga committed a patch related to this issue.
It has been pushed to "libreoffice-6-4":

https://git.libreoffice.org/core/commit/c506720874cedc4999d0c0e4d680914a3100b832

tdf#127777 fix "CrossBetween" for not imported combined chart

It will be available in 6.4.0.1.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.