<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 - Impossible to save a Calc file with a chart with an invalid data range obtained when converting from data table"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=138833">138833</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Impossible to save a Calc file with a chart with an invalid data range obtained when converting from data table
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>7.0.2.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (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>ouyang.leyan@hotmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
In a chart with an internal data table copied to Calc, starting the process of
replacing the internal data table by data ranges (but without actually
configuring the data ranges) can leave the file in a state impossible to be
saved.
Steps to Reproduce:
1.Create a chart in Word, copy it to Excel.
2. Edit the chart and select "Data Ranges".
3. Choose Yes in the confirmation popup, the Data Ranges settings popup
appears.
However, the values chosen in the ranges are non-sensical, they do not refer to
cells at all ("category" for Categories, etc.)
4. Cancel this popup.
Actual Results:
The invalid ranges chosen by default are kept, the original data is still
displayed, and the file becomes impossible to save with the chart in it. A
popup appears "Error saving the document" "Write Error" "The file could not be
written".
Expected Results:
The default ranges should be valid by default, like when creating a new chart.
Even if the data is overwritten by an empty chart, the file stays usable.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.0.2.2
Build ID: 00(Build:2)
CPU threads: 4; OS: Linux 5.9; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
7.0.2-2
Calc: threaded</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>