Table of Contents

Class OdfSpreadsheetCalculationSettings

Namespace
OdfKit.Spreadsheet
Assembly
OdfKit.dll

Represents a high-level facade for ODS workbook-level calculation settings. 表示 ODS 活頁簿層級的計算設定高階外觀。

public sealed class OdfSpreadsheetCalculationSettings
Inheritance
OdfSpreadsheetCalculationSettings
Inherited Members

Properties

AutomaticFindLabels

Gets or sets whether labels are found automatically. 取得或設定是否自動尋找標籤。

public bool? AutomaticFindLabels { get; set; }

Property Value

bool?

CaseSensitive

Gets or sets whether searches and comparisons are case-sensitive. 取得或設定搜尋與比較是否區分大小寫。

public bool? CaseSensitive { get; set; }

Property Value

bool?

HasIteration

Gets whether iteration settings already exist. 取得是否已存在反覆運算設定。

public bool HasIteration { get; }

Property Value

bool

Iteration

Gets or creates iteration settings. 取得或建立反覆運算設定。

public OdfSpreadsheetIterationSettings Iteration { get; }

Property Value

OdfSpreadsheetIterationSettings

NullYear

Gets or sets the base year used for the null date. 取得或設定 null 日期所使用的基準年份。

public int? NullYear { get; set; }

Property Value

int?

PrecisionAsShown

Gets or sets whether calculations use the displayed precision. 取得或設定是否依顯示精度計算。

public bool? PrecisionAsShown { get; set; }

Property Value

bool?

SearchCriteriaMustApplyToWholeCell

Gets or sets whether search criteria must match the entire cell. 取得或設定搜尋條件是否必須符合整個儲存格。

public bool? SearchCriteriaMustApplyToWholeCell { get; set; }

Property Value

bool?

UseRegularExpressions

Gets or sets whether formula searches use regular expressions. 取得或設定公式搜尋是否使用正規表示式。

public bool? UseRegularExpressions { get; set; }

Property Value

bool?

UseWildcards

Gets or sets whether formula searches use wildcards. 取得或設定公式搜尋是否使用萬用字元。

public bool? UseWildcards { get; set; }

Property Value

bool?

Methods

ClearIteration()

Clears iteration settings. 清除反覆運算設定。

public void ClearIteration()