I do not have access to later Excel versions. MS Excel 2007 does not offer the full set of 'Paste Special' options after cutting cells either. A loss of functionality occurs only if this bug can be fixed by aligning the behaviour of 'Paste Special' with 'Paste' after cutting cells. It can be replaced in the workflow by 'Copy' and 'Paste Special' with subsequent deletion of the old cells. Disabling 'Paste Special' after cutting cells avoids potentially severe loss or change of data due to bug 68976.ĭisabling 'Paste Special' after cutting cells does not lead to a loss of functionality. I suggest the interim solution to disable 'Paste Special' after cutting cells. Paste Special with selection 'Paste all', option 'Transpose', operation 'None' and no shift of cells.Įxpected result: Cell E6 is linked with cell B7 and cell F6 is linked with cell B8.Īctual result: Cell E6 is still linked with cell B6 and cell F6 is still linked with cell C6. Mark cells B6:C6 and cut these two cellsĥ. Link cell E6 to cell B6 and link cell F6 to cell C6ģ. Fill cell B6 with the number 4 and cell C6 with the number 7Ģ. Instead of downloading the sheet, the following workflow can be carried out for illustration and reproduction.ġ. The expected and unexpected results are illustrated in the attached spreadsheet 'Example-sheet-for-bug-report_Cut-and-paste-special-with-transposing_.ods' with the 'Paste Special' option 'Transpose'. Therefore, 'Cut' and 'Paste Special' leads to the same result as 'Copy' and 'Paste Special' with subsequent deletion of the old cells. The result is unexpected: Formula links still point to the old positions of the moved cells.

This shift of formula links does not occur with the command 'Paste Special' after cutting cells. with 'Paste' instead of 'Paste Special'), all formula links to these cells point to the new cell positions after pasting the cells.

If cells are cut and then pasted normally (i.e.

Openoffice calc paste values