Thread ID: |
Created: |
Updated: |
Platform: |
Replies: |
148043 | Oct 2,2019 06:38 PM UTC | Oct 3,2019 01:43 PM UTC | WinForms | 1 |
![]() |
Tags: XlsIO |
Hello!
I use Syncfusion.XlsIO in such scenario:
1. Read template .xlsx file. The file contains first sheet with TemplateMarkers to fill row data and second sheet with formulas to perform calculations.
2. Enable formula calculations by call ws.EnableSheetCalculations();
3. Fill data to ITemplateMarkersProcessor
At this moment I suppose all formulas in the second sheet are calculated.
After that I need to take calculated values from sheet with formulas. I iterate over worksheet.Cells and try to take cell.DisplayText
Unfortunately, I found that cell.DisplayText takes more 90% of time. You can see this in attached trace screenshot.
As I understood from trace analysis the reason of this behaviour is that during getting cell.DisplayText Syncfusion.XlsIO starts formulas recalculation. But I suppose formulas already calculated.
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.
This page will automatically be redirected to the sign-in page in 10 seconds.