Workbook.GetTextHeight(String, Font, Double)

Description

Returns the minimum height required to fit the given text string using the given font.

Parameters

text

The text string whose height will be calculated.

font

The font that will be used to format the text.

desiredWidth

The width, in character units, of the cell or area into which the text will be inserted.

Returns

The minimum height, in character units, required to accomodate the given text string.

Remarks

Themaximum height of any one row is 409 units, so if the height return is greater than 409, you must merge cells across multiple rows and set the height of each row to accomodate the total minimum height of the text.

Examples