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
XLSReadWriteII 5 - IsFormulaCell
Re: XLSReadWriteII 5 - IsFormulaCell
Hello
Use the CellType property.
Example:
Use the CellType property.
Example:
Code: Select all
if FXSS.XLS[0].CellType[2,2] in [xctFloatFormula,xctStringFormula,xctBooleanFormula,xctErrorFormula] then
ShowMessage('Formula cell');
Lars Arvidsson, Axolot Data