Apache OpenOffice (AOO) Bugzilla – Issue 124026
Cell Cursor reaches hidden area when delete row above hidden row
Last modified: 2014-01-15 06:16:04 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 deleted. 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
(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