Problem while exporting to PDF

Aspose.Cells Product Family
52

Hi,
I found another bug while exporting textbox to pdf, please see attachments

Locale.setDefault(Locale.US);
Workbook workbook = new Workbook(“c:\src.xls”);
workbook.save(“c:\out.pdf”, FileFormatType.PDF);

Aspose 7.0.1.2 / JDK 1.4

Kind regards

53

Hi,

I was able to replicate the problem using the latest version:
Aspose.Cells for Java v7.0.1.3


We have logged this issue. We will fix it and update you asap.

This issue has been logged as CELLSJAVA-30972.

Java


String path = “F:\Shak-Data-RW\Downloads\src.xls”;


Workbook book = new Workbook(path);

book.save(path + “.out.pdf”, SaveFormat.PDF);

54

Hi,
I don’t know if the new bug I found is linked to others, but, if it can help your investigations …
Please see atachments

Workbook workbook = new Workbook(“c:\src2.xls”);
workbook.save(“c:\out.pdf”, FileFormatType.PDF);

I noticed that if I change numbers alignments, they are showed normally.
Those numbers are not hand written but generated with datas from a db

.Cells 7.0.1.2 JDK 1.4

Kind regards

55

Hi,

Please see the output file, it appears to be fine. Please see both the source and output file.

I have tested it with latest version:
Aspose.Cells for Java v7.0.1.3

Java


String path = “F:\Shak-Data-RW\Downloads\src2.xls”;


Workbook wb = new Workbook(path);


wb.save(path+".out.pdf");

56

Hi, it seems to be Ok with 7.0.1.3, gonna test previous bugs

57

Hi,

Please download: Aspose.Cells for Java v7.0.1.6

We have fixed the issue of line break for the content of textbox.

For the issue of font underline, I am afraid it is only supported by JDK1.6 and later. For JDK1.5 and prior versions, setting underline attributes for java.awt.Font takes no effect.

For the issues of larger gap between characters(looks like extra spaces), we are still working on them and I am afraid we need more time to fix it.

58

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

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

Hi Aspose team.

Since another PDF export problem.

Well, the export of my full of data book doesn’t work. So, I returned to bases :

Workbook book = new Workbook();
book.getWorksheets().get(0).getCells().get(“A1”).putValue(“test”);
book.save(“c:\dest.pdf”, FileFormatType.PDF);

I’m tried with JRE 1.6_u26 and JRE1.4.2_11
I tried with Aspose .Cells v :
-7.0.0.3
-7.0.1.1
-7.0.1.2
-7.0.1.3
-7.0.1.5
-7.0.2

Since v7.0.1.2 (included) the generated pdf with code above doesn’t work : when I try to open it with acrobat reader I get following error : 14

Kind regards


Edit : I just remember the Local French issue - I turn into Local US and it works with v7.0.2
I though it was fixed

60

Still trying to generate my pdf file …

While using Acrobat reader pro to convert my xls file into pdf, a warning poped telling me it should be convert to PDF 1A-b format.

I tried to set the Compliance in Aspose, but I get an Exception I don’t understand. please check following code and Exception

Workbook bookSrc = new Workbook(fileName+".xls");
PdfSaveOptions save = new PdfSaveOptions();
save.setCompliance(PdfCompliance.PDF_A_1_B);
bookSrc.save(fileName+".pdf", save);

com.aspose.cells.CellsException: can’t parse argument number 0:yyyy-MM-ddTHH:mm:ssZ
at com.aspose.cells.wU.a(Unknown Source)
at com.aspose.cells.Workbook.a(Unknown Source)
at com.aspose.cells.Workbook.save(Unknown Source)
at PDF.ConvertPDF.main(ConvertPDF.java:23)

thank you

61

I got the same problem!

62

Hi Kristof,


Please give us more details about the issue, attach your Excel file, output PDF file, sample codes etc… Also give us your environment details, e.g OS, locale settings, JDK version etc. We will check it soon.
63
Amjad Sahi:
Hi Kristof,

Please give us more details about the issue, attach your Excel file, output PDF file, sample codes etc.. Also give us your environment details, e.g OS, locale settings, JDK version etc. We will check it soon.


What about PDF Compliance exception ?
64

Hi Bnpparis!

We have found and solved the issues mentioned in this thread, and will provide the fiix in 2~3 days.

Thanks

65

Hi,


Please try the new fixed version: v7.0.2.3. We have fixed the issues now.


Thank you.

66


Hi Aspose team

Amjad Sahi:
Hi,

We have fixed the issues now.




I don’t think so…

I’m using .Cells 7.0.2.3 with JRE 1.4, with following code :
Locale.setDefault(Locale.US);
CellsHelper.setFontDir(“c:\windows\fonts”);
Workbook bookSrc = new Workbook(fileName+“.xls”);

PdfSaveOptions save1 = new PdfSaveOptions();
save1.setCompliance(PdfCompliance.PDF_A_1_B);
bookSrc.save(fileName+“1.pdf”, save1);

PdfSaveOptions save2 = new PdfSaveOptions();
bookSrc.save(fileName+“2.pdf”, save2);

Attached files :
- test.xls : source file
- test1.pdf : generated file using aspose with PdfCompliance.PDF_A_1_B
- test2.pdf : generated file using aspose without PdfCompliance.PDF_A_1_B
- test Good.pdf : generated file using acrobat reader pro

While test1 or test2 is not equals to test Good, we cannot consider issues are fixed.

Another detail, I ticked the “private” check box - the thread is public now …

Kind regards

67

Hi,


Thanks for providing us sample files and give us your feedback.

We will look into it soon. Once we have any update about it, we will share it here immediately.

Thank you.


68

Any news since 3 weeks ?

69

Hi,


We are still evaluating those issues. We will try to provide a fix to remove those blocks in the generated pdf soon. But for the underline, because font's underline only can be supported by JDK1.6 and later versions, we are afraid currently we cannot make it display in PDF for JDK14.

Thank you.

70
Hi,

Please try the attached version/fix: v7.0.3.3.
We have fixed the issue of blocks in the generated file.

Thank you.
71

The issues you have found earlier have been fixed in (v7.0.4) this update.