XLSReadWriteII 5 - IsFormulaCell

[afalencar]

Hi

I'm trying to convert my source code developed for version 4, and i found a situation without a clear way to change it:

if (Cell[col,row] is TFormulaCell) then
{something}

How can i verify if a specific cell already contains a formula, with the new version ?

Thanks

[larsa]

Hello

Use the CellType property.

Example:

Code: Select all

  if FXSS.XLS[0].CellType[2,2] in [xctFloatFormula,xctStringFormula,xctBooleanFormula,xctErrorFormula] then
    ShowMessage('Formula cell');