Problem while exporting to PDF

Aspose.Cells Product Family
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.

72

HI Aspose Team.

It’s much better with 7.0.4 version but still not usable for production usage.
Please check attached file for a new bug I’ve detected

As you can see in PDF file,
- some spaces are missing (employsapproximately5,400persons)
- Right margin is not correct (the “m” and “n” are truncate)
- A part of diagramm is missing (Civil part in this exemple)


source code :
Workbook book = new Workbook(“c:\test.xls”);
book.save(“c:\test.pdf”, FileFormatType.PDF);

Using .Cell 7.0.4 with JDK 1.4

Kind regards

73

Hi,


Thanks for the files,

I have managed to reproduce the 2nd and 3rd issues, the first is fine with v7.0.4.2 (latest fix).
e.g

- some spaces are missing (employsapproximately5,400persons) – OK
- Right margin is not correct (the “m” and “n” are truncate) – ISSUE
- A part of diagramm is missing (Civil part in this exemple) – ISSUE



I have logged them and reopened your existing issue "30972", we will soon look into it soon.

Thank you.
74

Hi,

Please try this new fix: Aspose.Cells for Java v7.0.4.7

We have fixed the issue about truncated ‘m’ and ‘n’, please try this new fix. For the issue of lost chart image, we are still working on it and we are afraid we need more time to fix it.

75

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

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

I’m really glad to know you have delete my previous post.

As you didn’t answered last time, can you confirm your fix doesn’t work with JDK 1.4 ?

Key features : Aspose.Cells for Java is available for Java 1.4 or 1.5 and will run wherever Java is installed

Kind regards

77

Hi,


Well, yes, Aspose.Cells for Java does support JDK1.4, 1.5, 1.6 or greater versions. Also, in general, all the features that the product supports would work (except for a few exceptional cases which are relevant to Fonts (issues)) fine on any JDK versions.

Thank you.
78

Well, I confirm you, your fix doesn’t work with JDK 1.4. As fonts are not the same between 1.4 and 1.5, we can say that the bug is due to fonts.

Last question:
In textbox, why line is not wrapped by works like in the xls file ?

79

Hi,


"Last question:
In textbox, why line is not wrapped by works like in the xls file ?"

Could you give us template file(s) and sample code to show the issue, we will check it soon.

Thank you.