Docs HotXLS

DisplayFormulas-property

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

Syntaxe

property DisplayFormulas: Boolean;

Remarques

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

Exemple

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;