Function removeFormatting

Formatting.js:135–149

()

}

function removeFormatting() {
  // Get the active spreadsheet and sheet
  const spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  const sheet = spreadsheet.getActiveSheet();

  // Get the range of all cells that contain data
  const lastRow = sheet.getLastRow();
  const lastColumn = sheet.getLastColumn();
  const range = sheet.getRange(1, 1, lastRow, lastColumn);

  // Clear all formatting from the range
  range.clearFormat();

  Logger.log('Formatting removed from the sheet.');
}