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.
We were able to reproduce the issue, it happens with XLS formats, but it doesn't with XLSX format.
We will include the fix in the next release.
Thank you! That is very good news.
Do you have any idea when the next release is? and which version number i should be looking for?
We expect to have the version in the AppStore within 2 weeks approximately.