Documentazione HotXLS

DisplayFormulas proprietà

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

Sintassi

proprietà DisplayFormulas: Boolean;

Osservazioni

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

Esempio

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;