The attached workbook was created entirely with Aspose Cells version 8.0.1.3. (.NET 3.5 version).
When opening it in Microsoft Excel the attached screen shots of errors are reported from Microsoft Excel.
Excel finds unreadable content in the Workbook.
Hi Michael,
Hello Babar,
Again this is a bit problematic given the size of the application, databases required and configuration settings to set up our application.
Somewhere in your code it appears there is bad content being written to the Xlsx file, and callers into the Aspose library should be protected from this.
We have been trying to narrow it down so as to help your find the issue, but this has proved difficult also.
One thing we think may be causing it is cells with Centre Across Selection Formatting, but we are not 100% sure there.
Note, it wasn’t a problem prior to version 8.
Hope this helps you.
Regards,
Mike
Hi Mike,
Hi Babar,
Thanks for investigating this issue. (And also the issue re Inserting Rows I also raised today)
This issue and the other I raised today re Inserting Rows and getting an Exception are real problems for us at the moment as we cannot move customers (from version 7…where things worked pretty well) to version 8 (which apparently picks up and fixes a lot of other matters we have previously raised (pre version 8) and have been fixed by you guys. We are more than keen to release those fixes, but can’t at the moment due to the issues we are currently having with version 8.
I can send you lots of Workbooks that we create with Aspose 8 entirely where this (unreadable content error from Microsoft Excel upon opening) issue happens when opening in Microsoft Excel. All these (via code Aspose created) Workbooks worked fine pre version 8…version 7.7.2 of Aspose Cells was our previous stable working release.
I fully appreciate how it is difficult to get to the heart of these issues without access to source code, reproducible code snippets et al; from both parties. We will endeavor to try and narrow these problems down (had no success there yet, but not for want of trying) and, if we can provide you with more targeted info to help you reproduce the issues, we most certainly will.
As fellow software developers we fully understand that finding the cause of the problem is the difficult bit; fixing it is the easy bit.
I’m not sure if Aspose can issue source code so as to enable developers like us to replicate (and thus debug) problems more easily? Some of our other partners like DevExpress allow this. Does Aspose have a policy regarding that, as I’m sure these issues once stepped through with the entire source code stack would be easy to find and fix.
If so, maybe we could explore that tactic if triaging and fixing this issue and also the issue with inserting rows becomes problematic and time lagged – i.e., we can’t get to the bottom of quickly.
Conversely, we would be happy to do so also; however as an end user application like ours, it is problematic to do this in terms of setting up an environment with multiple databases, config files, registry settings, other third party libraries, COM integration et al etc etc.
We really do need a solution to these issues asap, and will work with you guys as best we can to resolve.
As another suggestion, is it possible to retro fit your fixes (I’m of the understanding, only available now in version 8) for issues we have raised back into version 7? That is, can the Aspose Cells version 7 codebase be re-issued with bug fixes that now require version 8 but don’t impact on version 8…but will work equally well in version 7…???
Maybe this is an option that would suit us both well and also give you and us some time to thoroughly test version 8. I can give you a list of the issues that we have raised that Aspose have notified us that are fixed in version 8 that we would be happy to see retro fitted into version 7. I fully understand if this is not possible, but think it is worth mentioning as a probable solution until we can nail down the problems we are having with version 8.
Failing all that, I’d like to discuss with you setting up a virtual machine to place our application on, hosted by you, so that you could step though our problems when all else has failed. I’m very sure the bugs we find (particularly the couple we are talking about here) are very easily found and fixed, given all the appropriate code/information at hand.
We need to resolve these issues asap. We are willing to help you to do so in the best of mutual outcomes.
Babar, if you would like to discuss this, please give me a call on +61 4 930 20220. I know our time zones probably differ a bit, but please call, leave a return phone number if I’m not available, and I will most certainly get back to you.
I look forward to hearing from you, and again thanks for your help.
Best Regards,
Mike
Apologies if this (long) post is without formatting and paragraph spacing etc….seems to happen for some reason on the Aspose reply text box. I have attached a word doc to make it easier to read if so.
HI Mike,
Hi again,
Thanks Babar,
I have installed 8.0.2 and run against my code base and cannot reproduce these issues with that version of Aspose Cells. (My code base is the same as when I initially raised the issue).
I’m guessing that although these issues 42599 and 42596 were not specifically mentioned in the list of changes/fixes for 8.0.2, they have somehow been found and fixed, or related to some of the fixes specifically mentioned in the 8.0.2 release notes…???
Are you able to confirm…???
Cheers,
Mike
Hi Mike,