[Libreoffice-bugs] [Bug 129701] Skip empty cells option does not work in Calc Text Import dialog

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #10 from mirko.sessa at gmail.com ---
I do reproduce on:
Version: 6.4.6.2 (x64)
Build ID: 0ce51a4fd21bff07a5c061082cc82c5ed232f115
CPU threads: 8; OS: Windows 10.0 Build 17763; UI render: default; VCL: win; 
Locale: it-IT (it_IT); UI-Language: en-US
Calc: threaded

I had a similar issue in production, so I tried to isolate the problem.
In my experience, the paste unformatted text command works properly when the
"skip empty cells" is selected.
On the other side, when the "skip empty cells" is NOT selected, the bug arises
only when the source range contains an empty value at the END of a row. Such
empty value at the end of the source row does not overwrite the corresponding
destination cell in CALC.

. Initial CALC destination range (the one to overwrite)
a | B
c | d

. Source comma-separated range
1,
3,4

Actual result of paste special unformatted text w/o "skip empty cells"
1 | b
3 | 4

Expected result:
1 |
3 | 4

I think that the steps to reproduce initially provided by NISZ LibreOffice Team
could fit in this new explanation because the empty cell B3 in the source
column-range B1:B4 might be considered as an empty cell at the end of the row
3.

-- 
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/20201013/fe028355/attachment.htm>