[Solved] Resize image in comment

Discuss the spreadsheet application
Post Reply
SkippyOffice
Posts: 1
Joined: Thu Jun 29, 2023 7:53 am

[Solved] Resize image in comment

Post by SkippyOffice »

I am new (again), tried the various Offices before then left for Excel. I am back again to see if any of the Office versions are more user friendly to comments in Calc cells. Haven't found it yet. And I am still not sure how to start a new topic (sorry). So, all I want to do is to insert a picture into a comment in Calc. Which I can do. But it is too big or too small. I am assuming I can drag to resize with the mouse, but this is not working out. The picture ends up either too wide or too tall. Tried the shift key before dragging. This does more proportionally but when I let go of the shift and mouse, it is either too wide or too tall but not as much. So figured I would ask if such a thing is doable. Sorry for hijacking the thread.

 Edit: Split from [Solved] Some images become corrupted on importing as this is a different issue. 
Last edited by MrProgrammer on Mon Jul 10, 2023 7:15 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved] -- MrProgrammer, forum moderator
Open Office 4.1.14
Windows 11
User avatar
robleyd
Moderator
Posts: 5500
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Resizing images in comments

Post by robleyd »

I am still not sure how to start a new topic
Near the top of the page on the index of each sub-forum is a red button labelled, strangely, New Topic.
newtopic.png
newtopic.png (50.47 KiB) Viewed 1287 times
You might also find it useful to read the Survival Guide, if you haven't already done so.
Slackware 15 (current) 64 bit
Apache OpenOffice 4.1.16
LibreOffice 26.2.2.2; SlackBuild for 26.2.2 by Eric Hameleers
---------------
I hate this damn computer, I wish that I could sell it.
It won't do what I want it to, Only what I tell it.
User avatar
Lupp
Volunteer
Posts: 3755
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

Re: Resizing images in comments

Post by Lupp »

That's a strange thing. I actually never had an idea of a need or knew somebody having a related idea, or somebody asking in a forum... how to put an image into an annotation (aka "comment") to a Calc cell.
So I needed to get to the fundaments.

0. The visible annotation object is a shape. It only knows reduced and simple text services, and it doesn't accept an inserted image (which would factually reside in a nested shape).
1. Therefore you can't insert an image into an annotation.
2. If you are editing the annotation, you get, however, offered the menu path >Insert>Image. How to understand?
3. The menu path is misleading. In fact you can't insert the image, but only import it as the graphic assigned to the .Area of the annotation's shape.
4. To adapt size and position (or the tile mode e.g.) you need to use the 'Area' dialog
Y. Don't forget that an annotation needs to contain at least one character of text (may be a space). Otherwise it's automatically removed on Quit Edit.
Z. You never can "insert" a second image into a shapes area.
aoo110161ImageShownInAnnotation.ods
(64.78 KiB) Downloaded 81 times
On Windows 10: LibreOffice 25.8.4 and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
Mountaineer
Posts: 336
Joined: Sun Sep 06, 2020 8:27 am

Re: Resizing images in comments

Post by Mountaineer »

Lupp wrote: Thu Jun 29, 2023 9:20 pm .... I actually never had an idea of a need or knew somebody having a related idea, or somebody asking in a forum...
Somebody even created an extension:
viewtopic.php?f=47&t=103079
LibreOffice 7.6 on Windows 10pro and other Versions parallel
User avatar
Zizi64
Volunteer
Posts: 11505
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Resizing images in comments

Post by Zizi64 »

Always use optimized images for the Open/LibreOffice. "Optimizing" means here: Crop, resize, resample a picture, and set the color depth and the file format of the image BEFORE you insert it, or import it into a document. The Open/LibreOffice is NOT a pixelgraphic editor. Use third party softwares for this task.
Tibor Kovacs, Hungary; LO7.5.8/25.8.5.2 /Win7-10-11 x64Prof.
PortableApps: LO3.3.0-25.8.5.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Post Reply