API Reference
Class
OdsDataPilotTable
An ODF data pilot table. Imported settings outside the typed field subset remain in the source XML.
Inheritance
- Object
- OdsDataPilotTable
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.AddDataPilotTable
- Property OdsDocument.DataPilotTables
Methods
public OdsDataPilotField AddField(String sourceFieldName, String orientation, String function = null) #Returns:
OdsDataPilotFieldAdds a source field to this table using an ODF orientation and optional aggregation function.
Parameters
- sourceFieldName System.String
- orientation System.String
- function System.String = null
Inherited Methods
public override Boolean Equals(Object obj) #Returns:
BooleanInherited from Object
Parameters
- obj Object
Properties
public String Name { get; } #Gets the data pilot name.
public String SourceRangeAddress { get; } #Gets the ODF source cell range, when the source is a local cell range.
public String TargetRangeAddress { get; } #Gets the ODF target cell range.
public IReadOnlyList<OdsDataPilotField> Fields { get; } #Gets the source fields in document order.
public Boolean HasAdvancedSettings { get; } #Whether imported grouping, field references, member selection, or nonlocal sources exceed the simple conversion subset.