Chart-image issues

Aspose.Cells Product Family
1
We use Aspose Cells 2.5.2 (instead of current version Aspose 2.5.4) because of some issues in 2.5.4

In both versions I found following issues:
When I save a chart with #NV values to an Image, the series with the #NV value does not have thousand-seperators and the datalabel has no text.
(
see attachment: barcharts.zip
e.g. "tom" 2. bar has no label
e.g. "spontaneous awareness" has a label "1100" instead of "1.100"
)

I also found out, that when I invoke "chartPoint.getDataLabels()" no thousand-seperator is beeing displayed in the image (see attachments: stackedcharts.zip)

In a stacked bar diagram the legend order in the image is different to the legend order in the excel file
(
see attachment: stackedcharts.zip
"Total" is in the image on first position, in the excel at last position
)

In 2.5.4 the thousand-seperator does not care about local number formatting :
I set the workbook-locale to German and English, but the datalables in both chart-images have the same number formatting (1.000,00)
This worked in 2.5.2 (see attachment: barcharts.zip)

Please provide us a solution for that
2

Hi,

Thanks for posting the problem.

I can found the problems with the latest version Aspose.Cells for Java v2.5.4.12. We will investigate this issue and provide you a fix asap.

This issue has been logged as CELLSJAVA-28982.

3

Hi,


I have another problem with the image-quality. I tried improve the quality for JPG and PNG with the following methods, but could not recognize any difference

imgOpts.setFashion(FileFormatType.UNKNOWN);
imgOpts.setQuality(100);
imgOpts.setHorizontalResolution(2048);
imgOpts.setVerticalResolution(1536);

and
imgOpts.setFashion(FileFormatType.UNKNOWN);
imgOpts.setQuality(1);
imgOpts.setHorizontalResolution(400);
imgOpts.setVerticalResolution(300);

(See attachment barchart_quality.zip)
4

Hi,

I have also forwarded this question of yours to our development team. We will update you once we will get any input from them.

5

Hi,


How long do you think does it take to get a fixed version for all the issues?
6

Hi,

We are still working on these issues and will try to provide a fix in this week which may improve the generated image for chart.

For the quality of generated image, we are afraid we cannot support it soon. Currently the quality options take effect only for converting sheet to images.

7

Hi!

During my tests I found another issue like this.
I attached a .ppt showing a dark image where parts of it seem missing or merged together at the left side.

Looking forward to your reply.

8

Hi,

Thanks for your feedback. We have logged your comment. We will update you asap.

9

Hi again!
Another issue occured today: One specific chart is cropped slightly, so part of the text is missing.
(refer to attachment: right chart, left border - next to the dark brown piece of the cake)

Can you look at this too?
Looking forward to your reply.

10
Hi,

We have fixed the issues of chart2image in your original post. For the issue of number format for locale German and English, We have tested 2.5.2 but get the same result with current versions.

We think maybe you used different locale settings for your jvm so that you can get the correct number format. Also, with recent versions/fixes, you can change locale for number formatting by calling following methods explicitly:

Workbook.getWorkbookSettings().setRegion(CountryCode.GERMANY);
Workbook.getWorkbookSettings().setLocale(...);
Workbook.getWorkbookSettings().setLanguage(...);
And for your latest two issues shown in ppt, we will look into it soon.

Download:
Aspose.Cells for Java (Latest Version)
11

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

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

Hi,
we still have the issue with poor results from the Chart.toImage()
functionality. Currently we are using Aspose Cells version 7.0.3 for JDK1.5.



I have found lots of threads regarding the same issues. We tried to use
EMF vector graphics with custom resolution but this produces the same
poor quality as regular image types like JPEG for example.

13

Hi,

Thanks for your feedback. I have reopened your issue. We will further look into it and update you asap.

Please also create a sample application to replicate the problem using the latest version:
Aspose.Cells for Java (Latest Version)
and post here. It will help us in investigation.

14

Hi,


Has this been addressed yet? I am having the same issue, makes no difference to the generated image any of the parameters regarding resolution or quality.

Please advice.

Thanks
15

Hi,

Thanks for your posting and using Aspose.Cells for Java.

Please provide us your project with input and output file. We will check it at our end and update you asap.

16

Hi, I can’t provide you with the project and there’s no input file, I generate the excel sheet in the code, fill the sheet with values and from that I generate the chart.

I save the image in .emf format, please find attached the image and find below part of the code for creating the image, the code BTW is in java.


Thanks a lot in advance.

17

Hi, just replied with the needed into in an email.


Please advice.

Thanks!
18

Hi,

Thanks for your posting and using Aspose.Cells for Java.

We do not find any issue with your given chart. If you are having problem, then create your charts in Ms-Excel manually and convert them into images. We will check your charts at our end. If you find any issue, let us know.

19

The problem is not the chart I sent, the problem is that the image size, weight and quality doesn’t change from quality 1 to quality 100. My question was if this bit was working or not

20

Hi,

Thanks for your posting and using Aspose.Cells for Java.

You are right. The image quality does not have any effect on the generated image. We have logged this issue in our database. We will look into this issue and resolve it. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSJAVA-40495.