Class
OdsDataPilotTable
OfficeIMO.OpenDocument
An ODF data pilot table. Imported settings outside the typed field subset remain in the source XML.
Inheritance
- object
- OdsDataPilotTable
Usage
Explore 2 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 2
- Method OdsDocument.AddDataPilotTable
- Property OdsDocument.DataPilotTables
Methods
public OdsDataPilotField AddField(string sourceFieldName, string orientation, string? function = null) #Adds a source field to this table using an ODF orientation and optional aggregation function.
Parameters
- sourceFieldName string
- orientation string
- function string? = null
Returns
OdsDataPilotFieldInherited Methods
Properties
public string? SourceRangeAddress { get; } #Gets the ODF source cell range, when the source is a local cell range.
public IReadOnlyList<OdsDataPilotField> Fields { get; } #Gets the source fields in document order.
public bool HasAdvancedSettings { get; } #Whether imported grouping, field references, member selection, or nonlocal sources exceed the simple conversion subset.