Need clarification on formula calculation when workbook is opened

Aspose.Cells Product Family
1

Hi Team,

Need clarification on the below listed points:-

1)When a excel workbook is opened using Aspose.Cells.Workbook class, are formulas calculated ?
2)Is there a way to disable formulas so that no calculation is done when an excel workbook containg formulas is opened.

Thanks,
Ashish Sharma

2

Hi,


I think you may try the following sample code to ignore parsing formulas when opening your template file, please refer to the code segment below:
e.g
Sample code:
var options = new LoadOptions() { ParsingFormulaOnOpen = false };
var workbook = new Aspose.Cells.Workbook(@“e:\test2\Book1.xlsx”, options);
…


Hope, this helps a bit.

Thank you.
3

Thanks Amjad for such a quick response.