Thread ID: |
Created: |
Updated: |
Platform: |
Replies: |
105833 | Nov 22,2012 09:01 AM UTC | Nov 26,2012 04:16 AM UTC | ASP.NET Web Forms (Classic) | 3 |
![]() |
Tags: XlsIO |
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 ?
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.
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.
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.
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.
or the page will be automatically redirected to sign-in page in 10 seconds.