image - Find&Replace script in Google Docs SpreadSheets -

i have google spreadsheet direct links images (jpg , png):

https://docs.google.com/spreadsheet/ccc?key=0aopgwppcjtzhddh6mw1qnvjhshlwvtlfrnrtd0pvngc&usp=sharing

i want increase rows heights starting "2nd row" 100px , render images there.

it's possible via find&replace:

1. find jpg , replace jpg", 1)
2. find http://img , replace =image("http://img)
3. select rows , scale them

and same png image-urls.

watch screencast http://www.screenr.com/s0rh

is possible automate via script? think - yes! have pretty simple googled lot haven't found solution. can't myself don't know coding. , make script?

a function ask simple, if have basic understanding of language (javascript), know how use development environment, , read api documentation.

for example, see script. it's been added shared spreadsheet, can view (and run it) in script editor there.

/**  * scan column a, looking images have been inserted using  * =image() function. row image, set row height  * 100 pixels.  */ function resizeimagerows() {   var sheet = spreadsheetapp.getactivesheet();  // handle on sheet   var headers = 1;                              // number of header rows @ top   var firstrow = headers + 1;                   // first row data   var lastrow = sheet.getlastrow();             // last row data   var imagerange = sheet.getrange(1, 1, lastrow, 1);  // column    // formulas column a, without headers   var formulas = imagerange.getformulas().slice(headers);    // image() formulas, , set row height.   (var = 0; i< formulas.length; i++) {     if (formulas[i][0].indexof('image') !== -1) {       sheet.setrowheight(i+firstrow, 100); // set height 100 pixels     }   } }