[Upstream] Auto Filter show blank lines below filtered results

[Unco New]

1) lsb_release -rd
Description: Ubuntu 11.10
Release: 11.10

2) apt-cache policy libreoffice-calc
libreoffice-calc:
  Installed: 1:3.4.3-3ubuntu2
  Candidate: 1:3.4.3-3ubuntu2
  Version table:
 *** 1:3.4.3-3ubuntu2 0
        500 http://us.archive.ubuntu.com/ubuntu/ oneiric/main i386 Packages
        100 /var/lib/dpkg/status

3) What is expected to happen in LibreOffice Calc via the Terminal:

cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/882046/+attachment/2573773/+files/Suivi_Clients.ods && localc -nologo Suivi_Clients.ods

primary click cell A1 -> ADPM and only the filter results are shown with no blank lines below.

4) What happens instead is 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

Original Reporter Comments: Try to select the unwanted lines and delete them, turn the filter off and on again, there's one more unwanted line at the bottom !

[penalvch (penalvch)]

Unco New , thank you for taking the time to report this bug and helping to make Ubuntu better. The issue you are reporting is an upstream one and it would be nice if somebody having it could send the bug to the developers of the software by following the instructions at http://wiki.documentfoundation.org/BugReport . If you have done so, please tell us the number of the upstream bug (or the link), so we can add a bugwatch that will inform us about its status. Thanks in advance.

[Unco New (unconew)]

Created attachment 52804
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 !

[Unco New (unconew)]

Here's the link of the upstream bug. Thanks !

https://www.libreoffice.org/bugzilla/show_bug.cgi?id=42286

[Pjacquod (pjacquod)]

I get the same
I will try to debug sort the point out.

[Pjacquod (pjacquod)]

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.

[Pjacquod (pjacquod)]

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

[Björn Michaelsen (bjoern-michaelsen)]

fixed in upstream 3.5.0, and included in current precise release:
https://launchpad.net/ubuntu/+source/libreoffice/1:3.5.1-1ubuntu1