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.3+98f265239ae8df4639650ecd7029244cc5e52dfc

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