In This Topic ▼

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