aspose.cells

Classes

Constants

Class Cell

Encapsulates the object that represents a single Workbook cell.

Example:

var excel = new aspose.cells.Workbook();
var cells = excel.getWorksheets().get(0).getCells();

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

//Set style of a cell
var style = cell.getStyle();
//Set background color
style.setBackgroundColor(aspose.cells.Color.getYellow());
//Set format of a cell
style.getFont().setName("Courier New");
style.setVerticalAlignment(aspose.cells.TextAlignmentType.TOP);
cell.setStyle(style);

Property Getters/Setters Summary
`function`	`getBoolValue()`
	Gets the boolean value contained in the cell.
`function`	`getColumn()`
	Gets column number (zero based) of the cell.
`function`	`getComment()`
	Gets the comment of this cell.
`function`	`containsExternalLink()`
	Indicates whether this cell contains an external link. Only applies when the cell is a formula cell.
`function`	`getDateTimeValue()`
	Gets the DateTime value contained in the cell.
`function`	`getDisplayStringValue()`
	Gets the formatted string value of this cell.
`function`	`getDoubleValue()`
	Gets the double value contained in the cell.
`function`	`getFloatValue()`
	Gets the float value contained in the cell.
`function`	`getFormula()`
`function`	`setFormula(value)`
	Gets or sets a formula of the Cell.
`function`	`getFormulaLocal()`
`function`	`setFormulaLocal(value)`
	Get the locale formatted formula of the cell.
`function`	`getHtmlString()`
`function`	`setHtmlString(value)`
	Gets and sets the html string which contains data and some formats in this cell.
`function`	`getIntValue()`
	Gets the integer value contained in the cell.
`function`	`isArrayFormula()`
	Indicates whether the cell formula is an array formula.
`function`	`isArrayHeader()`
	Indicates the cell's formula is and array formula and it is the first cell of the array.
`function`	`isErrorValue()`
	Checks if a formula can properly evaluate a result.
`function`	`isFormula()`
	Represents if the specified cell contains formula.
`function`	`isInArray()`
	Indicates whether the cell formula is an array formula.
`function`	`isInTable()`
	Indicates whether this cell is part of table formula.
`function`	`isMerged()`
	Checks if a cell is part of a merged range or not.
`function`	`isSharedFormula()`
	Indicates whether the cell formula is part of shared formula.
`function`	`isStyleSet()`
	Indicates if the cell's style is set. If return false, it means this cell has a default cell format.
`function`	`isTableFormula()`
	Indicates whether this cell is part of table formula.
`function`	`getName()`
	Gets the name of the cell.
`function`	`getNumberCategoryType()`
	Represents the category type of this cell's number formatting. The value of the property is NumberCategoryType integer constant.
`function`	`getR1C1Formula()`
`function`	`setR1C1Formula(value)`
	Gets or sets a R1C1 formula of the Cell.
`function`	`getRow()`
	Gets row number (zero based) of the cell.
`function`	`getSharedStyleIndex()`
	Gets cell's shared style index in the style pool.
`function`	`getStringValue()`
	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).
`function`	`getStringValueWithoutFormat()`
	Gets cell's value as string without any format.
`function`	`getType()`
	Represents cell value type. The value of the property is CellValueType integer constant.
`function`	`getValue()`
`function`	`setValue(value)`
	Gets the value contained in this cell.
`function`	`getWorksheet()`
	Gets the parent worksheet.

