SSpread.MaxTextCellHeight Property

Gets the height required to display the text set in the cell.

Before referencing this property, use the Col, Row properties to specify the target cell.

This property is read-only.

Find the height required to display the text based on the font size set in the cell.

Multi-line cells with the TypeEditMultiLine and TypeTextWordWrap properties return the height required to display all multi-line text relative to the current column width and font size.

By using the MaxTextCellWidth and MaxTextCellHeight properties, you can find the optimum size according to the state of the cell.

The MaxTextRowHeight property allows to get the required height of the entire row.

Example of usage

Col = 2;
Row = 3;
Text = "Biz/Browser";
print(MaxTextCellWidth , MaxTextCellHeight, "\n");
ColWidth(2) = MaxTextCellWidth;
RowHeight(3) = MaxTextCellHeight;

Related Items
MaxTextCellWidth, MaxTextRowHeight, RowHeight property