To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=33851
------- Additional comments from [EMAIL PROTECTED] Thu Oct 12 03:22:41 -0700 2006 ------- jeandom speaks sense to me! That's exactly what I'd expect. An that should work the same way for dragging selected areas, eg. if rows are filtered to show 1,3,5,6,7,8 and you drag 6,7,8 up three visible cells, then their values should be moved to 1,3,5. As for filling (ie. when you highlight a cell (or cells) and drag the handle down) this should also only fill in the visible cells. However, formula should be properly changed to count the hidden cels. eg. if cell B1 has the formula =A1+1 and row 2 is hidden then drag-filling down to the visisble cell below (ie. B3) should set B3 = B1+1, but should leave B2 untouched. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]