Description: When selecting a filter in an autofiltered range, the last row becomes grayed out and no new rows can be edited. It does not happen always, but I think it happens when the autofilter has to deal with a large amount of rows, like in the attached example. Steps to Reproduce: 1. Select a filter in an autofilter 2. Try to edit the next row after the last row with data Actual Results: The next row after the last row of visible data is not visible nor editable Expected Results: All the rows that have not been hidden by the autofilter are not editable Reproducible: Always User Profile Reset: No Additional Info: I tried on different computers and user accounts with different OS (linux and windows). Minimum affected version might not be 100% accurate. It stopped working somewhere in the 7.6 versions
Created attachment 192646 [details] It happens with this example sheet
We used to be able to do the following procedure: Independently of the Autofilter setting, in attachment 192646 [details] 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.
One potential improvement would be to have the "(Empty)" item always available as _first_ item in the AutoFilter list, independently of whether an actual empty cell is part of the listed items. Please note that I am not saying anything regarding the "(Empty)" item being either ON or OFF (checked, or not) in the AutoFilter list. I am only pondering whether the item should rather be always available in the first location in the list. Having the "(Empty)" item available (to be checked/unchecked, that's another matter) would be a simple workaround to this problem in simple cases. Since tdf#158314 is also related to the "(Empty)" item in AutoFilter, I am CC'ing Kevin Suo, who might have a possible suggestion about this issue, and might even be able to implement this idea, or to evaluate an alternative solution.