We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Use Template File With Formulas ERRORS

Thread ID:

Created:

Updated:

Platform:

Replies:

36679 Nov 7,2005 08:53 AM Nov 9,2005 07:42 AM Windows Forms 5
loading
Tags: XlsIO
Adrian White
Asked On November 7, 2005 08:53 AM

Hi I''m trying to open a .xls file and getting exceptions such as; 1) "Not enough elements in Stack" and 2) "Cannot find Formula token with code: 52". The .xls file in question contains formulas, if I remove the formulas the exceptions do not occur. Removing the formulas is not an option for me. I need to know what the limitations/best practices are of xlsio with regard to using .xls files as templates with formulas and also what formulas are supported by xlsio. I''m using excelengine to open the .xls file. Many Thanks in Advance Adrian

Administrator [Syncfusion]
Replied On November 8, 2005 04:36 AM

Hi Adrian, Here is a Sample in the Evaluation centre regarding Formulas. see to this link: http://www.syncfusion.com/support/EvaluationCenter/default.aspx?cNode=4 Please take a look and if you again see the problem, please send me the Sample which throws exception. Thanks for your interest with Syncfusion products. Best Regards, Seetha >Hi > >I''m trying to open a .xls file and getting exceptions such as; >1) "Not enough elements in Stack" and >2) "Cannot find Formula token with code: 52". > >The .xls file in question contains formulas, if I remove the formulas the exceptions do not occur. Removing the formulas is not an option for me. > >I need to know what the limitations/best practices are of xlsio with regard to using .xls files as templates with formulas and also what formulas are supported by xlsio. > >I''m using excelengine to open the .xls file. > >Many Thanks in Advance > >Adrian

Adrian White
Replied On November 8, 2005 06:12 AM

Thanks Seetha I''m attaching the template which uses the offset function. This returns the "Not enough elements in stack" exception. The offset formulas are in Column Q, if you delete all but one or two of the offset formulas, the exception does not occur. I tried using the choose function as a different way of achieving the same result but this raises the "Cannot find Formula token with code: 0". Seetha, can you explicitly detail for me which functions xlsio supports please? Also, I''m still searching the forums and kb for this answer but can you let me know if it''s possible to replicate Excel''s ''Calculate'' method? I need the template file to calculate the formulas it contains whilst I am processing the file with xlsio. Thanks Adrian

Administrator [Syncfusion]
Replied On November 9, 2005 12:59 AM

Hi Adrian, Sorry for the Inconvenience. I haven''t got the template file. Could you please again attach the file. Best Regards, Seetha >Thanks Seetha > >I''m attaching the template which uses the offset function. This returns the "Not enough elements in stack" exception. The offset formulas are in Column Q, if you delete all but one or two of the offset formulas, the exception does not occur. > >I tried using the choose function as a different way of achieving the same result but this raises the "Cannot find Formula token with code: 0". > >Seetha, can you explicitly detail for me which functions xlsio supports please? > >Also, I''m still searching the forums and kb for this answer but can you let me know if it''s possible to replicate Excel''s ''Calculate'' method? I need the template file to calculate the formulas it contains whilst I am processing the file with xlsio. > >Thanks > >Adrian

Adrian White
Replied On November 9, 2005 06:11 AM

Sure here you are.

offset.zip

Administrator [Syncfusion]
Replied On November 9, 2005 07:42 AM

Hi Adrian, Regarding the OFFSET and CHOOSE functions, It has been fixed in the latest internal version and the fix will be available in the next release. The next release is on November 21st. I herewith attach the functions which are supported by XlsIO. formula632671565671525550.zip Thanks for your Continued interest with Syncfusion products. Best Regards, Seetha >Sure here you are.

offset.zip

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;