Can open xls but xlsm has "Invalid Formula" error

I have an xlsm file that when calling the .open method throws an Invalid Formula exception. However if I save the file as an 97-2003 xls file Aspose.Cells can open it just fine.


We are using version 4.7.0.8 (from a previous fix).

I have appended the two files to this post. Can you tell me what about the formula is having the issue. I searched the forums and have found similar issues but the answers are unrelated to my worksheet as far as I can tell.

Thanks,

Tim Daniels

Hi Tim,

Thank you for considering Aspose.

After an initial test we have found the issue. We will look into it and get back to you soon.

Thank You & Best Regards,

I was wondering if you have a correction to the issue that you found yet?

Thanks

Tim Daniels

Hi Tim,

Thank you for considering Aspose.

We are working to resolve your issue and we will provide you a fix soon.

Thank you for being patient.

Hi Tim,

Thank you for considering Aspose.

Please try the attached latest fix of Aspose.Cells. We have fixed your mentioned issue.

Thank You & Best Regards,

Thanks for the fix, it solved the formula problem, but in testing it revealed another issue with the IsProtected and UnProtect methods for xlsm, howver I will post that in a new thread.


Thanks for you quick respose to the formula issue.

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


This message was posted using Notification2Forum from Downloads module by Amjad Sahi.