UtilsGetInternalPaneSplitHeight Method

Calculates the internal height of a split pane in a worksheet. This height is used only in the XML documents of worksheets and is not exposed to the (Excel) user

Namespace: NanoXLSX
Assembly: NanoXLSX (in NanoXLSX.dll) Version: 2.6.5+4f4b44a718a20dda8ca2c0c4d00bd7eee7c80f5d

Syntax

Copy

public static float GetInternalPaneSplitHeight(
	float height
)

Parameters

height Single: Target row(s) height (one or more rows, displayed in Excel)

Return Value

Single
The internal pane height, used in worksheet XML documents in case of worksheet splitting

Remarks

The internal split height is based on the height of one or more rows. It also depends on various constants.
This method is derived from the Perl implementation by John McNamara (https://stackoverflow.com/a/5010899).
Negative row heights are automatically transformed to 0.

Reference

Utils Class

NanoXLSX Namespace