Ubuntu
libreoffice package

Values cleared when scrolling in standard filter dialog

Bug #1881811 reported by Martin van Zijl
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
LibreOffice
Fix Released
Medium
libreoffice (Ubuntu)
Confirmed
Medium
Unassigned

Bug Description

I was actually developing a change for LibreOffice when I found this bug. It exists both on my installed version of LibreOffice (6.0.7.3) and the latest master branch (git commit 058caeef45f9abf12e4e243aafbbb1c2ebcbc057).

1. Create a spreadsheet with a column of data.
2. Apply autofiltering to the column.
3. Select "standard filter..." from the filter menu.
4. Add a condition (e.g. "Number = 1").
5. Click OK. Data will be filtered as expected.
6. Close the spreadsheet.
7. Open the spreadsheet again.
8. Select "standard filter..." from the filter menu.
9. Scroll down and up again in the filter dialog.

Actual:
The value "1" will be cleared for some reason.

Expected:
The value is not cleared by scrolling.

This also exists in the master, except you don't even have to scroll down and back up. Simply moving the scrollbar at all will trigger this bug.

Ubuntu Release:
Description: Ubuntu 18.04.4 LTS
Release: 18.04

Package version:
libreoffice:
  Installed: (none)
  Candidate: 1:6.0.7-0ubuntu0.18.04.10
  Version table:
     1:6.0.7-0ubuntu0.18.04.10 500
        500 http://nz.archive.ubuntu.com/ubuntu bionic-updates/universe amd64 Packages
        500 http://security.ubuntu.com/ubuntu bionic-security/universe amd64 Packages
     1:6.0.3-0ubuntu1 500
        500 http://nz.archive.ubuntu.com/ubuntu bionic/universe amd64 Packages

(But also in master branch of code.)

ProblemType: Bug
DistroRelease: Ubuntu 18.04
Package: libreoffice-calc 1:6.0.7-0ubuntu0.18.04.10
ProcVersionSignature: Ubuntu 5.3.0-53.47~18.04.1-generic 5.3.18
Uname: Linux 5.3.0-53-generic x86_64
NonfreeKernelModules: wl
ApportVersion: 2.20.9-0ubuntu7.15
Architecture: amd64
CurrentDesktop: ubuntu:GNOME
Date: Wed Jun 3 09:03:51 2020
InstallationDate: Installed on 2019-09-14 (262 days ago)
InstallationMedia: Ubuntu 18.04.2 LTS "Bionic Beaver" - Release amd64 (20190210)
SourcePackage: libreoffice
UpgradeStatus: No upgrade log present (probably fresh install)

Revision history for this message
Martin van Zijl (martin-vanzijl) wrote :
Revision history for this message
Martin van Zijl (martin-vanzijl) wrote :
Revision history for this message
Heather Ellsworth (hellsworth) wrote :

Thank you so much for the report and the video displaying the issue!

So you built libreoffice upstream from 058caeef45f9abf12e4e243aafbbb1c2ebcbc057 and the video displays this version - is that right? Could you please tell me what the Help->About Libreoffice show the version is?

Heather Ellsworth (hellsworth)
tags: added: rls-bb-incoming
Revision history for this message
Martin van Zijl (martin-vanzijl) wrote :

The upstream version Help->About Libreoffice shows the following:

Version: 7.1.0.0.alpha0+
Build ID: 058caeef45f9abf12e4e243aafbbb1c2ebcbc057
CPU threads: 8; OS: Linux 5.3; UI render: default; VCL: gtk3
Locale: en-US (en_NZ.UTF-8); UI: en-US
Calc: threaded

Actually I posted two videos. The video at the top of comment #1 above shows the bug for version 6.0.7.3. (https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1881811/+attachment/5379869/+files/filter-bug-installed-version.ogv).

The video in comment #2 shows it for the upstream version (https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1881811/+attachment/5379873/+files/filter-bug-latest-master.ogv).

Revision history for this message
In , Heather Ellsworth (hellsworth) wrote :

Description:
The value of an autofiltered column cleared from standard filter when scrolling.

See consistent reproducibility steps and video demonstration.

The issue was produced on both Ubuntu 20.04 and Debian testing with TDF 6.4.4.2 debs.

