Created attachment 52804 [details] The example file Problem description: Auto Filter show blank lines below filtered results Steps to reproduce: 1. Open the file attached 2. Select ADPM in the cell A1 3. What is expected :the filter results are shown with no blank lines below. What happens instead : blank lines are shown below the filtered results. As well, these cannot be deleted by pressing the following 3 keys simultaneously: Ctrl - + Delete entire row(s) -> OK button 4. turn the filter off and on again, there's one more unwanted line at the bottom !
I get the same I will try to debug sort the point out.
Just for the record. At initialisation, the parameter nEndRow (a member of ScDBData class) is initialized with a value that does not contain all rows, hence the initial view with some empty rows. Further, each time the filter is changed, the parameter nEndRow is reduced of 1, which creates the increasing number of empty rows. Investigation now in two directions: 1. why it decreases each time of 1 2. why it initialises not with all rows.
solved (with commit 88611e702a18d2 ). This means for users, that this will be solved in 3.5.0 If the cherry-pick is done to 3.4.5, this version will also have the corrected behaviour. (but still need approbation for 3.4.5) Best regards