Table of Contents

Class OdfDatabaseRangeInfo

Namespace
OdfKit.Spreadsheet
Assembly
OdfKit.dll

Represents summary information for a database range in a spreadsheet. 表示試算表中一個資料庫範圍的摘要資訊。

public sealed class OdfDatabaseRangeInfo
Inheritance
OdfDatabaseRangeInfo
Inherited Members

Constructors

OdfDatabaseRangeInfo(string, string, bool, bool, IReadOnlyList<OdfDatabaseFilterConditionInfo>, IReadOnlyList<OdfDatabaseSortRuleInfo>)

Represents summary information for a database range in a spreadsheet. 表示試算表中一個資料庫範圍的摘要資訊。

public OdfDatabaseRangeInfo(string name, string targetRangeAddress, bool displayFilterButtons, bool containsHeader, IReadOnlyList<OdfDatabaseFilterConditionInfo> filterConditions, IReadOnlyList<OdfDatabaseSortRuleInfo> sortRules)

Parameters

name string

The database range name. / 資料庫範圍名稱。

targetRangeAddress string

The target range address string from table:target-range-address. / 目標範圍位址字串（table:target-range-address）。

displayFilterButtons bool

Whether to display auto-filter buttons. / 是否顯示自動篩選按鈕。

containsHeader bool

Whether the first row is treated as labels. / 第一列是否視為標籤。

filterConditions IReadOnlyList<OdfDatabaseFilterConditionInfo>

The filter condition list. / 篩選條件清單。

sortRules IReadOnlyList<OdfDatabaseSortRuleInfo>

The sort rule list. / 排序規則清單。

Properties

ContainsHeader

Gets whether the first row is treated as labels. 取得第一列是否視為標籤。

public bool ContainsHeader { get; }

Property Value

bool

DisplayFilterButtons

Gets whether auto-filter buttons are displayed. 取得是否顯示自動篩選按鈕。

public bool DisplayFilterButtons { get; }

Property Value

bool

FilterConditions

Gets the filter condition list. 取得篩選條件清單。

public IReadOnlyList<OdfDatabaseFilterConditionInfo> FilterConditions { get; }

Property Value

IReadOnlyList<OdfDatabaseFilterConditionInfo>

Name

Gets the database range name. 取得資料庫範圍名稱。

public string Name { get; }

Property Value

string

SortRules

Gets the sort rule list. 取得排序規則清單。

public IReadOnlyList<OdfDatabaseSortRuleInfo> SortRules { get; }

Property Value

IReadOnlyList<OdfDatabaseSortRuleInfo>

TargetRangeAddress

Gets the target range address string. 取得目標範圍位址字串。

public string TargetRangeAddress { get; }

Property Value

string

Methods

TryGetTargetRange(out OdfCellRange)

Attempts to parse TargetRangeAddress as an OdfCellRange. 嘗試將 TargetRangeAddress 解析為 OdfCellRange。

public bool TryGetTargetRange(out OdfCellRange range)

Parameters

range OdfCellRange

The cell range returned when parsing succeeds. / 解析成功時傳回的儲存格範圍。

Returns

bool

true if parsing succeeds. / 若解析成功則為 true。