https://bugs.documentfoundation.org/show_bug.cgi?id=159778
ady <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |NEW Ever confirmed|0 |1 --- Comment #2 from ady <[email protected]> --- We used to be able to do the following procedure: Independently of the Autofilter setting, in attachment 192646 you have hidden rows. Select All. Menu Format > Rows > Show (or use the context menu on any Row Header). The Autofilter settings are kept as they were before, but the rows after the end of the list are now not hidden. Re-apply the AutoFilter (as its settings were not changed, so it was enough to open the filter and click OK). Now you can insert new data. Additionally, I seem to recall some limit about AutoFilter, around 1000 rows. I am not sure about its consequences regarding this behavior. My guess is that the new behavior, in which we cannot see the rows that follow the filtered area when using the above procedure, is a consequence of some "recent" changes to the AutoFilter feature. So IDK whether developers would consider this as a bug, or just an uncontrollable consequence. In such case, perhaps this should be an enhancement request, in order to restore the possibility of adding data while there is a filter area. Whether that would be wise, that's another matter. Beware: in any case, if the new data should be part of the filtered area, the filter should be re-applied after the data was added anyway. I do not recall whether the new additional data is automatically added to the filtered area – I mean, without having to re-select the whole area anew. -- You are receiving this mail because: You are the assignee for the bug.