Method Summary
`function`	`calculate(options)`
`function`	Calculates the formula of the cell.
`function`	`characters(startIndex, length)`
`function`	Returns a Characters object that represents a range of characters within the cell text.
`function`	`copy(cell)`
`function`	Copies data from a source cell.
`function`	`equals(cell)`
`function`	Checks whether this object refers to the same cell with another cell object.
`function`	`equals(obj)`
`function`	Checks whether this object refers to the same cell with another.
`function`	`getArrayRange()`
`function`	Gets the array range if the cell's formula is an array formula.
`function`	`getCharacters()`
`function`	Returns all Characters objects that represents a range of characters within the cell text.
`function`	`getCharacters(flag)`
`function`	Returns all Characters objects that represents a range of characters within the cell text.
`function`	`getConditionalFormattingResult()`
`function`	Get the result of the conditional formatting.
`function`	`getDependents(isAll)`
`function`	Get all cells which refer to the specific cell.
`function`	`getDisplayStyle()`
`function`	Gets the display style of the cell. If the cell is conditional formatted, the display style is not same as the cell.GetStyle().
`function`	`getDisplayStyle(includeMergedBorders)`
`function`	Gets the display style of the cell. If the cell is conditional formatted, the display style is not same as the cell.GetStyle().
`function`	`getFormatConditions()`
`function`	Gets format conditions which applies to this cell.
`function`	`getFormula(isR1C1, isLocal)`
`function`	Get the formula of this cell.
`function`	`getHeightOfValue()`
`function`	Gets the height of the value in unit of pixels.
`function`	`getHtmlString(html5)`
`function`	Gets the html string which contains data and some formats in this cell.
`function`	`getLeafs()`
`function`	Get all cells which will be updated when this cell is modified. This method can only work after calling Workbook.CalculateFormula with WorkbookSettings.CreateCalcChain of value true.
`function`	`getMergedRange()`
`function`	Returns a Range object which represents a merged range.
`function`	`getPrecedents()`
`function`	Gets all cells or ranges which this cell's formula depends on.
`function`	`getStringValue(formatStrategy)`
`function`	Gets the string value by specific formatted strategy.
`function`	`getStyle()`
`function`	Gets the cell style.
`function`	`getStyle(checkBorders)`
`function`	If checkBorders is true, check whether other cells' borders will effect the style of this cell.
`function`	`getTable()`
`function`	Gets the table which contains this cell.
`function`	`getValidation()`
`function`	Gets the validation applied to this cell.
`function`	`getValidationValue()`
`function`	Gets the value of validation which applied to this cell.
`function`	`getWidthOfValue()`
`function`	Gets the width of the value in unit of pixels.
`function`	`hashCode()`
`function`	Serves as a hash function for a particular type.
`function`	`isRichText()`
`function`	Indicates whether the cell string value is a rich text.
`function`	`putValue(boolValue)`
`function`	Puts an boolean value into the cell.
`function`	`putValue(dateTime)`
`function`	Puts a DateTime value into the cell.
`function`	`putValue(doubleValue)`
`function`	Puts a double value into the cell.
`function`	`putValue(intValue)`
`function`	Puts an integer value into the cell.
`function`	`putValue(objectValue)`
`function`	Puts an object value into the cell.
`function`	`putValue(stringValue)`
`function`	Puts a string value into the cell.
`function`	`putValue(stringValue, isConverted)`
`function`	Puts a string value into the cell and converts the value to other data type if appropriate.
`function`	`putValue(stringValue, isConverted, setStyle)`
`function`	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.
`function`	`removeArrayFormula(leaveNormalFormula)`
`function`	Remove array formula.
`function`	`setAddInFormula(addInFileName, addInFunction)`
`function`	Sets an Add-In formula to the cell.
`function`	`setArrayFormula(arrayFormula, rowNumber, columnNumber)`
`function`	Sets an array formula(legacy array formula entered via CTRL+SHIFT+ENTER in ms excel) to a range of cells.
`function`	`setArrayFormula(arrayFormula, rowNumber, columnNumber, isR1C1, isLocal)`
`function`	Sets an array formula to a range of cells.
`function`	`setArrayFormula(arrayFormula, rowNumber, columnNumber, options)`
`function`	Sets an array formula to a range of cells.
`function`	`setCharacters(characters)`
`function`	Sets rich text format of the cell.
`function`	`setDynamicArrayFormula(arrayFormula, options, calculate)`
`function`	Sets dynamic array formula and make the formula spill into neighboring cells if possible.
`function`	`setFormula(formula, isR1C1, isLocal, value)`
`function`	Set the formula and the value of the formula.
`function`	`setFormula(formula, options, value)`
`function`	Set the formula and the value of the formula.
`function`	`setFormula(formula, value)`
`function`	Set the formula and the value of the formula.
`function`	`setSharedFormula(sharedFormula, rowNumber, columnNumber)`
`function`	Sets a formula to a range of cells.
`function`	`setSharedFormula(sharedFormula, rowNumber, columnNumber, isR1C1, isLocal)`
`function`	Sets a formula to a range of cells.
`function`	`setSharedFormula(sharedFormula, rowNumber, columnNumber, options)`
`function`	Sets a formula to a range of cells.
`function`	`setStyle(style)`
`function`	Sets the cell style.
`function`	`setStyle(style, explicitFlag)`
`function`	Apply the cell style.
`function`	`setStyle(style, flag)`
`function`	Apply the cell style.
`function`	`toString()`
`function`	Returns a string represents the current Cell object.

