Hi,
I am using Aspose.Cells v8.5.2.4
The attached workbook contains a sheet with name like Sheet1 & space ’ here
If we specify the format like ‘Sheet 1 & space ’ here’!R1C1:R2C2
in the name.setR1C1RefersTo API,we get the exception
com.aspose.cells.CellsException: Invalid formula:"=‘Sheet1 & space ’ here’!r1c1:r2c2".
Code snippet :
int rangeIndex = workbook.getWorksheets().getNames().add(“dummyrange”);
Name name = workbook.getWorksheets().getNames().get(rangeIndex);
name.setR1C1RefersTo(R1C1pattern);
name = workbook.getWorksheets().getNames().get(rangeIndex);
Can you verify this issue.
–Jaspreet