Apache OpenOffice (AOO) Bugzilla – Issue 46738
Paste Special's Shift cells does not works correctly after Cut
Last modified: 2013-08-07 15:12:27 UTC
Shift Cell options in Paste Special dialog does not work correctly (imho) after cutting cells in some cases, depending on the location of the paste target cell(s) relative to the cut cell(s). * No shift cell option is available if the paste target cell is the same as the cut cell. * Only shift down is available if the target cell is on the same row as the cut cell. * Only shift right is available if the target cell is on the same column as the cut cell This implies that you can only shift cells down when pasting a cut column, right when pasting a cut row, which does not make sense (imho). (Both shift cells options are available if the target cell is in another row and another column than the cut cell.)
*** Issue 46740 has been marked as a duplicate of this issue. ***
*** Issue 46739 has been marked as a duplicate of this issue. ***
requirements as it is a rfe
I really don't think this should be a RFE as : * The correct Shift Cell options are proposed after a Copy (instead of a Cut) * The actually available options generate errors for rows (create new spreadsheet document, select a row, cut, change selection to another row, paste special with shift cell right, get error message "Filled cell cannot be shifted beyond the sheet" [with empty cells!]). * I do not understand what purpose the currently available options may fulfil, but I think that the missing ability to move rows and columns by cut-and-paste is a really basic and necessary one (I choose P3 because you can always copy-paste then erase). IMO, this is really a bug that should be fixed for 2.0. (I am no programmer but this looks like it is a simple check to choose which options are available that is inverted somewhere, as the correct options are available for a Copy-Paste instead of a Cut-Paste). Sincerely, Fousage
You can somehow find a workaround for this with a new feature that will be added soon: Title: Insertion of Cells in a Spreadsheet via Drag & Drop Effective from: CWS calccolrowmove *Description* ------------- When moving or copying a marked cell range via drag & drop to a new row or column, by default the target cells are overwritten. An insert drag & drop mode can be activated by pressing the ALT key in addition to the SHIFT and CTRL keys before dropping. In this case the source data are inserted at the new position, that means the target cells are shifted to the right or down. In the insert drag & drop mode also a new preview cursor is shown. *Specification URL* ------------------- http://specs.openoffice.org/calc/ease-of-use/Insertion_of_Cells.odt
Hi, this is basically a double to Issue 21280 . Frank *** This issue has been marked as a duplicate of 21280 ***
closed double
I was also experiencing problems and found this issue has already been reported. Just for clarity, I wanted to add details about what I was doing so that testing can at least include my use-case. I import a CSV file that has the 1st row as column header names. All following rows are data-rows containing various values for each of the columns. To view the CSV more convenently, I split-n-freeze the view so that scrolling through the data keeps the top row and the 1st column visible at all times. I do this by selecting the top 4 cells of the imported CSV, selecting split, and finally freeze the spreadsheet. Next, I find that certain columns of data might be better located next to other columns. If I were in Excel, the procedure to do this would be as follows: 1. Click the spreadsheet column header, which selects all cells in that column. 2. Right click to cut. Excel surrounds the cut-selected data with a "dancing border". 3. Click the spreadsheet column header where I want the data to be moved to. Clicking the column header selects all cells in that column. 4. Move the data by Inserting Cut Cells. This procedure will move the column selected in step 2 to the location selected in step 3. OpenOffice Calc requires that I Paste Special. However when I Cut the cells and highlight an entire column, the Paste Special dialog grays out the Shift-Cells-Right option which is all that makes sense in the case of selecting an entire column before pasting.