Calc: copy range as unformatted text?
When copying multiple cells of text (e.g. a column with text entered in each of the first three rows), the expected result is to paste the text from those three cells as three lines of unformatted text in another app. This is the result that occurs when copying from Microsoft Excel and Google Sheets. However, the actual result with Calc is an attempt to paste a PNG file (e.g. when pasting in Slack) or insert a table of three rows (e.g. when pasting in Gmail) rather than pasting unformatted text.
I tried copy range as you wrote from Excel to Calc and I got right data in the same cell. I didn't see any PNG. What version of LibreOffice do you use?
LibreOffice 6.1.4.2. Copy-paste from one spreadsheet to another works fine. This issue is when copying the range to a word processor.
Works for me with
Paste Special
, then chooseUnformatted text
.Thanks for the comment. I updated the question to specify for apps where Paste Special is not an option.