XlsWorksheet AllocatedRangeIncludesFormatting Property

There are two different algorithms to create UsedRange object: 1) Default. This property = true. The cell is included into UsedRange when it has some record created for it even if data is empty (maybe some formatting changed, maybe not - cell was accessed and record was created). 2) This property = false. In this case XlsIO tries to remove empty rows and columns from all sides to make UsedRange smaller.

public bool AllocatedRangeIncludesFormatting { get; set; }

Public Property AllocatedRangeIncludesFormatting As Boolean
	Get
	Set

public:
property bool AllocatedRangeIncludesFormatting {
	bool get ();
	void set (bool value);
}

member AllocatedRangeIncludesFormatting : bool with get, set