True False sc/res/paste_transpose.png True False sc/res/paste_values_formats.png True False sc/res/paste_values_only.png False 6 Paste Special False dialog False vertical 12 False end gtk-ok True True True True True True False True 0 gtk-cancel True True True True False True 1 gtk-help True True True True False True 2 True False True end 0 True False 6 center True True True Values Only img_paste_values_only True True True 0 True True True Values & Formats img_paste_values_formats True True True 1 True True True Transpose img_paste_transpose True True True 2 False True 1 True False 12 12 True False True True 0 none True False 6 12 True False vertical 6 _Paste all True True True False True 0 True Pastes all cell contents, comments, formats, and objects into the current document. False True 0 Te_xt True True False True 0 True Inserts cells containing text. False True 1 _Numbers True True False True 0 True Inserts cells containing numbers. False True 2 _Date & time True True False True 0 True Inserts cells containing date and time values. False True 3 _Formulas True True False True 0 True Inserts cells containing formulae. False True 4 _Comments True True False True 0 True Inserts comments that are attached to cells. If you want to add the comments to the existing cell content, select the "Add" operation. False True 5 For_mats True True False True 0 True Inserts cell format attributes. False True 6 _Objects True True False True 0 True Inserts objects contained within the selected cell range. These can be OLE objects, chart objects, or drawing objects. False True 7 True False Selection 0 0 True False True True 0 none True False 6 12 True False vertical 6 Non_e True True False True 0 True True Does not apply an operation when you insert the cell range from the clipboard. The contents of the clipboard will replace existing cell contents. False True 0 _Add True True False True 0 True none Adds the values in the clipboard cells to the values in the target cells. Also, if the clipboard only contains comments, adds the comments to the target cells. False True 1 _Subtract True True False True 0 True none Subtracts the values in the clipboard cells from the values in the target cells. False True 2 Multipl_y True True False True 0 True none Multiplies the values in the clipboard cells with the values in the target cells. False True 3 Di_vide True True False True 0 True none Divides the values in the target cells by the values in the clipboard cells. False True 4 True False Operations 1 0 True False True True 0 none True False 6 12 True False vertical 6 S_kip empty cells True True False If enabled, blank cells in source will not override the target. True 0 True Empty cells from the clipboard do not replace target cells. If you use this option in conjunction with the "Multiply" or the "Divide" operation, the operation is not applied to the target cell of an empty cell in the clipboard. False True 0 _Transpose True True False True 0 True The rows of the range in the clipboard are pasted to become columns of the output range. The columns of the range in the clipboard are pasted to become rows. False True 1 _Link True True False True 0 True Inserts the cell range as a link, so that changes made to the cells in the source file are updated in the target file. To ensure that changes made to empty cells in the source file are updated in the target file, ensure that the "Paste All" option is also selected. False True 2 True False Options 0 1 True False True True 0 none True False 6 12 True False vertical 6 Don't sh_ift True True False True 0 True True Inserted cells replace the target cells. False True 0 Do_wn True True False True 0 True no_shift Target cells are shifted downward when you insert cells from the clipboard. False True 1 _Right True True False True 0 True no_shift Target cells are shifted to the right when you insert cells from the clipboard. False True 2 True False Shift Cells 1 1 False True 2 ok cancel help Inserts the contents of the clipboard into the current file in a format that you can specify.