google sheetsgoogle-apps-script
I am new to Google spreadsheet and I'm wondering if there are any other ways to draw attention to a box rather than just change its colour.
I want to emphasize a box drawing a circle on it.
I saw that you can draw a figure and assign it to a script, Is it possible to make it transparent and through a script be positioned over a box with a certain value? Or this feature is meant only to trigger scripts?
A couple of days of looking at your code and I think I may have a solution, but it's a little bit of a kludge.
You can create a function that returns a 2D array which will fill the cells below and to the right of the original cell. So I would try something like this: (sample sheet here)
= getSheetNames(2)
where your student sheets are after the second sheet, and use this custom function:
function getSheetNames(after) {
var ss = SpreadsheetApp.getActiveSpreadsheet();
if (arguments.length === 0) {
after = 0;
}
var allSheets = ss.getSheets();
var allSheetNames = [];
var sheetCount = allSheets.length;
for (var i = after; i < sheetCount; i++) {
//as you're putting them all in one row, you don't use array wrappers
allSheetNames.push(allSheets[i].getName());
//because it's merged need to add extra cell
allSheetNames.push('');
}
return allSheetNames;
}
Edit - as you are using one row and inserting into merged cells - I have made some changes
The answer to your first question is:
function test() {
return SpreadsheetApp.getActiveSheet().getActiveCell().getColumn();
}
Add the code under Tools>Script editor and press the save button.
I've prepared an example file for you: sample GAS code
Best Answer
It's possible to use Google Apps Script to insert an image to a sheet in a spreadsheet, but as far as I know, Google Apps Script doesn't have a service to draw that image, so you should create or get the image first.
If you are new to Google Spreadsheet and to Google Apps Script, consider to start learning about them at https://developers.google.com/apps-script/
UPDATE:
The Slides Service was added to Google Apps Script, so now it's possible to make a drawing there, but it's not yet ready to edit a box to draw a circle into it directly on Google Sheets, but it's closer :)
See Extending Google Slides.
Related Q&A on Stack Overflow