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

Serious Bug with Importing Names from Excel File

Thread ID:




56486 Feb 15,2007 04:58 PM UTC WinForms 0
Tags: GridControl
Michael Foord
Asked On February 15, 2007 04:58 PM UTC

We have just upgraded to Essential Studio

We now have a *serious* problem with importing named cells and cell ranges from Excel files.

Attached is a sample Visual Studio project with sample Excel file which illustrates it.

Named cell ranges representing columns in Excel have the format:


Rows are similarly:


These *used* to import fine (as the 'name.Value foir names in workbook.Names).

They *now* come in as :

'Sheet1'!C3 for column 3 or
'Sheet1'!R9 for row 9

Presumably 'C' for column and 'R' for row. *Unfortunately* these are impossible to disambiguate from named cells using relative syntax - which excel *does* allow.

This is a big problem for us.

By the way - with this version we *still* see named formulae coming in with name.Value set to null. (To reproduce create an Excel file. Go to Insert->Name-Define menu option and create a name with the value '=42' - then iterate over the names using our sample.)

Both of these issues are a big problem for us.


Michael Foord



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