Spire.XLS API

Spire.XLS namespace

Spire.Xls.Core

IWorkbook Interface

IWorkbook Properties

ActiveSheet Property

ActiveSheetIndex Property

AddInFunctions Property

Allow3DRangesInDataValidation Property

ArgumentsSeparator Property

Author Property

BuiltInDocumentProperties Property

Charts Property

CodeName Property

CustomDocumentProperties Property

Date1904 Property

DetectDateTimeInValue Property

DisableMacrosStart Property

DisplayedTab Property

DisplayWorkbookTabs Property

HasMacros Property

IsCellProtection Property

IsDisplayPrecision Property

IsHScrollBarVisible Property

IsRightToLeft Property

IsVScrollBarVisible Property

IsWindowProtection Property

MaxColumnCount Property

MaxRowCount Property

Names Property

Palette Property

PasswordToOpen Property

PivotCaches Property

ReadOnly Property

ReadOnlyRecommended Property

RowSeparator Property

Saved Property

StandardFont Property

StandardFontSize Property

Styles Property

TabSheets Property

ThrowOnUnknownNames Property

Version Property

Worksheets Property

IWorkbook Allow3DRangesInDataValidation Property

Indicates whether to allow usage of 3D ranges in DataValidation list property (MS Excel doesn't allow).

Namespace: Spire.Xls.Core
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)

Syntax

C++

ASP.NET

Copy

bool Allow3DRangesInDataValidation { get; set; }

Property Allow3DRangesInDataValidation As Boolean
	Get
	Set

property bool Allow3DRangesInDataValidation {
	bool get ();
	void set (bool value);
}

abstract Allow3DRangesInDataValidation : bool with get, set

Property Value

Type: Boolean

Reference

IWorkbook Interface

Spire.Xls.Core Namespace

IWorkbook AddLanguageSpecificTextSet("LST65174C39_0?cpp=::|nu=."); Allow3DRangesInDataValidation Property

Property Value

Reference

IWorkbook Allow3DRangesInDataValidation Property