Can open xls but xlsm has "Invalid Formula" error

Aspose.Cells Product Family
1

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
2

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,

3

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

Thanks

Tim Daniels

4

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.

5

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,

6

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.
7

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.