Bug 166428 - Stock Chart is not correctly saved and corrupts the spreadsheet file
Summary: Stock Chart is not correctly saved and corrupts the spreadsheet file
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
25.2.3.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisectRequest, regression
Depends on:
Blocks:
 
Reported: 2025-05-02 08:07 UTC by MS
Modified: 2025-05-04 06:52 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
example data for a stock chart (13.23 KB, application/vnd.oasis.opendocument.spreadsheet)
2025-05-02 17:06 UTC, MS
Details

Note You need to log in before you can comment on or make changes to this bug.
Description MS 2025-05-02 08:07:36 UTC
Description:
When creating a stock chart which is not Type 1, everything looks as expected. But when the file is saved, closed and opened again, the specific stock data is replaced by several unspecific data rows (the number depends on how many columns have your data table, used as data source). Of course also the chart is empty, because the data is now nonsense. When saving again, the data rows in the chart multiply again and again with each following save. After a while the document can still be opened, but saving takes longer and longer and the file size increases dramatically. 

Steps to Reproduce:
1. create a new spreadsheet document
2. create a data table with 3 rows and 3 columns, enter any numbers in this matrix (e.g. 1 to 9 distributed over the cells)
3. select the data matrix and create a chart, type "stock chart", use NOT the Type 1, but e.g. "candle stick chart" (Type 2)
4. save the file
5. close the file
6. open the saved file

Actual Results:
1. before saving, the diagram is shown and has one data row with "low", "high" and "close" values attached
2. after closing and opening again, you have 4 data rows, where the first is empty and all others have the table columns attached as Y-Data
3. if saving, closing and opening again, the number of chart data rows multiplies with the number of table columns, and this happens each time you save

Expected Results:
after opening the saved file, the result should be the same as before closing 


Reproducible: Always


User Profile Reset: Yes

Additional Info:
you can compare the content.xml from the document with a diff-viewer to see, how the number of data rows increases with each save operation

Version: 25.2.3.2 (X86_64) / LibreOffice Community
Build ID: bbb074479178df812d175f709636b368952c2ce3
CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: CL threaded
Comment 1 m_a_riosv 2025-05-02 14:42:39 UTC
What file format do you use to save?

Please attach a sample file with the raw data, without the chart, to test it.
Comment 2 MS 2025-05-02 17:06:40 UTC
Created attachment 200633 [details]
example data for a stock chart

The saved file is ods format. It contains the sample data for stock chart from libreoffice-help, without having the chart inside.
Comment 3 m_a_riosv 2025-05-02 23:02:48 UTC
Seems the issue is at saving, open a file saved with the chart right in Ver 24.8.7 o previous open the chart fine with 25.2 or posterior.
But saving with 25.2 or posterior, shows the issue with 24.8.7 or previous.

Reproducible
Version: 25.2.0.3 (X86_64) / LibreOffice Community
Build ID: e1cf4a87eb02d755bce1a01209907ea5ddc8f069
CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded
+
Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 923da8a3855afae1f3f3a5f50d1fec08bbc02438
CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: en-GB
Calc: CL threaded


Latest version that works on the ones I have installed.
Version: 24.8.7.1 (X86_64) / LibreOffice Community
Build ID: 67172c63871c755bc0e5f9fc0c892575790cdcf6
CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded