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
Created attachment 172692 [details] File in which this bug is visible
Created attachment 172693 [details] Screenshot of what I mean
This is expected and not a bug. The row headers show the actual row numbers, not a sequential numbering of visible rows. Rows 3-5 and 7-9 are filtered out and not visible, hence the row numbers displayed are 1,2,6,10.
I understand but how can this behavior be intuitive? It also stops the user from inserting new columns
For the record, I am not complaining as I am not entitled to anything but I don't understand how this feature helps the end user. If anything, it breaks their sheet.