Missing elements when extracting complex charts

We’re evaluating Aspose.Cells for both .NET and Java for extracting quite complex Excel charts.

In the attached file there’s a spreadsheet with a few charts. For testing purposes we extracted the first three in .NET and JAVA.
Following are the issues with generated images:

Chart 0:
- .NET - everything as expected, except missing TextBox on the right
- JAVA - missing TextBoxes on both sides + the legend is wrapped into one column and cropped

Chart 1:
- .NET - the legend is in one column
- JAVA - missing TextBox, legend in one column, cropped

Chart 2:
- .NET - missing TextBox
- JAVA - missing both TextBoxes

Additionally in all .NET images the TextBoxes at the bottom are almost out of the chart’s bounds.

The format we’re saving to is .emf, however the issue seems to us format-agnostic (extracted png looked the same)

Code we used for extracting (C#):
var workbook = new Aspose.Cells.Workbook(“c:/temp/clf_1.xlsx”);
var chart = workbook.Worksheets[“NAM Graphs”].Charts[0];
chart.ToImage(“c:/temp/chart_0_net.emf”, System.Drawing.Imaging.ImageFormat.Emf);

JAVA code looks very similar

Are these issues related with badly formated chart in excel, or rather bugs in aspose.cells?
Which Aspose.Cells version (JAVA or .NET) is more recommended for extracting complex charts (we can see differences between these two)?

Hi Tomasz,

Thanks for your posting and using Aspose.Cells.

We have tested these issues using the latest versions: Aspose.Cells
for .NET v8.0.1.3
and Aspose.Cells
for Java v8.0.1.3
and found them.

We have highlighted the issues in screenshots for a reference.

We recommend you to use latest versions, however these issues exist because of rendering bugs in Aspose.Cells.

We have logged these issues in our database for investigation. We will look into it and fix them. Once, these issues are resolved or we have some other update for you, we will let you know asap.

These issues have been logged as

  • CELLSNET-42613 - Missing elements when extracting complex charts
  • CELLSJAVA-40807 - Missing elements when extracting complex charts

I’ve prepared another set of extracted charts (both JAVA and .NET Aspose Cells)

Find in the package the source spreadsheet, extracted charts in .emf format, and comparision images (.png) showing found issues in corresponding charts.

There are a few issues, some of them are repeating:
- unequal allignment of axis values
- legend mark is not thick enough
- textboxes are placed wrongly, some overlap each other
- missing axis values
- different orientation of the legend
- unwanted space between axis values and the bound of chart
- wrong axis values

Hi Tomasz,

Thanks for your posting and using Aspose.Cells.

Please download and try the latest version: Aspose.Cells
for .NET v8.0.1.4
and Aspose.Cells
for Java v8.0.1.4
. It should resolve some of your issues.

Please create multiple threads for your multiple issues. Each thread should deal one issue at a time. A single thread is not suitable to resolve all of your issues. It will help us sort out your issues and fix them accordingly.

Thanks for your cooperation.

Hi,

Please try our latest version/fix: Aspose.Cells for .NET 8.2.1.2
We have fixed the issue "CELLSNET-42613" now. We fixed the missing “Operating Rate, %” text in the chart.

Let us know your feedback.

Thank you.

Hi Tomasz,


Please also try the latest version of Aspose.Cells for Java 8.2.1.2 against the problem logger earlier as CELLSJAVA-40807, and feel free to write back in case you face any difficulty.

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


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

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


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