Axolot Data

Posted: **Tue Dec 11, 2012 5:31 pm**

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

Posted: **Thu Dec 13, 2012 9:09 am**

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');

Axolot Data

XLSReadWriteII 5 - IsFormulaCell

XLSReadWriteII 5 - IsFormulaCell

Re: XLSReadWriteII 5 - IsFormulaCell