Aspose.com » Public Forums for Customers an... » Aspose.Cells Product Family » Can open xls but xlsm has "Invalid Formula" error

Can open xls but xlsm has "Invalid Formula" error

Last post 04-14-2009, 3:02 AM by Amjad Sahi. 6 replies.
Sort Posts: Previous Next

  •  04-02-2009, 10:47 AM 173108

    Can open xls but xlsm has "Invalid Formula" error .NET

    Attachment: Present (inaccessible)
    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
    Filed under: Aspose.Cells Invalid Formula xlsm
     

  •  04-02-2009, 11:11 AM 173114 in reply to 173108

    Re: Can open xls but xlsm has "Invalid Formula" error

    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,

    Nausherwan Aslam
    Support Developer,
    Aspose Sialkot Team
    Contact Us
     

  •  04-07-2009, 1:52 PM 173860 in reply to 173114

    Re: Can open xls but xlsm has "Invalid Formula" error

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

    Thanks

    Tim Daniels
     

  •  04-08-2009, 1:30 AM 173909 in reply to 173860

    Re: Can open xls but xlsm has "Invalid Formula" error

    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.

    Nausherwan Aslam
    Support Developer,
    Aspose Sialkot Team
    Contact Us
     

  •  04-08-2009, 5:27 AM 173944 in reply to 173860

    Re: Can open xls but xlsm has "Invalid Formula" error

    Attachment: Present (inaccessible)

    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,

    Nausherwan Aslam
    Support Developer,
    Aspose Sialkot Team
    Contact Us
     

  •  04-08-2009, 9:56 AM 173998 in reply to 173944

    Re: Can open xls but xlsm has "Invalid Formula" error

    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.
     

  •  04-14-2009, 3:02 AM 174628 in reply to 173108

    Re: Can open xls but xlsm has "Invalid Formula" error

    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.
     
View as RSS news feed in XML

© Aspose 2002-2012. All Rights Reserved.

Live Chat