Free Support Forum - aspose.com

Excel to PDF conversion problems in Aspose.Java

Hi,

Following are some issues found initially in Aspose.NET (follow link) and reproduced also in Aspose.Java!


1 - Cross.xls

Incorrect Shape Rendering : the resulted PDF has a trimmed shapes with a part of the check not shown.

2 - Checkbox.xls

Checkboxes are miss-aligned. On the source file checkbox is aligned on the left, while on the resulted PDF a strange behavior of alignment is occurring.

3 - text cropped bottom.xls

Text cropped: The title has been cropped on Line 8.

4 - arrows-text-margin.xls

A lot of errors!
  • Sheet 1
    • Page 1
      • Rectangle Shifted
      • Yellow arrow clockwise inverted
      • Text with numbers shifted
      • Text wrap : photo (1)
    • Page 2
      • Red arrow clockwise inverted
      • end text overlapped
  • Sheet 2
    • Triangle over text and not-aligned with text
  • Sheet 3
    • Page 1
      • Text missing : "Rapprocher"
    • Page 2
      • Red arrow clockwise inverted
  • Sheet 4
    • Red arrow clockwise inverted

6 - text on drawing.xls

Text is not aligned in circle,triangle,hex..

That's all for this thread, please take time to answer for all points mentioned above.



Greetings,

Mohammad

PS. I'll attach only resulted PDF files, you can find original excel files used by following the .net ticket

Hi Mohammad,


Thank you for contacting Aspose support.

We are looking into your presented scenario against the latest version of Aspose.Cells for Java 8.1.1.4. We will shortly get back to you with updates in this regard.

Hi Mohammad,


Thank you for your patience.

We have evaluated your presented scenarios on our end while using the latest version of Aspose.Cells for Java 8.1.1.4. A few of the mentioned issues didn’t replicate as we have recently upgraded the Java version of the API. Moreover, regarding the cropped text for the merged cells, you have to call Worksheet.autoFitRows before exporting the spreadsheet to PDF format as demonstrated below.

Java

Workbook book = new Workbook(myDir + “text+cropped+bottom.xls”);
Worksheet sheet = book.getWorksheets().get(0);
AutoFitterOptions options = new AutoFitterOptions();
options.setAutoFitMergedCells(true);
sheet.autoFitRows(options);
book.save(myDir + “text+cropped+bottom.pdf”, SaveFormat.PDF);

Issues that didn't reproduce with Aspose.Cells for Java 8.1.1.4 are as follow. Please check the attached resultant PDF file for your reference.

  1. Rectangle shifted
  2. Text "Rapprocher" missing

Issues that reproduced, and have been logged in our bug tracking system are as follow.

  1. CELLSJAVA-40911: Text is not aligned in side the shape
  2. CELLSJAVA-40912: Check boxes are not aligned properly
  3. CELLSJAVA-40913: Arrow direction has changed
  4. CELLSJAVA-40914: Incorrect shape rendering (cropped shape)
  5. CELLSJAVA-40915: Shape overlapping the text
  6. CELLSJAVA-40916: Text outside of the page break is rendered as wrapped text
  7. CELLSJAVA-40917: Missing dots/dotted lines

We have attached all above tickets to this thread for future correspondence in this regard. Please spare us little time to properly analyze the mentioned problems, and to provide a fix at earliest possible. In the meanwhile, we will keep you posted with updates in this regard.

The issues you have found earlier (filed as CELLSJAVA-40915;CELLSJAVA-40914;CELLSJAVA-40912) have been fixed in this update.


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

Hi,


Please try our latest fix/version: Aspose.Cells for Java v8.3.0.1


We have fixed your issue "CELLSJAVA-40911" now.


Let us know your feedback.


Thank you.

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


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

Hi Mohammad,


Thank you for your patience with us.

Please try the latest version of Aspose.Cells for Java 8.4.2.1 against the tickets logged earlier as CELLSJAVA-40917 (Missing Dots/Dotted Lines when rendered to PDF) & CELLSJAVA-40916 (Text outside of the page break is rendered in PDF as wrapped).

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


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

@vdoc,

Please try our latest version/fix: Aspose.Cells for .NET v20.9.7 (attached)
Aspose.Cells20.9.7 For .Net2_AuthenticodeSigned.Zip (5.4 MB)
Aspose.Cells20.9.7 For .Net4.0.Zip (5.4 MB)
Aspose.Cells20.9.7 For .NetStandard20.Zip (5.4 MB)

Your issue “CELLSJAVA-40913” should be fixed in it.

Let us know your feedback.