MS Excel chart to image rendering gives error on 64bit platform in .NET

Hi,

Your product simply fantastic, but…
On the 32 bit OS (Xp) when I run the exe this:
Dim imgChart_2 As Bitmap = wb.Worksheets(chartSheetIndex_2).Charts(0).ToImage()
works fine.

But

When i copy the application to windows server 2008 64bit everything works except for this particular command.
When I try to load a bmp into the variable everything is fine. So the problem is with this function.

This is the error:
Problem signature:
Problem Event Name: CLR20r3
Problem Signature 01: smartcreateppttest.exe
Problem Signature 02: 1.0.3773.26371
Problem Signature 03: 4bdc2ef7
Problem Signature 04: System.Drawing
Problem Signature 05: 4.0.0.0
Problem Signature 06: 4ba1e086
Problem Signature 07: 328
Problem Signature 08: 2c
Problem Signature 09: System.OverflowException
OS Version: 6.1.7600.2.0.0.18.10
Locale ID: 1033
Additional Information 1: 0a9e
Additional Information 2: 0a9e372d3b4ad19135b953a78882e789
Additional Information 3: 0a9e
Additional Information 4: 0a9e372d3b4ad19135b953a78882e789

Plus info: Windows Server 2008 64bit + .Net framework 4 is used.

I hope there is a solution ASAP.

Thank you,

Andras

Hi,

We will look into your issue on your underlying environment and get back to you soon.

By the way, could you try the attached version and let us know if the ToImage method works.


Thank you.

Hi,

Thank you, I tried. Unfortunately it does not work either.
If I run the my exe from mapped network location, on my pc there is no error. If I run it on the server (the same directory) it does not.


Thank you,

Andras

Hi Andras,

We have tested the ToImage() method and did not find any errors on 64bit platform.
Our system's configurations are Win7 + VS2008 + .Net Framework 3.5. Please provide us more detail of your server configuration and share a sample project to reproduce the issue regarding ToImage feature. This will help us figure out the issue soon.

Thank You & Best Regards,

First of all , thank you for your help:

Here are some more details:
Windows 2008 Server 64 bit edition.
The .net application uses framework 3.5 and VS2010

Interesting, that when i run the app from network drive (on my xp machine) it is ok.
When i run it on the server it gives the error.
I attached the app and the xml it gets data from.
You do not need the referenced dlls, they are just for database manipulation.

Andras

Hi Andras,

Thank you for sharing the sample application and further details about your issue.

We will look into it and get back to you soon.

Thank You & Best Regards,

Hi,

The project you provided cannot be built again. We created a simple project (attached). Please test on your server. If it is ok. Please provide a simple project including the referenced dlls to us for reproducing the issues. If it throws error, please attach the exception message and the calling stack.

Thank you.

Guys, I am sorry. I found the problem.
But this would be interesting to handle.
I forgot to take into consideration that the different cultures need different handling.
Due to this I produced for example 3656532565 number instead of 36,56532565 in the chart, thus the chart could not handle it.

It would be good to handle it somehow, since the problem symptom showed something else.

Basically that was it. Problem solved.

Andras