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: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

formula cross-reference sheet

Thread ID:





82345 Jun 9,2009 09:25 PM UTC Jun 23,2009 06:12 AM UTC WinForms 1
Tags: XlsIO
Melinda Peirce
Asked On June 9, 2009 09:25 PM UTC

I am reading in an Excel page to a grid control. I have a workbook that I am reading multiple pages from. some pages reference a cell on the first page, which is fine, except that when I look at the formula in the worksheetcell the sheet name has single quotes around it. my excel file doesn't have the quotes, and the grid control should also not have the quotes. Is there a method to remove these quotes so that the formula can be written out properly?


Jisha Joy [Syncfusion]
Replied On June 23, 2009 06:12 AM UTC


Thank you for posting query to us.

I have tested the issue by importing a excel sheet to GridControl by GridExcelConverter. But it is exporting formulas to grid cell as shown in excel cell. The formula in grid cell also does not have any quotes in grid cell. Please see the sample that I tested the issue.


Could you please have a look at the above sample, if still the issue exists please reproduce the issue in the sample or provide us a sample having issue?.



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