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
: 147489 (view as bug list)
Depends on:
Blocks: Chart XLS
  Show dependency treegraph
 
Reported: 2015-01-02 12:51 UTC by Hannes
Modified: 2024-02-18 03:12 UTC (History)
6 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 (allotropia)
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 (allotropia) 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.
Comment 19 QA Administrators 2020-12-11 03:47:53 UTC Comment hidden (obsolete)
Comment 20 Denis Lisov 2020-12-11 07:14:14 UTC
I can confirm that the problem is still present in Libreoffice

Version: 7.0.3.1
Build ID: 00(Build:1)
CPU threads: 8; OS: Linux 5.9; UI render: default; VCL: kf5
Locale: en-GB (en_GB.utf8); UI: en-US
Gentoo official package
Calc: threaded

(with one local patch that's not relevant to this problem)
Comment 21 raal 2022-02-17 18:20:37 UTC
*** Bug 147489 has been marked as a duplicate of this bug. ***
Comment 22 QA Administrators 2024-02-18 03:12:44 UTC
Dear Hannes,

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
 
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug