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.

Issue in calculating formulas in excel template

Thread ID:

Created:

Updated:

Platform:

Replies:

105833 Nov 22,2012 04:01 AM Nov 25,2012 11:16 PM ASP.NET Web Forms (Classic) 3
loading
Tags: XlsIO
Prakash Makhija
Asked On November 22, 2012 04:01 AM

Hello,

 

I am using syncfusion to set some formulas in excel using existing template. i.e. using open method I am opening a template and then setting some formulas, data validation in it.

 

In my existing excel template , there are some formulas and data validation but when I set formulas using syncfusion and then open that excel the existing formulas and data validations in excel template are not calculated.

 

Can you please suggest some solution ?


Rajesh A [Syncfusion]
Replied On November 23, 2012 02:42 AM

Formula Calculation:

XlsIO supports to enable the dynamic formula calculation using EnableSheetCalculation method. Please use the below code snippet to evaluate the formula dynamically. Also we have attached the sample for your reference.

Code Snippet:

workbook.Worksheets[0].EnableSheetCalculations();

Sample Link: Sample.zip

Data Validation Calculation:

We are not able to understand your actual requirement. Can you share us your expected output and sample which helps us to proceed further.

Please let us know if you need further clarification.

Thanks,

Rajesh A.


Prakash Makhija
Replied On November 23, 2012 04:05 AM

Thanks Rajesh,

My actual requirement is, i have a template in which there is data validation condition in column B (column B contains a list, i have created the list from lookup in another tab)  and using syncfusion i am opening that template and adding another list in column C using syncfusion. when i genrate that template it display list only in column C and not in B.

 


Rajesh A [Syncfusion]
Replied On November 25, 2012 11:16 PM

Hi Prakash,

Thank you for using the Syncfusion Products,

   We are able to reproduce the reported issue from our side. We are requesting you to create a new direct-trac incident and Request for issue in that. This will help us to have a regular follow-up.

Direct-Trac Link: Login

Please let us know if you require any further clarifications.

Thanks,

Rajesh A.


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.

;