Assigned
Status Update
No update yet.
Comments
im...@gmail.com
This is a very useful feature, please add at least one method for the ability to insert images into cells. Thank you very much!
ya...@gmail.com
I want the ability to insert images into cells too.This function is very useful for workflow automation.Thank you!
pr...@gmail.com
I concur -- I am trying to develop a project right now where it would be great if I could insert am image directly into a cell.
co...@swellshark.com
I would like to be able to insert an image w GAS but I would ALSO like to ref that src from JS through Spreadsheet services PRETTY PLEASE!!!
ma...@gmail.com
I add to the plea. we need it desperately!
st...@gmail.com
I need this for a product I'm working on. Please!
[Deleted User] <[Deleted User]>
Is there any expectation of getting it done?
yi...@globalfoundries.com
I add to the plea. we need it desperately and this affected the whole corporation system group
jr...@gmail.com
Also need this badly
sc...@reddencourtcloud.co.uk
I would really like this feature too. I work in a school and this would really help with some of my Google Sheets projects I am currently working on.
ja...@gmail.com
would be useful to me as well...
mi...@gmail.com
I would really like this feature too.
ma...@gmail.com
+1
ju...@gmail.com
Useful to me. Thanks for your support of this feature. Waiting patiently.
[Deleted User] <[Deleted User]>
this feature would be very beneficial to me. I'll wait for further update. Thank you!
be...@gmail.com
I would also really like this feature for a project I'm working on. Thanks!
vv...@newmoonproduction.com
I would also need this feature, so it becomes possible to move rows and pictures together without having to bind pictures to cells manually
[Deleted User] <[Deleted User]>
+1
se...@gmail.com
any update on doing this?
of...@gmail.com
Please, I need this feature urgently, now that Google Drive Images are not showing in the Sheets anymore...
00...@family-support.org
This is a great opportunity to make a real difference to businesses that pay to access Gsuite! Please make it available.
os...@gmail.com
ad...@zuzaslanguages.com
I would like this feature as well.
vb...@genius.paris
I would need it as weel :)
gb...@gmail.com
Yes it would be useful as =image() is not reliable.
sk...@gmail.com
Please make this happen!
pr...@gmail.com
Also looking forward for this
ja...@gmail.com
+1
jo...@gmail.com
i would use this, including the ability to invoke a script when the image/cell is clicked
ch...@gmail.com
Please make this happen! Needed for more than 2000 picture and image() doesn't work properly...
se...@gmail.com
+1
hi...@gmail.com
I am also waiting
ra...@gmail.com
Why this seemingly basic feature is missing using Google Script, and this thread is open for more than a year ?!
This needs the due attention.
This needs the due attention.
xa...@nouvellesimages.xyz
+10
da...@laveapparel.com
+1
pa...@gmail.com
+1
ja...@gmail.com
+1
bg...@wfrc.org
+1
ja...@gmail.com
Yes, please add this feature.
gg...@gmail.com
Not really possible to even determine if it has been entered in a cell or not. This is a must for scripting.
ga...@fullstackone.com
+1
gu...@teenage.engineering
+1
zc...@heliogt.com
+10
sc...@gmail.com
+1
zc...@heliogt.com
Is there any work around to getImage() where google scripts can copy and .setValue() to an image? I'd like to copy and paste images in a cell and put that image in a new cell using a script. Does anyone have a workaround for this?
jo...@education.nsw.gov.au
Yes please
cl...@gmail.com
Yes please add this to the Google Sheets REST API as well.
=IMAGE() doesn't export properly to Excel, whereas when using 'Insert image in cell', it does get exported to the .xlsx file succesfully.
=IMAGE() doesn't export properly to Excel, whereas when using 'Insert image in cell', it does get exported to the .xlsx file succesfully.
va...@gmail.com
Make sure you all starred this issue
ad...@hanoverschools.org
Please add this to the API!! It is a much needed feature!
ma...@gmail.com
+1
ki...@gmail.com
Inserting image into a cell with apps script will be very useful feature!
ad...@gmail.com
+1
in...@bbaq.de
+2
47...@gmail.com
I would like script commands to copy in cell image and paste it into another sheet. I would like to have the image "blow up" on mouse hover, and whatever tap up tap down equivalent for android / iphone.
pe...@gmail.com
still waiting
in...@bbaq.de
Google, make it good for your clients.
ap...@gmail.com
I too would like this function
ma...@gmail.com
+1
th...@yoobic.com
+1
pl...@gmail.com
+1
in...@bbaq.de
Google is probably too big for such little problems )
br...@braviaderm.com
Please +1
ki...@gmail.com
Hello all,
Hope Google engineers will consider for this request.
Till then you can try the following work around:
function putImageInCell() {
let url = 'https://www.google.com/images/branding/googlelogo/1x/googlelogo_color_272x92dp.png ';
const ss = SpreadsheetApp.getActiveSpreadsheet();
const s = ss.getSheetByName('Sheet1');
const r = s.getRange('A1');
r.setFormula(`=image("${url}")`);
SpreadsheetApp.flush();
r.copyTo(r,{contentsOnly: true});
SpreadsheetApp.flush();
}
Hope this helps!
Hope Google engineers will consider for this request.
Till then you can try the following work around:
function putImageInCell() {
let url = '
const ss = SpreadsheetApp.getActiveSpreadsheet();
const s = ss.getSheetByName('Sheet1');
const r = s.getRange('A1');
r.setFormula(`=image("${url}")`);
SpreadsheetApp.flush();
r.copyTo(r,{contentsOnly: true});
SpreadsheetApp.flush();
}
Hope this helps!
dv...@tsas.vn
Almost 1 year and a quarter later and the status is still new. At least pretend to bother about developers, Google?
sk...@gmail.com
Yes Lazy Google is excelent in hording tasks. Do You have gsuit? Please write an complaint that way to them.
ks...@gmail.com
Please add this feature. It will be very useful
er...@gmail.com
This would do so much to make me continuing use sheets over excel, airtable, or other spreadsheet software!! Please work on this, Google
pe...@gmail.com
me2
sk...@gmail.com
This request is so easy to fullfill, but You are lazy as hell.
sk...@gmail.com
P2 my ass
am...@gmail.com
I understand that we now can add images into a cell, but there is no ability to export the images along with the rest of the spreadsheet data. I would get a LOT of use out of this missing functionality--my current workaround is to save the spreadsheet as a pdf, which is decidedly suboptimal.
ht...@gmail.com
+1
ja...@ipxhq.com
Very useful feature for my addOn. Please advise on status
mr...@gmail.com
Still waiting...
sk...@gmail.com
I just want to say, In the upper right corner You can add your feedback. Write that You like this request be revised by someone more capable, since this issue is clearly very easy to fulfill and probably one of the few things not avaible in apiv4.
ma...@gmail.com
Please add this feature. Imagine a usecase where I insert an image in the cell (very tiny to see) and I write a quick script to hover on the image to show a bigger size.
sk...@gmail.com
I believe that the moderator for this task left sometime ago and we are writing and nobody get's notified, look at CC it's normal @gmail, in other issues there is always some @google mails...
ju...@assembly.nz
Please add this feature.
pe...@gmail.com
We should all get our family and friends to come here and star the request to increase the numbers.
pa...@gmail.com
+1
sk...@gmail.com
Here is no Assignee, please use the feedback button to rise You concern that this post is abonded!
ro...@gmail.com
+1
vi...@dobromyslov.ru
+1
bi...@gmail.com
+1
pl...@gmail.com
Please add the ability to transfer images using the "Linked objects" function.
pr...@gmail.com
IMAGE SHOULD NOT BE CONSIDERED AS NULL FOR =QUERY FUNCTION AS WELL!!!!
an...@fsgi.com
+1
al...@scopely.com
+1
st...@imerys.com
+1
gr...@gmail.com
+1
he...@darrieumerlou.fr
+1000
pe...@hkcss.org.hk
+1
no...@gmail.com
Please View this IssueTicket https://issuetracker.google.com/issues/157888759 and star it. It is the basic request mentioned from this task.
th...@gmail.com
+1
er...@hedblad.com
Please!!
jo...@gmail.com
+1
gl...@gmail.com
+1
bu...@gmail.com
+1
na...@apps4gs.com
+1
ja...@gmail.com
+10 or more!
pa...@gmail.com
need to be able to manipulate pic in a cell somehow
ja...@gmail.com
A workaround like this works for me for what I want to achieve atm
Insert one or more images in one or more cells in a tab in the sheet you are working in. Call it something like "Image Source"
In the sheet where you want to add the same image, just point to the images in the source sheet something like this ='Image Source'!B2
Example:https://docs.google.com/spreadsheets/d/16gs35EYqxr1Q5471nmiyt5HcD594QPaThWJFY4CQ8es/edit?usp=sharing
You can also do this with scripting something lik this:
someSpreadsheet.getActiveRangeList().setFormula('Image Source!B2');
Insert one or more images in one or more cells in a tab in the sheet you are working in. Call it something like "Image Source"
In the sheet where you want to add the same image, just point to the images in the source sheet something like this ='Image Source'!B2
Example:
You can also do this with scripting something lik this:
someSpreadsheet.getActiveRangeList().setFormula('Image Source!B2');
va...@gmail.com
this is very interesting #104
st...@gmail.com
I'd like this feature as well. Please add it.
lf...@gmail.com
+1
re...@gmail.com
+1
lu...@gmail.com
+1
sc...@jammedia.ie
workaround with =image() was working but now seems to not work on Team Drives, despite images being public. This really needs a proper api fix please.
fi...@gmail.com
Agree that =Image is not a functional workaround
[Deleted User] <[Deleted User]>
+1
si...@bardrick.com
+1
We are using google sheets to qualify and version control our product content, with images in cells as references to feature descriptions and instructions.
From these product data sheets, we produce content review documents (copy decks) therefore we require the functionality to get these images from the original spreadsheet, as we do with the text and data. Doing this manually is not scalable in our case.
We are using google sheets to qualify and version control our product content, with images in cells as references to feature descriptions and instructions.
From these product data sheets, we produce content review documents (copy decks) therefore we require the functionality to get these images from the original spreadsheet, as we do with the text and data. Doing this manually is not scalable in our case.
sa...@ansync.com
Maybe it's worth describing a possible motivation for this to be added -- I don't see any other way that it will get developer attention (please add your own):
Images in cells are a used extensively in industry for things like process checklists, assembly instructions, pick lists, and bills of material -- these are all very much at the core of the manufacturing world. Quite simply, adding a picture removes a potential source of error of someone picking the wrong part -- or ordering the wrong thing. No coincidentally, this is the the type of document that gets processed or generated by a script.
Excel scripting can do it -- we need this.
Images in cells are a used extensively in industry for things like process checklists, assembly instructions, pick lists, and bills of material -- these are all very much at the core of the manufacturing world. Quite simply, adding a picture removes a potential source of error of someone picking the wrong part -- or ordering the wrong thing. No coincidentally, this is the the type of document that gets processed or generated by a script.
Excel scripting can do it -- we need this.
ju...@digijoukkue.fi
Need this feature very much in multiple projects!
Image in cell is needed for displaying images of products (using google sheets for product management and supply management). We have a lot of scripts in google sheets to automate things, but not being able to fetch and insert images with GAS means we can't implement everything we wanted. Thus, we don't have all our users in Google Workspace, will do if this feature becomes available.
Currently this feature is available in Excel macros, so we are using Microsoft products until this feature is in Google Sheets.
Image in cell is needed for displaying images of products (using google sheets for product management and supply management). We have a lot of scripts in google sheets to automate things, but not being able to fetch and insert images with GAS means we can't implement everything we wanted. Thus, we don't have all our users in Google Workspace, will do if this feature becomes available.
Currently this feature is available in Excel macros, so we are using Microsoft products until this feature is in Google Sheets.
47...@gmail.com
Please add functionality to google sheets scripting. Allow me to execute the interactive dialog box "Insert image" (Insert >> Image >> Image in cell) with a script command.
kl...@ritenourschools.org
I need to have code to rebuild spreadsheets when students mess then up. These spreadsheets can include images with assigned scripts. The images could be in or over the cell.
my...@gmail.com
Yea, ditto. This feature wud really be so helpful in publishing the official registration form content upon uploaded photos via gform.
ma...@gmail.com
+1
sh...@gmail.com
+1
th...@gmail.com
Is there an alternative?
ja...@gmail.com
Not really an alternative, but rather some work arounds.
da...@gmail.com
Any update?
dl...@gmail.com
Even if you could just make ongridimage return the actual blob, that'd be fine with me - but yes, + 100000 this anything please.
ka...@gmail.com
+1 need ability to link embedded images from sheets into slides
r....@lineopi.ch
+1
si...@bardrick.com
++1
ca...@gmail.com
Please make this happen!
mo...@gmail.com
I'd like to request this feature as well. Thank you
go...@mediaworks.co.nz
This is a necessary feature. Please implement it. :)
je...@les3chouettes.fr
This is a necessary feature. Please implement it. :)
re...@wisockijunior.com.br
This is a necessary feature. Please implement it. :)
se...@gmail.com
Hi,
The easiest way I found to do it is:
SpreadsheetApp.getActive().getActiveRange().setValue("=IMAGE(\"IMAGE_URL\")");
lu...@gmail.com
I think it's a critical feature to be added as well
ri...@projectsupportsystems.co.uk
Much more interested in being able to get an image from a cell for further processing so we can more easily satisfy client requirements. At the moment this is an entirely manual and time consuming task for us!
mi...@gmail.com
It is possible to INSERT in-cell images using undocumented APIs. However it is not possible to get image data (
ha...@gmail.com
Hi, inserting an image into a cell would be a great feature of app scripts. Thanks
ma...@gmail.com
Hi,
I would like to be able to retrieve image from an image in cell. Very useful! Please implement! Thanks very much!
I would like to be able to retrieve image from an image in cell. Very useful! Please implement! Thanks very much!
[Deleted User] <[Deleted User]>
I would also like/need the ability to retrieve image from an image in cell. Please implement this feature! Thanks.
ch...@gmail.com
Yes, please add
te...@gmail.com
+1
rh...@gmail.com
Near the top of my wish list. Please add
se...@gmail.com
+1
am...@lightricks.com
+1
jk...@gmail.com
+1
dg...@jart.co
+1 NEED NEED NEED SOS!!!
[Deleted User] <[Deleted User]>
+1
[Deleted User] <[Deleted User]>
+1
vp...@gmail.com
+1
ra...@gmail.com
I am looking for an API to retrieve the "In cell" images stored.
ne...@gmail.com
+1
gs...@gmail.com
+1 Hardneed.
w1...@apps.losrios.edu
+1
ca...@usd413.org
+1
na...@gmail.com
You could also use "=IMAGE(A1)" where the url is in cell A1. This will let you put an image inside that cell from appscript
[Deleted User] <[Deleted User]>
+10
ky...@gmail.com
Comment has been deleted.
tl...@mapertech.com
+999999999999
ra...@nomad.systems
To solve this issue we could add a new cell format type called "Image". This way we could have links in the image and if the user/dev decides we could show the image in cell.
po...@ics.edu.hk
+1 request this function!
ka...@gmail.com
Add me and give me may adwance salary
ay...@reciprocidad.org
I was hoping to use this feature thinking it was available, so thumbs up 👍, I think it would be great to have it.
cb...@gmail.com
I would like to be able to fetch a cell's image from google scripts. When we debug the cell with image in it there is a method for getContentUrl() which should be able to get the url to the image. Too bad it doesn't work. From the google script the image is of type "CellImage" and there doesn't seem to be any way to get the image from this.
[Deleted User] <[Deleted User]>
+1 for this
jw...@gmail.com
+1
ed...@waypoint-france.com
+1
ra...@nomad.systems
We just need an new cell format called Image! This would allow us to store
an url in the cell and preview it same time when needed...
śr., 12 sty 2022, 12:18 użytkownik <buganizer-system@google.com> napisał:
an url in the cell and preview it same time when needed...
śr., 12 sty 2022, 12:18 użytkownik <buganizer-system@google.com> napisał:
al...@grips.io
+1
mb...@logitech.com
+1
dr...@gmail.com
+1
kp...@gmail.com
Was able to insert image in cell using next code:
function insertImageIntoCell()
{
let image = SpreadsheetApp.newCellImage().setSourceUrl('https://www.gstatic.com/images/branding/product/2x/apps_script_48dp.png').setAltTextDescription('Google Apps Script logo').toBuilder().build();
SpreadsheetApp.getActive().getActiveSheet().getRange('A1').setValue(image);
}
el...@lightcrafttech.com
+1
bl...@gmail.com
I would love that too!
[Deleted User] <[Deleted User]>
Egarly waiting for this feature
[Deleted User] <[Deleted User]>
+1
pc...@gmail.com
+1
bi...@circuitcase.com
+1
[Deleted User] <[Deleted User]>
Comment has been deleted.
sp...@gmail.com
+1
in...@gmail.com
+1
in...@gmail.com
There's a related bug report regarding the fact that CellImage.getContentUrl fails with an unexpected internal error:
I'm experiencing it, too:
Exception: Unexpected error while getting the method or property getContentUrl on object SpreadsheetApp.CellImage.
am...@hcpa.edu.br
+1
a....@gmail.com
+1
so...@riverlearningtrust.org
+1
in...@gmail.com
+1
ja...@skippet.com
+1
je...@ensio.eu
Nearly 4 years later and still no sign of update on this critical request.
Really nice Google !
Really nice Google !
pr...@gmail.com
Is there an update on this. Accessing cell images using getUrl() method still does not work, even if the image was originally entered into the cell using =IMAGE() formula that actually has the url parameter. Hoping this request is already taken up on priority.
si...@gmail.com
+1
Just please fix what you already have and possibly expand blob functionality
Just please fix what you already have and possibly expand blob functionality
ky...@bertholdhk.com
It is a pain to manually insert to the cell when converting from an excel spreadsheet
jo...@gmail.com
+1
co...@gmail.com
It is very difficult to getValues and setValues when there is an image in cell.
[Deleted User] <[Deleted User]>
+1
ro...@gmail.com
+1
co...@gmail.com
Would like to be able to get images that are in cells with google script as well. I do like the cell image feature, but would really like a larger preview when hovering over it. Airtable has some awesome features when it comes to images: https://support.airtable.com/docs/guide-to-gallery-view
gu...@roche.com
+1
nu...@gmail.com
+1, would love for the Sheets API to support retrieving Image content from a cell.
ro...@catorcedias.com
+1
dh...@gmail.com
How is this still being ignored after 4 years and hundreds of people saying how incredibly useful this would be?
an...@focusmfginc.com
I see Classes CellImage, CellImageBuilder and SpreadsheetApp.newCellImage() seem to be relevant. Officially, getContentUrl() and getUrl() should to have adequate functionality. I think the central problem is that getContentUrl() and getUrl() aren't properly implemented, and return the following errors:
Exception: Unexpected error while getting the method or property getContentUrl on object SpreadsheetApp.CellImage.
Exception: The URL should not be empty.
(GetUrl() is returning null)
I manually place my images into cells and would love to have it work either way. Image capture automation can be difficult, it seems that Snipping Tool or equivalent is useful to ensure the correct visual information is being captured.
Exception: Unexpected error while getting the method or property getContentUrl on object SpreadsheetApp.CellImage.
Exception: The URL should not be empty.
(GetUrl() is returning null)
I manually place my images into cells and would love to have it work either way. Image capture automation can be difficult, it seems that Snipping Tool or equivalent is useful to ensure the correct visual information is being captured.
an...@focusmfginc.com
Further, by right-clicking on the cell containing an image and clicking "Show Edit History", a link is shown which appears to be what should be returned by getContentUrl().
getContentUrl() documentation as follows:
Returns a Google-hosted URL to the image. This URL is tagged with the account of the requester, so anyone with the URL effectively accesses the image as the original requester. Access to the image might be lost if the spreadsheet's sharing settings change. The returned URL expires after a short period of time.
Return
String — The Google-hosted URL of the image.
I haven't tried adding images using CellImageBuilder yet, but it doesn't seem that useful. It will take longer to capture images and save them and name them and configure CellImageBuilder than to capture manually.
getContentUrl() documentation as follows:
Returns a Google-hosted URL to the image. This URL is tagged with the account of the requester, so anyone with the URL effectively accesses the image as the original requester. Access to the image might be lost if the spreadsheet's sharing settings change. The returned URL expires after a short period of time.
Return
String — The Google-hosted URL of the image.
I haven't tried adding images using CellImageBuilder yet, but it doesn't seem that useful. It will take longer to capture images and save them and name them and configure CellImageBuilder than to capture manually.
an...@focusmfginc.com
Further, invoking toBuilder() and calling getContentUrl() on the CellImageBuilder object also doesn't work:
Exception: Unexpected error while getting the method or property getContentUrl on object SpreadsheetApp.CellImageBuilder.
I am firmly convinced that these methods are not working.
Exception: Unexpected error while getting the method or property getContentUrl on object SpreadsheetApp.CellImageBuilder.
I am firmly convinced that these methods are not working.
li...@gmail.com
Comment has been deleted.
li...@gmail.com
Comment has been deleted.
jp...@google.com
dh...@gmail.com
And now the severity of this ticket was dropped from S2 to S0. Great.
a....@gmail.com
since this is now assigned can we get an ETA maybe?
dh...@gmail.com
I wouldn't hold my breath...
ba...@gmail.com
Comment has been deleted.
ha...@gmail.com
getContentUrl() is live in the documentation and simply does not work and seems not to have ever worked. How does that happen?
ia...@gmail.com
Still cautiously waiting for this feature. It would really be a life-changer!
he...@gmail.com
Pleeeeeease!
Description
This is definitely a feature we were waiting for since apps script started.
Since it's also going to be attached to cell, finding and removing images would be much easier to write script for (I never understood the point of images not attached anyways).
like SpreadsheetApp.getActiveSheet().getRange("A2").getImage()
SpreadsheetApp.getActiveSheet().getRange("A2").setImage("url")
if url is google drive link just insert it without having to adjust permissions to public. (if my understanding is correct that's how it works right now in Google Sheets.