Skip to content

Instantly share code, notes, and snippets.

@rytoj
Created October 20, 2015 12:29
Show Gist options
  • Save rytoj/6834204e65e9f06014c3 to your computer and use it in GitHub Desktop.
Save rytoj/6834204e65e9f06014c3 to your computer and use it in GitHub Desktop.
function onOpen() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
ss.addMenu("STATUSAS", [
{name : "DATA", functionName : "statusasAtlikta"},
]);
}
function statusasAtlikta() {
//perkelta is ankstesnes funkcijos
//randa pazymeta stulpeli ir eilute
var range = SpreadsheetApp.getActiveRange();
var col = range.getColumn();
var row = range.getRow();
var
lastrow = range.getLastRow(),
ss = SpreadsheetApp.getActiveSpreadsheet(),
last = SpreadsheetApp.getActive().getDataRange().getNumColumns(),
alp = "ABCDEFGHIJKLMNOPQRSTUVWXYZ";
//randa aktyvu langeli ir salia esanti
//apsibreziam data
var today = new Date();
var dd = today.getDate();
var mm = today.getMonth()+1; //January is 0!
var yyyy = today.getFullYear();
//datos formatavimas
if(dd<10) {
dd='0'+dd
}
if(mm<10) {
mm='0'+mm
}
//gaunam laika
var valandos = today.getHours();
var minutes = today.getMinutes();
var sekundes = today.getSeconds();
//minuciu formatavimas
if (minutes < 10)
minutes = "0" + minutes
//spausdinam koda
today = yyyy+'-'+mm+'-'+dd+' '+valandos+':'+minutes+':'+sekundes;
var cell = SpreadsheetApp.getActive().getActiveCell().setValue(today);
//spalvina eilute
ss.setActiveSelection("A" + row + ":" + alp.charAt(last-1) + lastrow).setBackground('#fff2cc').setFontColor('#005F64');
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment