To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109292 Issue #|109292 Summary|Calc: Cut/Paste Row/Column Component|Spreadsheet Version|OOo 3.2 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|nolim66yh
------- Additional comments from nolim6...@openoffice.org Mon Feb 15 15:45:32 +0000 2010 ------- A feature of Excel that I use frequently is being able to cut a row(s) or column(s) and then paste it(them) to another location (effective a move operation). I have not been able to find an equivalent operation in Calc except to Cut the row, Insert blank line where it needs to go, Paste the row to the new blank line, Delete the original (now blank) line. Today I discovered Paste Special... but it does appear to work right. Setup a simple spreadsheet with several rows and columns filled: 1) Select a row by right-clicking the row number, then select Cut (the row blanks) 2) Select a row above this by right-clicking the row number, then select Paste Special... 3) There is a Shift Cells selection, but the Down option is dimmed (unselectable), but that's what I want. 4) By the way, the Right option is not dimmed, but selecting Right gives the error "Filled cells cannot by shifted beyond the sheet.", which make sense. Following this same procedure except with columns and upon selecting Paste Special, the Right option is dimmed. Of course Down is selectable, but selecting it gives the same error as above. These seems to work opposite of the way it should work. The Shift Down (for rows) and Shift Right (for columns) should be selectable and the cells paste should shift the current cells up to the blank row(s)/column(s) left by the Cut. By the way, when using Copy instead of Cut, it works the way it should. --------------------------------------------------------------------- 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org