ASE Home Page Products Download Purchase Support About ASE
ChartDirector Support
Forum HomeForum Home   SearchSearch

Message ListMessage List     Post MessagePost Message

  Lack of memory in excel to draw chart
Posted by Thiago Almeida Franco on Aug-29-2013 05:56
Hi,
each time i use the code

Set simplebar = c.makePicture()

excel takes 20 mb of memory and do not return it even after i close the forms. When i call
the chart many times, i have to close excel and open again  to free memory, because there
is no more memory to execute it.
What can i do to return this memory automatic in order to not worry about memory again?


Thank you!

  Re: Lack of memory in excel to draw chart
Posted by Thiago Almeida Franco on Aug-29-2013 21:50
Attachments:
Here is an example.
This chart takes 8 mb of memory each time i draw and don't return it. if i use it many times i
get the message from excel :"Out of memory".
How can i erase all the data used to draw, so the memory before and after are the same?
Is there a way to restablish this memory without close the application?

Thank you.
Pasta1.xlsm
Pasta1.xlsm

136.26 Kb

  Re: Lack of memory in excel to draw chart
Posted by Peter Kwan on Aug-30-2013 06:54
Hi Thiago,

I confirm this is in fact due to a bug in ChartDirector. We should be able to produce a patch by next Monday to solve this problem. I will update you when the patch is available.

Regards
Peter Kwan

  Re: Lack of memory in excel to draw chart
Posted by Thiago Almeida Franco on Aug-30-2013 07:06
Thank you very much.

I think your software is fantastic and i am glad i could help you to find this bug.
Please, let me know as soon as this patch is available.
I will recommend ChartDirector to my friends.


Thank you!

  Re: Lack of memory in excel to draw chart
Posted by Peter Kwan on Sep-04-2013 15:38
Hi Thiago,

Sorry for the late reply. We have updated the ChartDirector for ASP/COM/VB on Monday but I forgot to update this post.

You may uninstall the previous "ChartDirector for ASP/COM/VB", then download the latest "ChartDirector for ASP/COM/VB" from our web site, and then install it. It should then solve the problem.

Hope this can help.

Regards
Peter Kwan

  Re: Lack of memory in excel to draw chart
Posted by Thiago Almeida Franco on Sep-04-2013 19:45
Hi Peter,

i will download and test the last version.

Thank You!
Regards.