fullCalcOnLoad on XLSX files

Aspose.Cells Product Family
1
We are using Aspose.Cells to generate very large sheets. Occassionaly we have issues in where the CalculateFormula() method does not correctly calculate all formula on our sheet, giving us a number of cells containing #N/A where Excel would give a value.

To counter this we'd like to set the 'fullCalcOnLoad' attribute described here:

`http://msdn.microsoft.com/en-us/library/documentformat.openxml.spreadsheet.calculationproperties.aspx`

This ensures Excel performs a full recalculation when the sheet is opened. Setting ReCalculateOnLoad to true does not cause the fullCalcOnLoad attribute to be added to the XLSX workbook.

We can use the Microsoft Open XML SDK to set this attribute but this would require us to reopen and resave the workbook saved by Aspose.Cells.

Could you add a feature request to enable us to set fullCalcOnLoad?

Thanks
2

Hi,

Thanks for your posting and considering Aspose.Cells.

Please provide us your source/output xls/xlsx files and the code replicating the problem. We will look into it and provide you a fix or advise.

Please also download and try the latest version:
Aspose.Cells for .NET (Latest Version)

3

My request is more of a feature request than a bug report.


We’d like a way to set the ‘fullCalcOnLoad’ attribute that is documented in the below link inside the XLSX files that Aspose.Cells generates:

http://msdn.microsoft.com/en-us/library/documentformat.openxml.spreadsheet.calculationproperties.aspx

This would ensure that Excel performs a full recalculation when the XLSX file is opened.

I’ve tried v7.1.1.2 and cannot see a way to set fullCalcOnLoad.

Thanks for your help.
4

Hi,

Please use WorkbookSetting.ReCalculateOnOpen