https://bugs.documentfoundation.org/show_bug.cgi?id=118858
--- Comment #12 from Gabor Kelemen (allotropia) <[email protected]> --- I did some research with the example file about paste results: Calc puts copied data to the clipboard in various formats, and some are filtered, some are not. External applications (even Writer) may or may not choose a filtered one by default. Calc default paste: filtered. Writer default paste: not filtered (result is a table) Impress default paste: not filtered Notepad default paste: filtered Notepad++ default paste: filtered Excel 16 default paste: not filtered Word 16 default paste: filtered (result is a table) Pasting in Writer with all the Paste special options, results in: LO spreadsheet: filtered (result is OLE object) DDE Link: unfiltered HTML: filtered Rich text formatting (RTF): unfiltered Rich text formatting (Richtext): unfiltered Unformatted text: filtered Graphics Device Interface Metafile (GDI): filtered Bitmap image: filtered Pasting in Excel has some more options on top of these: PNG: filtered Unformatted text (TSV-Calc): filtered Data Interchange Format (DIF): unfiltered For comparison, Excel -> Word (2016 in my case) paste supports the following formats: Default: filtered Special, Excel Worksheet Object: filtered Special, RTF: filtered Special, Unformatted text: filtered Special, Bitmap: filtered Special, EMF: filtered Special, HTML: filtered Special, Unformatted Unicode Text: filtered So all in all, we may say that in case of spreadsheet to text editor it makes sense to change the relevant formats - in our case, RTF. I'm unsure about the "DDE Link" format, may make sense to keep as-is, given it's kinda rarely used. Another interesting comparison, Excel -> PowerPoint results in the following: Default: filtered Special: Excel Worksheet object: filtered Special: HTML: filtered Special: RTF: Filtered Special: Unformatted text: filtered Special: EMF: filtered Special: WMF: filtered Special: DIB: filtered Special: Bitmap: Filtered And Calc -> Impress: Default paste: unfiltered Special: LO spreadsheet: filtered Special: GDI: filtered Special: BMP: Filtered Special: HTML: crash (oops... I'll file a separate one for this) Special: Unformatted: Filtered Special: Rich Text Format (RTF): Unfiltered Special: Rich text formatting (Richtext): Unfiltered (also why do we even need 2 RTF paste formats?) -- You are receiving this mail because: You are the assignee for the bug.