- Property Getters/Setters Detail
  - getWorksheet : Worksheet
```
function getWorksheet()
```
    Gets the parent worksheet.
  - getDateTimeValue : DateTime
```
function getDateTimeValue()
```
    Gets the DateTime value contained in the cell.
  - getRow : Number
```
function getRow()
```
    Gets row number (zero based) of the cell.
    Cell row number
  - getColumn : Number
```
function getColumn()
```
    Gets column number (zero based) of the cell.
  - isFormula : boolean
```
function isFormula()
```
    Represents if the specified cell contains formula.
  - getType : Number
```
function getType()
```
    Represents cell value type. The value of the property is CellValueType integer constant.
  - getName : String
```
function getName()
```
    Gets the name of the cell.
    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 : boolean
```
function isErrorValue()
```
    Checks if a formula can properly evaluate a result.
    Only applies to formula cell.
  - getStringValue : String
```
function getStringValue()
```
    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).
  - getStringValueWithoutFormat : String
```
function getStringValueWithoutFormat()
```
    Gets cell's value as string without any format.
    NOTE: This class is now obsolete. Instead, User should get the value object and format it according to the value type and the specific requirement. This property will be removed 12 months later since December 2020. Aspose apologizes for any inconvenience you may have experienced.
  - getNumberCategoryType : Number
```
function getNumberCategoryType()
```
    Represents the category type of this cell's number formatting. The value of the property is NumberCategoryType integer constant.
  - getDisplayStringValue : String
```
function getDisplayStringValue()
```
    Gets the formatted string value of this cell.
  - getIntValue : Number
```
function getIntValue()
```
    Gets the integer value contained in the cell.
  - getDoubleValue : Number
```
function getDoubleValue()
```
    Gets the double value contained in the cell.
  - getFloatValue : Number
```
function getFloatValue()
```
    Gets the float value contained in the cell.
  - getBoolValue : boolean
```
function getBoolValue()
```
    Gets the boolean value contained in the cell.
  - getSharedStyleIndex : Number
```
function getSharedStyleIndex()
```
    Gets cell's shared style index in the style pool.
  - getFormula/setFormula : String
```
function getFormula() / function setFormula(value)
```
    Gets or sets a formula of the Cell.
    A formula string always begins with an equal sign (=). And please always use comma(,) as parameters delimiter, such as "=SUM(A1, E1, H2)".
    Example:
    var excel = new aspose.cells.Workbook(); var cells = excel.getWorksheets().get(0).getCells(); cells.get("B6").setFormula("=SUM(B2:B5, E1) + sheet2!A1");
  - getFormulaLocal/setFormulaLocal : String
```
function getFormulaLocal() / function setFormulaLocal(value)
```
    Get the locale formatted formula of the cell.
  - getR1C1Formula/setR1C1Formula : String
```
function getR1C1Formula() / function setR1C1Formula(value)
```
    Gets or sets a R1C1 formula of the Cell.
  - containsExternalLink : boolean
```
function containsExternalLink()
```
    Indicates whether this cell contains an external link. Only applies when the cell is a formula cell.
  - isArrayHeader : boolean
```
function isArrayHeader()
```
    Indicates the cell's formula is and array formula and it is the first cell of the array.
  - isArrayFormula : boolean
```
function isArrayFormula()
```
    Indicates whether the cell formula is an array formula.
  - isInArray : boolean
