GrapeCity.Documents.Excel.XlsxSaveOptions.IgnoreFormulas

IgnoreFormulas Property

IgnoreFormulas

Gets or sets whether formula cells are treated as value cells when saving to an .xlsx file.

When this property is true, formula cells are exported as value cells in Excel instead of preserving their formulas.

Declaration

public bool IgnoreFormulas { get; set; }

Public Property IgnoreFormulas As Boolean

Examples

XlsxSaveOptions options = new XlsxSaveOptions();
options.IgnoreFormulas = true;
bool ignoreFormulas = options.IgnoreFormulas;
workbook.Save("path/to/output.xlsx", options);