← Back to team overview

desktop-packages team mailing list archive

[Bug 882046] Re: [Upstream] Auto Filter show blank lines below filtered results

 

Launchpad has imported 4 comments from the remote bug at
https://bugs.freedesktop.org/show_bug.cgi?id=42286.

If you reply to an imported comment from within Launchpad, your comment
will be sent to the remote bug automatically. Read more about
Launchpad's inter-bugtracker facilities at
https://help.launchpad.net/InterBugTracking.

------------------------------------------------------------------------
On 2011-10-26T16:35:13+00:00 Unco New wrote:

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 !

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/882046/comments/3

------------------------------------------------------------------------
On 2011-11-02T21:15:39+00:00 Pjacquod wrote:

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

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/882046/comments/5

------------------------------------------------------------------------
On 2011-11-06T15:15:56+00:00 Pjacquod wrote:

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.

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/882046/comments/6

------------------------------------------------------------------------
On 2011-11-27T18:07:16+00:00 Pjacquod wrote:

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

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/882046/comments/7


** Changed in: df-libreoffice
       Status: Unknown => Fix Released

** Changed in: df-libreoffice
   Importance: Unknown => Medium

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/882046

Title:
  [Upstream] Auto Filter show blank lines below filtered results

Status in LibreOffice Productivity Suite:
  Fix Released
Status in “libreoffice” package in Ubuntu:
  Triaged

Bug description:
  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 !

To manage notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/882046/+subscriptions


References