HotXLS Docs

FormulaHidden property

Gets or 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

Syntax

property FormulaHidden: boolean;

Remarks

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

Example

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;