Return to Revisions

2 of 4

replaced inline formatting with code block

edit approved May 4, 2015 at 23:44

It looks like this issue is due to a bug in the new Google Sheets, but you can use this simple script as a workaround.

In your sheet, go to Tools > Script Editor. Erase the existing code in Code.gs and add this instead:

function setCellAlign(range, alignment) {
   var ss = SpreadsheetApp.getActiveSpreadsheet();
   var sheet = ss.getSheets()[0];
   var cell = sheet.getRange(range);
   cell.setHorizontalAlignment(alignment);
 }
function onFormSubmit() {
   setCellAlign("A1:F500", "center");
}

In the second-to-last-line, change F500 to the expected bottom-right cell of your sheet. For example, if your rightmost column is G and you want to hold 1000 responses in your sheet, change the value to G1000 so the second-to-last line is setCellAlign("A1:G1000", "center");

Save the script project as "AutoAlign"
Within the Script Editor, go to Resources > Current project's triggers. Add a new trigger for onFormSubmit, From spreadsheet, On form submit, and press "Save."

Your responses should now align automatically to the center. For whatever reason this script fails to work 1% of the time, but if that happens the next form submission will fix the previous row.

answered May 4, 2015 at 23:36

Stefan