Issue 89043

Summary: incorrect selection if auto filter applied, cell border not applied to whole selection
Product: Calc Reporter: norbert2 <norbert.notz>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, oc, pricefvbp1
Version: BEA300m2   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
bug_selection_auto_folter.ods none

Description norbert2 2008-05-05 21:47:33 UTC 
Hi.

I have found the following problems in OOo 3.0.0 Beta Linux:

- please open the attached speadsheet (it contains an applied auto filter)

- (make sure focus is in cell A1, should be default after laoding the spreadsheet)

- pres CTRL+SHIF+ARROW_DOWN


Bug 1:
The resulting selection is A1:A41 instead of A1:A40


Bug 2:
With this selection try the follwoing:
- Click the button to apply cell border (bottom/right button in the drop down
menu of the "Border" button in the toolbar)

The border has only been applied to cell A1.


I'm not sure if this a regression since OOo 2.4 since I don't have OOo 2.4
installed anymore. But since I don't remember that I had such problems with OOo
2.4 I guess it is a regression.
Comment 1 norbert2 2008-05-05 21:48:09 UTC 
Created attachment 53397 [details]
bug_selection_auto_folter.ods
Comment 2 norbert2 2008-05-05 21:49:59 UTC 
(attachement has bad name: "folter" -> "filter", but this doesn't matter)
Comment 3 amy2008 2008-07-07 08:38:03 UTC 
It's reproducible on DEV300_m21_en WinXP.
Comment 4 redflagzhulihua 2008-07-07 10:12:48 UTC 
I tested it on OOo3.0BetaRC1.


a. I can't reproduce bug1, only the cells with data are selected.

b. Bug2 can be reproduced with the attachment.

c. If show the hidden rows in the attachment, cell borders can be added to 
cells normally.

d. Hide some rows in above document, cell borders still can be added to cells 
normally.

e. Undo above document to the original state, bug2 is reproduced again.

f. Create a new calc document and add some filters, cell borders always work 
well.

So I think maybe there's something to do with the document itself. But I can't 
find anything special in the file.
Comment 5 kla 2008-08-28 14:47:47 UTC 
Change Target
and not an regression: same behavior as in 2.4.1.
Comment 6 redflagzhulihua 2009-04-09 09:25:00 UTC 
*** Issue 94763 has been marked as a duplicate of this issue. ***
Comment 7 thorsten.ziehm 2009-05-18 13:55:12 UTC 
OOo 3.1 is released. Please check the issue, if it still exists in OOo 3.1. If
yes, please work on it to get it fixed in one of the next releases. Until then
the issue get the target 3.x.
Comment 8 Frank 2013-03-31 17:43:28 UTC 
Some of the time I can't select a cell? I then have to select another and arrow over to it?