[Libreoffice-bugs] [Bug 119949] New: Filter broken by blank line

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=119949

Bug ID: 119949
Summary: Filter broken by blank line
Product: LibreOffice
Version: 6.1.1.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-***@lists.freedesktop.org
Reporter: ddascalescu+***@gmail.com

Description:
Certain blank lines in a sheet cause filtering in filtered columns to stop -
any values in the column beyond that line will be displayed, even if they don't
match the filter.

Steps to Reproduce:
1. Open the attached .ods file and follow the instructions within; namely:
2. Click the autofiltered column header
3. Uncheck all but "VISA"

Actual Results:
Extraneous rows are present after filtering

Expected Results:
Only row 2 should be visible after filtering.


Reproducible: Always


User Profile Reset: No



Additional Info:
This breaks badly expense tracking in sheets that have total rows (a total row
would have a blank value for the filtered "Payment" column from the example).

The bug is probably reproducible on all OS-es, and I've tested on Ubuntu.

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=119949

--- Comment #1 from Dan Dascalescu <ddascalescu+***@gmail.com> ---
Created attachment 144970
--> https://bugs.documentfoundation.org/attachment.cgi?id=144970&action=edit
Example .ods file that breaks filtering

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=119949

raal <***@post.cz> changed:

What |Removed |Added
----------------------------------------------------------------------------
CC| |***@post.cz
Status|UNCONFIRMED |RESOLVED
Resolution|--- |NOTABUG

--- Comment #2 from raal <***@post.cz> ---
Hello, in this file is set range

You can unzip ods file and see it in file content.xml
-<table:database-ranges>

<table:database-range table:name="__Anonymous_Sheet_DB__0"
table:orientation="column" table:display-filter-buttons="true"
table:target-range-address="Expenses.A1:Expenses.A5"/>

</table:database-ranges>

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=119949

--- Comment #3 from Dan Dascalescu <ddascalescu+***@gmail.com> ---
@rall, I'm not sure I fully understand your comment.

Do you expect a regular user (not a developer) to unzip the .ODS and look at
content.xml? What exactly do they see there? What does that range mean? Why
would the filter stop?

What if they encounter this problem in a real-life file, with thousands of
rows? I hope you realize that's how I encountered it, and I spent a good hour
isolating the problem to a small enough file to make investigation easy.

Anyway.

Can this bug please be reopened? As long as there is no clear indication to a
regular end user, *in the Calc UI* as to why this filter is stopped by a blank
line, I don't believe this bug is "RESOLVED" or "NOTABUG" in any way.

I'm a developer and I still don't understand what's going on. Let's try to be a
little more user-friendly than that.

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=119949

--- Comment #4 from raal <***@post.cz> ---
Hello, I think that's because user set range and then created autofilter. In
such case is autofilter's range corresponding selected range.

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=119949

Dan Dascalescu <ddascalescu+***@gmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Resolution|NOTABUG |---
Ever confirmed|0 |1
Status|RESOLVED |REOPENED

--- Comment #5 from Dan Dascalescu <ddascalescu+***@gmail.com> ---
Just ran into this issue again, and would like to ask for a 3rd party opinion.
Thanks!

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=119949

Xisco Faulí <***@libreoffice.org> changed:

What |Removed |Added
----------------------------------------------------------------------------
Ever confirmed|1 |0
CC| |***@libreoffice.org
Status|REOPENED |UNCONFIRMED

--- Comment #6 from Xisco Faulí <***@libreoffice.org> ---
You can't confirm your own bugs. Moving it back to UNCONFIRMED until someone
else confirms it.

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=119949

Korrawit Pruegsanusak <***@gmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Attachment #144970|application/octet-stream |application/vnd.oasis.opend
mime type| |ocument.spreadsheet