Docs HotXLS

FormulaHidden-property

Obtient ou définit a value that indicates whether the Formula in the range will be hidden when the Worksheet is protected. True if the Formula will be hidden when the Worksheet is protected

Syntaxe

property FormulaHidden: boolean;

Remarques

The Formula will not be hidden if the Workbook is protected and the Worksheet is not

Exemple

This example sets the Formula of cell A6 to calculate the sum of cells A1 through A5, uses the FormulaHidden property to hide the Formula

With Workbook.Sheets[1].Cells[6,1] do
begin
   Formula := '=SUM(A1:A5)';
   FormulaHidden := true;
end;