Description: The worst problem is that content of cells out of the screen will keep original data. Steps to Reproduce: 1. Select a data row (or column) with first cells empty 2. Copy 3. Paste Unformatted Text (Ctrl+Shift+Alt+V) A B C D (column headers) 1 a b c (cells content to be copied and pasted) 2 j k l m (cells content) 3 (empty row) 1 a b c c (actual result when pasting in same row) 2 a b c m (actual result when pasting in other row) 3 a b c (actual result when pasting in other empty row) Actual Results: First empty cells are skipped. Last empty cells are skipped (last occupied cells, in same number that first empty cells, will remain as before) One or multi row/column is the same. Expected Results: Empty cells position are pasted as empty. Reproducible: Always User Profile Reset: No Additional Info: Versión: 6.4.7.2 (x64) Id. de compilación: 639b8ac485750d5696d7590a72ef1b496725cfb5 Subprocs. CPU: 4; SO: Windows 10.0 Build 17763; Repres. IU: predet.; VCL: win; Configuración regional: es-AR (es_AR); Idioma de IU: es-ES Calc: threaded Version: 24.8.0.3 (X86_64) / LibreOffice Community Build ID: 0bdf1299c94fe897b119f97f3c613e9dca6be583 CPU threads: 4; OS: Windows 10 X86_64 (10.0 build 17763); UI render: Skia/Raster; VCL: win Locale: es-MX (es_AR); UI: en-US Calc: threaded
(In reply to LeroyG from comment #0) > Expected Results: > Empty cells position are pasted as empty. IDK whether that is really the expected behavior for pasting as Unformatted Text. I mean, it might be expected by some user (maybe), but, is it really the wrong behavior according to what the feature/action should really do? IOW, is this really a bug, or just a user's expectation that does not match what the action should do? BTW, using paste special can achieve the desired behavior expressed in comment 0.
By the way: Writer keep empty paragraphs and spaces before paragraphs with Paste Unformatted Text (Ctrl+Shift+Alt+V).
If the source includes cells with content in more than one row, with empty cells to the left and up, the Text Import dialog ignore the empty cells. Copy B1:D3: A B C D 1 2 a b c 3 d e f Past in A1: A B C D 1 a b c 2 d e f c 3 d e f If the source includes cells with content in one row, Ctrl+Shift+Alt+V does not invoque the Text Import dialog, and the empty cells to the left are ignored. Copy A1:D1: A B C D 1 a b Past in A1: A B C D 1 a b b
Hello LeroyG, I can't confirm that the bug is present in master. Version: 25.2.0.3 (X86_64) / LibreOffice Community Build ID: e1cf4a87eb02d755bce1a01209907ea5ddc8f069 CPU threads: 12; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Vulkan; VCL: win Locale: en-US (en_FI); UI: en-US Calc: threaded and Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: a8ec21adf255b70bb6eeb0a1717190df303d8b26 CPU threads: 12; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Vulkan; VCL: win Locale: en-US (en_FI); UI: en-US Calc: threaded
(In reply to mikhail.machine from comment #4) > I can't confirm that the bug is present in master. > > Version: 25.2.0.3 (X86_64) / LibreOffice Community > Build ID: e1cf4a87eb02d755bce1a01209907ea5ddc8f069 > CPU threads: 12; OS: Windows 10 X86_64 (10.0 build 19045); UI render: > Skia/Vulkan; VCL: win > Locale: en-US (en_FI); UI: en-US > Calc: threaded But is reproducible with: Version: 25.2.0.3 (X86_64) / LibreOffice Community Build ID: e1cf4a87eb02d755bce1a01209907ea5ddc8f069 CPU threads: 4; OS: Windows 10 X86_64 (10.0 build 17763); UI render: Skia/Raster; VCL: win Locale: es-MX (es_AR); UI: en-US Calc: threaded Are you following the steps?
Version 25.2.1.2 Build ID: d3abf4aee5fd705e4a92bba33a32f40bc4e56f49 CPU threads: 8; OS: Windows 11 x86_64 UI render: Skia/Raster; VCL: win Locale: en-US; UI: en-US Calc: threaded Bug confirmed. If you paste with CTRL + V, the empty cells are accounted for, but if you paste the row without formatting CTRL + SHIFT + ALT + V, there are no empty cells copied and all of the pasted cells are shifted to the left.
Reproducible with: Version: 25.8.0.4 (X86_64) Build ID: 48f00303701489684e67c38c28aff00cd5929e67 CPU threads: 12; OS: Windows 10 X86_64 (build 17763); UI render: Skia/Vulkan; VCL: win Locale: es-AR (es_AR); UI: es-ES Calc: CL threaded