[Libreoffice-bugs] [Bug 67097] binding to data lost when saved as fods

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=67097

--- Comment #9 from pjryynan at gmail.com ---
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 6.0.7.3 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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20191010/cf18ff7f/attachment.html>