次の方法で共有


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.

See Also

Reference

PivotUserEdit Members

DocumentFormat.OpenXml.Office2010.Excel Namespace