PivotUserEdit Class
Defines the PivotUserEdit Class.This class is only available in Office2010.When the object is serialized out as xml, its qualified name is x14:userEdit.
Inheritance Hierarchy
System.Object
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlCompositeElement
DocumentFormat.OpenXml.Office2010.Excel.PivotUserEdit
Namespace: DocumentFormat.OpenXml.Office2010.Excel
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
Syntax
'宣言
<OfficeAvailabilityAttribute(FileFormatVersions.Office2010)> _
<ChildElementInfoAttribute(GetType(Formula))> _
<ChildElementInfoAttribute(GetType(PivotEditValue), FileFormatVersions.Office2010)> _
Public Class PivotUserEdit _
Inherits OpenXmlCompositeElement
'使用
Dim instance As PivotUserEdit
[OfficeAvailabilityAttribute(FileFormatVersions.Office2010)]
[ChildElementInfoAttribute(typeof(Formula))]
[ChildElementInfoAttribute(typeof(PivotEditValue), FileFormatVersions.Office2010)]
public class PivotUserEdit : OpenXmlCompositeElement
Remarks
The following table lists the possible child types:
DocumentFormat.OpenXml.Office.Excel.Formula <xne:f>
PivotEditValue <x14:editValue>
2.6.41 CT_PivotUserEdit
Target namespace: https://schemas.microsoft.com/office/spreadsheetml/2010/main
Referenced by: CT_PivotEdit
A complex type that specifies user input, related to PivotTable what-if analysis in a single cell of the PivotTable ([ISO/IEC-29500-1] section 18.10) data area.
Child Elements:
xm:f : An ST_Formula ([ISO/IEC-29500-1] section 18.18.35) element that specifies a formula. The formula MUST adhere to the grammar provided in Formulas, with the following restrictions:
The formula MUST NOT use the bang-reference or bang-name production rules.
editValue : A CT_PivotEditValue element that specifies the user input value that replaces the original cell value, in a single cell of the PivotTable ([ISO/IEC-29500-1] section 18.10) data area.
The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.
<xsd:complexType name="CT_PivotUserEdit">
<xsd:choice minOccurs="1" maxOccurs="1">
<xsd:element ref="xm:f" minOccurs="1" maxOccurs="1"/>
<xsd:element name="editValue" type="CT_PivotEditValue" minOccurs="1" maxOccurs="1"/>
</xsd:choice>
</xsd:complexType>
See section 5.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).
Thread Safety
Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.