GrapeCity.Documents.Excel.SpecialCellType

Enum SpecialCellType

Namespace

GrapeCity.Documents.Excel

Assembly

GcDocs.Excel.dll

Specifies the type of cells.

public enum SpecialCellType

Fields

AllFormatConditions = 0

Cells of any format condition in the specified range.

AllValidation = 1

Cells having validation criteria in the specified range.

Blanks = 2

Empty cells in the specified range.

Comments = 3

Cells containing notes in the specified range.

Constants = 4

Cells containing constants. Use the SpecialCellsValue to filter values by data types.

Formulas = 5

Cells containing formulas. Use the SpecialCellsValue to filter formulas by return types.

LastCell = 6

The last visible cell in the used range of the worksheet of the specified range.

MergedCells = 10

Merged cells that intersects with the specified range.

SameFormatConditions = 7

Cells having the same format as the top-left cell of the specified range.

SameValidation = 8

Cells having the same validation criteria as the top-left cell of the specified range.

Tags = 11

Cells containing tags in the specified range.

Visible = 9

All visible cells in the specified range.