Free Support Forum - aspose.com

Another Regression with 8.9.0

I’ve discovered another regression with newer versions. Works good with 8.6.0 and 8.9.0 seems to work fine with Excel 2003 (.xls) versions.



I’m running the following code against the Excel spreadsheet.





var workingFolder = System.IO.Path.GetDirectoryName(Environment.GetCommandLineArgs()[0]);

var workbook = new Workbook(System.IO.Path.Combine(workingFolder, “Chart.xlsx”));

var worksheet = workbook.Worksheets[1];

var asposeChart = worksheet.Charts[0];



var options = new Aspose.Cells.Rendering.ImageOrPrintOptions();

options.VerticalResolution = 300;

options.HorizontalResolution = 300;

options.ImageFormat = ImageFormat.Bmp;

options.Quality = 100;



// this screws up the chart

asposeChart.Calculate();



var imageFileName = “Chart.png”;

asposeChart.ToImage(System.IO.Path.Combine(workingFolder, imageFileName), options);



Console.WriteLine("Saved image at " + System.IO.Path.Combine(workingFolder, imageFileName));

Console.ReadLine();





The chart has data, but when you Calculate, the stacked portion disappears.



Thanks.

Hi,


Thanks for the template file and sample code.

After an initial test, I observed the issue as you mentioned by using your template file and sample code. I found that chart’s data stacked portion is missing in the output Chart after using Chart.Calculate() method. I am using the latest version/fix: Aspose.Cells for .NET v9.0.9.x
e.g
Sample code:

var workbook = new Workbook(“e:\test2\Chart.xlsx”);
var worksheet = workbook.Worksheets[1];
var asposeChart = worksheet.Charts[0];
var options = new Aspose.Cells.Rendering.ImageOrPrintOptions();
options.VerticalResolution = 300;
options.HorizontalResolution = 300;
options.ImageFormat = ImageFormat.Bmp;
options.Quality = 100;
// this screws up the chart
asposeChart.Calculate();
asposeChart.ToImage(“e:\test2\out1.bmp”, options);

I have logged a ticket with an id “CELLSNET-44803” for your issue. We will look into it soon.

Once we have an update on it, we will let you know here.

Thank you.
Hi again,

This is to update you that we have resolved the problem logged earlier as CELLSNET-44803. We will shortly provide the next revision of Aspose.Cells for .NET here for your testing.

Hi,


Please try our latest version/fix: Aspose.Cells for .NET v16.11.2 (attached).

Let us know your feedback.

Thank you.

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


This message was posted using Notification2Forum from Downloads module by Aspose Notifier.