Issue 94883 - Filtering rows with the value "empty" hides the header row when text exists above it
Summary: Filtering rows with the value "empty" hides the header row when text exists a...
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOO300m9
Hardware: PC Windows XP
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2008-10-11 20:54 UTC by squenson
Modified: 2013-01-29 21:52 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Filter behavior with "empty" when text above header row (12.99 KB, text/plain)
2008-10-11 20:56 UTC, squenson 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description squenson 2008-10-11 20:54:47 UTC 
When using the auto-filter option in Calc, I obtain a different behavior in
these two nearly identical cases.

Case 1
======

A | B
-----
1 | 1
1 |
2 | 2

When I filter using the column B to find the empty cells, I correctly obtain:

A | B
-----
1 |


Case 2
======

t         t is a text in a cell just above the header row.
A | B     This is the only change
-----
1 | 1
1 |
2 | 2

When I filter using the column B to find the empty cells, I incorrectly obtain:

1 |

The header row has disappeared, it seems it has been considered as part of the
filtering process which is incorrect in my opinion.
Comment 1 squenson 2008-10-11 20:56:20 UTC 
Created attachment 57126 [details]
Filter behavior with "empty" when text above header row
Comment 2 Rainer Bielefeld 2008-10-12 10:00:07 UTC 
I checked with "Ooo 3.0.0 RC3 Multilingual version German UI WIN XP: [OOO300m8
(Build9357)]" and can confirm the reported effect with "FilterWithRowAbove.ods".
I found similar behaviour with an own new document.

Steps to reproduce:
1. open new dochment.
2. Inserte column "A" following instructions "Case 1" in report, starting in
   Cell A2
3. Inserte column "B" following instructions "Case 1" in report, starting in
   Cell B2
4. Clik on A2: drag mouse pointer to B5 (to highlight "A2:B5"
5. Menu 'Data -> Filter -> Autofilter'
   Autofilter appears as expected
6. Click into 'A1'
7. Click filter button in B2
8. Standard filter, 'Value "- empty -" <ok>
   al works as expected
9. Menu 'Data -> Filter -> Remove filter'
   All lines will eb shown as expected, data area will be highlighted.
10. Redo from 6 several times, you will get always the same result

Now stop in Step 8

11. Menu "Data -> Filter -> Auto filter
    Autofilter will be removed as expected
12. Type word "text" into 'A1' , <enter> and click into A1
13. Redo from step 4!
    As soon as you click "Standard Filter" in step 8, the auto filter buttons 
    will disappear, and the highlighted area will be 'A1:B5'
   
Not a big problem because you can solve it by defining a data area A2:B5
(containing column headings), but that problem does not appear with 2.4.1, and
unexpected, because filter works fine with empty row 1

@squenson:
Please contribute information concerning your OS and Platform.
Comment 3 squenson 2008-10-12 10:21:32 UTC 
It happens on my Windows XP SP3 machine, with OOo300m5 (build: 9350)
I also experienced it on Windows XP SP3 French Edition, with OOo 2.4.1. French
Edition.
Comment 4 squenson 2008-10-22 06:08:05 UTC 
I have now installed OOo 300m9 and the issue exists as well in this version.
Comment 5 squenson 2009-06-20 17:02:05 UTC 
I have now installed OOo 310m11 (build:9399) and the issue exists as well in
this version.