Aspose cells gridweb wrong cell reference

Aspose.Cells Product Family
1

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.
Screenshot attached.
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]

Thanks,
Ved
2

Hi,

Thanks for your posting and using Aspose.Cells for GridWeb.

Please provide us your sample project replicating this issue. We will check it at our end. In case of error, we will fix it.