[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

--- Comment #15 from Xavier Guillot <Valeryan_24 at orange.fr> ---
Created attachment 161956
  --> https://bugs.documentfoundation.org/attachment.cgi?id=161956&action=edit
Empty cells not sorted, even if have a color background

I confirm the bug : some cells, if they are on a border of a table and the
column has no value, even if they are selected to be sorted and have a
background color, stay at the same place and are not moved with the next ones,
which creates a visual break and adds work to rearrange the presentation.

For example in my screenshot : often I have incomplete tables - ie an agronomic
test after harvest, I enter the grain yield and sort from best to lowest
productive (except row 1), but I keep an empty column to add later the oil
content. I set to (some or all) rows different colors.

If the column with empty cells is on the right of the table / selection, they
are not sorted (columns E-F-G in my test).

If they are on the middle, they are well moved with the others (M-N-O).

Also, if I add on first example, on column C only one value on a cell without
any colored background and keep all others empty, all the rows are well sorted
and "empty" cells moved.

Cells should not considered as empty if a background color has been set ; if
one cell is not seen as empty, the whole column must not be seen as empty, too,
and be sorted. Or more logical, if the cells are selected for sorting, they
should be sorted, empty or not...

-- 
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/20200613/54f582cf/attachment.htm>