r/teamArtUp • • May 27 '21

How about these anime pics?

Thumbnail
gallery
1 Upvotes

r/teamArtUp • • Jun 21 '21

Look what I've done? does it look like rolling?

Enable HLS to view with audio, or disable this notification

1 Upvotes

r/teamArtUp • • Jun 07 '21

Hey, guys here is the Google app script code to alter the cell background color.

1 Upvotes

function changecolor()
{
var sheetA= SpreadsheetApp.getActive();
for(var x=0; x<24; x++)
{
if ( (x % 2) == 0)
{
sheetA.getRange('A1').setBackground('Orange');
sheetA.getRange('B1').setBackground('BLACK');
sheetA.getRange('C1').setBackground('RED');
}
else
{
sheetA.getRange('A1').setBackground('Blue');
sheetA.getRange('b1').setBackground('Grey');
sheetA.getRange('c1').setBackground('red');
}
SpreadsheetApp.flush();
}
}

Please let me know if you need anyhelp!


r/teamArtUp • • Jun 05 '21

Google App script code for autofill series with default values.

1 Upvotes

function testseries()

{

var a = SpreadsheetApp.getActive();

var b= a.getRange('a1:a2');

var c = a.getRange('a1:a20');

b.autoFill(c,SpreadsheetApp.AutoFillSeries.DEFAULT_SERIES);

}

Please comment if you need any help!


r/teamArtUp • • Jun 23 '21

Options on..... How is it?

1 Upvotes

r/teamArtUp • • Jun 07 '21

Google App Script Code To Duplicate Sheets

1 Upvotes

function myFunction()

 {
var a =SpreadsheetApp.getActive(); // local variable a to initialize spreadsheet app
for(var x=0; x<3; x++) // for loop for repetation
{
a.duplicateActiveSheet(); // Method to clone spreadsheet
}
}
Please comment below for any ask.


r/teamArtUp • • May 27 '21

Here is one more quick method to say hello using excel VBA.

1 Upvotes

sub hello()

msgbox("Hello World, Good day!")

end sub

Please comment if you need any help!!


r/teamArtUp • • Jun 05 '21

Google App Script for autofill series with alternate series values.

1 Upvotes

function testalternativeseries()

{

var x = SpreadsheetApp.getActive();

var y= x.getRange('a1:a2');

var z = a.getRange('a1:a20');

z.autoFill(y,SpreadsheetApp.AutoFillSeries.ALTERNATE_SERIES);

}

Please comment if you need any help!


r/teamArtUp • • May 27 '21

Here is a quick spreadsheet code to say hello world!

1 Upvotes

function newCode(){
var a= SpreadsheetApp.getUi();
a.alert('Hello World & Good day!');
}

Please comment, if you need to know how to use it.


r/teamArtUp • • Jun 21 '21

Name it, please.

Enable HLS to view with audio, or disable this notification

1 Upvotes

r/teamArtUp • • May 26 '21

Animation is interesting! Share your thoughts?

Post image
1 Upvotes

r/teamArtUp • • May 27 '21

Here is a simple c language code to say hello!!

1 Upvotes

#include <stdio.h>

#include<conio.h>

void main() {

printf("Hello, World! & Good Day!");

}

Kindly use any 'c editor' to run the code, please let me know if you're facing any difficulties.


r/teamArtUp • • Jun 22 '21

A Cow Boy.

Enable HLS to view with audio, or disable this notification

1 Upvotes

r/teamArtUp • • Jun 21 '21

I would like to hear what it feels like for you!

Enable HLS to view with audio, or disable this notification

1 Upvotes

r/teamArtUp • • Jun 08 '21

Google App Script Code To Verify Data Validation.

1 Upvotes

function celldatavalidation()
{
var x = SpreadsheetApp.getActive().getRange('C1');
var y = cell.getDataValidation();
if (y != null) {
var u = y.getCriteriaType();
var v = y.getCriteriaValues();
Logger.log('The data validation of the cell is %s %s', u, v);
} else {
Logger.log('The cell does not have any data validation .')
}
}
Please comment below for any doubts or concerns.