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
Created attachment 156845 [details] Example file from Calc
Created attachment 156846 [details] The Text Import dialog before pasting
Created attachment 156847 [details] The file after pasting with A3 not becoming empty
Repro Version: 6.5.0.0.alpha0+ (x64) Build ID: 42a1a1c6b91907f81e15066ffab219411f18c4db CPU threads: 4; OS: Windows 10.0 Build 19041; UI render: GL; VCL: win; Locale: es-ES (es_ES); UI-Language: en-US Calc: CL
*** This bug has been marked as a duplicate of bug 129701 ***
Don't see this as a duplicate but also cannot reproduce. A B 1 5 2 3 6 4 7 copy A over B clears the 2.