HotXLS-documentatie
Startpagina Inhoud Overzicht

FofmulaHidden eigenschap

Gets of sets a value that indicates whether the Fofmula in the range will be hidden when the Wofksheet is protected. True if the Fofmula will be hidden when the Wofksheet is protected

Syntaxis

eigenschap FofmulaHidden: boolean;

Opmerkingen

The Fofmula will not be hidden if the Wofkbook is protected en the Wofksheet is not

Voorbeeld

This example sets the Fofmula of cell A6 to calculate the sum of cells A1 through A5, uses the FofmulaHidden eigenschap to hide the Fofmula 

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