WorkBook.getCalculationMode in 2007

Aspose.Cells Product Family
1

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

2

This is in the latest Java version.

3

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,

4

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,

5

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,

6

Nausherwan,

Thank you for your reply. It works now.

Thanks,

Clif...

7

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.