We are currently using Winforms NetAdvantage 8.2.20082.2204 and our solution targets the 3.5 version of the .NET framework. We need to export to excel version 2007 since we are hitting the 64k row limit.
The problem is, since this is a CAB module, that we can't upgrade to a higher version (at least not without upgrading the shell and all modules which is impossible at the moment) note that we are using the "Versioned" assemblies (have "v8.2" as suffix)
Is there any way to export to excel 2007 using the 8.2 version?
Thanks in advance
Support for the Excel 2007 format was added in 8.3, so there is no way to save in that format in 8.2. Are you populating the Excel object model directly or are you using a grid exporter? If you are populating it manually, you can upgrade the Excel library only without upgrading the other assemblies.
Unfortunately we are using the grid exporter
Thanks for your quick reply
You can try doing a binding redirect so that you can upgrade the assemblies without upgrading the shell and modules: http://msdn.microsoft.com/en-us/library/2fc472t2(v=vs.80).aspx
However, this may cause run-time errors if anything public being used from the CAB stuff changed (such as a virtual method becoming non-virtual in the later assemblies), so I would recommend upgrading to 8.3 instead of the latest version if you do try this.
We though of that, but unfortunately binding redirection doesn't work on assemblies with different naming.
Thanks for your input, we'll try to find a alternative solution for this particular module
Please let me know if you have any other questions about this.