Hi Aspose Team,
In case of merged cells in GridWeb,when we enter a formula (eg: “=E4”).The result of formula execution takes reference of wrong cell.
The behavior in excel is different from that in GridWeb.
Test Excel attached.
Steps to test the scenario
(Kindly refer to Screenshot and test excel to reproduce below given points)
1. In Test Excel attached,in cell B6 I have written formula =“E4”.The formula execution results in “)”.[Refer Test Excel]
2. In GridWeb Screenshot attached,in cell C7 I have written formula = “E4”.The formula execution results in “-44608” instead of “)” which is different from excel behavior.[Refer screenshot]