<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Copying a chart converts data ranges to data table"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=113572">113572</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Copying a chart converts data ranges to data table
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.2 all versions
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>s.mehrbrodt@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=137422" name="attach_137422" title="Example document">attachment 137422</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=137422&action=edit" title="Example document">[details]</a></span>
Example document
1. Open the attached document
2. The chart has a data range defined (right-click chart, "Edit", then click
"Data ranges" in the toolbar).
3. Leave chart editing mode (Esc) and copy and paste the chart into an empty
document.
Then try to find the data range and adjust it.
It's no longer there, the data range has been converted to a data table.
The advantage of this behavior is that the chart looks the same wherever you
paste it because its data is attached to it.
However, if you want to change the chart to use a data range instead as before,
there's no obvious way to do this. You can drag+drop the cells you want to use
as data range onto the diagram.
We should make this easier. I don't think we should change the default since it
probably does makes sense in most cases to have the data attached to the chart
when copying it.
But we should
1) Enable the button "Data ranges" even when the chart has a data table. The
user should be warned that he will lose the data table when he decides to use a
data range instead. This should also be possible using the context menu.
2) As a second step, ask the user when pasting a chart whether he wants to
- paste the chart with the original data converted to a data table (as it is
now, should stay the default)
- paste only the chart and use the data from the sheet he pastes into (might
make sense when one has similiar sheets and wants to use the same chart
everywhere)</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>