https://bugs.documentfoundation.org/show_bug.cgi?id=151133
Bug ID: 151133
Summary: Remove empty rows faster in Calc
Product: LibreOffice
Version: 7.5.0.0 alpha0+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: libreaj...@gmail.com
Description:
If there are several lines and content it's not easy to remove them together.
We have an idea.
Steps to Reproduce:
Hi, for example, I have a calc document with some data. I removed something
from it. Now I have several empty rows in my data. (pic1.png)
I want to remove empty rows faster.
Actual Results:
In order to remove empty rows I may select and delete them individually.
Expected Results:
I wish to select the page or area than click on "Remove empty rows" command
from menu.
Reproducible: Always
User Profile Reset: No
Additional Info:
You may also remove empty rows with filtering.
- Open a document
- Create a scenario as pic1.png
- Click on the most left corner of Calc table to select all page
- Menu -> Data -> Auto Filter
- Click on the drop-down arrow of the table header
- Select only "Empty" lines
- On the document, select empty lines and than remove them.
- Return Auto Filter and reset back.
As you can see, this alternative is better for some cases but we may handle the
situation faster.
This idea comes from:
-
https://www.linuxteknik.com/libreoffice-calc-sheette-bos-satirlar-nasil-silinir/
-
https://www.libreofficehelp.com/how-to-delete-blank-rows-in-libreoffice-calc-sheet/
---------------
Version: 7.4.1.2 / LibreOffice Community
Build ID: 3c58a8f3a960df8bc8fd77b461821e42c061c5f0
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-US (C); UI: en-US
Flatpak
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
