Documentazione HotXLS

FormulaHidden proprietà

Gets o sets 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

Sintassi

proprietà FormulaHidden: boolean;

Osservazioni

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

Esempio

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

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