[Libreoffice-bugs] [Bug 107779] Sorting breaks rows data alignement when functions include columns with no data

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=107779

Luca <pp.luca at tiscali.it> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|CLOSED                      |REOPENED
         Resolution|NOTABUG                     |---
     Ever confirmed|0                           |1

--- Comment #2 from Luca <pp.luca at tiscali.it> ---
(In reply to Eike Rathke from comment #1)
> 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. 

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".

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170512/1f447242/attachment.html>