Skip to content

Instantly share code, notes, and snippets.

@oshliaer
Created February 27, 2018 15:37
Show Gist options
  • Save oshliaer/f1f8f9dff0253a5f7aa174dd59df6fbd to your computer and use it in GitHub Desktop.
Save oshliaer/f1f8f9dff0253a5f7aa174dd59df6fbd to your computer and use it in GitHub Desktop.
Default value of the cell of a Google Spreadsheet
function myFunction() {
var value = SpreadsheetApp.openById("ABC").getSheets()[0].getRange("A1").getValue();
Logger.log("value: %s" , value );
Logger.log("value == '': %s" , value == "" );
Logger.log("value === '': %s" , value === "" );
Logger.log("value === undefined: %s", value === undefined);
Logger.log("value === null: %s" , value === null );
Logger.log("!value: %s" , !value );
Logger.log("value === 0: %s" , value === 0 );
}
/*
[18-02-27 18:36:33:868 MSK] value:
[18-02-27 18:36:33:868 MSK] value == '': true
[18-02-27 18:36:33:869 MSK] value === '': true
[18-02-27 18:36:33:870 MSK] value === undefined: false
[18-02-27 18:36:33:870 MSK] value === null: false
[18-02-27 18:36:33:871 MSK] !value: true
[18-02-27 18:36:33:872 MSK] value === 0: false
[18-02-27 18:37:17:853 MSK] value: 0.0
[18-02-27 18:37:17:854 MSK] value == '': true
[18-02-27 18:37:17:854 MSK] value === '': false
[18-02-27 18:37:17:855 MSK] value === undefined: false
[18-02-27 18:37:17:855 MSK] value === null: false
[18-02-27 18:37:17:856 MSK] !value: true
[18-02-27 18:37:18:017 MSK] value === 0: true
*/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment