Hi,
I am trying to translate excel file into pdf, but i’m getting
“com.aspose.cells.CellsException Invalid sheet reference for the defined Name” exception.
Probably because excel file has reference to other file that doesn’t exist. I am wondering if there is a possibility to ignore such exceptions and just leave blank cell where invalid reference exist?
I am alos sending you excel that is causing a problem Test Excel.zip (45.6 KB)
Thanks and kind regards,
Uros
Thanks for the template file.
Please notice, I am able to reproduce the issue as you mentioned. I found an exception “com.aspose.cells.CellsException: Invalid sheet reference for the defined Name” when trying to render your Excel file to PDF file format. I have logged a ticket with an id “CELLSJAVA-45021” for your issue. We will look into the details of the issue.
Once we figure it out or we have an update on it, we will let you know.
This is to inform you that your issue has been resolved now. The fix will be included in our upcoming release (Aspose.Cells v23.1) which is scheduled in the first half of January 2023. You will be notified once the next release is published.
The issues you have found earlier (filed as CELLSJAVA-45021) have been fixed in Aspose.Cells for Java 23.1.