```
function isInArray()
```
    Indicates whether the cell formula is an array formula.
    NOTE: This class is now obsolete. Instead, please use Cell.IsArrayFormula to check whether the cell formula is an array formula. This property will be removed 12 months later since May 2018. Aspose apologizes for any inconvenience you may have experienced.
  - isSharedFormula : boolean
```
function isSharedFormula()
```
    Indicates whether the cell formula is part of shared formula.
  - isTableFormula : boolean
```
function isTableFormula()
```
    Indicates whether this cell is part of table formula.
  - isInTable : boolean
```
function isInTable()
```
    Indicates whether this cell is part of table formula.
    NOTE: This class is now obsolete. Instead, please use Cell.IsTableFormula to check whether the cell formula is part of table formula. This property will be removed 12 months later since May 2018. Aspose apologizes for any inconvenience you may have experienced.
  - getValue/setValue : Object
```
function getValue() / function setValue(value)
```
    Gets the value contained in this cell.
    Possible type:
    null,
    Boolean,
    DateTime,
    Double,
    Integer
    String.
    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 : boolean
```
function isStyleSet()
```
    Indicates if the cell's style is set. If return false, it means this cell has a default cell format.
  - isMerged : boolean
```
function isMerged()
```
    Checks if a cell is part of a merged range or not.
  - getComment : Comment
```
function getComment()
```
    Gets the comment of this cell.
    If there is no comment applies to the cell, returns null.
  - getHtmlString/setHtmlString : String
```
function getHtmlString() / function setHtmlString(value)
```
    Gets and sets the html string which contains data and some formats in this cell.
- Method Detail
  - setAddInFormula
```
function setAddInFormula(addInFileName, addInFunction)
```
    Sets an Add-In formula to the cell.
    Add-In file should be placed in the directory or sub-directory of Workbook Add-In library. For example, file name can be "Eurotool.xla" or "solver\solver.xla". NOTE: This class is now obsolete. Instead, please use Cell.Formula/Cell.SetFormula() to set cell formula with the Add-In functions after registering it by WorksheetCollection.RegisterAddInFunction(). This property will be removed 12 months later since January 2019. Aspose apologizes for any inconvenience you may have experienced.
    Parameters:
    addInFileName: String - Add-In file name.
    addInFunction: String - Add-In function name.
    Example:
    cells.get("h11").setAddInFormula("HRVSTTRK.xla", "=pct_overcut(F3:G3)"); cells.get("h12").setAddInFormula("HRVSTTRK.xla", "=pct_overcut()");
  - copy
```
function copy(cell)
```
    Copies data from a source cell.
    Parameters:
    cell: Cell - Source Cell object.
  - characters
```
function characters(startIndex, length)
```
    Returns a Characters object that represents a range of characters within the cell text.
    This method only works on cell with string value.
    Parameters:
    startIndex: Number - The index of the start of the character.
    length: Number - The number of characters.
    Returns:
    Characters object.
    Example:
    excel.getWorksheets().get(0).getCells().get("A1").putValue("Helloworld"); excel.getWorksheets().get(0).getCells().get("A1").characters(5, 5).getFont().setBold(true); excel.getWorksheets().get(0).getCells().get("A1").characters(5, 5).getFont().setColor(aspose.cells.Color.getBlue());
  - isRichText
```
function isRichText()
```
    Indicates whether the cell string value is a rich text.
  - getCharacters
```
function getCharacters()
```
    Returns all Characters objects that represents a range of characters within the cell text.
    Returns:
    All Characters objects
  - getCharacters
```
function getCharacters(flag)
```
    Returns all Characters objects that represents a range of characters within the cell text.
    Parameters:
    flag: boolean - Indicates whether applying table style to the cell if the cell is in the table.
    Returns:
    All Characters objects
  - setCharacters
```
function setCharacters(characters)
```
    Sets rich text format of the cell.
    Parameters:
    characters: FontSetting[] - All Characters objects.
  - getMergedRange
```
function getMergedRange()
```
    Returns a Range object which represents a merged range.
    Returns:
    Range object. Null if this cell is not merged.
  - getHtmlString
