Aspose cells number not rendered and dialog box issue

Hi,
Converted excel showing # for numbers and dialog box is not converted properly,
please check these input/output files

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): CELLSNET-52678

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.

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): CELLSNET-52679

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.

@rutuja.mahajan,

Please notice, the two separate tickets for your mentioned issues are logged:

  • CELLSNET-52678 - Showing “#” for numbers in the converted PDF
  • CELLSNET-52679 - Dialog box is not converted into output PDF properly

We will evaluate both tickets and once we have an update on any of the issues, we will let you know.

@rutuja.mahajan
The problem described in CELLSNET-52679 is actually caused by ‘DialogBox’ not being rendered, which is a new feature and may take a long time to develop. Once progress is made, we will notify you as soon as possible.

@rutuja.mahajan

For numbers are displayed as #, only the first page you highlighted/commented has this problem, we will try to fix it. For other pages you highlighted/commented, the numbers are also displayed as # in the Excel generated pdf(Manually clear printarea for every sheet, then manually save to pdf in Excel).

Please let us know your feedback.

@rutuja.mahajan

This is to inform you that your issue CELLSJAVA-45200(old Id: CELLSNET-52678) has been resolved. The fix will be included in an upcoming release (Aspose.Cells v23.3) that we plan to release in the first half of March 2023. You will be notified when the next version is released.

The issues you have found earlier (filed as CELLSJAVA-45200(old Id: CELLSNET-52678)) have been fixed in Aspose.Cells for Java 23.3.

1 Like

Hi,
Now I am using the latest Aspose cells 23.3
Using java 8 on Windows system I have found different issues, please check these files Output_23.3.zip (8.7 MB)

Through code we are considering the printarea and onePagePerSheet is set to False.

@rutuja.mahajan

We can’t reproduce the issue by directly saving to pdf file: output.pdf (244.8 KB)

Workbook wb = new Workbook("PRV-MM-TQ-00015.xls");
wb.save("output.pdf");

Please share us your souce code if your code is different, and share us the generated pdf file generated by Aspose.Cells.

Hi,
It was not getting converted through Aspose, for this I have already raised ticket and provided the source code,

@rutuja.mahajan

We can’t reproduce the issue with your code on our side.
Also it seems that the pdf you shared is not generated by Aspose.Cells:
Screenshot_producer.png (36.5 KB)

Please share us the pdf file generated by Aspose.Cells.

Yes, it is not converted through Aspose, that is the issue, getting java.lang.Exception
I can not share generated PDF before that only I am getting exception.

Can you share latest Aspose cell 23.3 jar, in case it is not correct one which I have downloaded.

@rutuja.mahajan,
Please visit the link: Aspose.Cells | Excel Spreadsheet Processing Java Library

@rutuja.mahajan

I am a little confused.
What is the issue now on your side?

Please ignore this previous output zip it was not generated through Aspose.
Also the standalone program works fine but when I run in my project workbook.save throwing the exception, checking at my end.
Thanks.

@rutuja.mahajan
Is the issue of throwing exception same as Aspose Cells exception while converting XLS files ?
If you want to comfirm version , please use System.out.println( CellsHelper.getVersion());

Yes it is same. I will try this, thanks.

@rutuja.mahajan
We will close this topic and we can discuss the issue of throwing exception in another topic.

Yes, issue of throwing exception can be discuss on that topic, but keep this open for CELLSNET-52679 - Dialog box is not converted into output PDF properly