Free Support Forum - aspose.com

Quotes appear in formula

Hi,
In excel file, there is a formula which don’t have quotes when opened with MS Excel 2016, but there are quotes in formula when extracted through aspose cells. Can you help me with this? I am using aspose cells for java 18.8.0.

String path = "navodnici.xlsx";
Workbook workbook = new Workbook(path);
Worksheet worksheet = workbook.getWorksheets().get(0);
Cell cell = worksheet.getCells().get("A1");
System.out.println(cell.getFormula());

Desktop.zip (15.9 KB)

Excel file and screenshot are attached to the post.

Regards,
Zeljko

@Zeljko,

Thanks for the template file and sample code.

After an initial test, I am able to observe the issue as you mentioned by using your sample code with your template file. I found that quotes appear in the formula when retrieving the cell formula via Aspose.Cells APIs. I have logged a ticket with an id “CELLSJAVA-42725” for your issue. We will look into it soon.

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

@Zeljko,

This is to inform you that we have fixed your issue (logged earlier as “CELLSJAVA-42725”) now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

@Zeljko,

Please find attached the latest version/fix: Aspose.Cells for Java v18.9.3

Your issue should be fixed in it.

Let us know your feedback.
Aspose.Cells for Java_v18.9.3.zip (6.3 MB)

The issues you have found earlier (filed as CELLSJAVA-42725) have been fixed in Aspose.Cells for Java 18.10. You can also get the latest Aspose.Cells for Java version from Maven repos. with simple configurations. Please see the document for your reference: https://docs.aspose.com/display/cellsjava/Installation

This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi