I have a problem when using a named range from an Excel spreadsheet as the datasource in ReportPlus.
The Excel sheet is located on a webserver. ReportPlus can see the spreadsheet and load the data, but i have an issue.
When ReportPlus loads the sheet it only loads the first two columns. The named range in the sheet covers columns A to K. As the named range will change every time i update my sheet i cannot set the range manually. So basically i have to rely on the automatic range selection option, but as stated above it auto detects only the first two columns. Is this a known issue? Is there a solution?
I have verified that the named range is correctly configured. Excel sheet version is 2003.
Thank you for contacting Infragistics.
Would you be able to provide a copy of the workbook with dummy data in it so I can test the issue?
Here is the file i am trying to use. It is normally located so it can be reached on a http server. I had to zip the file to be able to attach it to my reply.
The named range i am trying to use is BIData.
Thank you for the sample data. I was able to reproduce the issue. I am currently researching the issue. I will update this thread when I have more information.
I have submitted this issue to our engineers for them to research. I will send another update once I've heard from them about the issue.
Any news on this issue?