Issue 124026 - Cell Cursor reaches hidden area when delete row above hidden row
Summary: Cell Cursor reaches hidden area when delete row above hidden row
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 3.4.0
Hardware: All Windows 7
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2014-01-15 06:15 UTC by Rainer Bielefeld
Modified: 2014-01-15 06:16 UTC (History)
2 users (show)

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

Sample Document (9.35 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-01-15 06:15 UTC, Rainer Bielefeld
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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