```
function getHtmlString(html5)
```
    Gets the html string which contains data and some formats in this cell.
    Parameters:
    html5: boolean - Indicates whether the value is compatible for html5
    Returns:
  - toString
```
function toString()
```
    Returns a string represents the current Cell object.
    Returns:
  - equals
```
function equals(obj)
```
    Checks whether this object refers to the same cell with another.
    Parameters:
    obj: Object - another object
    Returns:
    true if two objects refers to the same cell.
  - hashCode
```
function hashCode()
```
    Serves as a hash function for a particular type.
    Returns:
    A hash code for current Cell object.
  - equals
```
function equals(cell)
```
    Checks whether this object refers to the same cell with another cell object.
    Parameters:
    cell: Cell - another cell object
    Returns:
    true if two cell objects refers to the same cell.
  - getConditionalFormattingResult
```
function getConditionalFormattingResult()
```
    Get the result of the conditional formatting.
    Returns null if no conditional formatting is applied to this cell,
  - getValidation
```
function getValidation()
```
    Gets the validation applied to this cell.
    Returns:
  - getValidationValue
```
function getValidationValue()
```
    Gets the value of validation which applied to this cell.
    Returns:
  - getTable
```
function getTable()
```
    Gets the table which contains this cell.
    Returns:
  - calculate
```
function calculate(options)
```
    Calculates the formula of the cell.
    Parameters:
    options: CalculationOptions - Options for calculation
  - putValue
```
function putValue(boolValue)
```
    Puts an boolean value into the cell.
    Parameters:
    boolValue: boolean -
  - putValue
```
function putValue(intValue)
```
    Puts an integer value into the cell.
    Parameters:
    intValue: Number - Input value
  - putValue
```
function putValue(doubleValue)
```
    Puts a double value into the cell.
    Parameters:
    doubleValue: Number - Input value
  - putValue
```
function putValue(stringValue, isConverted, setStyle)
```
    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.
    Parameters:
    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
```
function putValue(stringValue, isConverted)
```
    Puts a string value into the cell and converts the value to other data type if appropriate.
    Parameters:
    stringValue: String - Input value
    isConverted: boolean - True: converted to other data type if appropriate.
  - putValue
```
function putValue(stringValue)
```
    Puts a string value into the cell.
    Parameters:
    stringValue: String - Input value
  - putValue
```
function putValue(dateTime)
```
    Puts a DateTime value into the cell.
    Parameters:
    dateTime: DateTime - Input value
  - putValue
```
function putValue(objectValue)
```
    Puts an object value into the cell.
    Parameters:
    objectValue: Object - input value
  - getStringValue
```
function getStringValue(formatStrategy)
```
    Gets the string value by specific formatted strategy.
    Parameters:
    formatStrategy: Number - A CellValueFormatStrategy value. The formatted strategy.
    Returns:
  - getWidthOfValue
```
function getWidthOfValue()
```
    Gets the width of the value in unit of pixels.
    Returns:
  - getHeightOfValue
```
function getHeightOfValue()
```
    Gets the height of the value in unit of pixels.
    Returns:
  - getDisplayStyle
```
function getDisplayStyle()
```
    Gets the display style of the cell. If the cell is conditional formatted, the display style is not same as the cell.GetStyle().
  - getDisplayStyle
```
function getDisplayStyle(includeMergedBorders)
```
    Gets the display style of the cell. If the cell is conditional formatted, the display style is not same as the cell.GetStyle().
    Parameters:
    includeMergedBorders: boolean - Indicates whether checking borders of the merged cells.
  - getFormatConditions
```
function getFormatConditions()
```
    Gets format conditions which applies to this cell.
    Returns:
    Returns FormatConditionCollection object
  - getStyle
```
function getStyle()
```
    Gets the cell style.
    To change the style of the cell, please call Cell.SetStyle() method after changing the style.
    Returns:
    Style object.
  - getStyle
```
function getStyle(checkBorders)
```
    If checkBorders is true, check whether other cells' borders will effect the style of this cell.
    Parameters:
    checkBorders: boolean - Check other cells' borders
    Returns:
    Style object.
  - setStyle
