Skip to main content

Search OfficeIMO

Enter a topic, API type, or PowerShell command.

Documentation Search all OfficeIMO/

API Reference

Class

ExcelRangeCompareOptions

Namespace OfficeIMO.Excel
Assembly OfficeIMO.Excel
Modifiers sealed

Options controlling worksheet/range value comparisons.

Inheritance

  • Object
  • ExcelRangeCompareOptions

Usage

Explore 2 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.

Accepted by parameters 2

Constructors

public ExcelRangeCompareOptions() #

Properties

public Boolean TreatNullAndEmptyStringAsEqual { get; set; } #

Treats null values and empty strings as equal. Enabled by default to match common reporting expectations.

public Boolean TrimStrings { get; set; } #

Trims string values before comparing.

public Boolean IgnoreCase { get; set; } #

Compares string values using ordinal case-insensitive comparison.