Share via

How to show formula calculation in excel created with Open XML in Protected view programmatically

Goranović, Iva 0 Reputation points
2023-03-14T14:21:39.5233333+00:00

How to show formula values in cells in Excel generated with OpenXml in Protected view on excel open?

Tried with this but not work.
WorkbookPart.Workbook.CalculationProperties.ForceFullCalculation = true;

WorkbookPart.Workbook.CalculationProperties.FullCalculationOnLoad = true;

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
4,352 questions
0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.