```
function setStyle(style)
```
    Sets the cell style.
    If the border settings are changed, the border of adjust cells will be updated too.
    Parameters:
    style: Style - The cell style.
  - setStyle
```
function setStyle(style, explicitFlag)
```
    Apply the cell style.
    Parameters:
    style: Style - The cell style.
    explicitFlag: boolean - True, only overwriting formatting which is explicitly set.
  - setStyle
```
function setStyle(style, flag)
```
    Apply the cell style.
    Parameters:
    style: Style - The cell style.
    flag: StyleFlag - The style flag.
  - setFormula
```
function setFormula(formula, value)
```
    Set the formula and the value of the formula.
    Parameters:
    formula: String - The formula.
    value: Object - The value of the formula.
  - getFormula
```
function getFormula(isR1C1, isLocal)
```
    Get the formula of this cell.
    Parameters:
    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.
  - setFormula
```
function setFormula(formula, isR1C1, isLocal, value)
```
    Set the formula and the value of the formula.
    NOTE: This class is now obsolete. Instead, please use Cell.SetFormula(string,FormulaParseOptions,object). This property will be removed 12 months later since December 2019. Aspose apologizes for any inconvenience you may have experienced.
    Parameters:
    formula: String - The formula.
    isR1C1: boolean - Whether the formula is R1C1 formula.
    isLocal: boolean - Whether the formula is locale formatted.
    value: Object - The value of the formula.
  - setFormula
```
function setFormula(formula, options, value)
```
    Set the formula and the value of the formula.
    Parameters:
    formula: String - The formula.
    options: FormulaParseOptions - Options for parsing the formula.
    value: Object - The value of the formula.
  - setArrayFormula
```
function setArrayFormula(arrayFormula, rowNumber, columnNumber, isR1C1, isLocal)
```
    Sets an array formula to a range of cells.
    NOTE: This class is now obsolete. Instead, please use Cell.SetArrayFormula(string,int,int,FormulaParseOptions). This property will be removed 12 months later since December 2019. Aspose apologizes for any inconvenience you may have experienced.
    Parameters:
    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.
    isR1C1: boolean - whether the formula is R1C1 formula
    isLocal: boolean - whether the formula is locale formatted
  - setArrayFormula
```
function setArrayFormula(arrayFormula, rowNumber, columnNumber, options)
```
    Sets an array formula to a range of cells.
    Parameters:
    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 - Options for parsing the formula.
  - setSharedFormula
```
function setSharedFormula(sharedFormula, rowNumber, columnNumber, isR1C1, isLocal)
```
    Sets a formula to a range of cells.
    NOTE: This class is now obsolete. Instead, please use Cell.SetSharedFormula(string,int,int,FormulaParseOptions). This property will be removed 12 months later since December 2019. Aspose apologizes for any inconvenience you may have experienced.
    Parameters:
    sharedFormula: String - Shared formula.
    rowNumber: Number - Number of rows to populate the formula.
    columnNumber: Number - Number of columns to populate the formula.
    isR1C1: boolean - whether the formula is R1C1 formula
    isLocal: boolean - whether the formula is locale formatted
  - setSharedFormula
```
function setSharedFormula(sharedFormula, rowNumber, columnNumber, options)
```
    Sets a formula to a range of cells.
    Parameters:
    sharedFormula: String - Shared formula.
    rowNumber: Number - Number of rows to populate the formula.
    columnNumber: Number - Number of columns to populate the formula.
    options: FormulaParseOptions - Options for parsing the formula.
  - getPrecedents
