Bug 106067 - A chart in a duplicated sheet sometimes loses its data range
Summary: A chart in a duplicated sheet sometimes loses its data range
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
5.2.2.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Chart-Data
  Show dependency treegraph
 
Reported: 2017-02-17 17:37 UTC by david.vantyghem
Modified: 2023-07-23 11:22 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
An example of a chart that lost all the references with the data. (108.66 KB, image/jpeg)
2017-02-17 17:37 UTC, david.vantyghem
Details
Example with broken copy of sheet (16.36 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-02-18 22:52 UTC, Ferry Toth
Details

Note You need to log in before you can comment on or make changes to this bug.
Description david.vantyghem 2017-02-17 17:37:06 UTC
Created attachment 131299 [details]
An example of a chart that lost all the references with the data.

If a copy (duplicate) a sheet, al the data and the charts are copied in the new shhet. But sometimes, the chart can't be edited anymore, it looses all the references to the data.
Comment 1 Xisco Faulí 2017-02-17 20:36:09 UTC
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. 
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
(Please note that the attachment will be public, remove any sensitive information before attaching it. 
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
Comment 2 Ferry Toth 2017-02-18 22:51:45 UTC
I found this in 5.2.2.2 as well. I happens at least when copying a sheet containing a XY chart, the data ranges in the copied sheet get mixed up. See attachment.
Comment 3 Ferry Toth 2017-02-18 22:52:43 UTC
Created attachment 131328 [details]
Example with broken copy of sheet
Comment 4 Buovjaga 2017-02-19 19:07:47 UTC
NEW per Ferry's case
Comment 5 QA Administrators 2018-06-15 02:45:11 UTC Comment hidden (obsolete)
Comment 6 david.vantyghem 2018-07-21 07:35:46 UTC
Bug still present in LibreOffice :

Version: 6.0.5.2
Build ID: 1:6.0.5~rc2-0ubuntu0.16.04.1~lo1
Threads CPU : 4; OS : Linux 4.15; UI Render : par défaut; VCL: gtk2; 
Locale : fr-FR (fr_FR.UTF-8); Calc: group

When I copy (duplicate) a sheet with data and charts, all is copied in the new sheet but sometimes, the chart use the data of the original sheet and not the data of the new sheet.
Comment 7 david.vantyghem 2018-07-21 07:36:58 UTC
I duplicate the sheets and save, close then open the file before testing it.
Comment 8 QA Administrators 2019-07-22 02:44:19 UTC Comment hidden (obsolete)
Comment 9 QA Administrators 2021-07-22 03:50:22 UTC Comment hidden (obsolete)
Comment 10 QA Administrators 2023-07-23 03:15:06 UTC Comment hidden (obsolete)
Comment 11 david.vantyghem 2023-07-23 07:08:38 UTC
It seems to work now.

Version: 7.3.7.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Ubuntu package version: 1:7.3.7-0ubuntu0.22.04.3
Calc: threaded
Comment 12 Aron Budea 2023-07-23 11:22:27 UTC
Let's use status WORKSFORME, since the fixing change is unknown.