Exceptions on loading valid Excel file - every time

Aspose.Cells Product Family
36

Hi,

Please download and try: Aspose.Cells for .NET v7.0.4.6

We have removed some Hashtable.Add in saving the file.

37

Still getting the exception.

It’s being caused by a key of ‘0’ being added to a dictionary more than once, as the exception states. It is not from directly manipulating a Hashtable so if you have any code doing that; that’s not the source of the problem.

38

Hi,

Please run the AposeCellsProblem project with the attacehd debug version, some logs will be exported to c:\log.txt.

Please post c:\log.txt here, then we can find where the exception throws as we could not get it in our develop machine

39

Here’s the file.

40

Hi,


Thanks for the log file, we will investigate it and get back to you soon.

Thank you.
41

Hi,

Thanks for your log file.

But the exception is out of our imaging. We could not get where it throws exception from log file.

Please try the attached debug version, we have added more log info.

42

Here is another version of the log file.

43

Hi,


Thanks for providing us the needed log file, we will look into it and get back to you asap.

44

Any update?

45

Hi,

I am afraid, there is no update for you at the moment.

I have logged your comment though and we will provide you update in next week because related developers are on holidays.

46

Hi,

It's very strange.

We think the file should be generated fine without any exception after checking the log file.

Did you run the project in debug mode?

47

I cannot run it in debug mode because it tries to write the log file to the c:\ drive. It needs administrator privileges in order to do that so I have to use the executable directly.

If you make the log file write to ./ instead of c:\ I’ll be able to run it in debug mode.

48

Hi,

We have logged your feedback/suggestion in our database.

We will get back to you asap.

49

Hi,

Please try the attached debug version.

We have changed log file to "./log.txt".

50

Here is the new log.txt. I ran in debug mode, and got the exception.

Hopefully the log means something useful to you. It does not contain a stack trace so I’m not sure if it will be helpful. Can I suggest that you go into whatever catch blocks are in the saving code and write their contents to the log file? (It’s generally good practice to log exceptions in the first place).

51

Hi,
It’s so strange.
We think the file “test2.xls” should be generated fine after checking log file.
Could check whether the generated file is fine?

52

Ok, I thought we covered this already…

It is not preventing the file from saving. The exception is thrown and caught all inside of the Apose.Cells.dll. The issue is that it causes the debugger to break (aka notify the user an exception was thrown) every single time an application that is using this component saves. This is the exact same scenario as was with the exceptions in new Workbook() that you already fixed.

As I already said, somewhere in your code you have try-catch blocks. You need to write the log file inside of the catch blocks. That is the way to track down where the exception is coming from.

Again, the file saves normally- the issue is that it causes the debugger to halt every time debugging an application that uses Aspose.Cells.

53

Hi,

Please download and try this fix:
Aspose.Cells
for .NET v7.1.0.4

54

Great! It finally works! Thanks!

55

The issues you have found earlier (filed as CELLSNET-40141) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.