API Reference
OdsSheet
An XML-backed ODS worksheet with sparse repeat-run editing.
Inheritance
- Object
- OdsSheet
Usage
Explore 3 API references to this type
This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.
Returned or exposed by 3
- Method OdsDocument.AddSheet
- Method OdsDocument.GetSheet
- Property OdsDocument.Sheets
Methods
public OdsChart AddChart(OdsChartType type, String categoriesAddress, IReadOnlyList<OdsChartSeries> series, Int64 anchorRow, Int64 anchorColumn, OdfRect bounds, String? title = null, String? name = null) #OdsChartAdds a bounded chart linked to existing ODS cells and anchored in this sheet.
Parameters
- type OfficeIMO.OpenDocument.OdsChartType
- categoriesAddress System.String
- series System.Collections.Generic.IReadOnlyList<OfficeIMO.OpenDocument.OdsChartSeries>
- anchorRow System.Int64
- anchorColumn System.Int64
- bounds OfficeIMO.OpenDocument.OdfRect
- title System.String? = null
- name System.String? = null
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) #String?Reads 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 virtual Boolean Equals(Object? obj) #BooleanParameters
- obj Object?
Properties
public IReadOnlyList<OdsChart> Charts { get; } #Embedded charts whose chart content can be read safely from this package.
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 OdsUsedRange? UsedRange { get; } #Smallest rectangle containing cells with a value, formula, or text.