Posted 8 September 2017, 3:10 pm EST
I am opening an excel template into spreadsheet and then programmatically adding a shape to it. I am using the overload AddShape(shape,int ,int). For some templates the shape is not aligned with the cell border.
Please find the attachment for more details, I was expecting the shape border aligned with the horizontal line between column 40 and 41.
What can be the reasons for this? I have checked if the template has any hidden columns or if it is considering wrong row column, but I am not able to find a solution. Is there any way I can find the coordinates of the cell?