Pasting Contents in Special Formats /text/shared/guide/pasting.xhp clipboard;pasting formatted/unformatted text inserting;clipboard options pasting;formatted/unformatted text text formats;pasting formats;pasting in special formats mw changed "pasting;..." and "clipboard;..." and added two index entries Pasting Contents in Special Formats Contents that are stored on the clipboard can be pasted into your document using different formats. In %PRODUCTNAME you can choose how to paste the contents using a dialog or a drop-down icon. The available options depend on the contents of the clipboard. In Writer text documents, you can press Command+OptionCtrl+Alt+Shift+V to paste the contents of the clipboard as unformatted text.

Pasting clipboard contents using an icon menu

Click the arrow next to the Paste icon on the Standard Bar to open the menu. Select one of the options. If you do not like the result, click the Undo icon and then paste again with another option.

Pasting clipboard contents using a dialog

Choose Edit - Paste special. Select one of the options and click OK. If you are in a spreadsheet and the contents of the clipboard are spreadsheet cells, then a different Paste Special dialog appears. Use the Paste Special dialog to copy cells using basic or advanced options. Transpose: swaps the rows and the columns of the cell range to be pasted. Link: pastes the cell range as a link. If the source file changes, the pasted cells change also. The other options are explained in the help, when you call the Paste Special dialog from within %PRODUCTNAME Calc.UFI: the text is switched to "Calc" there.
Paste Special
/cp-6.4 LibreOffice 核心代码仓库文档基金会
summaryrefslogtreecommitdiff
path: root/sc/source/ui/vba/excelvbahelper.cxx
AgeCommit message (Expand)Author
2024-10-26cid#1555767 COPY_INSTEAD_OF_MOVECaolán McNamara
2024-05-20loplugin:ostr in sc/.../vbaNoel Grandin
2023-02-16SfxViewShell::GetViewFrame never returns null, change to a referenceCaolán McNamara
2023-02-14tdf#149786 sc: add VBA function: ExportAsFixedFormatBalazs Varga
2023-01-23XUnoTunnel->dynamic_cast in ScCellRangesBaseNoel Grandin
2023-01-12override GetModel in ScDocShellNoel Grandin
2022-12-21Use ScModelObj's existing XUnoTunnelStephan Bergmann
2022-05-04Just use Any ctor instead of makeAny in scStephan Bergmann
2022-01-21sc: fix VBA Copy-Paste using same and separate documentTomaž Vajngerl
2021-10-16Simplify vector initialization in scJulien Nabet
2021-09-15Use <comphelper/servicehelper.hxx> implementing XUnoTunnel part 1Mike Kaganski
2020-08-13loplugin:stringstatic also look for local staticsNoel Grandin
2020-08-09loplugin:flatten in sc/ui/vbaNoel Grandin
2020-01-31new loplugin:namespaceindentationNoel Grandin
2020-01-15clang-tidy modernize-concat-nested-namespace in scNoel Grandin
2019-11-22Extend loplugin:external to warn about classesStephan Bergmann
2019-07-26tdf#42949 Fix IWYU warnings in sc/source/ui/vba/*cxxGabor Kelemen
2019-06-17Add comphelper::getUnoTunnelImplementation templateArkadiy Illarionov
2019-05-13fix wrong SET/QUERY flags passed to uno::ReferenceNoel Grandin
2019-01-07Simplify containers iterations in sc/source/ui/{unoobj,vba}Arkadiy Illarionov
2018-11-30tdf#42949 Fix IWYU warnings in sc/source/ui/*/hxxGabor Kelemen
2018-06-27tdf#118308: Incorrect Paste Special dialog when ...Henry Castro
2018-05-28sc: release XTransferable2 when used with VBA compatibility helpersHenry Castro
2018-05-23tdf#117228: crash in SfxItemSet::GetItemState...Henry Castro
2017-12-08sc lok: 1 view has 1 clipboard to transfer dataHenry Castro
2017-10-23loplugin:includeform: scStephan Bergmann
2017-08-29loplugin:constparam in sc part9Noel Grandin
2017-06-26loplugin:oncevar in scNoel Grandin