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.