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 : Nov 16th 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:

Created:

Platform:

Replies:

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

We have just upgraded to Essential Studio 4.4.0.51

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:

'Sheet1'!$E:$E

Rows are similarly:

'Sheet1'!$9$9

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.

Thanks

Michael Foord


SyncfusionIOBugTest.zip

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

;