admin

born 1976, Falticeni , Suceava , Romania
648

admin 's Posts

In this tutorial, I will show you the differences between getValue and getDisplayValue in Google Apps Script. I used a default project with a default spreadsheet document with my birthday 1976-03-07 into A1 cell and format text as year-month-day. I add Apps Script API to my project. On the spreadsheet,… Continue Reading Google Apps Script – getValue or getDisplayValue – part 032.

The tutorial for today is about a math problem named happy number. I used my repl.it account to test it. The algorithm of this program is simple: To find out if a number is happy, replace the number by the sum of the squares of its digits. Repeat the process… Continue Reading C# – First steps with C# and .NET – part 020 .

The tutorial for today is about toast message into a spreadsheet. Use script editor, run the next code source it with authorization:

JavaScript
1
2
3
4
5
function myFunction() {
  var ss = SpreadsheetApp.getActive();
  ws = ss.getSheetByName("Sheet1");
  ss.toast("This is a toast message!");
}

You will see a message toast in the bottom right area of the spreadsheet with this text: This is a toast message!

Today I will present briefly Class GmailThread. It can be used to retrieve data from incoming electronic mail received by Gmail. Let’s see a simple example. First, open a spreadsheet, and from Tools open the Script editor to run this source code:

1
2
3
4
5
6
7
function getGmailData() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var threads = GmailApp.search("is:unread in:inbox", 0, 7);
  for (var t=0; t<threads.length; t++) {
    sheet.appendRow([threads[t], threads[t].getId(), threads[t].getLabels(),threads[t].getFirstMessageSubject()])
  }
}

. Add and run with authorization for Gmail… Continue Reading Google Apps Script – about Class GmailThread – part 030.

This is simple to do. Open a GAS script in google editor. You can use the google drive menu New – Google Apps Script or create a new document and use from menu: Tools – Script editor to open a new google apps script editor. Select Gmail A.P.I. from the… Continue Reading Google Apps Script – delete a email – part 029.

This is the most simple way to have a joystick on your game. The project comes with three images one for the exit application and two images for the joystick. One image is for the background joystick on this I add another image for the joystick. The projects have two… Continue Reading Unity 3D – A simple joystick project .

Google is coming up with a new feature called Google Developer Profile. They inform us about this option as follows: Google Developer Profile, is a way to learn about Google technologies and unlock achievements. Your profile captures your achievements with badges and saves your progress as you complete pathways, which… Continue Reading Web – Google Developer Profile.

Another C# example with constructors in a derived class using the repl.it online tool for C# . Another good online tool can be found on this web page. You can run it here with the command:

1
mono main.exe

 The source code is this:

C#
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
using System;
 
namespace InheritanceApplication {
class Ship {
 
double ship_width;
double ship_length;
 
// Default constructor for class Ship
public Ship()
{
Width = Length = 0.0;
}
 
// Constructor for Ship get width and length of Ship
public Ship(double w, double l)
{
Width = w;
Length = l;
}
 
// Properties for Width
public double Width
{
get {
   return ship_width;  
}
 
set {  
  ship_width = value < 0 ? -value : value;  
}
}
            // Properties for Length
public double Length
{
get {  
   return ship_length;  
}
 
set {  
  ship_length = value < 0 ? -value : value;
}
}
            // display Ship status
public void ShipStatus()
{
Console.WriteLine("The ship width and length in metters are: Width "
+ Width + "| Length " + Length);
}
}
 
// A derived class of Ship named Interstellar_Ship.
class Interstellar_Ship : Ship {
 
string Interstellar_Engine;
 
// A default constructor of Interstellar_Ship.
public Interstellar_Ship()
{
Interstellar_Engine = "Velocity";
}
 
// Constructor base
public Interstellar_Ship(string s, double w, double l)
: base(w, l)
{
Interstellar_Engine = s;
}
 
// Return area of Interstellar_Ship.
public double Area()
{
return Width * Length;
}
 
// Display engine of Interstellar_Ship's.
public void DisplayInterstellar_Engine()
{
Console.WriteLine("Interstellar_Ship engine for " + Interstellar_Engine);
}
}
 
// Inheriting Interstellar_Ship class
class Speed_Interstellar_Ship : Interstellar_Ship {
 
int speed_ship;
 
// Constructor
public Speed_Interstellar_Ship(int speed, string s,
  double w, double l)
: base(s, w, l)
{
speed_ship = speed;
}
 
// Display the speed.
public void Display_Speed()
{
Console.WriteLine("Speed in km/s is: " + speed_ship);
}
}
 
// Driver Class
class GFG {
 
// Main Method
public static void Main()
{
Speed_Interstellar_Ship first_ship = new Speed_Interstellar_Ship(131000,  
   "catafest Velocity Engine", 1000.33, 176.3);
 
Speed_Interstellar_Ship second_ship = new Speed_Interstellar_Ship(176000,
   "mythcat Hybrid Variable-impulse Chemical", 177.0, 441.0);
 
Console.WriteLine("Details of first ship: ");
first_ship.DisplayInterstellar_Engine();
first_ship.ShipStatus();
first_ship.Display_Speed();
 
Console.WriteLine("Area of ship: " + first_ship.Area());
Console.WriteLine();
 
Console.WriteLine("Details of second_ship: ");
second_ship.DisplayInterstellar_Engine();
second_ship.ShipStatus();
second_ship.Display_Speed();
 
Console.WriteLine("Area of ship: " + second_ship.Area());
}
}
}

Translate »