Steps to Reproduce:
1. Create a spreadsheet with a column of data.
2. Apply autofiltering to the column.
3. Select "standard filter..." from the filter menu.
4. Add a condition (e.g. "Number = 1").
5. Click OK. Data will be filtered as expected.
6. Close the spreadsheet.
7. Open the spreadsheet again.
8. Select "standard filter..." from the filter menu.
9. Scroll down and up again in the filter dialog.

Actual Results:
Field cleared on scroll.

Expected Results:
Field should not be cleared on scroll.

Reproducible: Always

User Profile Reset: No

Additional Info:
Happens in the 6.4.4.2 debs downloaded from TDF's site.

The user that found this issue has also reproduced the issue with git commit 058caeef45f9abf12e4e243aafbbb1c2ebcbc057, which is 7.1.0.0.alpha0+

The original launchpad bug: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1881811

Revision history for this message
In , Heather Ellsworth (hellsworth) wrote :

Created attachment 161621
Video showing the reproducer steps and failure

Changed in libreoffice (Ubuntu):
status: New → Confirmed
importance: Undecided → Medium
Revision history for this message
Heather Ellsworth (hellsworth) wrote :

Thanks so much Martin. I've filed an upstream bug: https://bugs.documentfoundation.org/show_bug.cgi?id=133683

Heather Ellsworth (hellsworth)
Changed in libreoffice (Ubuntu Bionic):
status: New → Confirmed
Changed in libreoffice (Ubuntu Focal):
status: New → Confirmed
Changed in libreoffice (Ubuntu Bionic):
importance: Undecided → Medium
Changed in libreoffice (Ubuntu Focal):
importance: Undecided → Medium
tags: added: rls-ff-incoming rls-gg-incoming
Bug Watch Updater (bug-watch-updater)
Changed in df-libreoffice:
importance: Unknown → Medium
status: Unknown → New
Revision history for this message
Sebastien Bacher (seb128) wrote :

The issue was discussed in the team meeting, it's not involving data loose, easy to workaround and mostly cosmetic, we are rejecting the rls nomination, the bug can still be fixed but it's going to follow our special tracking process for the issue

no longer affects: libreoffice (Ubuntu Bionic)
no longer affects: libreoffice (Ubuntu Focal)
no longer affects: libreoffice (Ubuntu Groovy)
tags: added: rls-bb-wontfix rls-ff-wontfix rls-gg-wontfix
removed: rls-bb-incoming rls-ff-incoming rls-gg-incoming
Sebastien Bacher (seb128)
tags: added: rls-bb-notfixing rls-ff-notfixing rls-gg-notfixing
removed: rls-bb-wontfix rls-ff-wontfix rls-gg-wontfix
Revision history for this message
In , Ilmari-lauhakangas (ilmari-lauhakangas) wrote :

This problem did not exist in 3.3.0 (tested on Windows).

In 3.5 and 3.6, you don't even have to scroll - the field is blank upon opening the dialog. The current behaviour started with 4.0

I bibisected the change in behaviour with the Linux 43all repository to the range https://git.libreoffice.org/core/+log/d59024b652ccfaf7247da113ec36788fe260de74..4b4ca8030285bd66526ff5bb2b6ea5a75a6c6bc7

The problem seems to be in the document structure somehow: if I open a filter created with 3.3.0 in 3.5.0, I can see the value in the dialog no matter what I do.

Bug Watch Updater (bug-watch-updater)
Changed in df-libreoffice:
status: New → Confirmed
Revision history for this message
In , Gabor Kelemen (kelemeng) wrote :

This seems to have been fixed in 7.1 since:

https://git.libreoffice.org/core/+/937b780e3f696552fc686bf0c80c3050443b111a

author Martin van Zijl <email address hidden> Wed May 27 08:21:39 2020 +1200
committer Heiko Tietze <email address hidden> Tue Sep 15 08:40:04 2020 +0200

tdf#76898 standard filter: add buttons to remove conditions

Bug Watch Updater (bug-watch-updater)
Changed in df-libreoffice:
status: Confirmed → Fix Released
Revision history for this message
In , Buzea-bogdan (buzea-bogdan) wrote :

it's ok in
Version: 7.2.0.0.alpha1+ (x64) / LibreOffice Community
Build ID: 3b57ebb445df8a2bc3d916ea79f8af45e20e4e62
CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: ro-RO (ro_RO); UI: en-US
Calc: threaded

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.