Description: Copying multiple rows,then pasting somewhere else using "Paste Special, Skip Empty cells," does not skip the empty rows. It past empty rows as well as non-empty rows. I get it: an empty cell and an empty row are not the same thing. Still, when you do the same function with Excel, it skips the empty rows. The "Skip Empty Cells feature" is pretty useless if it also does not skip empty rows. Steps to Reproduce: 1.Select multiple rows. 2.Paste Special, Skip Empty Cells. 3. Actual Results: 1.Select multiple rows. 2.Paste Special, Skip Empty Cells. Expected Results: It pastes empty rows. Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: en-US Module: SpreadsheetDocument [Information guessed from browser] OS: Linux (All) OS is 64bit: yes
Created attachment 156914 [details] Workbook illustrating Skip Empty Cells function does not Skip empty rows
This sounds like our bug #129701 *** This bug has been marked as a duplicate of bug 129701 ***