<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:jyrki.hofman@gmail.com" title="Jiří Hofman <jyrki.hofman@gmail.com>"> <span class="fn">Jiří Hofman</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - Absolute references in graphs move when data moves"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=137019">bug 137019</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>RESOLVED
</td>
<td>NEW
</td>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>NOTABUG
</td>
<td>---
</td>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>
</td>
<td>1
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Absolute references in graphs move when data moves"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=137019#c2">Comment # 2</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Absolute references in graphs move when data moves"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=137019">bug 137019</a>
from <span class="vcard"><a class="email" href="mailto:jyrki.hofman@gmail.com" title="Jiří Hofman <jyrki.hofman@gmail.com>"> <span class="fn">Jiří Hofman</span></a>
</span></b>
<pre>(In reply to m.a.riosv from <a href="show_bug.cgi?id=137019#c1">comment #1</a>)
<span class="quote">> What it's wrong? It keeps the references where the initial data is after
> insert a row before. It's the same if you have that reference in a cell.</span >
I hope I explained it quite clearly.
If a user makes a graph from the first x rows and updates the data by inserting
a row, the graph is not updated. He has to manually change the graph. There is
no way how to fix the data range in the graph.
It is fine that the data range changes when the references are relative but
changing it when the references are absolute makes no sense. Especially when
the relative references behave in the same way as absolute references.</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>