[Libreoffice-bugs] [Bug 113979] Paste unformated text does not ignore empty cells

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #7 from Laurent BP <jumbo4444 at yahoo.fr> ---
(In reply to Tamás Gulácsi from comment #6)
> The "Text to Columns" case is clear, you don't want to have anything there
> which weren't in the text before.
> The simplest case for this is converting ",a,b,c" to columns - you want "_ a
> b c" and not ",a,b,c a b c".
I do not totally agree with you. It's OK for the *first* column: if text starts
with a separator, first column must be empty.
But if text contains several successive separator, user may (or not) want to
keep the previous content of the cell.
Lets consider for example in column A: ",b,,d,,f". 
In Text to column with comma as separator, with previous behavior (prior 5.3)
content of column C and E where preserved (and column A was not emptied which
was the bug). With new behavior (from version 5.3), column A, C and E are
emptied.

As this was the behavior from the beginning, not erasing columns C and E should
be consider as a feature.

An option "Skip empty cells" would make all users happy, if Text to column
function considers to erase first column if text starts with a separator.

-- 
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/20171122/25b9bb6f/attachment.html>