TxtSaveOptionsTrimLeadingBlankRowAndColumn Property

Indicates whether leading blank rows and columns should be trimmed like what ms excel does. Default is true.

Namespace: Aspose.Cells
Assembly: Aspose.Cells (in Aspose.Cells.dll) Version: 22.5.0.0 (22.5.0)

Syntax

public bool TrimLeadingBlankRowAndColumn { get; set; }

Public Property TrimLeadingBlankRowAndColumn As Boolean
	Get
	Set

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

member TrimLeadingBlankRowAndColumn : bool with get, set

Property Value

Type: Boolean

Remarks

Same with the rule in ms excel, a row/column will not be taken as blank if it has custom style, even if it contains no cell data. When saving with LightCells mode, this option takes no effect. User should control the output range by the implementation of LightCellsDataProvider or by speicifing ExportArea

Reference

TxtSaveOptions Class

Aspose.Cells Namespace

TxtSaveOptionsAddLanguageSpecificTextSet("LST192475C_0?cpp=::|nu=.");TrimLeadingBlankRowAndColumn Property

Property Value

Reference

TxtSaveOptionsTrimLeadingBlankRowAndColumn Property