[Libreoffice-bugs] [Bug 142712] New: Both standard and advanced filters delete rows breaking sequential numbering

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 142712
           Summary: Both standard and advanced filters delete rows
                    breaking sequential numbering
           Product: LibreOffice
           Version: 7.1.3.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: fpesari at tuxfamily.org

Description:
This is a very serious bug which affected more than one user, myself included.

Both the Standard filter and the Advanced filter generate a filtered range
which skips some rows instead of maintaining the original sequential numbering.

In addition to this and maybe as a consequence of it, new columns can't be
inserted in a sheet in which filters are used.

The only way around this behavior is to enable the option to copy the results
of the filter into a target range but this is counterintuitive.

Steps to Reproduce:
1. Create a table with some entries
2. Use a standard or advanced filter on it

Actual Results:
Row numbers will be missing if some values are filtered out

Expected Results:
The row numbering should stay consistent regardless of the rows which were
filtered out


Reproducible: Always


User Profile Reset: No



Additional Info:
I am using a build from the openSUSE Tumbleweed repositories.

Version: 7.1.3.2 / LibreOffice Community
Build ID: 10(Build:2)
CPU threads: 8; OS: Linux 5.12; UI render: default; VCL: kf5
Locale: it-IT (en_US.UTF-8); UI: it-IT
Calc: threaded

-- 
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/20210608/f03c8a0d/attachment.htm>