Bug 69698 - FILESAVE: Line width & color of Stock Chart not properly saved
Summary: FILESAVE: Line width & color of Stock Chart not properly saved
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
4.0.4.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 76881 (view as bug list)
Depends on:
Blocks: Chart
  Show dependency treegraph
 
Reported: 2013-09-23 09:43 UTC by Mamoth
Modified: 2019-03-18 21:53 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
Compare the 3 charts on the left-hand side and the images on the right-hand side : it is impossible to save the charts with these formattings. (89.22 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-09-23 09:43 UTC, Mamoth
Details
Same file again. (89.22 KB, application/vnd.oasis.opendocument.graphics)
2013-09-23 09:45 UTC, Mamoth
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Mamoth 2013-09-23 09:43:59 UTC
Created attachment 86351 [details]
Compare the 3 charts on the left-hand side and the images on the right-hand side : it is impossible to save the charts with these formattings.

Hello.

I have been working on compilling some scientific data and making some charts to present them as stock charts. 

I edited them to format the data series (changing the line widths and colours of the stock charts). When I save and re-open the file, all these hand-made formating is gone. I tried several times, only repeating the problem every time.

I have attached the file. 
By luck, I had exported the charts as images (to import them in LO Writer) before closing the file. I have included the images side by side to the charts in the spreadsheet so you can compare and see what are the changes that are impossible to save.
Comment 1 Mamoth 2013-09-23 09:45:33 UTC
Created attachment 86352 [details]
Same file again.
Comment 2 ign_christian 2013-09-23 10:07:39 UTC Comment hidden (obsolete)
Comment 3 Joel Madero 2013-09-24 02:11:14 UTC Comment hidden (obsolete)
Comment 4 Mamoth 2013-09-24 17:55:28 UTC
Hello.

Thanks for handling this bug.

Regarding the number of bugs : that some features of the charts (colour and line width) are not kept when the file is saved is a single bug, but I just found another one regarding the data series so I'll open another bug,

I filled the info regarding the version of LO (4.0.4.2). The OS is Ubuntu 12.04 up-to-date.

To reproduce the bug : 
 - download the second attachment. It's a .ods file. Open it.
 - There is only one sheet, called GES_sélection. It has 3 charts but also 3 images which are screen captures of the same charts, with some formatting changes. These images are what we are trying to achieve.
 - Ignore the first chart ('Emissions de gaz à effet de serre dans la productionde chaleur'). I'll open another bug for this one.
 - For the 2 other charts, reproduce the formating shown in the images : double-click the chart, and double-click any of the stock lines to open the 'Data series' window. Open the 'Line' tab. Change the width and the colour of the line.
 - Save the file and close it.
 - Open it again : the changes are gone.
Comment 5 ign_christian 2013-10-11 10:03:06 UTC
I can confirm those behavior on 2nd chard with LO 3.6.7.2 (Ubuntu 12.04 32bit). Changing of line color & width to 0,1cm not properly saved.

Also saw strange things:
- First line (éolien) properly saved
- At first reopening of the file after saving & closing, chart looks right. But double clicking the chart will rechange color & line width to previous state.
Comment 6 sophie 2014-04-16 09:15:35 UTC
*** Bug 76881 has been marked as a duplicate of this bug. ***
Comment 7 sophie 2014-04-16 09:16:59 UTC
Change plateform to all according to bug 76881 - Sophie
Comment 8 reddish 2014-05-23 12:46:49 UTC Comment hidden (me-too)
Comment 9 reddish 2014-05-23 12:48:20 UTC
(In reply to comment #8)
> I did some tests and can add that any decoration (lines, labels, shapes,
> arrows, etc)added to charts is lost after saving and retrieving the file.
> 
> Reddish

Forgot to add:

LO 4.2.4.2 Win 7.

Reddish
Comment 10 QA Administrators 2015-06-08 14:43:15 UTC Comment hidden (obsolete)
Comment 11 Buovjaga 2015-08-02 11:53:36 UTC
Repro comment 4.

Win 7 Pro 64-bit Version: 5.1.0.0.alpha1+
Build ID: 902255645328efde34ddf62227c8278e8dd61ff0
TinderBox: Win-x86@39, Branch:master, Time: 2015-07-30_03:52:07
Locale: en-US (fi_FI)
Comment 12 QA Administrators 2016-11-08 11:38:31 UTC Comment hidden (obsolete)
Comment 13 Timur 2018-10-11 15:26:45 UTC
Sorry to write this after many years but: Repro comment 4 with 6.2+. 
We don't know why this happens with example file (I can't recreate). Because it seems saved when simple stock chart is created from scratch.
Comment 14 Mark Lytle 2018-12-13 23:14:45 UTC
I'm having the same problem here.  I have posted this to the help forum over at Libreoffice but with a lot of people looking, no solutions.

https://ask.libreoffice.org/en/question/176160/having-trouble-with-stock-chart-creation-in-calc/

Not only am I not able to save the attributes of one of the series, sometimes it corrupts the X-axis to the point of unrecoverability.