XlsxWriteOptions

public sealed class XlsxWriteOptions

Namespace SharpCell.Xlsx · package SharpCell.Xlsx

Options for XlsxWriter.

Constructors

XlsxWriteOptions()

public XlsxWriteOptions()

The defaults: a save is refused when some formulas cannot be calculated.

Properties

KeepUncalculated

public bool KeepUncalculated { get; init; }

What to do with formulas SharpCell cannot calculate, such as calls of functions it does not know or links to other workbooks. False (the default) refuses to save with an XlsxWriteException. True keeps the result Excel saved for them and marks the file so that Excel recalculates every formula when it opens it; until then, cells that read such a formula show what SharpCell calculated for them.