HotXLS Docs

DisplayFormulas property

Returns or sets whether a classic XLS worksheet view displays formulas instead of formula results. Read/write Boolean.

Syntax

property DisplayFormulas: Boolean;

Remarks

This property controls the worksheet view flag saved in the BIFF WINDOW2 record. It does not change formulas, cached values, or calculation behavior.

Example

This example saves the worksheet so Excel opens it showing formula text.

Workbook.Sheets[1].Range['A1', 'A1'].Formula := '=1+2';
Workbook.Sheets[1].DisplayFormulas := True;