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.2+7f12a949130e0be1e987e553d2d08c083176cdca

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