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.4+e304ab0274fa680d1e83f83c8f76c3bd5a54caf2

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