We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

WorkBook.getCalculationMode in 2007

When I open a WorkBook with an xltx extension WorkBook.getCalculationMode returns a 1(Automatic). However, the workbook Formulas.CalculationOptions are in fact set to Manual(0). Can this be fixed?

Best,

Clifton Sothoron

This is in the latest Java version.

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Well, value 1 represents the Manual Calculation Mode. Following are the details about Calculation Modes:

If value is 0 = CalculationMode.AUTOMATIC

If value is 1 = CalculationMode.MANUAL

If value is 2 = CalculationMode.SEMIAUTOMATIC

Thank You & Best Regards,

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Please ignore my previous email. After further testing your issue, we found the problem. We will provide a fix for it soon. Your issue has been registered in our internal issue tracking system with issue id: CELLSJAVA-17019.

Thank You & Best Regards,

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Please try the attached latest version of Aspose.Cells. We have supported the CalculationMode property for reading excel2007 template files.

Thank You & Best Regards,

Nausherwan,

Thank you for your reply. It works now.

Thanks,

Clif...

The issues you have found earlier (filed as 17019) have been fixed in this update.


This message was posted using Notification2Forum from Downloads module by aspose.notifier.