We evaluated your issue further.
At present, our UpperLeftRow, UpperLeftColumn, LowerRightRow, LowerRightColumn are determined according to the starting point and ending point coordinates of the shape drawn. This is consistent with the content of the Excel file. After opening the Excel file as a compressed package, the following content will be found in the drawing1.xml file (see the image for reference.
1.png (3.5 KB)
If the purpose is to obtain the position and size of the actual display area of the shape, these variables may not get the expected results.
The main reasons are as follows:
For regular shapes, the starting point is the upper left corner and the end point is the lower right corner. For irregular shapes, the start and end positions are not always in the upper left and lower right corners.
If the shape is in the group, there is no row and column information, only the offset relative to the upper left corner of the group. The offset information here records the offset value when the shape is not flipped or rotated. Therefore, UpperLeftRow, UpperLeftColumn, LowerRightRow and LowerRightColumn calculated by the offset value may not be consistent with the actual display.
We have plans to provide a method to obtain the actual area size and position of the shape, but this function is very complicated and is still under development.
We will notify you as soon as we make some progress.