Bug 114279 - XLSX Difference line on charts does not appear in Calc
Summary: XLSX Difference line on charts does not appear in Calc
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
Depends on:
Blocks: OOXML-Chart
  Show dependency treegraph
 
Reported: 2017-12-06 10:49 UTC by Gabor Kelemen (allotropia)
Modified: 2023-07-20 11:16 UTC (History)
2 users (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-12-06 10:49 UTC, Gabor Kelemen (allotropia)
Details
Screenshot of the document in LO 6 and Excel 2013 (284.19 KB, image/png)
2017-12-06 10:49 UTC, Gabor Kelemen (allotropia)
Details
The example file saved by LO6 alpha (16.79 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2017-12-06 11:34 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-12-06 10:49:32 UTC
Created attachment 138238 [details]
Example file made with Excel 2013

If we create a simple “Points and Lines” Chart in Microsoft Excel 2013/2016 and add a difference line to the diagram, the LibreOffice Calc will not display the difference line because, this concept does not exist.

Steps to reproduce:
1. Create a new spreadsheet in Excel 2013/2016.
2. Create a simple “Points and Lines” Chart.
3. Add difference line to the diagram.
4. Save the spreadsheet in xlsx.
5. Open the file in LibreOffice Calc.

Actual results:
The difference line disappears from the diagram.

Expected results:
The difference line should not be disappear from the diagram.
Comment 1 Gabor Kelemen (allotropia) 2017-12-06 10:49:55 UTC
Created attachment 138239 [details]
Screenshot of the document in LO 6 and Excel 2013
Comment 2 Xisco Faulí 2017-12-06 11:06:54 UTC
Reproduced in

- Version: 6.1.0.0.alpha0+
Build ID: 889c72a7e54f241342f42b1b0a05858902228cbc
CPU threads: 4; OS: Linux 4.10; UI render: default; VCL: gtk3; 
Locale: ca-ES-valencia (ca_ES.UTF-8@valencia); Calc: group threaded

- Version: 4.3.0.0.alpha1+
Build ID: c15927f20d4727c3b8de68497b6949e72f9e6e9e

- Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)

- LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4
Comment 3 Gabor Kelemen (allotropia) 2017-12-06 11:34:32 UTC
Created attachment 138240 [details]
The example file saved by LO6 alpha
Comment 4 QA Administrators 2022-02-10 03:40:41 UTC Comment hidden (obsolete)
Comment 5 Amin Irgaliev 2023-07-20 11:16:25 UTC
Still repro with
Version: 7.6.0.1.0+ (X86_64) / LibreOffice Community
Build ID: 2198fd843b71ea6c8152f882b107eac7b3edd647
CPU threads: 12; OS: Linux 6.1; UI render: default; VCL: kf5 (cairo+xcb)
Locale: ru-RU (ru_RU.UTF-8); UI: en-US
Calc: threaded