Hi,
Hi,
Thanks for your posting and using Aspose.Cells.
We were able to observe this issue after executing the following code using the latest version: Aspose.Cells
for Java v8.2.0.1. The exception occurs because of special characters in the worksheet name.
We have logged this issue in our database for investigation. We will look into it and fix this issue. Once the issue is resolved or we have some other update for you, we will let you know asap.
This issue has been logged as CELLSJAVA-40971.
Java
String filePath = “F:\Shak-Data-RW\Downloads\Copy+1.xlsx”;
Workbook workbook = new Workbook(filePath);
int rangeIndex = workbook.getWorksheets().getNames().add(“dummyrange”);
Name name = workbook.getWorksheets().getNames().get(rangeIndex);
name.setR1C1RefersTo(“'Allowed ‘();@&=+$,%#’!r1c1:r10c10”);
name = workbook.getWorksheets().getNames().get(rangeIndex);
Exception:
Exception in thread “main” com.aspose.cells.CellsException: Invalid formula.“'Allowed ‘();@&=+$,%#’!r1c1:r10c10”.
at com.aspose.cells.us.a(Unknown Source)
at com.aspose.cells.Name.setRefersTo(Unknown Source)
at com.aspose.cells.Name.setR1C1RefersTo(Unknown Source)
at ClsAsposeTest.f1(ClsAsposeTest.java:412)
at ClsAsposeTest.main(ClsAsposeTest.java:47)
Hi,
Hi,
Hi,
code with your newly attached template file. I noticed MS Excel prompts
“Excel found unreadable content…” error when opening the output file
into it.
e.g
Sample code:
String filePath = "Book1_Allowed.xlsx";
Workbook workbook = new Workbook(filePath);
int rangeIndex = workbook.getWorksheets().getNames().add("dummyrange");
Name name = workbook.getWorksheets().getNames().get(rangeIndex);
name = workbook.getWorksheets().getNames().get(rangeIndex);
workbook.save("out1.xlsx");
Hi,
Thanks for using Aspose.Cells for Java.
Please download and try this fix: Aspose.Cells for Java v8.2.1.4 and let us know your feedback.
The issues you have found earlier (filed as CELLSJAVA-41042) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by Aspose Notifier.
The issues you have found earlier (filed as ) have been fixed in this update. This message was posted using BugNotificationTool from Downloads module by MuzammilKhan