Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function enlargeImage() {
- const formula = SpreadsheetApp.getActiveSpreadsheet().getActiveCell().getFormula();
- const url = /IMAGE\(\"(.*?)\"/g.exec(formula)[1];
- const html = `
- <!DOCTYPE html>
- <html>
- <head>
- <style>
- img {
- max-width: 100%;
- max-height: 100%;
- }
- </style>
- <base target="_top">
- </head>
- <body>
- <div class=img>
- <img src="${url}">
- </div>
- </body>
- </html>
- `
- SpreadsheetApp.getUi().showDialog(HtmlService.createHtmlOutput(html).setHeight(500).setWidth(800));
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement