VS:AutoFitWSRowHeights

The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

.VectorScript|VectorScript ..VS:Function Reference|Function Reference ..VS:Function_Reference_Appendix|Appendix

Description

Auto fit the height of rows to the content of the cells in the referenced worksheet.

AutoFitWSRowHeights allows height for a range of rows to be auto fitted to the contents of cells. To auto fit the height of a single worksheet row, specify identical values for the top/bottom row range boundaries.

PROCEDURE AutoFitWSRowHeights(
                worksheet   :HANDLE;
                fromRow     :INTEGER;
                toRow       :INTEGER);

def vs.AutoFitWSRowHeights(worksheet, fromRow, toRow):
    return None

Parameters

worksheet	HANDLE	Handle to worksheet
fromRow	INTEGER	Top row of row range
toRow	INTEGER	Bottom row of row range

Example

VectorScript

{Auto resizes the height of all rows from row 1 to row 4} 
PROCEDURE Example;
VAR
sheet :HANDLE;
BEGIN
sheet := GetTopVisibleWS; 
AutoFitWSRowHeights(sheet,1,4);
END;
RUN(Example);

Python

def Example():
	sheet = vs.GetTopVisibleWS() 
	vs.AutoFitWSRowHeights(sheet,1,4)
Example()

Version

Availability: from VectorWorks12.0