Table of Contents

Class OdfSpreadsheetLimits

Namespace
OdfKit.Spreadsheet
Assembly
OdfKit.dll

Defines defensive upper bounds for repeated spreadsheet rows and columns. 試算表重複列與欄的防禦性上限常數。

public static class OdfSpreadsheetLimits
Inheritance
OdfSpreadsheetLimits
Inherited Members

Fields

ChartMaxRepeat

The maximum repeated row or column count allowed while building an embedded chart's local data cache. 建立嵌入圖表本地資料快取時允許的最大重複列或欄次數。

public const int ChartMaxRepeat = 10000

Field Value

int

ChartRenderMaxCells

The maximum total cell count allowed when materializing a chart series data range for rendering. 圖表渲染時,將資料範圍具體化為陣列所允許的最大儲存格總數。

public const int ChartRenderMaxCells = 1000000

Field Value

int

CsvMaxRepeat

The maximum repeated row or column count allowed during CSV export. CSV 匯出時允許的最大重複列或欄次數。

public const int CsvMaxRepeat = 10000

Field Value

int

FormulaMaxDateSpanDays

The maximum number of days allowed for date-span iteration in date/time formula functions (e.g. WORKDAY, NETWORKDAYS), matching the widest date range supported by the spreadsheet engine. 日期時間公式函式(如 WORKDAY、NETWORKDAYS)逐日迭代所允許的最大天數,與試算表引擎支援的最大日期範圍一致。

public const int FormulaMaxDateSpanDays = 3000000

Field Value

int

FormulaMaxRepeat

The maximum repeated row or column count allowed during formula evaluation. 公式評估時允許的最大重複列或欄次數。

public const int FormulaMaxRepeat = 10000

Field Value

int

MaxColumnIndex

The maximum column index allowed by the ODF spreadsheet grid (matches Excel/Calc's 16,384-column limit). ODF 試算表格線允許的最大欄索引(與 Excel/Calc 的 16,384 欄上限一致)。

public const int MaxColumnIndex = 16383

Field Value

int

MaxRowIndex

The maximum row index allowed by the ODF spreadsheet grid (matches Excel/Calc's 1,048,576-row limit). ODF 試算表格線允許的最大列索引(與 Excel/Calc 的 1,048,576 列上限一致)。

public const int MaxRowIndex = 1048575

Field Value

int