2.2.3.33 wautosize

Brief Information

Resize worksheet column widths to display content of all cells

X-Function not designed for Auto GetN Dialog.

1. wautosize;

2. wautosize cw1:=2 cw2:=10 rh1:=2 rh2:=3 hw:=b;

Display Name	Variable Name	I/O and Type	Default Value	Description
Sheet to resize rows and columns	iw	Input Worksheet	<active>	Specify the worksheet to resize.
Min Col Width(-1=default, 2 = 2 chars)	cw1	Input double	1.5	Specify the minimum column width of the worksheet.
Max Col Width(-1=default, 10=10 chars)	cw2	Input double	25	Specify the maximal column width of the worksheet.
Min Row Height(-1=default, 1 = 1 line)	rh1	Input double	-1	Specify the minimum column height of the worksheet.
Max Row Height(-1=default, 2 = 2 lines)	rh2	Input double	-1	Specify the maximal column height of the worksheet.
Resize Height Width	hw	Input int	w	Specify the resize range Option list: w:Width Only Only resize the width of the worksheet h:Height Only Only resize the height of the worksheet b:Both Height and Width Resize the height and width of the worksheet together
Column Width Margin (% char width)	mw	Input int	80	Specify the width of column margin.
Row Height Margin (% char height)	mh	Input int	0	Specify the height of row margin.
Max # of Cols to resize(0=internal default)	limit	Input int	0	Specify the number of column to resize.

This function is used to resize the worksheet columns width by the maximal length in each column.