Issue 124026

Summary: Cell Cursor reaches hidden area when delete row above hidden row
Product: Calc Reporter: Rainer Bielefeld <rainerbielefeld_ooo_qa>
Component: editingAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: issues, rainerbielefeld_ooo_qa
Version: 3.4.0   
Target Milestone: ---   
Hardware: All   
OS: Windows 7   
See Also:
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Description Flags
Sample Document none

Description Rainer Bielefeld 2014-01-15 06:15:22 UTC
Created attachment 82281 [details]
Sample Document

Steps how to reproduce Reproducible with "AOO 4.0.1   – German UI / German locale  [Rev. 1524958 2013-09-20 11:40:29]" on  German WIN7 Home Premium (64bit)", “historic”  4.0  User Profile used for all  predecessor versions:

1. Open attached sample document
2. Menu 'View -> Toolbars -> Insert Cells' to make 'Insert Cells visible'
3. Menu 'Tools -> Customize -> Toolbars -> Insert Cells' to customize 
   Insert CellsToolbar
4. Add "Delete Rows" icon to toolbar and terminate 'Customize'
5. Use Auto Filter for Column "A", filter for "1" (Rows 2,3,4,6,17... 
   stay visible)
6. Click on B2
    > Cell Cursor around B2
7. Click Icon 'Insert Cells Toolbar  -> Delete rows' 2 times
    > deletes rows as expected, Cell Crsor stays at B2
8. Click Icon 'Insert Cells Toolbar  -> Delete rows'
   As expected row will be deleted as expected
   Unexpectedly now hidden cell B2 becomes selected. Dangerous:
9. Click Icon 'Insert Cells Toolbar -> Delete rows'
   You already see that the hidden row has become deleted. This must not happen
   Removing Auto filter shows that indeed row with "May NOT be deleted" has been

Additional Info:
(a) Although the current behavior that cell cursor stays in old cell
    coordinates is more or less plausible, a solution will have to be 
    found that the cell cursor does not reach a hidden cell in step 8
(b) Same with simply hiding rows instead of using filter
(c) Same with deleting Columns and deleting columns
(d) Same with 'Delete Rows' / 'Delete Columns' by rightclick on
    Row / Column Headings
(e) Same using menu 'Edit'
(f) Already reproducible with OOo 1.1.5
Comment 1 Rainer Bielefeld 2014-01-15 06:16:04 UTC
(g)  Already reproducible with  Pre-3.4.0 (OOo 1.1.0), but because of crippled  
     Version selector (Bug 123063) no useful info can be contributed