Bug 87964 - FILESAVE: Line type - Stepped in Chart saved in XLS / XLSX as Smooth (comment 17)
Summary: FILESAVE: Line type - Stepped in Chart saved in XLS / XLSX as Smooth (comment...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
4.1.0.4 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xls, implementationError
Depends on:
Blocks: Chart XLS
  Show dependency treegraph
 
Reported: 2015-01-02 12:51 UTC by Hannes
Modified: 2018-12-11 08:48 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
xls-file with incorrect displayed chart and screenshot (134.50 KB, application/vnd.ms-excel)
2015-01-03 14:45 UTC, Hannes
Details
ODS file with stepped line type chart (13.79 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-10-11 13:21 UTC, Timur
Details
Line chart options in Excel13 (24.11 KB, image/png)
2018-12-11 08:48 UTC, Gabor Kelemen
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Hannes 2015-01-02 12:51:04 UTC
Problem description: 
2 charts included in a xls file (file created by LO 4.2.7.2 and saved as xls) are displayed incorrectly after these steps: file-safe / close Calc / lock + unlock desktop / start Calc / open xls file.
Problem continues after completely restart of Mint17 (Cinnamon 2.2.16; kernel 3.13.0-24-generic). 

Problems in detail:
1) several values in chart differ from values in table;
2) value-lines (thickness, transparency) had changed;
3) value-lines: connection from one to next data point changed from 'step' to 'curved' style. 

Additional information: xls-file was marked "file changed" just after opening. 
Seems this bug is solved with LO version 4.3.x as stated in BUG 74808; but I have no RANDOM number in use... so just waiting for release version of LO 4.3.x?
Comment 1 raal 2015-01-02 18:07:58 UTC
Hello,

Thank you for filing the bug. Please send us a sample document, as this makes it easier for us to verify the bug. 
I have set the bug's status to 'NEEDINFO', so please do change it back to 'UNCONFIRMED' once you have attached a document.
(Please note that the attachment will be public, remove any sensitive information before attaching it.)
How can I eliminate confidential data from a sample document?
https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F
Thank you
Comment 2 Hannes 2015-01-03 14:45:06 UTC
Created attachment 111686 [details]
xls-file with incorrect displayed chart  and screenshot
Comment 3 Robinson Tryon (qubit) 2015-01-03 15:55:49 UTC
(In reply to Hannes from comment #2)
> Created attachment 111686 [details]
> xls-file with incorrect displayed chart  and screenshot

Repro document with embedded screenshot is a nice touch -- thanks! :-)

(In reply to Hannes from comment #0)
> 2 charts included in a xls file (file created by LO 4.2.7.2
>...
> Seems this bug is solved with LO version 4.3.x as stated in BUG 74808; but I
> have no RANDOM number in use... so just waiting for release version of LO
> 4.3.x?

LO 4.3 has been out since August 2014. LO 4.2.x is now End-of-Lifed. Get 4.3.5.2 here:
https://www.libreoffice.org/download/

Can you reproduce the problem with 4.3.5 or later? If so, change status back to UNCONFIRMED. If not, change status to RESOLVED WORKSFORME.
Thanks!

Status -> NEEDINFO
Comment 4 Hannes 2015-01-05 14:11:09 UTC
I will wait for LO-update shown by LinuxMint's Update Manager; I keep in mind to check the problem with the chart again if I have LO version 4.3.x installed.
Comment 5 Robinson Tryon (qubit) 2015-01-10 23:33:56 UTC
(In reply to Hannes from comment #4)
> I will wait for LO-update shown by LinuxMint's Update Manager; I keep in
> mind to check the problem with the chart again if I have LO version 4.3.x
> installed.

Hi Hannes,
I'm not sure how quickly Mint will push out a build of LO 4.3, but please do let us know how everything works out once you get the update.

If it's more than a couple of months from now, you may get an automated update to the bug report. Don't worry: You can always change the bug back to 'UNCONFIRMED' in the future if you find that the bug hasn't been fixed.
Comment 6 QA Administrators 2015-07-18 17:36:31 UTC Comment hidden (obsolete)
Comment 7 Libomark 2015-08-05 23:00:53 UTC
I find the bug persists using 4.4.2.2 in Win7.
Comment 8 raal 2015-08-20 11:15:50 UTC
I can confirm with Version: 5.1.0.0.alpha1+
Build ID: 6b7354ae66db40246a09e00aa876443057655a43
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2015-08-19_01:05:16

Steps to reproduce>
open file
edit chart / Chart type / change "Line type"  to "Stepped"
save, close, reopen

Actual results:
Line type =  Smooth
Comment 9 Hannes 2015-09-20 12:07:34 UTC
Hello,
I stopped waiting for new version of LO via MintUpdate and installed LO 5.0.1.2; Build-ID 81898c9f5c0d43f3473ba111d7b351050be20261 manually last week. The problem persists. (I dont know if this info is helpful as 'raal' already posted on 2015-08-20, using a higher version of LO.).
Comment 10 raal 2015-09-20 13:33:28 UTC
Correct status, problem persists => NEW
Comment 11 Hannes 2015-09-21 11:03:51 UTC
Hello,
I did some testing - maybe this is not a bug of LO, just a limitation of selected file format (xls, also xlsx) that causes that, and LO just cannot interprete what is stored in that format for full 100% when opening in LO. I also discovered that the Y-axis text labels change when using another than ODF (ods) file format. I encountered no problems so far using the ods file format. Suggestion: we consider it solved and LO displays a more strictly warning of unwanted changes when saving in other file formats than ODF.
Comment 12 Robinson Tryon (qubit) 2015-12-09 16:39:44 UTC Comment hidden (obsolete)
Comment 13 QA Administrators 2017-01-03 19:42:52 UTC Comment hidden (obsolete)
Comment 14 Libomark 2017-01-06 18:03:21 UTC
Bug still persists using Version: 5.2.0.4
Build ID: 066b007f5ebcc236395c7d282ba488bca6720265 under Win 7 Pro 64 bit.
Comment 15 QA Administrators 2018-01-07 03:31:14 UTC Comment hidden (obsolete)
Comment 16 Denis Lisov 2018-04-08 22:10:19 UTC
This bug is still present in Libreoffice 6.0.3.2 on Gentoo Linux (distribution package).
Comment 17 Timur 2018-10-11 13:21:04 UTC
Created attachment 145609 [details]
ODS file with stepped line type chart

This bug is not fileopen, but "FILESAVE: Line type - Stepped in Chart saved in XLS / XLSX as Smooth".
Started in 4.1 when stepped line type was added. Implementation error. Repro with 6.2+.
Comment 18 Gabor Kelemen 2018-12-11 08:48:50 UTC
Created attachment 147432 [details]
Line chart options in Excel13

It might be that Excel does not even has this chart type, at least I don't see it in the new line chart dialog options.