source codeTag Archive

source code

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.

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());
}
}
}

About you can read on the official webpage: MonoDevelop enables developers to quickly write desktop and web applications on Linux, Windows and macOS. It also makes it easy for developers to port .NET applications created with Visual Studio to Linux and macOS maintaining a single code base for all platforms.… Continue Reading C# – First steps with C# and .NET – part 018 .

Today I will show you how to use the MMX instructions. SSE stands for Streaming SIMD Extensions and uses 128-bit registers: XMM0 XMM1 XMM2 XMM3 XMM4 XMM5 XMM6 XMM7 The capabilities of the XMM registers are: 2 64-bit floating points (double precision) 2 64-bit integers 4 32-bit floating points (single-precision)… Continue Reading Programming with FASM – divide / multiply in Linux – part 009 .

Translate »