[Libreoffice-bugs] [Bug 129699] New: EDITING “Paste special - Unformatted text” does not overwrite content with empty cell

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 129699
           Summary: EDITING “Paste special - Unformatted text” does not
                    overwrite content with empty cell
           Product: LibreOffice
           Version: 6.5.0.0.alpha0+ Master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: libreoffice at nisz.hu

Description:
When copying and pasting a cell range in Calc that contains an empty cell, the
empty cell does not overwrite preexisting content in target cell range.

Steps to Reproduce:
1.      Open the attached simple Calc table with some text in A1:A4 and in
B1:B4 with B3 empty.
2.      Copy the B1:B4 range and paste it while standing on A1 with Paste
Special -> Unformatted text.
3.      The Text Import dialog shows and the preview shows that the third cell
would be empty. Click OK.


Actual Results:
The third cell is not overwritten with the empty cell.

Expected Results:
(1) The normal Ctrl-V paste would overwrite A3 with the empty cell content in
B3. 
(2) The user who reported this issue expects that Paste Special -> Unformatted
text would also empty the cell. This does not happen, because the Text Import
window has a “Skip empty cells” option that is turned on by default. Also:
turning it off does not seem to make a difference, that might be another bug.
(3) The “no overwrite with empty cell” result could be achieved by enabling the
Paste Special dialogs Skip empty cells option. “Skip empty cells” is off by
default so using Paste Special -> Paste Special and only pasting Text, Numbers,
Date & time gives also the same result as in (1).

To sum it: options (1) and (3) are overwriting the cell content by default, but
(2) does not. I’m not sure whether this is intentional or not. 
Syncing the default setting of “Skip empty cells” between the Text Import and
Paste Special dialogs would be a solution to this.



Reproducible: Always


User Profile Reset: No



Additional Info:
LibreOffice details:
Version: 6.5.0.0.alpha0+ (x64)
Build ID: 0ad51b30556f96bff0d78cc540781416c1ea6b8b
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: GL; VCL: win; 
Locale: hu-HU (hu_HU); UI-Language: en-US
Calc: CL

Also happens in:
Verzió: 6.0.0.3
Build az.: 64a0f66915f38c6217de274f0aa8e15618924765
CPU szálak: 4; OS: Windows 6.3; Felületmegjelenítés: alapértelmezett; 
Területi beállítások: hu-HU (hu_HU); Calc: CL

Verzió: 4.0.0.3 (Build az.: 7545bee9c2a0782548772a21bc84a9dcc583b89)

LibreOffice 3.5.0rc3 
Build ID: 7e68ba2-a744ebf-1f241b7-c506db1-7d53735

-- 
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/20191230/ca641c31/attachment-0001.htm>