Problem while exporting to PDF

Hi,

I currently encounter some problems while I'm trying to export attached file in PDF Format

The top chart make the application crash with following stacktrace, while the second and third items are not displayed.If I remove the first chart, the application doesn't crash but others chart aren't diplayed.

Here is my code :

try{

Workbook copy = new Workbook();

copy.open("Bugsheet.xls");

boolean isPdf = true;

if(isPdf)

copy.save("export.pdf", FileFormatType.PDF);

else

copy.save("export.xls", FileFormatType.EXCEL97TO2003);

}catch (IOException e) {

e.printStackTrace();

}

Stacktrace :

Exception in thread "main" java.lang.NegativeArraySizeException

at com.aspose.cells.a.a.b.o.b(Unknown Source)

at com.aspose.cells.a.a.i.e.a(Unknown Source)

at com.aspose.cells.a.a.i.b.a(Unknown Source)

at com.aspose.cells.a.a.b.o.a(Unknown Source)

at com.aspose.cells.a.a.b.b.a(Unknown Source)

at com.aspose.cells.a.a.b.n.a(Unknown Source)

at com.aspose.cells.a.a.b.b.a(Unknown Source)

at com.aspose.cells.a.a.b.f.a(Unknown Source)

at com.aspose.cells.a.a.b.b.a(Unknown Source)

at com.aspose.cells.a.a.b.s.a(Unknown Source)

at com.aspose.cells.a.a.b.b.a(Unknown Source)

at com.aspose.cells.a.a.b.s.a(Unknown Source)

at com.aspose.cells.a.a.b.b.a(Unknown Source)

at com.aspose.cells.a.a.b.s.a(Unknown Source)

at com.aspose.cells.a.a.b.b.a(Unknown Source)

at com.aspose.cells.a.a.b.s.a(Unknown Source)

at com.aspose.cells.a.a.b.b.a(Unknown Source)

at com.aspose.cells.a.a.b.s.a(Unknown Source)

at com.aspose.cells.a.a.b.b.a(Unknown Source)

at com.aspose.cells.a.a.b.s.a(Unknown Source)

at com.aspose.cells.a.a.b.b.a(Unknown Source)

at com.aspose.cells.a.a.b.s.a(Unknown Source)

at com.aspose.cells.a.a.b.b.a(Unknown Source)

at com.aspose.cells.a.a.b.s.a(Unknown Source)

at com.aspose.cells.a.a.b.b.a(Unknown Source)

at com.aspose.cells.a.a.b.s.a(Unknown Source)

at com.aspose.cells.a.a.b.b.a(Unknown Source)

at com.aspose.cells.a.a.b.s.a(Unknown Source)

at com.aspose.cells.a.a.b.b.a(Unknown Source)

at com.aspose.cells.a.a.b.s.a(Unknown Source)

at com.aspose.cells.a.a.b.b.a(Unknown Source)

at com.aspose.cells.a.a.b.s.a(Unknown Source)

at com.aspose.cells.a.a.b.p.a(Unknown Source)

at com.aspose.cells.a.a.b.b.a(Unknown Source)

at com.aspose.cells.a.a.b.s.a(Unknown Source)

at com.aspose.cells.a.a.b.b.a(Unknown Source)

at com.aspose.cells.a.a.b.s.a(Unknown Source)

at com.aspose.cells.a.a.b.b.a(Unknown Source)

at com.aspose.cells.a.a.b.g.a(Unknown Source)

at com.aspose.cells.a.a.j.w.a(Unknown Source)

at com.aspose.cells.a.a.i.b.a(Unknown Source)

at com.aspose.cells.a.a.j.k.a(Unknown Source)

at com.aspose.cells.iG.c(Unknown Source)

at com.aspose.cells.iG.b(Unknown Source)

at com.aspose.cells.Workbook.save(Unknown Source)

at TestExportPDF.main(TestExportPDF.java:14)

If I export to XLF format (isPdf =false) everything is Ok.

Using MS Excel 2002, Aspose.Cell 2.5.4, JDK 1.4

Kind regards, Guillaume

Hi,

Thanks for reporting this bug.

I was able to reproduce this bug with the latest version: Aspose.Cells for Java v2.5.4.14

We have logged this issue in our database. We will fix it asap.

This issue has been logged as CELLSJAVA-29285.

Ok thanks you Faiz

Hi,

Any news about this issue ?

Kind regards, Guillaume

Hi,

I am afraid, the issue is not yet resolved. I have also tested it with the latest version: Aspose.Cells for Java v2.5.4.15

I have added your comment, hopefully it will be fixed soon.

Hello

The situation starts to become very pressing and the bug delays of as much the deployment of our applications.

Would have an estimate of a date for possible a fix of the bug?

Very cordially

Hi,


We are working on your issue and hopefully, we can provide a fix for your issue within 3-5 days (on wards).

Thank you.

Hi,

Please try this new fix: Aspose.Cells for Java v2.5.4.18

Hi,

Thanks you for the fix, unfortunatly, it doesn't work perfectly.

The top left chart seems to be larger in the pdf file than in xls. Since there are other items near it, they are not displayed.

The chart at right works fine.

The final text item is still not displayed

Good point, the export doesn't crash the application any more.

Kind regards

Hi,

Thanks for your feedback. We have added your comment in our database. Once the issue is resolved or we have any update, we will let you know.

Hi,

For the first chart image, we do not find any extra items near it. Please show
us the screenshot for difference between pdf and excel.

For the shape
with text, it is an unsupported shape object for current aspose.cells(neither a
TextBox nor a simple Rectangle which we support currently). I am afraid we
cannot support it soon.

Dear all,

Please check the attachment file for difference I noticed between XLS and PDF.

Since I'm not an XL expert, is it possible to automatically convert the text box into another supported item ?

Kind regards

Hi,

Unfortunately, we cannot support textbox or a simple rectangle soon in pdf rendering.

Ok for textbox.

What about the chart's size ?

Hi,

It looks ok to me. Please see the output pdf.

Do you find any problem? Please make a screenshot and highlight the problems with dark red circles.

Please download the latest version:
Aspose.Cells
for Java v2.5.4.19

Hi,

As I told you, the first XLS file I send you was not in his original context.

In the full XLS file, there are a lot of others items near not-supported items.

Please check to screen attached, black borders and blue cells are partially or totally hidden because of the size of chart. Indeed, there is a lot of white space around chart itself that doesen't exists in XLS format

Kind regards

Hi,

Thanks for screenshot. Please also attach your full xls file.

Here is the original XLS file (without the data which are not in keeping with the bug)

Hi,

We will try to provide a new version in this month. The new version will solve this issue, also it will support more shapes for toImage/Pdf feature, including the text object in your current template file.

Hi,

Good news !