We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

IllegalArgumentException Aspose.cells for Java

Hello,
we are trying Aspose.Cells and Aspose.Slides for java for a possible purchase.
We have a problem with the new version of Aspose.Cells (the 2.2.1) while creating a chart from an excel file, the code is as follows :

ImageOptions imgOpts = new ImageOptions();
imgOpts.setImageFormat(ImageFormat.PNG);
imgOpts.setFashion(FileFormatType.EXCEL97TO2003);
fileName = sourceFilename + “-chart-” + i + “.png”;
chart.toImage(fileName, imgOpts);

where sourceFilename is “TestSlide_003.xls” and i is a counter whose value is 0, so the complete fileName will be : TestSlide_003.xls-chart-0.png

When the application executes the chart.toImage call we receive the following exception :

Error: Invalid substring range
java.lang.IllegalArgumentException: Invalid substring range
at java.text.AttributedString.(AttributedString.java:225)
at java.text.AttributedString.(AttributedString.java:187)
at com.aspose.a.i.b(Unknown Source)
at com.aspose.a.h.b(Unknown Source)
at com.aspose.a.h.a(Unknown Source)
at com.aspose.a.h.c(Unknown Source)
at com.aspose.a.h.a(Unknown Source)
at com.aspose.a.h.a(Unknown Source)
at com.aspose.a.c.a.a(Unknown Source)
at com.aspose.cells.Chart.toImage(Unknown Source)
at it.softsolutions.bvdealer.presentation.SlideGenerator.getFromDataSource(SlideGenerator.java:1329)
at it.softsolutions.bvdealer.presentation.SlideGenerator.(SlideGenerator.java:138)
at it.softsolutions.bvdealer.presentation.SlideGenerator.main(SlideGenerator.java:1171)

Attached you will find the original xls file. We are trying to convert to an image the chart “Monthly Volume -€ Millions”. Can you help us with it?

This error does not happen with the previous version of Aspose.Cells, the 2.2.0 . With it we have another problem : the image x-axis values are not the same as those of the excel original chart. Is this a known problem? Has it been resolved in the 2.2.1 release?

Thanks in advance for your help,
greetings,
Ruggero Rizzo.


Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Thank you for sharing the template file.

We have found your mentioned issue after an initial test. Your issue has been registered in our internal issue tracking system with issue id: CELLSJAVA-17403. We will look into it and get back to you soon.

Thank You & Best Regards,

Hi,

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Please try the attached latest version of Aspose.Cells. We have fixed your mentioned issue.

Thank You & Best Regards,

Thank you,
tomorrow we will try this new version, we will let you know the result!

Bye,
Ruggero Rizzo.

Hello,
everything works fine, thank you very much.

Ruggero Rizzo.

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


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