Cells throwing out of memory exceptions in Azure

Aspose.Cells Cloud Product Family
1

Hi,

We have an application which relies on aspose (slides, cells, and words) which we are porting to the azure cloud.

We currently build charts in cells, then embed them into ppt documents as OLE objects. In the azure environment when we retrieve these OLE objects we get Out of Memory errors.

More specifically when calling ToImage() on the chart to get the default display information for when we insert the OLE object into the chart we get the exception.

Are you guys aware of this issue? do you have any workarounds? Any planned fixes?

2

Hi,

Please create a sample application with your template file and post it here. This will help us figure out the issue soon.

Thank You & Best Regards,

3

Nausherwan:

Can you tell me if any progres have been made on this issue? We have worked through a similar issue with the PPT component with Alexey (Link) and he has recommended that we follow up with you regarding the issue in the Cell component.

Thanks,

Tom Murphy

4

Hi Tom,

Please create a sample application to show the issue and post it here. This will help us understand and figure out the issue soon.

Thank You & Best Regards,

5

Nausherwan:

I believe that the quickest method of getting this demonstrated and resolved would be for your team to contact and collaborate with Alexey and his Slides team. He is the one that identified that the issue the Slides component was experiencing was fixed and now exposing this issue with the Cells component. I believe he can probably give you more direct information on the issue.

Thanks,

Tom Murphy

6

Hi Tom,

We are coordinating with Aspose.Slides team to figure out this issue soon. As soon as we have any update, we will share it with you.

Thank You & Best Regards,

7

Nausherwan:

Any word on the progress on this issue or an estimate on when a fix might be available?

We unfortunately made development plans and subsequent commitments based on the timeline for the Slides fix and are not in the uncomfortable position of having to backpedal on those plans. Anything you can do to help us reset expectations would be greatly appreciated.

Thanks,

Tom Murphy

8

Hi Tom,

Which version you are using? Could you try the new version i.e. Aspose.Cells for .NET v5.0.0: http://www.aspose.com/community/files/51/.net-components/aspose.cells-for-.net/entry243604.aspx
and let us know if it works fine.

Thank you.

9

Amjad:

We pulled down the latest Cells component (Aspose.Cells for .NET v5.0.0) and we are still experiencing the same issue. Here is the feedback from our developer:

“The new Aspose.Cells DLL does not resolve the power point issue. We still continue to receive the Out Of Memory exception.”

Please let me know when you have an updated component for us to try.

Thanks,

Tom Murphy

10

Hi,

Thanks for sharing further details.

We are looking into your issue and will get back to you soon.

Thank you.

11

Hi,

After further exploration, we could not reproduce the issue here. We tested it on a computer with Win7 + Windows Azure Tools for Microsoft Visual Studio 1.2 + VS2010 + .Framework 4.0 etc. Could you create a simple test and provide it here?

Usually, the exceptions are thrown by the Font class. For example, Font.GetHeight(), Font.SizeInPoints, Font.EmSize etc. However, the Chart.ToImage() method does not use those methods directly. We create a simple Cloud Service project for testing the ToImage() method. Please set TestChart.aspx as start page and run it. We found when setting the trust level to “Full trust” all the formatted chart can be obtained. When you set the trust level to “Windows Azure trust”, only the emf format chart is not right, that throws security permission exception. The security exception occurs because of Graphics.GetHdc(). We will continue to look into it.

Now you can use other formats except Emf.

Thank you.

12

Muhammad:

Our development team is working against the 3.5 Framework. This might be the difference is being able to reproduce this issue.

Tom Murphy

13

Hi Murphy,

We successfully performed a test on VS 2008 (.NET 3.5) under Windows Vista 32-bit environment without any problem. In order to reproduce your issue, please provide a sample project for further investigation.

The sample project is attached here for your reference.

Best Regards

14

Muhammad,

I modified your code sample and added a second data set in CreateStaticData:

cells["C1"].PutValue("Investing Costs");
cells["C2"].PutValue(1000);
cells["C3"].PutValue(2000);
cells["C4"].PutValue(4000);

I also added this to the CreateStaticReport

chart.NSeries.Add("C2:C4", true);

Doing this causes me to receive the OutOfMemoryException when calling c.ToImage(ms, imageformat);

Can you demonstrate the correct way to add additional data series without getting this error?

15

Hi,

Based on the changes in the sample project suggested by you, we were able to reproduce the issue.

We have logged this issue in our Issue Tracking System as 18190 . We will update you soon once there is progress about this issue.

Kind Regards

16

Muhammad:

Do you have any update to the status of this issue? We are eagerly awaiting a fix for this issue so we can hopefully complete this functionality. We have been working through issues with the Aspose components for about a month now and we are looking forward to getting this resolved.

Any information you have on the status of this item would be greatly appreciated.

Thanks,

Tom Murphy

17

Hi,

We have resolved the issue. But we need further testing. We will try to provide the fixed version before the end of this week.

Thank you.

18

Hi,

We have solved the memory exception issue. Please try this fix (attached).

Thank you.

19

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

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

20

Moved here: Cells throwing out of memory exceptions in Azure - Free Support Forum - aspose.cloud