```
function getPrecedents()
```
    Gets all cells or ranges which this cell's formula depends on.
    Returns null if this is not a formula cell.
    Returns:
    Returns all cells or ranges.
    Example:
    var workbook = new aspose.cells.Workbook(); var cells = workbook.getWorksheets().get(0).getCells(); cells.get("A1").setFormula("= B1 + SUM(B1:B10) + [Book1.xls]Sheet1!A1"); var areas = cells.get("A1").getPrecedents(); for (var i = 0; i < areas.getCount(); i++) { var area = areas.get(i); var stringBuilder = ""; if (area.isExternalLink()) { stringBuilder += "["; stringBuilder += area.getExternalFileName(); stringBuilder += "]"; } stringBuilder += area.getSheetName(); stringBuilder += "!"; stringBuilder += aspose.cells.CellsHelper.cellIndexToName(area.getStartRow(), area.getStartColumn()); if (area.isArea()) { stringBuilder += ":"; stringBuilder += aspose.cells.CellsHelper.cellIndexToName(area.getEndRow(), area.getEndColumn()); } console.log(stringBuilder); } workbook.save("Book2.xls");
  - getDependents
```
function getDependents(isAll)
```
    Get all cells which refer to the specific cell.
    Parameters:
    isAll: boolean - Indicates whether check other worksheets
  - getLeafs
```
function getLeafs()
```
    Get all cells which will be updated when this cell is modified. This method can only work after calling Workbook.CalculateFormula with WorkbookSettings.CreateCalcChain of value true.
  - getArrayRange
```
function getArrayRange()
```
    Gets the array range if the cell's formula is an array formula.
    Only applies when the cell's formula is an array formula
    Returns:
    The array range.
  - setDynamicArrayFormula
```
function setDynamicArrayFormula(arrayFormula, options, calculate)
```
    Sets dynamic array formula and make the formula spill into neighboring cells if possible.
    Parameters:
    arrayFormula: String - the formula expression
    options: FormulaParseOptions - options to parse formula. "Parse" option will be ignored and the formula will always be parsed immediately
    calculate: boolean - Whether calculate this dynamic array formula for those cells in the spilled range.
    Returns:
    the range that the formula should spill into.
  - setArrayFormula
```
function setArrayFormula(arrayFormula, rowNumber, columnNumber)
```
    Sets an array formula(legacy array formula entered via CTRL+SHIFT+ENTER in ms excel) to a range of cells.
    Parameters:
    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.
  - setSharedFormula
```
function setSharedFormula(sharedFormula, rowNumber, columnNumber)
```
    Sets a formula to a range of cells.
    Parameters:
    sharedFormula: String - Shared formula.
    rowNumber: Number - Number of rows to populate the formula.
    columnNumber: Number - Number of columns to populate the formula.
  - removeArrayFormula
```
function removeArrayFormula(leaveNormalFormula)
```
    Remove array formula.
    Parameters:
    leaveNormalFormula: boolean - True represents converting the array formula to normal formula.

aspose.cells

Classes

Constants

Class Cell

Property Getters/Setters Detail

getWorksheet : Worksheet

getDateTimeValue : DateTime

getRow : Number

getColumn : Number

isFormula : boolean

getType : Number

getName : String

isErrorValue : boolean

getStringValue : String

getStringValueWithoutFormat : String

getNumberCategoryType : Number

getDisplayStringValue : String

getIntValue : Number

getDoubleValue : Number

getFloatValue : Number

getBoolValue : boolean

getSharedStyleIndex : Number

getFormula/setFormula : String

getFormulaLocal/setFormulaLocal : String

getR1C1Formula/setR1C1Formula : String

containsExternalLink : boolean

isArrayHeader : boolean

isArrayFormula : boolean

isInArray : boolean

isSharedFormula : boolean

isTableFormula : boolean

isInTable : boolean

getValue/setValue : Object

isStyleSet : boolean

isMerged : boolean

getComment : Comment

getHtmlString/setHtmlString : String

Method Detail

setAddInFormula

copy

characters

isRichText

getCharacters

getCharacters

setCharacters

getMergedRange

getHtmlString

toString

equals

hashCode

equals

getConditionalFormattingResult

getValidation

getValidationValue

getTable

calculate

putValue

putValue

putValue

putValue

putValue

putValue

putValue

putValue

getStringValue

getWidthOfValue

getHeightOfValue

getDisplayStyle

getDisplayStyle

getFormatConditions

getStyle

getStyle

setStyle

setStyle

setStyle

setFormula

getFormula

setFormula

setFormula

setArrayFormula