Set shape's input range wrong

Workbook wb = new Workbook("C:/S.xlsx");
Shape shape = wb.getWorksheets().get(0).getShapes().get(0);
System.out.println(shape.getInputRange());
shape.setInputRange("$C$2:$C$4");
System.out.println(shape.getInputRange());
wb.save("C:/S2.xlsx");


The input range of shape in S2.xlsx is $C$2

Hi,


Thanks for your posting and using Aspose.Cells.

We were able to observe this issue and logged it in our database for a fix.

This issue has been logged as

  • CELLSJAVA-42225 - Unable to set Shape Input Range

Hi,

Thanks for your posting and using Aspose.Cells.

It is to update you that some additional data is added since Office 2013. We do not support them now. We will fix this bug in the next month.
Hi,

Thanks for using Aspose.Cells.

This is to inform you that we have fixed your issue CELLSJAVA-42225 now. We will soon provide the fix after performing QA and including other enhancements and fixes.
Hi,

Thanks for using Aspose.Cells.

Please download and try the following latest fix: Aspose.Cells for Java v17.3.8 and let us know your feedback.

The issues you have found earlier (filed as CELLSJAVA-42225) have been fixed in Aspose.Cells for Java 17.4.0.


This message was posted using Notification2Forum from Downloads module by Aspose Notifier.