Chart Axis scale not kept when saving it as an image using 'SheetToImage'

Aspose.Cells Product Family
1

Hi,

I have some code that takes a chart from a spreadsheet, and saves it as an image.

The chart has a fixed minimum and maximum, but this is ignored when the image is generated.

I have attached an example..

thanks,

Steve

2
Hi Steve,

Please try the attached version and let us know if it works fine now.

I have tried the following sample code using your template file with the attached version and it works fine.

Sample code:

Workbook workbook = new Workbook();
workbook.Open("f:\\test\\aspose+scale+feature.xls");
Worksheet sheet = workbook.Worksheets[0];
Chart chart = sheet.Charts[0];
chart.ToImage("f:\\test\\c2imagefile.emf", ImageFormat.Emf);

Thank you.

3

Hi,

Thanks for your quick response. The problem seems to occur when the values used by the chart are changed, for example:

' open sheet

' change some cells used as data by the chart

' save chart(0) as image

Apologies if this also works with your example, but I couldn't get it all to work. :(

Cheers,

Steve

4

Hi,

Well, I tried your scenario but could not reproduce the issue, could you post your sample code with template files (output xls file and output image file) here, we will check it soon.

Tank you.

5

Amjad,

Thanks for the attachments- version 4.7.1.10 has fixed the problem. Great!

Previously I had been using 4.7.1.0 which is the latest version I could download on your web-site.

Does this mean that .10 is a beta, a general hotfix, or a hotfix specifically for this problem?

Thanks again for your time sorting this out,

Steve

6

Hi Steve,

TheFurbster:

Does this mean that .10 is a beta, a general hotfix, or a hotfix specifically for this problem?

Well, you can use the provided fix v4.7.1.10 as an official release. It is an intermediate kind of version which is provided as a fix against some bugs including yours. Normally, a bug fix version is posted in the support forums. You can use this fix for your requirements as long as you wish; it will behave like an official release. It is to be noted here, our next official release would include all the functionality of the previous fixes (including all the intermediate versions till the next official release).

Thanks for your understanding.