C1.WPF.Excel Namespace > C1XLBook Class : KeepFormulas Property |
'Declaration
<System.ComponentModel.DescriptionAttribute("Specifies whether the component should preserve formulas when loading and saving XLS/XLSX files.")> <System.ComponentModel.DefaultValueAttribute()> Public Property KeepFormulas As System.Boolean
[System.ComponentModel.Description("Specifies whether the component should preserve formulas when loading and saving XLS/XLSX files.")] [System.ComponentModel.DefaultValue()] public System.bool KeepFormulas {get; set;}
Setting this property to true allows you to load existing XLS/XLSX files, modify the values in some cells, and save the file preserving the formulas. This is the default setting.
Setting this property to false causes the component to remove the formulas in the book when it is loaded. Saving the file in this case will retain the last calculated values but will remove the formulas.
Assigning any value to a cell will clear the formula in the cell.
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2