Skip to content

Instantly share code, notes, and snippets.

@btamayo

btamayo/macro.gs

Last active May 13, 2023 05:31
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save btamayo/3374b32a3b10ae55ee15f00f39c91b0b to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save btamayo/3374b32a3b10ae55ee15f00f39c91b0b to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. btamayo revised this gist May 13, 2023. 1 changed file with 12 additions and 7 deletions.
    19 changes: 12 additions & 7 deletions macro.gs
    View file
    Original file line number Diff line number Diff line change
    @@ -1,31 +1,36 @@
    function ResizeRow() {
    // Be careful about this. If you change this to `getActiveSpreadSheet()`, it will be super confusing:
    // see https://www.reddit.com/r/GoogleAppsScript/comments/10dbe41/comment/j4knea5
    var spreadsheet = SpreadsheetApp.getActiveSheet();
    var selection = spreadsheet.getSelection();
    var sheet = SpreadsheetApp.getActiveSheet();
    var selection = sheet.getSelection();
    var activeRange = selection.getActiveRange();
    var rowsInSelection = activeRange.getNumRows();

    var cell = selection.getCurrentCell();
    var row = cell.getRow();
    var col = cell.getColumn();

    // Leaving this as an example of how to log
    // Leaving these as an example of how to log and for debugging
    Logger.log('[Selection] Row: ' + row);
    Logger.log('[Selection] Col: ' + col);
    Logger.log('[Selection] rowsInSelection: ' + rowsInSelection);

    for (let i = 0; i < rowsInSelection; i++) {
    row = row + i;

    range = spreadsheet.getRange(row, col)
    cell = spreadsheet.setCurrentCell(range)
    Logger.log('[Loop] Row: ' + row);
    Logger.log('[Loop] Col: ' + col);

    range = sheet.getRange(row, col)
    cell = sheet.setCurrentCell(range)

    Logger.log('[Range] cell: ' + cell.getA1Notation());
    height = cell.getHeight()

    spreadsheet.setRowHeight(row, height + 50);
    sheet.setRowHeight(row, height + 100);
    cell.setVerticalAlignment("middle");
    cell.setWrapStrategy(SpreadsheetApp.WrapStrategy.WRAP);
    }

    return
    };
  2. btamayo revised this gist May 13, 2023. 1 changed file with 31 additions and 1 deletion.
    32 changes: 31 additions & 1 deletion macro.gs
    View file
    Original file line number Diff line number Diff line change
    @@ -1 +1,31 @@
    sdfsdfdf
    function ResizeRow() {
    // Be careful about this. If you change this to `getActiveSpreadSheet()`, it will be super confusing:
    // see https://www.reddit.com/r/GoogleAppsScript/comments/10dbe41/comment/j4knea5
    var spreadsheet = SpreadsheetApp.getActiveSheet();
    var selection = spreadsheet.getSelection();
    var activeRange = selection.getActiveRange();
    var rowsInSelection = activeRange.getNumRows();

    var cell = selection.getCurrentCell();
    var row = cell.getRow();
    var col = cell.getColumn();

    // Leaving this as an example of how to log
    Logger.log('[Selection] Row: ' + row);
    Logger.log('[Selection] Col: ' + col);
    Logger.log('[Selection] rowsInSelection: ' + rowsInSelection);

    for (let i = 0; i < rowsInSelection; i++) {
    row = row + i;

    range = spreadsheet.getRange(row, col)
    cell = spreadsheet.setCurrentCell(range)
    height = cell.getHeight()

    spreadsheet.setRowHeight(row, height + 50);
    cell.setVerticalAlignment("middle");
    cell.setWrapStrategy(SpreadsheetApp.WrapStrategy.WRAP);
    }

    return
    };
  3. btamayo created this gist May 13, 2023.
    1 change: 1 addition & 0 deletions macro.gs
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1 @@
    sdfsdfdf