GrapeCity.Documents.Excel.SpecialCellsValue

SpecialCellsValue Enum

Specifies cells with a particular value type to include in the result.

Used as the second parameter of SpecialCells(SpecialCellType, SpecialCellsValue?) when the cell type is Constants or Formulas, to further filter cells by their value type (numbers, text, logical values, or errors).

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

[Flags]
public enum SpecialCellsValue

<Flags>
Public Enum SpecialCellsValue

Examples

worksheet.Range["A1"].Value = "Text";
worksheet.Range["B1"].Value = 100;
worksheet.Range["C1"].Value = true;

// Find cells containing numeric constants
IRange numberCells = worksheet.Cells.SpecialCells(SpecialCellType.Constants, SpecialCellsValue.Numbers);

// Find cells containing text constants
IRange textCells = worksheet.Cells.SpecialCells(SpecialCellType.Constants, SpecialCellsValue.TextValues);

Fields

Name	Description
Errors	Cells with errors.
Logical	Cells with logical values.
Numbers	Cells with numeric values.
TextValues	Cells with text.