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.
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.