Bug 121744 - XLSX Export y axis of Column and Line Chart created with Excel shows wrong values of Data Series exported and opened in Calc
Summary: XLSX Export y axis of Column and Line Chart created with Excel shows wrong va...
Status: RESOLVED FIXED
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: target:6.3.0 target:6.2.0.2
Keywords: filter:xlsx
Depends on:
Blocks: OOXML-Chart
  Show dependency treegraph
 
Reported: 2018-11-27 15:38 UTC by NISZ LibreOffice Team
Modified: 2019-03-25 02:52 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
A screenshot showcasing the issue. (132.00 KB, image/png)
2018-11-27 15:38 UTC, NISZ LibreOffice Team
Details
An example file (21.08 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2018-11-27 15:39 UTC, NISZ LibreOffice Team
Details
An example file after saved in Calc (20.87 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2018-11-27 15:39 UTC, NISZ LibreOffice Team
Details

Note You need to log in before you can comment on or make changes to this bug.
Description NISZ LibreOffice Team 2018-11-27 15:38:00 UTC
Description:
Excel 2016 shows wrong values of Data Series when the document is exported and opened in LibreOffice Calc 6.2.0.0.beta1++ 

The same happens when the Column and Line Chart is created with LibreOffice Calc

Steps to Reproduce:
    1. Create a new document in Microsoft Excel.
    2. Fill in with text the first five item in the first column
    3. Fill in with numbers the first five item in the second and third column
    4. Select A1:C5 range
    5. Insert Combo Chart
    6. Save the file as XLSX
    7. Open the same file in LibreOffice Calc 
    8. Select File and Save As
    9. Name and reload the file
    10. Compare the original file opened in Calc and the exported file opened in Calc

Actual Results:
Y axis of Column and Line Chart in XLSX documents created with Microsoft Excel 2016 shows wrong values of Data Series when the document is exported and opened in LibreOffice Calc 6.2.0.0.beta1++

Expected Results:
Y axis of Column and Line Chart should show the same values of Data Series as the original file opened in Calc 6.2.0.0.beta1++


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 NISZ LibreOffice Team 2018-11-27 15:38:43 UTC
Created attachment 147070 [details]
A screenshot showcasing the issue.
Comment 2 NISZ LibreOffice Team 2018-11-27 15:39:10 UTC
Created attachment 147071 [details]
An example file
Comment 3 NISZ LibreOffice Team 2018-11-27 15:39:39 UTC
Created attachment 147072 [details]
An example file after saved in Calc
Comment 4 Xisco Faulí 2018-11-28 17:01:15 UTC
Patch in gerrit: https://gerrit.libreoffice.org/#/c/64146/
Comment 5 Xisco Faulí 2018-11-28 17:04:25 UTC
Reprodcued in

Version: 5.2.0.0.alpha0+
Build ID: 3ca42d8d51174010d5e8a32b96e9b4c0b3730a53
Threads 4; Ver: 4.10; Render: default; 

Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)

LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4
Comment 6 Commit Notification 2018-12-01 08:30:34 UTC
Jozsef Szakacs committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/+/21399c7378be020e5e43fc07575f46e87e2d607b%5E%21

tdf#121744 XLSX Export Combinated Chart (Column and Line)

It will be available in 6.3.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 2018-12-20 10:24:18 UTC
Jozsef Szakacs committed a patch related to this issue.
It has been pushed to "libreoffice-6-2":

https://git.libreoffice.org/core/+/d58d92d72b00f45c56a3b0fe55ca9fd837d244a9%5E%21

tdf#121744 XLSX Export Combinated Chart (Column and Line)

It will be available in 6.2.0.2.

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 Xisco Faulí 2019-01-21 18:45:20 UTC
A polite ping to Jozsef Szakacs:
Is this bug fixed? if so, could you please close it as RESOLVED FIXED ? Otherwise, Could you please explain what's missing?
Thanks
Comment 9 Gabor Kelemen (allotropia) 2019-01-22 07:43:22 UTC
It's fixed, we just forgot to close it.