2.2.3.33 wautosize


Brief Information

Resize worksheet column widths to display content of all cells

Additional Information

X-Function not designed for Auto GetN Dialog.

Command Line Usage

1. wautosize;

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

X-Function Execution Options

Please refer to the page for additional option switches when accessing the x-function from script

Variables

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.

Description

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

English | Deutsch | 日本語