<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - Paste unformated text does not ignore empty cells" href="https://bugs.documentfoundation.org/show_bug.cgi?id=113979#c7">Comment # 7</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - Paste unformated text does not ignore empty cells" href="https://bugs.documentfoundation.org/show_bug.cgi?id=113979">bug 113979</a> from <a class="email" href="mailto:jumbo4444@yahoo.fr" title="Laurent BP <jumbo4444@yahoo.fr>"> Laurent BP</a> <pre>(In reply to Tamás Gulácsi from <a href="show_bug.cgi?id=113979#c6">comment #6</a>) > 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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>