Partager via


DataValidationForumla1 Class

Defines the DataValidationForumla1 Class.This class is only available in Office2010.When the object is serialized out as xml, its qualified name is x14:formula1.

Inheritance Hierarchy

System.Object
  DocumentFormat.OpenXml.OpenXmlElement
    DocumentFormat.OpenXml.OpenXmlCompositeElement
      DocumentFormat.OpenXml.Office2010.Excel.DataValidationFormulaType
        DocumentFormat.OpenXml.Office2010.Excel.DataValidationForumla1

Namespace:  DocumentFormat.OpenXml.Office2010.Excel
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

Syntax

'Declaration
<OfficeAvailabilityAttribute(FileFormatVersions.Office2010)> _
Public Class DataValidationForumla1 _
    Inherits DataValidationFormulaType
'Usage
Dim instance As DataValidationForumla1
[OfficeAvailabilityAttribute(FileFormatVersions.Office2010)]
public class DataValidationForumla1 : DataValidationFormulaType

Remarks

The following table lists the possible child types:

  • DocumentFormat.OpenXml.Office.Excel.Formula <xne:f>

2.6.4 CT_DataValidationFormula

Target namespace: https://schemas.microsoft.com/office/spreadsheetml/2010/main

Referenced by: CT_DataValidation

A complex type that specifies a formula used in data validation.

Child Elements:

xm:f : An f element that specifies a formula for the data validation. The formula MUST adhere to the grammar provided in Formulas, with the following restrictions:

The formula MUST NOT use the ref-infix-operator, local-cell-reference, bang-reference, bang-name, array-constant, sheet-range-reference, or structure-reference production rules.<13>

MUST be an external-cell-reference if used by the formula1 element of the ancestor CT_DataValidation element, and the formula1 element of the ancestor CT_DataValidation element uses the external-cell-reference production rule, and the type attribute of the ancestor CT_DataValidation element is “list”.

MUST NOT be an external-cell-reference that references more than one cell if used by the formula1 element of the ancestor CT_DataValidation element and the type attribute of the ancestor CT_DataValidation element is not “list”.

MUST NOT be an external-cell-reference that references more than one cell if used by the formula2 element of the ancestor CT_DataValidation element.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

<xsd:complexType name="CT_DataValidationFormula">

<xsd:sequence>

<xsd:element ref="xm:f" minOccurs="1" maxOccurs="1"/>

</xsd:sequence>

</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

DataValidationForumla1 Members

DocumentFormat.OpenXml.Office2010.Excel Namespace