Posted 30 January 2025, 2:59 am EST
Hi,
We have successfully reproduced the reported issue in SpreadJS version 17.0.4.
Root Cause Analysis:
The issue arises due to how formulas are applied to shapes in SpreadJS. Currently, SpreadJS does not support applying reference formulas directly to shapes, and this feature request is present in our product backlog with internal tracking id SJS-26669.
In Excel, when a formula is applied to a shape, the formula is bound to the shape itself.
However, in SpreadJS, applying a formula while a shape is selected results in the formula being assigned to the cell beneath the shape, rather than the shape itself.
Resolution:
This bug has been fixed in latest version of SpreadJS V18.0.2 . We recommend updating to the latest version to ensure proper functionality and avoid this issue.
We hope this information helps. Please let us know if you need any further clarification.
Best Regards,
Ankit