Table of Contents

Class SaveOptions

Namespace
SlapKit.Excel.Excel
Assembly
SlapKit.Excel.dll
public class SaveOptions
Inheritance
SaveOptions
Inherited Members
Extension Methods

Constructors

SaveOptions()

public SaveOptions()

Properties

ConsolidateConditionalFormatRanges

public bool ConsolidateConditionalFormatRanges { get; set; }

Property Value

bool

ConsolidateDataValidationRanges

public bool ConsolidateDataValidationRanges { get; set; }

Property Value

bool

EvaluateFormulasBeforeSaving

Evaluate a cells with a formula and save the calculated value along with the formula.

  • True - formulas are evaluated and the calculated values are saved to the file. If evaluation of a formula throws an exception, value is not saved but file is still saved.
  • False (default) - formulas are not evaluated and the formula cells don't have their values saved to the file.
public bool EvaluateFormulasBeforeSaving { get; set; }

Property Value

bool

FilterPrivacy

Gets or sets the filter privacy flag. Set to null to leave the current property in saved workbook unchanged

public bool? FilterPrivacy { get; set; }

Property Value

bool?

GenerateCalculationChain

public bool GenerateCalculationChain { get; set; }

Property Value

bool

ValidatePackage

public bool ValidatePackage { get; set; }

Property Value

bool