Styjun

Monty Hall Problem with a Fallible Monty

Raw curve25519 public key points

How can the artificial womb be made affordable for the common people?

Sextortion with actual password not found in leaks

Why did computer video outputs go from digital to analog, then back to digital?

Why did modems have speakers?

Idioms: Should it be " the internet is a seemingly infinite well of information" or "the internet is a seemingly infinite wealth of information"

What's the explanation for this joke about a three-legged dog that walks into a bar?

how to add 1 milliseconds on a datetime string?

How did C64 games handle music during gameplay?

How could an engineer advance human civilization by time traveling to the past?

Other than a swing wing, what types of variable geometry have flown?

Why is DC so, so, so Democratic?

How can I tell if there was a power cut when I was out?

Using paddles to support a bug net

USA: Can a witness take the 5th to avoid perjury?

Where is this photo of a group of hikers taken? Is it really in the Ural?

Why does the salt in the oceans not sink to the bottom?

What is an Eternal Word™?

Issue with ContourPlot

"It is what it is" in French

How may I shorten this shell script?

Who controls a summoned steed’s familiar?

The seven story archetypes. Are they truly all of them?

How to resize columns from minimum width to auto resize

How to set table column width for dynamic drop down list?How to adjust properly the Label container width, to its parent or brother widthHow to set up fixed width for <td>?How to get time value from google sheetCheck date and edit adjacent cell in Google Sheet with Google ScriptProtect everything but a range for editing on user baseAuto Column width script not working but Font and alignment areGoogle apps scripts set cell formulas needing row number for a row added via appendrowPrint a certain range of a Google Spreadsheet using a scriptThe best way to copy all cell contents between Spreadsheets

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

1

I have a spreadsheet with a number of sheets. The first sheet has X used columns and the remaining sheets have Y used columns. What I want to do is resize the columns between a given width and the auto-resize width if it is bigger.

So far I have the following code which auto-resizes the columns.

function resizeColumns() 
 SpreadsheetApp.flush();
 var ss = SpreadsheetApp.getActiveSpreadsheet();
 var sheets = ss.getSheets();

 var lastColumnMain = sheets[0].getLastColumn();
 var lastColumnUniversities = sheets[1].getLastColumn();

 for (var i = 0; i < sheets.length; i++) 
 var range;
 if (i == 0) 
 sheets[i].autoResizeColumns(1, lastColumnMain);
 range = sheets[i].getRange(1, 1, 1, lastColumnMain);
 else 
 sheets[i].autoResizeColumns(1, lastColumnUniversities);
 range = sheets[i].getRange(1, 1, 1, lastColumnUniversities);
 
 // Change width if less than 110 pixels
 

I thought about using a range to somehow get the column width and then change from there if they were too small but I'm lacking the vision to see exactly how to do so.

google-apps-script google-sheets width

share|improve this question

asked Mar 26 at 14:48

Max MichelMax Michel

981111 bronze badges

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  sheet.getColumnWidth(1) will get the width of 1st column. sheet.autoResizeColumns(startCol, numberOfCols) will auto-resize cols starting from startCol and will resize numberOfCols from starting col. I don't see any use of range. To resize more than one cols manually to a particular width, I guess you'll have to use 1st function to get all the col widths one by one using a loop and then use the 2nd function to set a width.
  
  – ra89fi
  Mar 26 at 17:40
  
  

  
  
  
  

add a comment | 

1

I have a spreadsheet with a number of sheets. The first sheet has X used columns and the remaining sheets have Y used columns. What I want to do is resize the columns between a given width and the auto-resize width if it is bigger.

So far I have the following code which auto-resizes the columns.

function resizeColumns() 
 SpreadsheetApp.flush();
 var ss = SpreadsheetApp.getActiveSpreadsheet();
 var sheets = ss.getSheets();

 var lastColumnMain = sheets[0].getLastColumn();
 var lastColumnUniversities = sheets[1].getLastColumn();

 for (var i = 0; i < sheets.length; i++) 
 var range;
 if (i == 0) 
 sheets[i].autoResizeColumns(1, lastColumnMain);
 range = sheets[i].getRange(1, 1, 1, lastColumnMain);
 else 
 sheets[i].autoResizeColumns(1, lastColumnUniversities);
 range = sheets[i].getRange(1, 1, 1, lastColumnUniversities);
 
 // Change width if less than 110 pixels
 

I thought about using a range to somehow get the column width and then change from there if they were too small but I'm lacking the vision to see exactly how to do so.

google-apps-script google-sheets width

share|improve this question

asked Mar 26 at 14:48

Max MichelMax Michel

981111 bronze badges

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  sheet.getColumnWidth(1) will get the width of 1st column. sheet.autoResizeColumns(startCol, numberOfCols) will auto-resize cols starting from startCol and will resize numberOfCols from starting col. I don't see any use of range. To resize more than one cols manually to a particular width, I guess you'll have to use 1st function to get all the col widths one by one using a loop and then use the 2nd function to set a width.
  
  – ra89fi
  Mar 26 at 17:40
  
  

  
  
  
  

add a comment | 

I have a spreadsheet with a number of sheets. The first sheet has X used columns and the remaining sheets have Y used columns. What I want to do is resize the columns between a given width and the auto-resize width if it is bigger.

So far I have the following code which auto-resizes the columns.

function resizeColumns() 
 SpreadsheetApp.flush();
 var ss = SpreadsheetApp.getActiveSpreadsheet();
 var sheets = ss.getSheets();

 var lastColumnMain = sheets[0].getLastColumn();
 var lastColumnUniversities = sheets[1].getLastColumn();

 for (var i = 0; i < sheets.length; i++) 
 var range;
 if (i == 0) 
 sheets[i].autoResizeColumns(1, lastColumnMain);
 range = sheets[i].getRange(1, 1, 1, lastColumnMain);
 else 
 sheets[i].autoResizeColumns(1, lastColumnUniversities);
 range = sheets[i].getRange(1, 1, 1, lastColumnUniversities);
 
 // Change width if less than 110 pixels
 

I thought about using a range to somehow get the column width and then change from there if they were too small but I'm lacking the vision to see exactly how to do so.

google-apps-script google-sheets width

share|improve this question

asked Mar 26 at 14:48

Max MichelMax Michel

981111 bronze badges

function resizeColumns() 
 SpreadsheetApp.flush();
 var ss = SpreadsheetApp.getActiveSpreadsheet();
 var sheets = ss.getSheets();

 var lastColumnMain = sheets[0].getLastColumn();
 var lastColumnUniversities = sheets[1].getLastColumn();

 for (var i = 0; i < sheets.length; i++) 
 var range;
 if (i == 0) 
 sheets[i].autoResizeColumns(1, lastColumnMain);
 range = sheets[i].getRange(1, 1, 1, lastColumnMain);
 else 
 sheets[i].autoResizeColumns(1, lastColumnUniversities);
 range = sheets[i].getRange(1, 1, 1, lastColumnUniversities);
 
 // Change width if less than 110 pixels
 

share|improve this question

asked Mar 26 at 14:48

Max MichelMax Michel

981111 bronze badges

share|improve this question

asked Mar 26 at 14:48

Max MichelMax Michel

981111 bronze badges

asked Mar 26 at 14:48

Max MichelMax Michel

981111 bronze badges

asked Mar 26 at 14:48

Max MichelMax Michel

981111 bronze badges