Bug 67097 - binding to data lost when saved as fods
Summary: binding to data lost when saved as fods
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
(earliest affected) release
Hardware: Other All
: lowest critical
Assignee: Not Assigned
Depends on:
Blocks: Chart
  Show dependency treegraph
Reported: 2013-07-19 18:03 UTC by Lennard Wasserthal
Modified: 2019-10-10 15:24 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

initial chart pie.ods (18.98 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-01-17 16:53 UTC, pierre-yves samyn
converted flat pie.fods (49.50 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-01-17 16:54 UTC, pierre-yves samyn

Note You need to log in before you can comment on or make changes to this bug.
Description Lennard Wasserthal 2013-07-19 18:03:22 UTC
Steps to reproduce:
1. Create Data in calc
2. Create a chart in calc with a table as this data
3. save as fods
4. close and load again
=> In the chart, you can't select a data source anymore. You can just edit a 
=> note that when you switched x/y axis for that chart, it is also flipped back.
Comment 1 Lennard Wasserthal 2013-07-19 18:05:56 UTC
=> In the chart, you can't select a data source anymore. You can just edit a "Diagram Data Table". Switching x/y data axis is not necessary.
Comment 2 Lennard Wasserthal 2013-07-19 18:06:41 UTC
And yes, the data coherency is broken
Comment 3 pierre-yves samyn 2014-01-17 16:52:12 UTC

I confirm on windows 7/64 with Version:
Build ID: cd65d6220c5694ee7012d7863bcde3455c9e3c30

and Version:
Build ID: ae8e579515fff84cbef1ccc2da78fa769fb079ec
TinderBox: Win-x86@39, Branch:master, Time: 2014-01-10_11:16:31

Comment 4 pierre-yves samyn 2014-01-17 16:53:33 UTC
Created attachment 92292 [details]
initial chart pie.ods
Comment 5 pierre-yves samyn 2014-01-17 16:54:04 UTC
Created attachment 92293 [details]
converted flat pie.fods
Comment 6 Joel Madero 2015-05-02 15:41:08 UTC Comment hidden (obsolete)
Comment 7 pierre-yves samyn 2015-05-09 10:29:30 UTC

The bug no more occurs on windows 7/64 & Version:
Build ID: 88805f81e9fe61362df02b9941de8e38a9b5fd16
Locale: fr_FR

I do not set status to RESOLVED WORKSFORME because there is another problem: it is necessary to force the update of the chart (Ctrl+Shift+ F9) to drawn it.

Steps to reproduce:
1. open attachment 92292 [details]
2. File> Save As fods
3. close and load again

Expected result: chart in the same "state" as before
Actual result: the chart is not drawn (except the legend)

you have to update with Ctrl+Shift+ F9.

I suppose it would open another bug but I let the reporter to decide

Comment 8 QA Administrators 2016-09-20 09:41:43 UTC Comment hidden (obsolete)
Comment 9 pjryynan 2019-10-10 15:24:15 UTC
Since this has been included in the chart improvement meta ticket last year, perhaps it'll be worthwhile to explain my steps to repeat it. This became a bit of a hindrance to us at work.

This is with LibreOffice on Ubuntu 18.04. (Build ID: 1:6.0.7-0ubuntu0.18.04.10)

1. Run LibreOffice Calc. It opens new untitled document.
2. Add second sheet and insert number 1 into cells A1:B2
3. Go back to first sheet, click Create Chart and Finish.
4. Edit chart data range to point to $Sheet2.$A$1:$Sheet2.$B$2 by selecting and right click menu.
5. Save file as .fods, close LibreOffice, reopen file.
6. Now the chart on sheet 1 looks ok but data ranges can no longer be changed via right click menu.

Note that while trying to come up with simple steps to do this, I tried putting a chart in sheet2 that referred to a range sheet1. That one didn't break upon reopening libreoffice/document. I then dragged sheet2 to left of sheet1, saved and restarted+reopened. Chart on "sheet2" (the leftmost sheet) broke. (Lost bindings?) It was not fixable by dragging the sheet to the right and restarting.