Created
October 20, 2015 12:29
-
-
Save rytoj/6834204e65e9f06014c3 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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