Hi,
I am facing the following issue with reading the attached Excel file. The file is completely Empty.
Error Msg: The worksheet reference must be followed by an exclamation point.Portion with error: [5]KI
Excel dll:- Infragistics4.Documents.Excel.v12.1
Version:12.1.20121.1001
Thanks!
I have recently fixed this issue. However, it required a large number of changes to fix. Therefore, it could only be fixed in version 12.1. In addition, the changes were made too close to the next SR release date, so it will not be released until the July SR, assuming no regression issues were introduced by the fix.
any update on the this Issue?
Would you let me know named reference is wrong in the file?
Hello Garth,
I have created CAS-91267-X4Q464 and linked it to the existing development issue.
The file is actually not empty. There are a large number of named references still defined in the file. I was able to reproduce this issue. It is actually already submitted as issue id 102878, but no fix has been implemented yet. The problem is that the formula for one of your named references uses a range of cells in a range of sheets, like so: ='Sheet1:Sheet3'!$A$1:$B$2. This is currently not recognized correctly by the Excel library. I will contact Developer Support and have them add you to the existing bug so you can be notified when it is fixed.