Category Archives: javascript

First step with ionic framework.

Node.js is a platform built on Chrome’s JavaScript runtime for easily building fast, scalable network applications. This tutorial is based on Fedora 30 distro.

1
2
3
4
5
6
[root@desk mythcat]# dnf install nodejs
Last metadata expiration check: 0:58:43 ago on Mon 12 Aug 2019 10:01:29 AM EEST.
Package nodejs-1:10.16.0-3.fc30.x86_64 is already installed.
Dependencies resolved.
Nothing to do.
Complete!

Let’s see the version for npm and nodejs:

1
2
3
4
[mythcat@desk ~]$ npm --version
6.9.0
[mythcat@desk ~]$ node --version
v10.16.0

Ionic Framework is the free, open source mobile UI toolkit for developing high-quality cross-platform apps for native iOS, Android, and the… Read More »

Google Apps Script – set colors – part 024.

This tutorial will show you how to alternate the colors by row. The first part will select by variables the active Spreadsheet, the sheet named Sheet1 and the range area. The for loop will parse all rows by modulo and set a variable named range_input. The color are changed by the setBackgrounds.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
// set alternate colors by Row
function alternate_Colors_byRow() {
  var spread_active = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = spread_active.getSheetByName("Sheet1");
  var range_input = spread_active.getRange("A1:B50").getValues();
  for(var i=0; i<range_input.length; i++){
    if(i%2==0){
      for(var k=0;k<range_input[0].length;k++){
        range_input[i][k]='#ffffff'
      }
    }    
    else{
      for(var k=0;k<range_input[0].length;k++){
        range_input[i][k]='#0076b0'
      }
    }  
  }
  sheet.getRange('A1:B50').setBackgrounds(range_input);
}

This is… Read More »