Printing MS Excel charts - various formatting issues for rendering in Java

Aspose.Cells Product Family
1

Dear Aspose Support Team

The attached file PrintIssuesCharts.xlsx has been created with Aspose.Cells (V 20.9.7). When the file is opened in Excel, it looks as desired (see also Screenshot_Excel_OK.PNG). However, when the file is printed directly from Aspose.Cells (e.g. to Microsoft Print to PDF), there are a few issues (see also Print.pdf and Screenshot_Print_PDF_not_OK.PNG):

  1. the label (3%) of the pie chart is overlapping with the chart title
  2. the category labels of the bar chart are much narrower (and the chart itself much wider)
  3. the lower borders are not properly aligned
  4. some of the lines in the bar chart are not straight

We would expect the file to be printed as it is shown in Excel.

PrintIssuesCharts.zip (760.3 KB)

2

@awepler,

Please notice, I am able to reproduce the issues as you mentioned by using the following sample code with your template file. I all your mentioned issues as per the screenshots:
e.g.
Sample code:

Workbook workbook = new Workbook(filePath);
com.aspose.cells.ImageOrPrintOptions printOptions = new com.aspose.cells.ImageOrPrintOptions();
com.aspose.cells.WorkbookRender wr = new com.aspose.cells.WorkbookRender(workbook, printOptions);

wr.toPrinter("Microsoft XPS Document Writer");

I have logged a ticket with an id “CELLSJAVA-43316” for your issue. We will look into it soon.

Once we have an update on it, we will let you know.

3

Do you already have any plans by when this will be fixed? Can we expect it in the next release? We have a big reporting beginning of November; it would be great if this works by then. Thank you for a short reply.

4

@awepler,

I am afraid, your issue is not resolved yet. We have logged your concerns into our database and we will try to fix the issue soon. Also, we will check if we can provide you an ETA on it (if it is going to take more time).

5

@awepler,

Please try our latest version/fix: Aspose.Cells for Java 20.10. Third and fourth issues are fixed in it. We are on first two issues.

Let us know your feedback.

6

Thank you for your support. Third and fourth issues are working fine with the new version. We are looking forward to the resolution of the first two issues.

7

@awepler,

Thanks for your feedback.

Once the first two issues are resolved we will update you.

8

@awepler,

The first two issues are also resolved now. We will provide the new fix in the next few days after we have performed QA and including other enhancements and fixes.

9

Thank you for the information. Can you give an estimate by when you will be able to provide the fixed version?

10

@awepler,

We will try to provide the fixed version in the next couple of days for your issue(s).

Please stay tuned.

11

@awepler,
Please try our latest version/fix: Aspose.Cells for Java v20.10.7:
aspose-cells-20.10.7-java.zip (7.2 MB)

Your issue should be fixed in it.

Let us know your feedback.

12

We have tested with the provided version. All four issues seem to be resolved now. Thank you.

13

@awepler,

Good to know that all your issues are fixed. In the event of further queries or issue, we will be happy to assist you soon.

14

The issues you have found earlier (filed as CELLSJAVA-43316) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi