Aspose Cells diagram circular annotation issue

Aspose.Cells Product Family
1

Hi,
We are using Aspose Cells 23.1 with JDK version 8 on CentOS 7.
We have installed all the basic fonts and msttcorefonts.

The circular annotations are missing in the diagram.

2

@rutuja.mahajan,

Thanks for the template file and screenshots.

We reproduced the issue as you mentioned using your sample Excel file(s). Circular annotations are missing in the diagram in Excel to PDF rendering. We are going to log appropriate ticket for your issue.

3

We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

  Issue ID(s): CELLSJAVA-45086

You can obtain Paid Support services if you need support on a priority basis, along with the direct access to our Paid Support management team.

4

@rutuja.mahajan

The diagram is an Emf image. The circular annotation only exists in EmfPlus records.
Please use the following code:

Workbook wb = new Workbook("Input.XLSX");
    
PdfSaveOptions pdfSaveOptions = new PdfSaveOptions();
pdfSaveOptions.setEmfRenderSetting(EmfRenderSetting.EMF_PLUS_PREFER);

wb.save("output.pdf", pdfSaveOptions);
5

Hi,
If I use this Emf render setting, it is creating invalid pdf not able to open it OR it is taking too much time to save pdf.
Input_with_Source_Code.zip (1.8 MB)

Can you please try this java code with this input file.

6

@rutuja.mahajan,
The results obtained by testing with Aspose Cells 23.1 with JDK 1.8 can be opened normally, and the whole process takes about 110 seconds. Attached are the test results. We will continue to track the issue. out_java.zip (768.7 KB)

7

Hi,

You mean you are going to improvise this process? OR will going to suggest any other option?
We can’t really implement this option, as it will delay our further dependent flow and will hold the user on UI till it gets complete.

9

@rutuja.mahajan
We have opened the following new ticket CELLSJAVA-45134 in our internal issue tracking system for this performance issue. We will try to improve performance for converting this file to pdf.

10

@rutuja.mahajan

I didn’t see remarkable performance difference before/after setting pdfSaveOptions.setEmfRenderSetting(EmfRenderSetting.EMF_PLUS_PREFER);, and the generated pdf file can be opened in Adobe Reader correctly.

After looking into the performance issue, there is a logo png image with large dimension(11811x4134) in the source file. After replace the image with the scaled dimension(200x70), the file can be converted in seconds.

Please check the attached file that the logo image is replaced: Input_replace_logo_image.zip (496.6 KB)

11

Hi,
With your input file it converts quickly. Have you changed the logo for all the sheets or any specific sheet only?

12

@rutuja.mahajan

I changed the underlying png image, it is for all the sheets.

1 Like
13

Thank you, we can close this topic now.

14

@rutuja.mahajan,

Thanks for your feedback.

It is nice to know that your issue is sorted out now. Feel free to write us back if you have further queries or comments, we will be happy to assist you soon.

1 Like
15