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
