Docs HotXLS
Accueil Sommaire Aperçu

HasFormula-property

Renvoie True if at least one cell in the range contains a Formula; otherwise, False

Syntaxe

property HasFormula: boolean;

Exemple

This example checks if the Worksheet one contains Formula 

if Workbook.Sheets[1].UsedRange.HasFormula then
begin
  //do something
end;
This example checks if the cell A1 contains Formula 

if Workbook.Sheets[1].Cells[6,1].HasFormula then
begin
  //do something
end;