<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:pp.luca@tiscali.it" title="Luca <pp.luca@tiscali.it>"> <span class="fn">Luca</span></a>
</span> changed
<a class="bz_bug_link
bz_status_REOPENED "
title="REOPENED - Sorting breaks rows data alignement when functions include columns with no data"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=107779">bug 107779</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>CLOSED
</td>
<td>REOPENED
</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_REOPENED "
title="REOPENED - Sorting breaks rows data alignement when functions include columns with no data"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=107779#c2">Comment # 2</a>
on <a class="bz_bug_link
bz_status_REOPENED "
title="REOPENED - Sorting breaks rows data alignement when functions include columns with no data"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=107779">bug 107779</a>
from <span class="vcard"><a class="email" href="mailto:pp.luca@tiscali.it" title="Luca <pp.luca@tiscali.it>"> <span class="fn">Luca</span></a>
</span></b>
<pre>(In reply to Eike Rathke from <a href="show_bug.cgi?id=107779#c1">comment #1</a>)
<span class="quote">> With "Update references when sorting range of cells" this is expected.
> Without a value in column E the sort range is A1:D3, but a reference like C3:E3
> points outside that range so is not moved with the data but adjusted to point
> to the original location. That's exactly why the option exists. </span >
That doesn't make sense to me: if I select all (step 2) I explicity tell the
program to sort all the rows and columns. That's how the sorting function
normally works in Calc.
If this behaviour is intentional, then the bug is not to warn users that their
sorting area has been arbitrary restricted and rows integrity will be lost.
I also see that warnings about the selected sorting area extention seem to have
disappeared in last versions of Calc. I think they should be reinstated. There
should be no situation when the records integrity is at risk without any
warning.
Please, understand that not intuitive, dangerous and incoherent behaviours
cannot be considered as "normal".</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>