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. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

XlsIO Getting cell.DisplayText takes a lot of time.

Thread ID:

Created:

Updated:

Platform:

Replies:

148043 Oct 2,2019 06:38 PM UTC Oct 3,2019 01:43 PM UTC WinForms 1
loading
Tags: XlsIO
Mikhail Zyubin
Asked On October 2, 2019 06:38 PM UTC

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.


Tell me please any idea how I can read fast already calculated values from the second sheet without starting recalc in every cell.DisplayText call.

Thank you,
Mike

Attachment: GetDisplayText_1128cd62.zip

Mohan Chandran [Syncfusion]
Replied On October 3, 2019 01:43 PM UTC

Hi Mikhail, 

Greetings from Syncfusion. 

When IWorksheet.EnableSheetCalculations() method is invoked, only the CalcEngine and required instances are created. The actual formula calculation starts only when you access the DispalyText or CalculatedValue property of the cell.  

We request you to share the Excel document used at your end, with data filled using Template Marker. This will be helpful for us to validate further to find the root cause of the issue from our side and provide prompt solution at the earliest. 

Regards, 
Mohan. 


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.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon 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.Close Icon

Live Chat Icon For mobile
Live Chat Icon