https://bugs.documentfoundation.org/show_bug.cgi?id=158297
--- Comment #1 from ady <adylo811...@gmail.com> --- OTOH, the behavior allows to overwrite prior values with newer values without "deleting" prior values when a new value does not exist – a differential replacement. So, there are cases for which the current behavior is useful. One possible alternative workaround to the case described in comment 0 would be to have some other character instead of "empty" fields/cells. For instance: * with a space character: Legend;1;2;3 b;b-1;b-2;b-3 empty; ; ; d;d-1;d-2;d-3 e;e-1;e-2;e-3 * with an underscore character: Legend;1;2;3 b;b-1;b-2;b-3 empty;_;_;_ d;d-1;d-2;d-3 e;e-1;e-2;e-3 which allows to replace the prior values, and then you could perform a (Find&)Replace action on the selected special character. IMO, I would not change the current behavior. -- You are receiving this mail because: You are the assignee for the bug.