Bug 139188 - Charts on copied sheet still reference the data in the original sheet
Summary: Charts on copied sheet still reference the data in the original sheet
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: dataLoss
: 153386 (view as bug list)
Depends on:
Blocks: Chart
  Show dependency treegraph
 
Reported: 2020-12-23 14:51 UTC by paulystefan
Modified: 2023-07-21 16:31 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
my test tables with public data (1.04 MB, application/vnd.oasis.opendocument.spreadsheet)
2020-12-23 14:51 UTC, paulystefan
Details

Note You need to log in before you can comment on or make changes to this bug.
Description paulystefan 2020-12-23 14:51:30 UTC
Created attachment 168452 [details]
my test tables with public data

LO 7.0.4.2-x64 is my actual system with win 10 x64

After copy the table with the default LO name (oldname_2) then the charts inside are not actually with the new table name.

what to do

copy a table and then look inside the chart with his data area.
Comment 1 paulystefan 2020-12-23 17:25:14 UTC
it is a copy of the sheet not a table
Comment 2 paulystefan 2020-12-26 18:32:20 UTC
After a change of data for a graph, the graph does not actualize.

You must save, close, and reopen to have an actual data view.

In this status, LO is at MSO 1990-Level.
Comment 3 Leyan 2020-12-29 10:12:57 UTC
I can confirm the bug with the attached file. When copying data and chart to a new sheet, the normal behavior is to adapt the range of the chart data source to point toward the new sheet, but this did not happen here. So the chart in the new sheet still points toward the data in the old sheet.

I was able to reproduce it by playing around but I am not sure what triggers the different behavior. However, I don't see how saving and reopening the file changed something on your side, as the range was saved using the old sheet, this should stay the same.

The snide comment about LibreOffice quality is quite unnecessary, it will not motivate developers further.
Comment 4 paulystefan 2020-12-30 12:00:07 UTC
For me, this is a big core bug. I want to motivate here for faster debugging. 

There is no choice for institutions or firms to use and sponsor LO with such errors. There are minor bugs and differences to MSO and big bugs and big differences. And the big differences decide first.
All that the program can do, should be perfect. 
And basic things must after 30 years star office, open office and libre office be perfect.
Better no feature or only beta feature than a buggy feature.

But this feature is a basic feature of all table programs.

MSO has also managed with templates to reproduce charts in the same way for equal tables with different data.

And saving Performance of MSO is with this sheet also 10 and more times faster. And there is near doubled file size of the ods against XLSX.


So now to the bugs in this sheet with LO.

There is a difference in behavior.

Copy of sheet with oldname_2: in charts only oldname

copy of sheet with a new name: some times new name in charts and some times old name in charts. There was no obvious system for me.

In Version 7.1.0.1, I see only the old name in the new sheet in charts.
In 7.0.x it was both possible. Then the charts do not actualize with new data in the new table.

In 6.4.7.2 I could destroy the session and lose the work with copy and rename action of sheets in this simple calc ods.
In 6.4.7.2 there was also a problem with the rename action.

So there is positive progress in development.
Comment 5 paulystefan 2020-12-31 11:45:10 UTC
For me, it is a critical bug, because every user must verify by hand the copied charts.

So it is like a data loss. The user has false charts in his sheets with new data wrote over old copied in his sheets.

Then there is no actualization in the charts with new data.
Comment 6 paulystefan 2021-05-12 14:49:46 UTC
in 7.13.2 x64 in win 10 x64 

it is partly solved

1. copy of sheet with default name oldname_2

no new name in copy sheet form!

2. save file

3. rename sheet to your name you wish

4. save file

Without saving the file the names spring back to the old name of the sheet.
Comment 7 m_a_riosv 2023-02-05 22:31:48 UTC
*** Bug 153386 has been marked as a duplicate of this bug. ***