API Reference
OdsSheet
An XML-backed ODS worksheet with sparse repeat-run editing.
Inheritance
- Object
- OdsSheet
Usage
This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.
Returned or exposed by
- Method OdsDocument.AddSheet
- Method OdsDocument.GetSheet
- Property OdsDocument.Sheets
Methods
public OdsCell Cell(Int64 row, Int64 column) #OdsCellGets an editable zero-based cell, splitting only the containing row and cell runs.
Parameters
- row System.Int64
- column System.Int64
public OdsColumn Column(Int64 column) #OdsColumnGets an editable zero-based column definition, creating a sparse definition when needed.
Parameters
- column System.Int64
public String GetFormula(Int64 row, Int64 column) #StringReads a formula without splitting or expanding repeat runs.
Parameters
- row System.Int64
- column System.Int64
public OdsCellValue GetValue(Int64 row, Int64 column) #OdsCellValueReads a value without splitting or expanding repeat runs.
Parameters
- row System.Int64
- column System.Int64
public OdsCell Merge(Int64 row, Int64 column, Int64 rowSpan, Int64 columnSpan) #OdsCellMerges a rectangular cell range and marks non-anchor positions as covered cells.
Parameters
- row System.Int64
- column System.Int64
- rowSpan System.Int64
- columnSpan System.Int64
public OdsCell Merge(Int64 row, Int64 column, Int64 rowSpan, Int64 columnSpan, Int64 maximumMaterializedCells) #OdsCellMerges a rectangular cell range under an explicit materialization bound.
Parameters
- row System.Int64
- column System.Int64
- rowSpan System.Int64
- columnSpan System.Int64
- maximumMaterializedCells System.Int64
public OdsRow Row(Int64 row) #OdsRowGets an editable zero-based row, splitting its repeat run without expanding it.
Parameters
- row System.Int64
Inherited Methods
public override Boolean Equals(Object obj) #BooleanParameters
- obj Object
Properties
public String PrintRanges { get; set; } #Optional ODF print range expression.
public IReadOnlyList<OdsRowRun> RowRuns { get; } #Sparse row runs without expanding table:number-rows-repeated.
public IReadOnlyList<OdsColumnRun> ColumnRuns { get; } #Sparse column definition runs without expanding repeats.
public Int64 RowCount { get; } #Logical row count represented by the sparse run model.
public Nullable<OdsUsedRange> UsedRange { get; } #Smallest rectangle containing cells with a value, formula, or text.
Fields
public const Int64 DefaultMaximumMergeCells #Default maximum number of cells that one merge operation may materialize.
100000