CellType Enumeration

Summary

Defines the types of cell content within a spreadsheet categorized based on their data content.

Syntax

JavaScript
lt.Document.SheetEditor.CellType = { 
	unknown: 0, 
	blank: 1, 
	numeric: 2, 
	string: 3, 
	formula: 4, 
	bool: 5, 
	date: 6 
} 

Members

Value Name Description
0 unknown The cell type is unknown.
This is typically used when the cell's content type cannot be determined.
1 blank The cell is empty, containing no data or value.
2 numeric The cell contains a numeric value. Numeric cells can hold integers, decimals, and other numerical formats.
They are often subject to formatting that affects their display (e.g., number of decimal places, currency symbols).
3 string The cell contains text data.
String cells can include letters, numbers, symbols, and spaces.
They are versatile and can be used for labels, names, or any non-numeric data.
4 formula The cell contains a formula.
Formulas are expressions that perform calculations or operations based on other cells' values.
The cell displays the result of the formula's calculation rather than the formula itself.
5 bool The cell contains a boolean value, which can be either true or false.
Boolean cells are often used for flags, toggles, or simple binary states.
6 date The cell contains a date.
Date cells can represent dates, and potentially times, in various formats.
They are subject to formatting that affects their display.

Remarks

This enumeration is essential for identifying the kind of data contained within a cell, which in turn influences how the cell is formatted, displayed, and interacted with.

Requirements

Target Platforms

See Also

Leadtools.Document.SheetEditor Namespace

Help Version 23.0.2024.5.29
Products | Support | Contact Us | Intellectual Property Notices
© 1991-2024 LEAD Technologies, Inc. All Rights Reserved.

Leadtools.Document.SheetEditor Assembly
Products | Support | Contact Us | Intellectual Property Notices
© 1991-2023 LEAD Technologies, Inc. All Rights Reserved.