On January 19, 2022, 2 Classes of 'CellImageBuilder' and 'CellImage' have been added to Spreadsheet Service

GasTips / news / spreadsheet
Google Apps Script / spreadsheet

On January 19, 2022, 2 classes of CellImageBuilder and CellImage have been added to the Spreadsheet Service.

Unfortunately, in the current stage, it seems that the image manually put to a cell without using the URL cannot still be retrieved.

  • When an image is manually put from URL and Google Drive to a cell, this image cannot be retrieved.
  • When an image is put using setSourceUrl method with a script, this image and URL cannot be retrieved.

I would like to expect to resolve these in the future update.

Also, I reported this to the Google issue tracker. https://issuetracker.google.com/issues/215575446

https://developers.google.com/apps-script/releases/#january_19_2022

 Share!