Download it now!
Bug 114513 - adding ability "Copy selection as Image (PNG or JPG)" for selecting in Calc
Summary: adding ability "Copy selection as Image (PNG or JPG)" for selecting in Calc
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Context-Menu Calc-UX Graphics-Export
  Show dependency treegraph
Reported: 2017-12-17 13:58 UTC by Roman Kuznetsov
Modified: 2020-09-17 20:02 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

paste menu from Calc in current 6.1.0alpha0+ master (13.11 KB, image/png)
2017-12-18 13:54 UTC, V Stuart Foote

Note You need to log in before you can comment on or make changes to this bug.
Description Roman Kuznetsov 2017-12-17 13:58:18 UTC
adding ability Copy selection as Image (PNG or JPG) for selecting in Calc 

Now we have Export to PNG or JPG range of cell from Calc uses menu File > Export and his option "Selection" (see #108317) 

I offer to realize "Copy selection as Image (PNG or JPG)" for use it in context menu in spreadsheet

Steps to Reproduce:
1. It is enhancement

Actual Results:  
we don't have ability "Copy selection as Image (PNG or JPG)" for selecting in Calc 

Expected Results:
we have ability "Copy selection as Image (PNG or JPG)" for selecting in Calc 

Reproducible: Always

User Profile Reset: No

Additional Info:

User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:58.0) Gecko/20100101 Firefox/58.0
Comment 1 V Stuart Foote 2017-12-17 15:32:26 UTC
Not clear there is any use case for doing this from a context menu. Where would one be copying the bitmap image to? The other LO modules pick up an image from system clipboard using LO paste special.

But if intent is to copy within Calc, placing a bitmap into a cell--and which can be done now with the export of selection to JPEG or PNG to an external file, and then inserting the image into a cell. Doing that more efficiently might be helpful.

But why a new context menu entry with a lot of new development? Currently a copy with selection action--using LO menu or defined accelerator/shortcut--places selection onto the system Clipboard and includes a PNG bitmap rendering (among numerous other formats of interest in an ODF context).
So rather than a context menu entry (still of questionable utility) it would make more sense to simply add an implicit bitmap selection to the Paste Special for Calc to access the bitmap from clipboard--as done now for the other LO modules. It would not include a JPEG rendering--but is that even needed, PNG is the preferred rendering.

Changing the summary to "Add a bitmap option to Calc Paste Special" would be the more useful enhancement.
Comment 2 Mike Kaganski 2017-12-18 12:33:00 UTC
The pasting to Calc as bitmap is already possible (using the Paste toolbar button drop-down, where the alternative paste formats are listed, bitmaps among them).

The "Paste special" in Calc is different from "Paste special" in other modules, so it would be fine to add the generic "Paste special" (maybe with some modified name) to the available commands. It's not efficient to expand the Calc's Paste Special dialog to include specific formats (maybe it's good to add a "System Paste special" button there, though, so that it would be sub-function of that dialog; or as a tab of that dialog maybe). But that's a different story.
Comment 3 V Stuart Foote 2017-12-18 13:54:47 UTC
Created attachment 138505 [details]
paste menu from Calc in current 6.1.0alpha0+ master

For GUI would think we could insert a Bitmap entry into the menu list Text - Number - Formula - Unformatted Text, but to only handle the optimized PNG as pushed to system clipboard by a selection Copy.
Comment 4 Eike Rathke 2017-12-19 20:53:50 UTC
Shouldn't the context menu entries be reserved for rather often used functionality? In my decades of spreadsheet usage I may have needed that once, if at all, I don't remember..