We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Throwing "Unknown Function with id [257]" exception when saving file (2410)

Hi,

I am writing to you about a problem we encountered in working with MSO Excel documents using the Aspose Cells for Java 20.3.0 library. In particular, when we load an Excel document whose format is “.xls” and immediately (without any changes) try to save it, the exception “com.aspose.cells.CellsException: Unknown function with id [257] (” Based on Chart “at Sheet1! D 3)” is thrown.

I am enclosing the zip file with source code, as well as the source and target Excel files.

In the hope that together we will quickly overcome the problem!
Best regards!

Nenad

Source code and XLS files.zip (15.2 KB)

@zpredojevic,
I have tried to reproduce this issue using the latest version but could not reproduce it. Could you please try the following sample code using the latest version and share your feedback?

String sourceFileDirFile = "source\\";
File sourceFile = new File(sourceFileDirFile, "unknownFunction.xls");
Workbook excel = new Workbook(new FileInputStream(sourceFile));
String excelTargetFilePath = "target\\unknownFunction-done.xls";
excel.save(excelTargetFilePath, SaveFormat.EXCEL_97_TO_2003);

aspose-cells-20.9.8-java.zip (7.2 MB)

@ahsaniqbalsidiqui,

I tried with version 20.9.0 and everything works properly. Thank you for your help!

Best regards,
Nenad

@zpredojevic,

Good to know that your issue is sorted out by the new version/fix. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.