## Cell class

Encapsulates the object that represents a single Workbook cell.

```javascript
class Cell;
```


### Example
```javascript
const { Workbook, Color, TextAlignmentType } = AsposeCells;

var excel = new Workbook();
var cells = excel.worksheets.get(0).cells;

//Put a string into a cell
var cell = cells.get(0, 0);
cell.putValue("Hello");
var first = cell.stringValue;
//Put an integer into a cell
cell = cells.get("B1");
cell.putValue(12);
var second = cell.intValue;
//Put a double into a cell
cell = cells.get(0, 2);
cell.putValue(-1.234);
var third = cell.doubleValue;
//Put a formula into a cell
cell = cells.get("D1");
cell.formula = "=B1 + C1";
//Put a combined formula: "sum(average(b1,c1), b1)" to cell at b2
cell = cells.get("b2");
cell.formula = "=sum(average(b1,c1), b1)";

//Set style of a cell
var style = cell.getStyle();
//Set background color
style.backgroundColor = Color.Yellow;
//Set format of a cell
style.font.setName("Courier New");
style.verticalAlignment = TextAlignmentType.Top;
cell.setStyle(style);
```
## Properties

| Property | Type | Description |
| --- | --- | --- |
| [worksheet](#worksheet--)| Worksheet | Readonly. Gets the parent worksheet. |
| [row](#row--)| number | Readonly. Gets row number (zero based) of the cell. |
| [column](#column--)| number | Readonly. Gets column number (zero based) of the cell. |
| [isFormula](#isFormula--)| boolean | Readonly. Represents if the specified cell contains formula. |
| [hasCustomFunction](#hasCustomFunction--)| boolean | Readonly. Checks whether there is custom function(unsupported function) in this cell's formula. |
| [type](#type--)| CellValueType | Readonly. Represents cell value type. |
| [name](#name--)| string | Readonly. Gets the name of the cell. |
| [isErrorValue](#isErrorValue--)| boolean | Readonly. Checks if the value of this cell is an error. |
| [isNumericValue](#isNumericValue--)| boolean | Readonly. Indicates whether the value of this cell is numeric(int, double and datetime) |
| [stringValue](#stringValue--)| string | Readonly. Gets the string value contained in the cell. If the type of this cell is string, then return the string value itself. For other cell types, the formatted string value (formatted with the specified style of this cell) will be returned. The formatted cell value is same with what you can get from excel when copying a cell as text(such as copying cell to text editor or exporting to csv). |
| [numberCategoryType](#numberCategoryType--)| NumberCategoryType | Readonly. Represents the category type of this cell's number formatting. |
| [displayStringValue](#displayStringValue--)| string | Readonly. Gets the formatted string value of this cell by cell's display style. |
| [intValue](#intValue--)| number | Readonly. Gets the integer value contained in the cell. |
| [doubleValue](#doubleValue--)| number | Readonly. Gets the double value contained in the cell. |
| [floatValue](#floatValue--)| number | Readonly. Gets the float value contained in the cell. |
| [dateTimeValue](#dateTimeValue--)| Date | Readonly. Gets the DateTime value contained in the cell. |
| [boolValue](#boolValue--)| boolean | Readonly. Gets the boolean value contained in the cell. |
| [hasCustomStyle](#hasCustomStyle--)| boolean | Readonly. Indicates whether this cell has custom style settings(different from the default one inherited from corresponding row, column, or workbook). |
| [sharedStyleIndex](#sharedStyleIndex--)| number | Readonly. Gets cell's shared style index in the style pool. |
| [formula](#formula--)| string | Gets or sets a formula of the [Cell](../cell/). |
| [formulaLocal](#formulaLocal--)| string | Get the locale formatted formula of the cell. |
| [r1C1Formula](#r1C1Formula--)| string | Gets or sets a R1C1 formula of the [Cell](../cell/). |
| [containsExternalLink](#containsExternalLink--)| boolean | Readonly. Indicates whether this cell contains an external link. Only applies when the cell is a formula cell. |
| [isArrayHeader](#isArrayHeader--)| boolean | Readonly. Indicates the cell's formula is an array formula and it is the first cell of the array. |
| [isDynamicArrayFormula](#isDynamicArrayFormula--)| boolean | Readonly. Indicates whether the cell's formula is dynamic array formula(true) or legacy array formula(false). |
| [isArrayFormula](#isArrayFormula--)| boolean | Readonly. Indicates whether the cell formula is an array formula. |
| [isSharedFormula](#isSharedFormula--)| boolean | Readonly. Indicates whether the cell formula is part of shared formula. |
| [isTableFormula](#isTableFormula--)| boolean | Readonly. Indicates whether this cell is part of table formula. |
| [value](#value--)| VObject | Gets/sets the value contained in this cell. |
| [isStyleSet](#isStyleSet--)| boolean | Readonly. Indicates if the cell's style is set. If return false, it means this cell has a default cell format. |
| [isMerged](#isMerged--)| boolean | Readonly. Checks if a cell is part of a merged range or not. |
| [comment](#comment--)| Comment | Readonly. Gets the comment of this cell. |
| [htmlString](#htmlString--)| string | Gets and sets the html string which contains data and some formats in this cell. |
| [isCheckBoxStyle](#isCheckBoxStyle--)| boolean | Indicates whether setting this cell as a check box. |
| [embeddedImage](#embeddedImage--)| Uint8Array | Gets and sets the embedded image in the cell. |
| [picture](#picture--)| Picture | Readonly. Gets a [Aspose.Cells.Drawing.Picture](../aspose.cells.drawing.picture/) instance to represent the embedded image in this cell or null if there is no embedded image for this cell. |

## Methods

| Method | Description |
| --- | --- |
| [calculate(CalculationOptions)](#calculate-calculationoptions-)| Calculates the formula of the cell. |
| [putValue(boolean)](#putValue-boolean-)| Puts a boolean value into the cell. |
| [putValue(number)](#putValue-number-)| Puts an integer value into the cell. |
| [putValue(number)](#putValue-number-)| Puts a double value into the cell. |
| [putValue(string, boolean, boolean)](#putValue-string-boolean-boolean-)| Puts a value into the cell, if appropriate the value will be converted to other data type and cell's number format will be reset. |
| [putValue(string, boolean)](#putValue-string-boolean-)| Puts a string value into the cell and converts the value to other data type if appropriate. |
| [putValue(string)](#putValue-string-)| Puts a string value into the cell. |
| [putValue(Date)](#putValue-date-)| Puts a DateTime value into the cell. |
| [putValue(VObject)](#putValue-vobject-)| Puts an object value into the cell. |
| [getStringValue(CellValueFormatStrategy)](#getStringValue-cellvalueformatstrategy-)| Gets the string value by specific formatted strategy. |
| [getWidthOfValue()](#getWidthOfValue--)| Gets the width of the value in unit of pixels. |
| [getHeightOfValue()](#getHeightOfValue--)| Gets the height of the value in unit of pixels. |
| [getDisplayStyle()](#getDisplayStyle--)| Gets the display style of this cell. |
| [getDisplayStyle(boolean)](#getDisplayStyle-boolean-)| Gets the display style of this cell. |
| [getDisplayStyle(BorderType)](#getDisplayStyle-bordertype-)| Gets the display style of this cell. |
| [getFormatConditions()](#getFormatConditions--)| Gets format conditions which applies to this cell. |
| [getStyle()](#getStyle--)| Gets the cell style. |
| [getStyle(boolean)](#getStyle-boolean-)| If checkBorders is true, check whether other cells' borders will effect the style of this cell. |
| [setStyle(Style)](#setStyle-style-)| Sets the cell style. |
| [setStyle(Style, boolean)](#setStyle-style-boolean-)| Apply the changed property of style to the cell. |
| [setStyle(Style, StyleFlag)](#setStyle-style-styleflag-)| Apply the cell style based on flags. |
| [setFormula(string, VObject)](#setFormula-string-vobject-)| Set the formula and the value(calculated result) of the formula. |
| [setFormula(string, FormulaParseOptions)](#setFormula-string-formulaparseoptions-)| Set the formula and the value(calculated result) of the formula. |
| [setFormula(string, FormulaParseOptions, VObject)](#setFormula-string-formulaparseoptions-vobject-)| Set the formula and the value(calculated result) of the formula. |
| [getFormula(boolean, boolean)](#getFormula-boolean-boolean-)| Get the formula of this cell. |
| [setArrayFormula(string, number, number)](#setArrayFormula-string-number-number-)| Sets an array formula(legacy array formula entered via CTRL+SHIFT+ENTER in MS Excel) to a range of cells. |
| [setArrayFormula(string, number, number, FormulaParseOptions)](#setArrayFormula-string-number-number-formulaparseoptions-)| Sets an array formula to a range of cells. |
| [setArrayFormula(string, number, number, FormulaParseOptions, VObject[][])](#setArrayFormula-string-number-number-formulaparseoptions-vobjectarrayarray-)| Sets an array formula to a range of cells. |
| [setSharedFormula(string, number, number)](#setSharedFormula-string-number-number-)| Sets shared formulas to a range of cells. |
| [setSharedFormula(string, number, number, FormulaParseOptions)](#setSharedFormula-string-number-number-formulaparseoptions-)| Sets shared formulas to a range of cells. |
| [setSharedFormula(string, number, number, FormulaParseOptions, VObject[][])](#setSharedFormula-string-number-number-formulaparseoptions-vobjectarrayarray-)| Sets shared formulas to a range of cells. |
| [getPrecedents()](#getPrecedents--)| Gets all references appearing in this cell's formula. |
| [getDependents(boolean)](#getDependents-boolean-)| Get all cells whose formula references to this cell directly. |
| [getPrecedentsInCalculation()](#getPrecedentsInCalculation--)| Gets all precedents(reference to cells in current workbook) used by this cell's formula while calculating it. |
| [getDependentsInCalculation(boolean)](#getDependentsInCalculation-boolean-)| Gets all cells whose calculated result depends on this cell. |
| [getArrayRange()](#getArrayRange--)| Gets the array range if the cell's formula is an array formula. |
| [setDynamicArrayFormula(string, FormulaParseOptions, boolean)](#setDynamicArrayFormula-string-formulaparseoptions-boolean-)| Sets dynamic array formula and make the formula spill into neighboring cells if possible. |
| [setDynamicArrayFormula(string, FormulaParseOptions, VObject[][], boolean, boolean)](#setDynamicArrayFormula-string-formulaparseoptions-vobjectarrayarray-boolean-boolean-)| Sets dynamic array formula and make the formula spill into neighboring cells if possible. |
| [setDynamicArrayFormula(string, FormulaParseOptions, VObject[][], boolean, boolean, CalculationOptions)](#setDynamicArrayFormula-string-formulaparseoptions-vobjectarrayarray-boolean-boolean-calculationoptions-)| Sets dynamic array formula and make the formula spill into neighboring cells if possible. |
| [setTableFormula(number, number, string, string, VObject[][])](#setTableFormula-number-number-string-string-vobjectarrayarray-)| Create two-variable data table for given range starting from this cell. |
| [setTableFormula(number, number, string, boolean, VObject[][])](#setTableFormula-number-number-string-boolean-vobjectarrayarray-)| Create one-variable data table for given range starting from this cell. |
| [setTableFormula(number, number, number, number, number, number, VObject[][])](#setTableFormula-number-number-number-number-number-number-vobjectarrayarray-)| Create two-variable data table for given range starting from this cell. |
| [setTableFormula(number, number, number, number, boolean, VObject[][])](#setTableFormula-number-number-number-number-boolean-vobjectarrayarray-)| Create one-variable data table for given range starting from this cell. |
| [removeArrayFormula(boolean)](#removeArrayFormula-boolean-)| Remove array formula. |
| [copy(Cell)](#copy-cell-)| Copies data from a source cell. |
| [characters(number, number)](#characters-number-number-)| Returns a Characters object that represents a range of characters within the cell text. |
| [replace(string, string, ReplaceOptions)](#replace-string-string-replaceoptions-)| Replace text of the cell with options. |
| [insertText(number, string)](#insertText-number-string-)| Insert some characters to the cell. If the cell is rich formatted, this method could keep the original formatting. |
| [isRichText()](#isRichText--)| Indicates whether the string value of this cell is a rich formatted text. |
| [getCharacters()](#getCharacters--)| Returns all Characters objects that represents a range of characters within the cell text. |
| [getCharacters(boolean)](#getCharacters-boolean-)| Returns all Characters objects that represents a range of characters within the cell text. |
| [setCharacters(FontSetting[])](#setCharacters-fontsettingarray-)| Sets rich text format of the cell. |
| [getMergedRange()](#getMergedRange--)| Returns a [Range](../range/) object which represents a merged range. |
| [getHtmlString(boolean)](#getHtmlString-boolean-)| Gets the html string which contains data and some formats in this cell. |
| [toJson()](#toJson--)| Convert [Cell](../cell/) to JSON struct data. |
| [getConditionalFormattingResult()](#getConditionalFormattingResult--)| Get the result of the conditional formatting. |
| [getValidation()](#getValidation--)| Gets the validation applied to this cell. |
| [getValidationValue()](#getValidationValue--)| Gets the value of validation which applied to this cell. |
| [getTable()](#getTable--)| Gets the table which contains this cell. |
| [getRichValue()](#getRichValue--)| Gets rich value of the cell. |
| [dispose()](#dispose--)|  |
| [toString()](#toString--)| Returns a string represents the current Cell object. |
| [equals(VObject)](#equals-vobject-)| Checks whether this object refers to the same cell with another. |
| [equals(Cell)](#equals-cell-)| Checks whether this object refers to the same cell with another cell object. |
| [getHashCode()](#getHashCode--)| Serves as a hash function for a particular type. |


### worksheet {#worksheet--}

Readonly. Gets the parent worksheet.

```javascript
worksheet : Worksheet;
```


### row {#row--}

Readonly. Gets row number (zero based) of the cell.

```javascript
row : number;
```


### column {#column--}

Readonly. Gets column number (zero based) of the cell.

```javascript
column : number;
```


### isFormula {#isFormula--}

Readonly. Represents if the specified cell contains formula.

```javascript
isFormula : boolean;
```


### hasCustomFunction {#hasCustomFunction--}

Readonly. Checks whether there is custom function(unsupported function) in this cell's formula.

```javascript
hasCustomFunction : boolean;
```


### type {#type--}

Readonly. Represents cell value type.

```javascript
type : CellValueType;
```


### name {#name--}

Readonly. Gets the name of the cell.

```javascript
name : string;
```


**Remarks**

A cell name includes its column letter and row number. For example, the name of a cell in row 0 and column 0 is A1.

### isErrorValue {#isErrorValue--}

Readonly. Checks if the value of this cell is an error.

```javascript
isErrorValue : boolean;
```


**Remarks**

Also applies to formula cell to check whether the calculated result is an error.

### isNumericValue {#isNumericValue--}

Readonly. Indicates whether the value of this cell is numeric(int, double and datetime)

```javascript
isNumericValue : boolean;
```


**Remarks**

Also applies to formula cell to check the calculated result

### stringValue {#stringValue--}

Readonly. Gets the string value contained in the cell. If the type of this cell is string, then return the string value itself. For other cell types, the formatted string value (formatted with the specified style of this cell) will be returned. The formatted cell value is same with what you can get from excel when copying a cell as text(such as copying cell to text editor or exporting to csv).

```javascript
stringValue : string;
```


### numberCategoryType {#numberCategoryType--}

Readonly. Represents the category type of this cell's number formatting.

```javascript
numberCategoryType : NumberCategoryType;
```


**Remarks**

When cell's formatting pattern is combined with conditional formatting patterns, then the returned type is corresponding to the part which is used for current value of this cell. For example, if the formatting pattern for this cell is "#,##0;(#,##0);"-";@", then when cell's value is numeric and not 0, the returned type is [NumberCategoryType.Number](../numbercategorytype.number/); When cell's value is 0 or not numeric value, the returned type is [NumberCategoryType.Text](../numbercategorytype.text/).

### displayStringValue {#displayStringValue--}

Readonly. Gets the formatted string value of this cell by cell's display style.

```javascript
displayStringValue : string;
```


### intValue {#intValue--}

Readonly. Gets the integer value contained in the cell.

```javascript
intValue : number;
```


### doubleValue {#doubleValue--}

Readonly. Gets the double value contained in the cell.

```javascript
doubleValue : number;
```


### floatValue {#floatValue--}

Readonly. Gets the float value contained in the cell.

```javascript
floatValue : number;
```


### dateTimeValue {#dateTimeValue--}

Readonly. Gets the DateTime value contained in the cell.

```javascript
dateTimeValue : Date;
```


### boolValue {#boolValue--}

Readonly. Gets the boolean value contained in the cell.

```javascript
boolValue : boolean;
```


### hasCustomStyle {#hasCustomStyle--}

Readonly. Indicates whether this cell has custom style settings(different from the default one inherited from corresponding row, column, or workbook).

```javascript
hasCustomStyle : boolean;
```


### sharedStyleIndex {#sharedStyleIndex--}

Readonly. Gets cell's shared style index in the style pool.

```javascript
sharedStyleIndex : number;
```


### formula {#formula--}

Gets or sets a formula of the [Cell](../cell/).

```javascript
formula : string;
```


**Remarks**

A formula string always begins with an equal sign (=). And please always use comma(,) as parameters delimiter, such as "=SUM(A1, E1, H2)".

**Example**
```javascript
const { Workbook } = AsposeCells;

var excel = new Workbook();
var cells = excel.worksheets.get(0).cells;
cells.get("B6").formula = "=SUM(B2:B5, E1) + sheet2!A1";
```

### formulaLocal {#formulaLocal--}

Get the locale formatted formula of the cell.

```javascript
formulaLocal : string;
```


### r1C1Formula {#r1C1Formula--}

Gets or sets a R1C1 formula of the [Cell](../cell/).

```javascript
r1C1Formula : string;
```


### containsExternalLink {#containsExternalLink--}

Readonly. Indicates whether this cell contains an external link. Only applies when the cell is a formula cell.

```javascript
containsExternalLink : boolean;
```


### isArrayHeader {#isArrayHeader--}

Readonly. Indicates the cell's formula is an array formula and it is the first cell of the array.

```javascript
isArrayHeader : boolean;
```


### isDynamicArrayFormula {#isDynamicArrayFormula--}

Readonly. Indicates whether the cell's formula is dynamic array formula(true) or legacy array formula(false).

```javascript
isDynamicArrayFormula : boolean;
```


### isArrayFormula {#isArrayFormula--}

Readonly. Indicates whether the cell formula is an array formula.

```javascript
isArrayFormula : boolean;
```


### isSharedFormula {#isSharedFormula--}

Readonly. Indicates whether the cell formula is part of shared formula.

```javascript
isSharedFormula : boolean;
```


### isTableFormula {#isTableFormula--}

Readonly. Indicates whether this cell is part of table formula.

```javascript
isTableFormula : boolean;
```


### value {#value--}

Gets/sets the value contained in this cell.

```javascript
value : VObject;
```


**Remarks**

Possible type: <p>null,</p> <p>Boolean,</p> <p>DateTime,</p> <p>Double,</p> <p>Integer</p> <p>String.</p> For int value, it may be returned as an Integer object or a Double object. And there is no guarantee that the returned value will be kept as the same type of object always.

### isStyleSet {#isStyleSet--}

Readonly. Indicates if the cell's style is set. If return false, it means this cell has a default cell format.

```javascript
isStyleSet : boolean;
```


### isMerged {#isMerged--}

Readonly. Checks if a cell is part of a merged range or not.

```javascript
isMerged : boolean;
```


### comment {#comment--}

Readonly. Gets the comment of this cell.

```javascript
comment : Comment;
```


**Remarks**

If there is no comment applies to the cell, returns null.

### htmlString {#htmlString--}

Gets and sets the html string which contains data and some formats in this cell.

```javascript
htmlString : string;
```


### isCheckBoxStyle {#isCheckBoxStyle--}

Indicates whether setting this cell as a check box.

```javascript
isCheckBoxStyle : boolean;
```


### embeddedImage {#embeddedImage--}

Gets and sets the embedded image in the cell.

```javascript
embeddedImage : Uint8Array;
```


### picture {#picture--}

Readonly. Gets a [Aspose.Cells.Drawing.Picture](../aspose.cells.drawing.picture/) instance to represent the embedded image in this cell or null if there is no embedded image for this cell.

```javascript
picture : Picture;
```


### calculate(CalculationOptions) {#calculate-calculationoptions-}

Calculates the formula of the cell.

```javascript
calculate(options: CalculationOptions) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| options | [CalculationOptions](../calculationoptions/) | Options for calculation |

### putValue(boolean) {#putValue-boolean-}

Puts a boolean value into the cell.

```javascript
putValue(boolValue: boolean) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| boolValue | boolean |  |

### putValue(number) {#putValue-number-}

Puts an integer value into the cell.

```javascript
putValue(intValue: number) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| intValue | number | Input value |

### putValue(number) {#putValue-number-}

Puts a double value into the cell.

```javascript
putValue(doubleValue: number) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| doubleValue | number | Input value |

### putValue(string, boolean, boolean) {#putValue-string-boolean-boolean-}

Puts a value into the cell, if appropriate the value will be converted to other data type and cell's number format will be reset.

```javascript
putValue(stringValue: string, isConverted: boolean, setStyle: boolean) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| stringValue | string | Input value |
| isConverted | boolean | True: converted to other data type if appropriate. |
| setStyle | boolean | True: set the number format to cell's style when converting to other data type |

### putValue(string, boolean) {#putValue-string-boolean-}

Puts a string value into the cell and converts the value to other data type if appropriate.

```javascript
putValue(stringValue: string, isConverted: boolean) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| stringValue | string | Input value |
| isConverted | boolean | True: converted to other data type if appropriate. |

### putValue(string) {#putValue-string-}

Puts a string value into the cell.

```javascript
putValue(stringValue: string) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| stringValue | string | Input value |

### putValue(Date) {#putValue-date-}

Puts a DateTime value into the cell.

```javascript
putValue(dateTime: Date) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| dateTime | Date | Input value |

**Remarks**

Setting a DateTime value for a cell dose not means the cell will be formatted as date time automatically. DateTime value was maintained as numeric value in the data model of both MS Excel and Aspose.Cells. Whether the numeric value will be taken as the numeric value itself or date time depends on the number format applied on this cell. If this cell has not been formatted as date time, it will be displayed as a numeric value even though what you input is DateTime.

### putValue(VObject) {#putValue-vobject-}

Puts an object value into the cell.

```javascript
putValue(objectValue: VObject) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| objectValue | VObject | input value |

### getStringValue(CellValueFormatStrategy) {#getStringValue-cellvalueformatstrategy-}

Gets the string value by specific formatted strategy.

```javascript
getStringValue(formatStrategy: CellValueFormatStrategy) : string;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| formatStrategy | [CellValueFormatStrategy](../cellvalueformatstrategy/) | The formatted strategy. |

### getWidthOfValue() {#getWidthOfValue--}

Gets the width of the value in unit of pixels.

```javascript
getWidthOfValue() : number;
```


### getHeightOfValue() {#getHeightOfValue--}

Gets the height of the value in unit of pixels.

```javascript
getHeightOfValue() : number;
```


### getDisplayStyle() {#getDisplayStyle--}

Gets the display style of this cell.

```javascript
getDisplayStyle() : Style;
```


**Returns**

display style of this cell

**Remarks**

Same with using [BorderType.SideBorders](../bordertype.sideborders/) for [GetDisplayStyle(BorderType)](../getdisplaystyle(bordertype)/). That is, this method will check and adjust top/bottom/left/right borders of this cell according to the style([GetStyle()](../getstyle()/)) of its adjacent cells, but do not check the merged cells, and do not check the display style of adjacent cells.

### getDisplayStyle(boolean) {#getDisplayStyle-boolean-}

Gets the display style of this cell.

```javascript
getDisplayStyle(includeMergedBorders: boolean) : Style;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| includeMergedBorders | boolean | Indicates whether checking borders of merged cells. |

**Returns**

display style of this cell

**Remarks**

If the specified flag is false, then it is same with [GetDisplayStyle()](../getdisplaystyle()/). Otherwise it is same with using [BorderType.SideBorders](../bordertype.sideborders/)|[BorderType.DynamicStyleBorders](../bordertype.dynamicstyleborders/) for [GetDisplayStyle(BorderType)](../getdisplaystyle(bordertype)/).

### getDisplayStyle(BorderType) {#getDisplayStyle-bordertype-}

Gets the display style of this cell.

```javascript
getDisplayStyle(adjacentBorders: BorderType) : Style;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| adjacentBorders | [BorderType](../bordertype/) | Indicates which borders need to be checked and adjusted         /// according to the borders of adjacent cells. |

**Returns**

display style of this cell

**Remarks**

If this cell is also affected by other settings such as conditional formatting, list objects, etc., then the display style may be different from [GetStyle()](../getstyle()/). <br></br>For flags of adjusting borders according to adjacent cells, [BorderType.TopBorder](../bordertype.topborder/)/[BorderType.BottomBorder](../bordertype.bottomborder/) [BorderType.LeftBorder](../bordertype.leftborder/)/[BorderType.RightBorder](../bordertype.rightborder/) denote whether check and combine the bottom/top/right/left borders of the left/right/top/bottom cells adjacent to this one. <br></br>For performance and compatibility consideration, some enums are used to denote some special operations: <br></br>[BorderType.Horizontal](../bordertype.horizontal/)/[BorderType.Vertical](../bordertype.vertical/) denote whether check and combine the bottom/right border of merged cells to this one. <br></br>[BorderType.Diagonal](../bordertype.diagonal/)(that is, both [StyleModifyFlag.DiagonalUpBorder](../stylemodifyflag.diagonalupborder/) and [StyleModifyFlag.DiagonalDownBorder](../stylemodifyflag.diagonaldownborder/) have been set) denotes check and combine borders from the display style of adjacent cells. <br></br>Please note, checking borders/styles of adjacent cells, especially the display styles, is time-consumed process. If there is no need to get the borders for the returned style, using [BorderType.None](../bordertype.none/) to disable the process of adjacent cells will give better performance. When getting borders of adjacent cells from styles defined on those cells only(without setting [BorderType.Diagonal](../bordertype.diagonal/)), the performance also may be better because checking the display style of one cell is time-consumed too.

### getFormatConditions() {#getFormatConditions--}

Gets format conditions which applies to this cell.

```javascript
getFormatConditions() : FormatConditionCollection[];
```


**Returns**

Returns [FormatConditionCollection](../formatconditioncollection/) object

### getStyle() {#getStyle--}

Gets the cell style.

```javascript
getStyle() : Style;
```


**Returns**

Style object.

**Remarks**

To change the style of the cell, please call Cell.SetStyle() method after modifying the returned style object. This method is same with [GetStyle(bool)](../getstyle(bool)/) with true value for the parameter.

### getStyle(boolean) {#getStyle-boolean-}

If checkBorders is true, check whether other cells' borders will effect the style of this cell.

```javascript
getStyle(checkBorders: boolean) : Style;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| checkBorders | boolean | Check other cells' borders |

**Returns**

Style object.

### setStyle(Style) {#setStyle-style-}

Sets the cell style.

```javascript
setStyle(style: Style) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| style | [Style](../style/) | The cell style. |

**Remarks**

If the border settings are changed, the border of adjust cells will be updated too.

### setStyle(Style, boolean) {#setStyle-style-boolean-}

Apply the changed property of style to the cell.

```javascript
setStyle(style: Style, explicitFlag: boolean) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| style | [Style](../style/) | The cell style. |
| explicitFlag | boolean | True, only overwriting formatting which is explicitly set. |

### setStyle(Style, StyleFlag) {#setStyle-style-styleflag-}

Apply the cell style based on flags.

```javascript
setStyle(style: Style, flag: StyleFlag) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| style | [Style](../style/) | The cell style. |
| flag | [StyleFlag](../styleflag/) | The style flag. |

### setFormula(string, VObject) {#setFormula-string-vobject-}

Set the formula and the value(calculated result) of the formula.

```javascript
setFormula(formula: string, value: VObject) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| formula | string | The formula. |
| value | VObject | The value(calculated result) of the formula. |

### setFormula(string, FormulaParseOptions) {#setFormula-string-formulaparseoptions-}

Set the formula and the value(calculated result) of the formula.

```javascript
setFormula(formula: string, options: FormulaParseOptions) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| formula | string | The formula. |
| options | [FormulaParseOptions](../formulaparseoptions/) | Options for parsing the formula. |

### setFormula(string, FormulaParseOptions, VObject) {#setFormula-string-formulaparseoptions-vobject-}

Set the formula and the value(calculated result) of the formula.

```javascript
setFormula(formula: string, options: FormulaParseOptions, value: VObject) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| formula | string | The formula. |
| options | [FormulaParseOptions](../formulaparseoptions/) | Options for parsing the formula. |
| value | VObject | The value(calculated result) of the formula. |

### getFormula(boolean, boolean) {#getFormula-boolean-boolean-}

Get the formula of this cell.

```javascript
getFormula(isR1C1: boolean, isLocal: boolean) : string;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| isR1C1 | boolean | Whether the formula needs to be formatted as R1C1. |
| isLocal | boolean | Whether the formula needs to be formatted by locale. |

**Returns**

the formula of this cell.

### setArrayFormula(string, number, number) {#setArrayFormula-string-number-number-}

Sets an array formula(legacy array formula entered via CTRL+SHIFT+ENTER in MS Excel) to a range of cells.

```javascript
setArrayFormula(arrayFormula: string, rowNumber: number, columnNumber: number) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| arrayFormula | string | Array formula. |
| rowNumber | number | Number of rows to populate result of the array formula. |
| columnNumber | number | Number of columns to populate result of the array formula. |

### setArrayFormula(string, number, number, FormulaParseOptions) {#setArrayFormula-string-number-number-formulaparseoptions-}

Sets an array formula to a range of cells.

```javascript
setArrayFormula(arrayFormula: string, rowNumber: number, columnNumber: number, options: FormulaParseOptions) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| arrayFormula | string | Array formula. |
| rowNumber | number | Number of rows to populate result of the array formula. |
| columnNumber | number | Number of columns to populate result of the array formula. |
| options | [FormulaParseOptions](../formulaparseoptions/) | Options for parsing the formula. |

### setArrayFormula(string, number, number, FormulaParseOptions, VObject[][]) {#setArrayFormula-string-number-number-formulaparseoptions-vobjectarrayarray-}

Sets an array formula to a range of cells.

```javascript
setArrayFormula(arrayFormula: string, rowNumber: number, columnNumber: number, options: FormulaParseOptions, values: VObject[][]) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| arrayFormula | string | Array formula. |
| rowNumber | number | Number of rows to populate result of the array formula. |
| columnNumber | number | Number of columns to populate result of the array formula. |
| options | [FormulaParseOptions](../formulaparseoptions/) | Options for parsing the formula. |
| values | VObject[][] | values for those cells with given array formula |

### setSharedFormula(string, number, number) {#setSharedFormula-string-number-number-}

Sets shared formulas to a range of cells.

```javascript
setSharedFormula(sharedFormula: string, rowNumber: number, columnNumber: number) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| sharedFormula | string | Shared formula. |
| rowNumber | number | Number of rows to populate the formula. |
| columnNumber | number | Number of columns to populate the formula. |

### setSharedFormula(string, number, number, FormulaParseOptions) {#setSharedFormula-string-number-number-formulaparseoptions-}

Sets shared formulas to a range of cells.

```javascript
setSharedFormula(sharedFormula: string, rowNumber: number, columnNumber: number, options: FormulaParseOptions) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| sharedFormula | string | Shared formula. |
| rowNumber | number | Number of rows to populate the formula. |
| columnNumber | number | Number of columns to populate the formula. |
| options | [FormulaParseOptions](../formulaparseoptions/) | Options for parsing the formula. |

### setSharedFormula(string, number, number, FormulaParseOptions, VObject[][]) {#setSharedFormula-string-number-number-formulaparseoptions-vobjectarrayarray-}

Sets shared formulas to a range of cells.

```javascript
setSharedFormula(sharedFormula: string, rowNumber: number, columnNumber: number, options: FormulaParseOptions, values: VObject[][]) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| sharedFormula | string | Shared formula. |
| rowNumber | number | Number of rows to populate the formula. |
| columnNumber | number | Number of columns to populate the formula. |
| options | [FormulaParseOptions](../formulaparseoptions/) | Options for parsing the formula. |
| values | VObject[][] | values for those cells with given shared formula |

### getPrecedents() {#getPrecedents--}

Gets all references appearing in this cell's formula.

```javascript
getPrecedents() : ReferredAreaCollection;
```


**Returns**

Collection of all references appearing in this cell's formula.

**Remarks**

ul> <li>Returns null if this is not a formula cell.</li> <li>All references appearing in this cell's formula will be returned no matter they are referenced or not while calculating. For example, although cell A2 in formula "=IF(TRUE,A1,A2)" is not used while calculating, it is still taken as the formula's precedents.</li> <li>To get those references which influence the calculation only, please use [GetPrecedentsInCalculation()](../getprecedentsincalculation()/).</li> </ul

**Example**
```javascript
const { Workbook, CellsHelper, SaveFormat } = AsposeCells;

var workbook = new Workbook();
var cells = workbook.worksheets.get(0).cells;
cells.get("A1").formula = "= B1 + SUM(B1:B10)";
var areas = cells.get("A1").getPrecedents();
for (var i = 0; i < areas.count; i++) {
    var area = areas.get(i);
    var stringBuilder = "";
    if (area.isExternalLink) {
        stringBuilder += "[";
        stringBuilder += area.externalFileName;
        stringBuilder += "]";
    }
    stringBuilder += area.sheetName;
    stringBuilder += "!";
    stringBuilder += CellsHelper.cellIndexToName(area.startRow, area.startColumn);
    if (area.isArea) {
        stringBuilder += ":";
        stringBuilder += CellsHelper.cellIndexToName(area.endRow, area.endColumn);
    }
}
var uint8Array = workbook.save(SaveFormat.Xlsx);
```

### getDependents(boolean) {#getDependents-boolean-}

Get all cells whose formula references to this cell directly.

```javascript
getDependents(isAll: boolean) : Cell[];
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| isAll | boolean | Indicates whether check formulas in other worksheets |

**Returns**

[Cell](../cell/)[]

**Remarks**

ul> <li>If one reference containing this cell appears in one cell's formula, that cell will be taken as the dependent of this cell, no matter the reference or this cell is used or not while calculating. For example, although cell A2 in formula "=IF(TRUE,A1,A2)" is not used while calculating, this formula is still be taken as A2's dependent. </li> <li>To get those formulas whose calculated results depend on this cell, please use [GetDependentsInCalculation(bool)](../getdependentsincalculation(bool)/).</li> <li>When tracing dependents for one cell, all formulas in the workbook or worksheet will be analized and checked. So it is a time consumed process. If user need to trace dependents for lots of cells, using this method will cause poor performance. For performance consideration, user should use [GetDependentsInCalculation(bool)](../getdependentsincalculation(bool)/) instead. Or, user may gather precedents map of all cells by [GetPrecedents()](../getprecedents()/) firstly, and then build the dependents map according to the precedents map.</li> </ul

### getPrecedentsInCalculation() {#getPrecedentsInCalculation--}

Gets all precedents(reference to cells in current workbook) used by this cell's formula while calculating it.

```javascript
getPrecedentsInCalculation() : ReferredAreaEnumerator;
```


**Returns**

Enumerator to enumerate all references(ReferredArea)

**Remarks**

This method can only work with the situation that [FormulaSettings.EnableCalculationChain](../formulasettings.enablecalculationchain/) is true for the workbook and the workbook has been fully calculated. If this cell is not a formula or it does not reference to any other cells, null will be returned.

### getDependentsInCalculation(boolean) {#getDependentsInCalculation-boolean-}

Gets all cells whose calculated result depends on this cell.

```javascript
getDependentsInCalculation(recursive: boolean) : CellEnumerator;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| recursive | boolean | Whether returns those dependents which do not reference to this cell directly         /// but reference to other leafs of this cell |

**Returns**

Enumerator to enumerate all dependents(Cell objects)

**Remarks**

To use this method, please make sure the workbook has been set with true value for [FormulaSettings.EnableCalculationChain](../formulasettings.enablecalculationchain/) and has been fully calculated with this setting. If there is no formula reference to this cell, null will be returned.

### getArrayRange() {#getArrayRange--}

Gets the array range if the cell's formula is an array formula.

```javascript
getArrayRange() : CellArea;
```


**Returns**

The array range.

**Remarks**

Only applies when the cell's formula is an array formula

### setDynamicArrayFormula(string, FormulaParseOptions, boolean) {#setDynamicArrayFormula-string-formulaparseoptions-boolean-}

Sets dynamic array formula and make the formula spill into neighboring cells if possible.

```javascript
setDynamicArrayFormula(arrayFormula: string, options: FormulaParseOptions, calculateValue: boolean) : CellArea;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| arrayFormula | string | the formula expression |
| options | [FormulaParseOptions](../formulaparseoptions/) | options to parse formula.         /// "Parse" option will be ignored and the formula will always be parsed immediately |
| calculateValue | boolean | whether calculate this dynamic array formula for those cells in the spilled range. |

**Returns**

the range that the formula should spill into.

**Remarks**

the returned range may be not same with the actual one that this dynamic array formula spills into. If there are non-empty cells in the range, the formula will be set for current cell only and marked as "#SPILL!". But for such kind of situation we still return the whole range that this formula should spill into.

### setDynamicArrayFormula(string, FormulaParseOptions, VObject[][], boolean, boolean) {#setDynamicArrayFormula-string-formulaparseoptions-vobjectarrayarray-boolean-boolean-}

Sets dynamic array formula and make the formula spill into neighboring cells if possible.

```javascript
setDynamicArrayFormula(arrayFormula: string, options: FormulaParseOptions, values: VObject[][], calculateRange: boolean, calculateValue: boolean) : CellArea;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| arrayFormula | string | the formula expression |
| options | [FormulaParseOptions](../formulaparseoptions/) | options to parse formula.         /// "Parse" option will be ignored and the formula will always be parsed immediately |
| values | VObject[][] | values(calculated results) for those cells with given dynamic array formula |
| calculateRange | boolean | Whether calculate the spilled range for this dynamic array formula.         /// If the "values" parameter is not null and this flag is false,         /// then the spilled range's height will be values.Length and width will be values[0].Length. |
| calculateValue | boolean | whether calculate this dynamic array formula for those cells in the spilled range when "values" is null         /// or corresponding item in "values" for one cell is null. |

**Returns**

the range that the formula should spill into.

**Remarks**

the returned range may be not same with the actual one that this dynamic array formula spills into. If there are non-empty cells in the range, the formula will be set for current cell only and marked as "#SPILL!". But for such kind of situation we still return the whole range that this formula should spill into.

### setDynamicArrayFormula(string, FormulaParseOptions, VObject[][], boolean, boolean, CalculationOptions) {#setDynamicArrayFormula-string-formulaparseoptions-vobjectarrayarray-boolean-boolean-calculationoptions-}

Sets dynamic array formula and make the formula spill into neighboring cells if possible.

```javascript
setDynamicArrayFormula(arrayFormula: string, options: FormulaParseOptions, values: VObject[][], calculateRange: boolean, calculateValue: boolean, copts: CalculationOptions) : CellArea;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| arrayFormula | string | the formula expression |
| options | [FormulaParseOptions](../formulaparseoptions/) | options to parse formula.         /// "Parse" option will be ignored and the formula will always be parsed immediately |
| values | VObject[][] | values(calculated results) for those cells with given dynamic array formula |
| calculateRange | boolean | Whether calculate the spilled range for this dynamic array formula.         /// If the "values" parameter is not null and this flag is false,         /// then the spilled range's height will be values.Length and width will be values[0].Length. |
| calculateValue | boolean | whether calculate this dynamic array formula for those cells in the spilled range when "values" is null         /// or corresponding item in "values" for one cell is null. |
| copts | [CalculationOptions](../calculationoptions/) | The options for calculating formula.         /// Commonly, for performance consideration, the [CalculationOptions.Recursive](../calculationoptions.recursive/) property should be false. |

**Returns**

the range that the formula should spill into.

**Remarks**

the returned range may be not same with the actual one that this dynamic array formula spills into. If there are non-empty cells in the range, the formula will be set for current cell only and marked as "#SPILL!". But for such kind of situation we still return the whole range that this formula should spill into.

### setTableFormula(number, number, string, string, VObject[][]) {#setTableFormula-number-number-string-string-vobjectarrayarray-}

Create two-variable data table for given range starting from this cell.

```javascript
setTableFormula(rowNumber: number, columnNumber: number, rowInputCell: string, columnInputCell: string, values: VObject[][]) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| rowNumber | number | Number of rows to populate the formula. |
| columnNumber | number | Number of columns to populate the formula. |
| rowInputCell | string | the row input cell |
| columnInputCell | string | the column input cell |
| values | VObject[][] | values for cells in table formula range |

### setTableFormula(number, number, string, boolean, VObject[][]) {#setTableFormula-number-number-string-boolean-vobjectarrayarray-}

Create one-variable data table for given range starting from this cell.

```javascript
setTableFormula(rowNumber: number, columnNumber: number, inputCell: string, isRowInput: boolean, values: VObject[][]) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| rowNumber | number | Number of rows to populate the formula. |
| columnNumber | number | Number of columns to populate the formula. |
| inputCell | string | the input cell |
| isRowInput | boolean | Indicates whether the input cell is a row input cell(true) or a column input cell(false). |
| values | VObject[][] | values for cells in table formula range |

### setTableFormula(number, number, number, number, number, number, VObject[][]) {#setTableFormula-number-number-number-number-number-number-vobjectarrayarray-}

Create two-variable data table for given range starting from this cell.

```javascript
setTableFormula(rowNumber: number, columnNumber: number, rowIndexOfRowInputCell: number, columnIndexOfRowInputCell: number, rowIndexOfColumnInputCell: number, columnIndexOfColumnInputCell: number, values: VObject[][]) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| rowNumber | number | Number of rows to populate the formula. |
| columnNumber | number | Number of columns to populate the formula. |
| rowIndexOfRowInputCell | number | row index of the row input cell |
| columnIndexOfRowInputCell | number | column index of the row input cell |
| rowIndexOfColumnInputCell | number | row index of the column input cell |
| columnIndexOfColumnInputCell | number | column index of the column input cell |
| values | VObject[][] | values for cells in table formula range |

### setTableFormula(number, number, number, number, boolean, VObject[][]) {#setTableFormula-number-number-number-number-boolean-vobjectarrayarray-}

Create one-variable data table for given range starting from this cell.

```javascript
setTableFormula(rowNumber: number, columnNumber: number, rowIndexOfInputCell: number, columnIndexOfInputCell: number, isRowInput: boolean, values: VObject[][]) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| rowNumber | number | Number of rows to populate the formula. |
| columnNumber | number | Number of columns to populate the formula. |
| rowIndexOfInputCell | number | row index of the input cell |
| columnIndexOfInputCell | number | column index of the input cell |
| isRowInput | boolean | Indicates whether the input cell is a row input cell(true) or a column input cell(false). |
| values | VObject[][] | values for cells in table formula range |

### removeArrayFormula(boolean) {#removeArrayFormula-boolean-}

Remove array formula.

```javascript
removeArrayFormula(leaveNormalFormula: boolean) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| leaveNormalFormula | boolean | True represents converting the array formula to normal formula. |

### copy(Cell) {#copy-cell-}

Copies data from a source cell.

```javascript
copy(cell: Cell) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| cell | [Cell](../cell/) | Source [Cell](../cell/) object. |

### characters(number, number) {#characters-number-number-}

Returns a Characters object that represents a range of characters within the cell text.

```javascript
characters(startIndex: number, length: number) : FontSetting;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| startIndex | number | The index of the start of the character. |
| length | number | The number of characters. |

**Returns**

Characters object.

**Remarks**

This method only works on cell with string value.

**Example**
```javascript
const { Workbook, Color } = AsposeCells;

var excel = new Workbook();
excel.worksheets.get(0).cells.get("A1").putValue("Helloworld");
excel.worksheets.get(0).cells.get("A1").characters(5, 5).font.isBold = true;
excel.worksheets.get(0).cells.get("A1").characters(5, 5).font.color = Color.Blue;
```

### replace(string, string, ReplaceOptions) {#replace-string-string-replaceoptions-}

Replace text of the cell with options.

```javascript
replace(placeHolder: string, newValue: string, options: ReplaceOptions) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| placeHolder | string | Cell placeholder |
| newValue | string | String value to replace |
| options | [ReplaceOptions](../replaceoptions/) | The replace options |

### insertText(number, string) {#insertText-number-string-}

Insert some characters to the cell. If the cell is rich formatted, this method could keep the original formatting.

```javascript
insertText(index: number, text: string) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| index | number | The index. |
| text | string | Inserted text. |

### isRichText() {#isRichText--}

Indicates whether the string value of this cell is a rich formatted text.

```javascript
isRichText() : boolean;
```


### getCharacters() {#getCharacters--}

Returns all Characters objects that represents a range of characters within the cell text.

```javascript
getCharacters() : FontSetting[];
```


**Returns**

All Characters objects

### getCharacters(boolean) {#getCharacters-boolean-}

Returns all Characters objects that represents a range of characters within the cell text.

```javascript
getCharacters(flag: boolean) : FontSetting[];
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| flag | boolean | Indicates whether applying table style to the cell if the cell is in the table. |

**Returns**

All Characters objects

### setCharacters(FontSetting[]) {#setCharacters-fontsettingarray-}

Sets rich text format of the cell.

```javascript
setCharacters(characters: FontSetting[]) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| characters | [FontSetting](../fontsetting/)[] | All Characters objects. |

### getMergedRange() {#getMergedRange--}

Returns a [Range](../range/) object which represents a merged range.

```javascript
getMergedRange() : Range;
```


**Returns**

[Range](../range/) object. Null if this cell is not merged.

### getHtmlString(boolean) {#getHtmlString-boolean-}

Gets the html string which contains data and some formats in this cell.

```javascript
getHtmlString(html5: boolean) : string;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| html5 | boolean | Indicates whether the value is compatible for html5 |

### toJson() {#toJson--}

Convert [Cell](../cell/) to JSON struct data.

```javascript
toJson() : string;
```


### getConditionalFormattingResult() {#getConditionalFormattingResult--}

Get the result of the conditional formatting.

```javascript
getConditionalFormattingResult() : ConditionalFormattingResult;
```


**Returns**

[ConditionalFormattingResult](../conditionalformattingresult/)

**Remarks**

Returns null if no conditional formatting is applied to this cell,

### getValidation() {#getValidation--}

Gets the validation applied to this cell.

```javascript
getValidation() : Validation;
```


**Returns**

[Validation](../validation/)

### getValidationValue() {#getValidationValue--}

Gets the value of validation which applied to this cell.

```javascript
getValidationValue() : boolean;
```


### getTable() {#getTable--}

Gets the table which contains this cell.

```javascript
getTable() : ListObject;
```


**Returns**

[ListObject](../listobject/)

### getRichValue() {#getRichValue--}

Gets rich value of the cell.

```javascript
getRichValue() : CellRichValue;
```


**Returns**

[CellRichValue](../cellrichvalue/)

### dispose() {#dispose--}



```javascript
dispose() : void;
```


### toString() {#toString--}

Returns a string represents the current Cell object.

```javascript
toString() : string;
```


### equals(VObject) {#equals-vobject-}

Checks whether this object refers to the same cell with another.

```javascript
equals(obj: VObject) : boolean;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| obj | VObject | another object |

**Returns**

true if two objects refers to the same cell.

### equals(Cell) {#equals-cell-}

Checks whether this object refers to the same cell with another cell object.

```javascript
equals(cell: Cell) : boolean;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| cell | [Cell](../cell/) | another cell object |

**Returns**

true if two cell objects refers to the same cell.

### getHashCode() {#getHashCode--}

Serves as a hash function for a particular type.

```javascript
getHashCode() : number;
```


**Returns**

A hash code for current Cell object.