Spire.XLS API
Spire.XLS namespace
Spire.Xls.Core.Spreadsheet
XlsWorksheet Class
XlsWorksheet Methods
AccessColumn Method
AccessRow Method
AddAllowEditRange Method
ApplyStyle Method
AutoFitColumn Method
AutoFitRow Method
CalculateAllValue Method
CheckExistence Method
Clear Method
ClearData Method
ColumnWidthToPixels Method
CopyFrom Method
CopyToClipboard Method
CreateNamedRanges Method
CreateRanges Method
DeleteColumn Method
DeleteRange Method
DeleteRow Method
DeleteRows Method
ExportDataTable Method
FreeRange Method
GetBoolean Method
GetCaculateValue Method
GetCalculateValue Method
GetCellType Method
GetClonedObject Method
GetColumnIsAutoFit Method
GetColumnIsHide Method
GetColumnWidth Method
GetColumnWidthPixels Method
GetDefaultColumnStyle Method
GetDefaultRowStyle Method
GetError Method
GetFormula Method
GetFormulaBoolValue Method
GetFormulaErrorValue Method
GetFormulaNumberValue Method
GetFormulaStringValue Method
GetNumber Method
GetRowHeight Method
GetRowHeightPixels Method
GetRowIsAutoFit Method
GetRowIsHide Method
GetStringValue Method
GetText Method
GetTextObject Method
GroupByColumns Method
GroupByRows Method
HasArrayFormula Method
HasArrayFormulaRecord Method
HideColumn Method
HideColumns Method
HideRow Method
HideRows Method
ImportCustomObjects Method
InitializeCollections Method
InsertArray Method
InsertArrayList Method
InsertColumn Method
InsertCutRange Method
InsertDataColumn Method
InsertDataColumns Method
InsertDataTable Method
InsertDataView Method
InsertRange Method
InsertRow Method
IntersectRanges Method
IsArrayFormula Method
IsColumnVisible Method
IsExternalFormula Method
IsRowVisible Method
MergeRanges Method
MoveWorksheet Method
PixelsToColumnWidth Method
Remove Method
RemoveMergedCells Method
RemovePanes Method
ReparseFormula Method
Replace Method
ReplaceAll Method
SaveAndGetShapesToImage Method
SaveShapesToImage Method
SaveToEMFImage Method
SaveToFile Method
SaveToHtml Method
SaveToImage Method
SaveToPdf Method
SaveToPdfStream Method
SaveToStream Method
SaveToXps Method
SetActiveCell Method
SetBlank Method
SetBoolean Method
SetCaculateValue Method
SetCalculateValue Method
SetCellValue Method
SetColumnWidth Method
SetColumnWidthInPixels Method
SetDefaultColumnStyle Method
SetDefaultRowStyle Method
SetError Method
SetFirstColumn Method
SetFirstRow Method
SetFormula Method
SetFormulaBoolValue Method
SetFormulaErrorValue Method
SetFormulaNumberValue Method
SetFormulaStringValue Method
SetLastColumn Method
SetLastRow Method
SetNumber Method
SetRowHeight Method
SetRowHeightInPixels Method
SetRowHeightPixels Method
SetText Method
SetValue Method
ShowColumn Method
ShowRow Method
Subtotal Method
ToEMFStream Method
ToImage Method
ToSVGStream Method
UngroupByColumns Method
UngroupByRows Method
Click or drag to resize

XlsWorksheet GetCalculateValue Method

Returns the formula string if the cell contains a formula, or the value if the cell cantains anything other than a formula.

Namespace: Spire.Xls.Core.Spreadsheet
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
Copy 
public Object GetCalculateValue(
	int row,
	int col
)

Parameters

row
Type: System Int32
The row of the cell.
col
Type: System Int32
The column of the cell.

Return Value

Type: Object
The formula string or value.
See Also