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.
Syncfusion Feedback

Getting calculated value instead of formula when reading excel file using ExcelRW

Thread ID:

Created:

Updated:

Platform:

Replies:

14904 Jun 8,2004 11:45 AM UTC Jun 8,2004 02:03 PM UTC Windows Forms 3
loading
Tags: XlsIO
vinod
Asked On June 8, 2004 11:45 AM UTC

Hi, I have a problem in that the Text property andthe value property returns the formula in the excel file i am reading. is there anyway to get the calculated value. The code below is similar to my intention foreach (Syncfusion.ExcelRW.IRange currentCell in UsedCells) { mySyncfusionGrid[row, col] = currentCell.Value; } vinod

Administrator [Syncfusion]
Replied On June 8, 2004 01:01 PM UTC

Hi Vinod, Thank you for your interest in Syncfusion Essential ExcelRW. We have already added a property that returns the calculated value. However , the change has not been included in the version that is available for download. Also, are you using the eval version?. Thanks. Best regards, Stephen. >Hi, >I have a problem in that the Text property andthe value property returns the formula in the excel file i am reading. is there anyway to get the calculated value. >The code below is similar to my intention > >foreach (Syncfusion.ExcelRW.IRange currentCell in UsedCells) >{ >mySyncfusionGrid[row, col] = currentCell.Value; >} > >vinod

vinod
Replied On June 8, 2004 01:16 PM UTC

Hi Stephen, I am using a binary only, registered Essential Suite 2.0.5.1. Thanks Vin

Administrator [Syncfusion]
Replied On June 8, 2004 02:03 PM UTC

Hi Vinod, Thanks for the info. I will send you the updated build later today. Could you go ahead and create a Direct Trac indicent in this regard. Thanks. Best regards, Stephen. >Hi Stephen, >I am using a binary only, registered Essential Suite 2.0.5.1. >Thanks Vin

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.

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

;