Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

You only get the dialoge you expected if the copied source was a range of a spreadsheet under the same LibO desktop. If the source is external (a different application or a second instance of LibO / soffice) Paste Special... prompts for the selection of a flavour supported by the clipboard due to the preceeding Copy operation (in your case no choice) and the option Unformated text brings up the same (or very similar) dialogue as you get when importing from a file (csv eg) or when using Text to Columns. This dialogue doesn't offer options for calculations or transposition.
Paste your data untransposed and transpose them in a second step with an internal Copy / Paste Special... sequence.

You only get the dialoge you expected if the copied source was a range of a spreadsheet under the same LibO desktop. If the source is external (a different application or a second instance of LibO / soffice) Paste Special... prompts for the selection of a flavour supported by the clipboard due to the preceeding Copy operation (in your case no choice) and the option Unformated text brings up the same (or very similar) dialogue as you get when importing from a file (csv eg) or when using Text to Columns. This dialogue doesn't offer options for calculations or transposition.
Paste your data untransposed and transpose them in a second step with an internal Copy / Paste Special... sequence.

===Attaching an image concerning the comments below 2018-12-16 19:20 CET===
Paste Special... dialogue

You only get the dialoge you expected if the copied source was a range of a spreadsheet under the same LibO desktop. If the source is external (a different application or a second instance of LibO / soffice) Paste Special... prompts for the selection of a flavour supported by the clipboard due to the preceeding Copy operation (in your case no choice) and the option Unformated text brings up the same (or very similar) dialogue as you get when importing from a file (csv eg) or when using Text to Columns. This dialogue doesn't offer options for calculations or transposition.
Paste your data untransposed and transpose them in a second step with an internal Copy / Paste Special... sequence.

===Attaching an image concerning the comments below 2018-12-16 19:20 CET===
Paste Special... dialogue

By the way: There is also a TRANSPOSE() function. It must be entered for array-evaluation and does not move formats.