Issue 127060

Summary: Past special a Calc spreadsheet as a bitmap has very low resolution.
Product: Writer Reporter: Brian <brian.guralnick.1>
Component: editingAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact:
Severity: Normal    
Priority: P5 (lowest) CC: drydstro, oooforum
Version: 4.1.2   
Target Milestone: ---   
Hardware: PC   
OS: Windows 7   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Description Flags
Bitmap paste.
Refference source Test-text.ods file
Refference source Test-text-bitmap.odt file
Results of tests, showing image size related to font none

Description Brian 2016-08-03 07:15:05 UTC
Created attachment 85622 [details]
Bitmap paste.

How can I improve the Paste-Special bitmap quality.
See attached image:
The original calc spreadsheet is on the left, the paste special bitmap is on the right.

I want to get rid of the coloration around the text fonts and improve the resolution to at least match what you see on the left.  At least a 4x improvement without the colors around the text would be a start, going to 600dpi would be even better.

This low quality bitmap paste also happens if I try to do a bitmap paste in Microsoft Word.

I don't want to use the GDI-metafile paste.  It's buggy with the text alignment as font type changes throughout the rest of my document.
Comment 1 oooforum (fr) 2016-08-04 11:54:26 UTC
A screenshot is not the better way to reproduce.
Please provide your ODS document.
Comment 2 Brian 2016-08-04 16:38:50 UTC
Created attachment 85626 [details]
Comment 3 Brian 2016-08-04 16:47:56 UTC
Created attachment 85627 [details]
Refference source Test-text.ods file
Comment 4 Brian 2016-08-04 16:48:39 UTC
Created attachment 85628 [details]
Refference source Test-text-bitmap.odt file
Comment 5 Brian 2016-08-04 16:51:20 UTC
See Test-text.ods and then test-text-bitmap.odt.

The .odt is a bitmap paste.  It's almost as if a screenshot is being done instead of a real bit-map render of the document.
Comment 6 Brian 2016-08-04 18:38:37 UTC
Comment on attachment 85626 [details]

Comment 7 Brian 2016-09-10 20:21:11 UTC
HELP....  Doesn't anyone have a ways to copy and paste in high resolution?

A screenshot with paint software gets better results than the built in copy and paste.

I need a way to get some of my spreadsheets and writer document pages into MS Office and the export screw up all the graphics.  The only reliable results for the pages which have graphics & symbols on them is to copy and paste them as graphics, but resolution is like worse than 72dpi with the annoying 'ClearType' color artifact technology which was designed only for LCD screens at native resolution.

I have a document with over 20 pages of charts & pages in write with symbols and graphics, (with another 20 pages of text only which export properly), which I need exported into MS Office and if you've seen my other issues with export .xls and .docx.

Comment 8 Daniel Rydstrom 2016-09-29 19:51:59 UTC
Hey Brian, sorry to hear you are having issues with the resolution when copying and pasting. Image resolution is important for the proper presentation of documents. I've attempted to reproduce the issue you are having with the same example/files you have provided, here are the results:

OS: Windows 10 (Anniversary Edition)
Version: Apache OpenOffice 4.2.0 WIN x86 Build 1761251

Hardware: Intel i5 6600k, 16gb RAM, GTX 1080
Screen Resolution (possibly relevant): 1440p

1. Downloaded attachment 85627 [details] and 85628
2. Opened them up in both Writer and Calc
3. Copied the cell A1 from Calc
4. Special Paste as bitmap into Writer
5. Repeat step 3-4 while changing the font size

The size of the image exactly matches the font size it was copied from with the same resolution. See attached .odt file for test results.
Comment 9 Daniel Rydstrom 2016-09-29 19:53:08 UTC
Created attachment 85705 [details]
Results of tests, showing image size related to font
Comment 10 Brian 2016-09-29 20:49:10 UTC
Even your larger lettering still has the red/blue halo surrounding the font when you zoom in.

The bitmap paste is clearly related to the screen resolution and has the LCD screen ClearType technology embedded, which I can't always control, like when I'm on a laptop.  Also, I can't always control the font size as when I receive completed spreadsheets & resizing everything will mess up the entire document.

It looks as if a .tiff printer driver, printing to a 24 bit .tiff at a selected resolution, say, 600dpi, is the only quality solution, then if needed, crop in a paint app before using the image elsewhere.  This is kind of a hassle, even if all I want to do is something as low quality as import the document into a video presentation app as a animated slide.