Bug 137709

Summary:	Paste "text" from Rich Text Format source into LibreOffice Calc pastes as image
Product:	LibreOffice	Reporter:	Mark Stewart <mark.g.stewart>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED NOTABUG
Severity:	minor	CC:	mark.g.stewart, pavlogradski
Priority:	medium
Version:	7.0.2.2 release
Hardware:	x86-64 (AMD64)
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	Example of pasted text appearing as image. Calc ODS file with text pasted as object

Description Mark Stewart 2020-10-23 15:02:36 UTC

Description:
When pasting text copied from a Rich Text Format source, the paste option pastes the text as an image object, not text.  

If I right-click and choose "Paste Special" I can choose to "paste as unformatted text", and it is successful.  If I chose "Paste Special" -> "Text" nothing is pasted.


Steps to Reproduce:
1. Copy some text from a Rich Text Format source.  I used part of an email body text in the Microsoft Outlook preview pane.
2. Paste somewhere in LibreOffice Calc.


Actual Results:
Data is pasted as an image, not text.  Has "handlebars" and right-clicking gives pop-up Object menu, "Send to Front", "Align" etc. options

Expected Results:
Paste as text, not image


Reproducible: Always


User Profile Reset: No



Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no

Version: 7.0.2.2 (x64)
Build ID: 8349ace3c3162073abd90d81fd06dcfb6b36b994
CPU threads: 12; OS: Windows 10.0 Build 18363; UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded

Source of "text" Microsoft Outlook Versioni 2002 (Build 12527.21236 Click-to-Run)

Comment 1 Mark Stewart 2020-10-23 15:06:25 UTC

Created attachment 166664 [details]
Example of pasted text appearing as image.

The "Copy Properties" pop-up dialog box is from the "Ditto" windows clipboard manager application, showing data in the Windows clipboard is available in 3 format, CT_TEXT, CF_UNICODETEXT, and Rich Text Format.

I can reproduce this issue if "Ditto" is not active.

Comment 2 Mark Stewart 2020-10-23 15:08:53 UTC

Created attachment 166665 [details]
Calc ODS file with text pasted as object

Calc spreadsheet with two text blocks that were pasted as imaage objects

Comment 3 Mark Stewart 2020-10-29 00:28:07 UTC

I tested on an older laptop, with version  6.3.3.2 (x64), using Microsoft TextPad as the source of the copy, and same results; pasted as an image.

Comment 4 pavlog 2020-11-22 21:56:26 UTC

Dear Mark, thanks for your report. Suppose it's not really a bug since it's a usual way for LO as the same is observed if you copy data from a docx file. As for your example you can also choose to paste as "Rich text formatting" if you prefer to paste the text as text.