How to reference current cell in Google Apps script spreadsheet

Question

A very basic question for google apps script: How do I reference the current cell from which the app script is being called for this current or active sheet in this spreadsheet?

Answer 1

initial state (before script execution)

example testing google app script

/**
 * Get selected cell coordinates and value, then set the cell value to 100
*/
function cellTester() {
  var spreadsheet = SpreadsheetApp.getActive();
  var sheet = spreadsheet.getActiveSheet();
  var cellRange = sheet.getActiveCell();
  var selectedColumn = cellRange.getColumn();
  var selectedRow = cellRange.getRow();
  Logger.log(`selectedColumn: ${selectedColumn}`);
  Logger.log(`selectedRow: ${selectedRow}`);
  Logger.log(`selected cell vale: ${cellRange.getValue()}`);
  cellRange.setValue(100);
}

final state (after the execution of the above script)

the log

    Log di Stackdriver
20 apr 2020, 23:23:56   Informazioni    selectedColumn: 3
20 apr 2020, 23:23:56   Informazioni    selectedRow: 2
20 apr 2020, 23:23:56   Informazioni    selected cell vale: 69