CODEWITHSUNDEEP
c#closedxml
Goran Backlund
Goran Backlund

Reputation: 87

ClosedXml C# to display formula output numbers

I'm using closedxml to generate and download an xlsx file from a .NET c# application

Is there a way to display the formulas output numbers without the user having to click Enable Editing after downloading and opening the file in excel?

Upvotes: 6

Views: 2612

Answers (1)

Francois Botha
Francois Botha

Reputation: 4849

There is an overload which allows you to evaluate formulas when saving the file. It's disabled by default.

void Save(Boolean validate, Boolean evaluateFormulae = false);

void SaveAs(String file, Boolean validate, Boolean evaluateFormulae = false);

Upvotes: 8

Related Questions