Google sheet need to refresh after adding the AltTextTitle to image for apply changes

[Sajeeva Hasith]

Google sheet, I want to add an image and add alter text title to the same image. But when I try to add alter text title, need to refresh the sheet to apply the changes.

Below is my current code:

  const sheet = SpreadsheetApp.getActiveSpreadsheet();

  const column = sheet.getActiveCell().getColumn();

  const row = sheet.getActiveCell().getRow();

  const inlineImage = sheet.insertImage(imageUrl, column, row);

  inlineImage.setAltTextTitle("some string value");

  SpreadsheetApp.flush();

[Clark Lind]

Try doing it all in the same call. This works for me, and the Alt text info is there when I look at the submenu:

  const inlineImage = sheet.insertImage(imageUrl, column, row)

    .setAltTextTitle("Some title")

    .setAltTextDescription("Some Description")

    .setHeight(200)

    .setWidth(150);

Full code for reference:

function addImage() {

  const imageUrl = "http://vignette2.wikia.nocookie.net/clubpenguin/images/d/d7/Stage_Script_icon.png";

  const sheet = SpreadsheetApp.getActiveSpreadsheet();

  const column = sheet.getActiveCell().getColumn();

  const row = sheet.getActiveCell().getRow();

  const inlineImage = sheet.insertImage(imageUrl, column, row)

    .setAltTextTitle("Some title")

    .setAltTextDescription("Some Description")

    .setHeight(200)

    .setWidth(150);

 // inlineImage.setAltTextTitle("some string value");

  SpreadsheetApp.flush();

}