Skip to main content
SearchCtrl K
Community

Source code

OfficeIMO.NET libraries, PowerShell module, CLI, Studio and browser tools 658 stars

Talk and help

DiscordQuestions, ideas and show and tell Report an issueBugs and feature requests SponsorFund ongoing development

Mode

Background

Search OfficeIMO

Enter a topic, API type, or PowerShell command.

Search the whole siteOpen search page →
Documentation Search all OfficeIMO/
Enum

ExcelDataValidationOperator

OfficeIMO.Excel

Edit on GitHub
Namespace
OfficeIMO.Excel
Assembly
OfficeIMO.Excel
Source revision
e163ccb36643 with working tree changes
Source
ExcelOpenXmlValueTypes.Generated.cs:172
Base
Enum
Implements
IComparable ISpanFormattable IFormattable IConvertible
Modifiers
sealed

Defines OfficeIMO values corresponding to DocumentFormat.OpenXml.Spreadsheet.DataValidationOperatorValues.

Inheritance

  • Enum
  • ExcelDataValidationOperator

Guides & Samples

Authored walkthroughs and practical samples linked to this API.

  • Tables and Ranges Guide

    Excel tables with AutoFilter, data validation, and conditional formatting in OfficeIMO.Excel. Includes examples and API links.

  • Asset depreciation schedule Sample

    Build an editable Excel straight-line depreciation register with residual values, useful lives, per-asset formulas and a total annual charge.

  • Rolling cash-flow forecast Sample

    Calculate opening cash, monthly net flow and closing cash in a six-month Excel forecast, with editable inputs and visible planning formulas.

  • Inventory replenishment plan Sample

    Calculate stock gaps, non-negative order quantities and proposed spend in an editable Excel workbook. Includes formulas and a PNG preview.

  • Weighted vendor scorecard Sample

    Compare synthetic vendor offers in Excel using explicit criteria, 1-5 scores and visible weighted-score formulas. Download the editable workbook.

Usage

Explore 13 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 8

Accepted by parameters 5

Values

public const ExcelDataValidationOperator Between #
ExcelOpenXmlValueTypes.Generated.cs:174

Represents the Open XML value between.

Value: 0
public const ExcelDataValidationOperator NotBetween #
ExcelOpenXmlValueTypes.Generated.cs:176

Represents the Open XML value notBetween.

Value: 1
public const ExcelDataValidationOperator Equal #
ExcelOpenXmlValueTypes.Generated.cs:178

Represents the Open XML value equal.

Value: 2
public const ExcelDataValidationOperator NotEqual #
ExcelOpenXmlValueTypes.Generated.cs:180

Represents the Open XML value notEqual.

Value: 3
public const ExcelDataValidationOperator LessThan #
ExcelOpenXmlValueTypes.Generated.cs:182

Represents the Open XML value lessThan.

Value: 4
public const ExcelDataValidationOperator LessThanOrEqual #
ExcelOpenXmlValueTypes.Generated.cs:184

Represents the Open XML value lessThanOrEqual.

Value: 5
public const ExcelDataValidationOperator GreaterThan #
ExcelOpenXmlValueTypes.Generated.cs:186

Represents the Open XML value greaterThan.

Value: 6
public const ExcelDataValidationOperator GreaterThanOrEqual #
ExcelOpenXmlValueTypes.Generated.cs:188

Represents the Open XML value greaterThanOrEqual.

Value: 7