Bug 69698 - FILESAVE: Line width and color of Stock Chart not properly saved (comment 4)
Summary: FILESAVE: Line width and color of Stock Chart not properly saved (comment 4)
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 129647 (view as bug list)
Depends on:
Blocks: Chart
  Show dependency treegraph
 
Reported: 2013-09-23 09:43 UTC by Mamoth
Modified: 2022-11-18 10:30 UTC (History)
7 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.
Comment 15 Tom 2020-01-14 02:07:07 UTC
*** Bug 129647 has been marked as a duplicate of this bug. ***
Comment 16 Richard Harding 2021-01-27 07:42:39 UTC
I have a chart with 4 data series, namely All Cause, Cancer, CDV and Other Mortality rates.

I use Stock Chart to show the median, the lower bound of the 95% confidence interval and the upper bound of the 95% confidence interval.

The OPENING and CLOSING are the median values of the data series, the LOW values are the lower bound of the 95% CI and HIGH values of the data range is the upper bound of the 95% CI.

After changing the body size of the candle stick and giving each data series a different colour, I end up with a very nice chart.

However, only the data series 1 formatting (ALL CAUSE MORTALITY) is saved.

If I add or delete a title then these changes are saved. If I edit the title, then these changes are not saved.

Closing LibreOffice without saving results in the warning message to save the document ONLY the title is added or deleted but not when the title is edited.

Similarly, closing LibreOffice without saving results in a warning message to save the document ONLY when the data series 1 is changed.

If I change data series 1 and 2 without saving, I still receive the warning message but only the changes to the formatting of data series 1 is saved.

The problem also exists on OpenOffice.
Comment 17 Stéphane Guillou (stragu) 2022-11-18 10:30:57 UTC
Reproduced in:

Version: 7.5.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 45d1fca81991f0d6837c98d6be6fe0d21d566fa5
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

Individually changed line widths and colours beyond series 1 are lost after save and reload.