Shape absolute positioning

Aspose.Cells Product Family
1

Hello


Can you help me please with following task:
I need to receive a absoluting position of image, but methods getLeft and getTop returns paddings in cell. (Source code presented below)

public void imagesTest() throws Exception{
Workbook wb = new Workbook(“D://img.xlsx”);

Worksheet ws = wb.getWorksheets().get(0);

Shape image = ws.getShapes().get(0);

System.out.println("Left "+image.getLeft());
System.out.println("Top "+image.getTop());
System.out.println("Width "+image.getWidth());
System.out.println("Height "+image.getHeight());
}

Best regards. Alexey
2

Hi Alexey,

Thanks for your posting and using Aspose.Cells.

Kindly explain the absolute positioning in terms of Excel in some screenshot so that we could log a New Feature request for this issue.

It will help us look into your requirements closely and we might be able to implement it in our future releases.

3

Hello.


In my example i need some methods, that should return

System.out.printlt(shape.getAbsoluteTop())
//Should prints some like “91” - 3 is padding in cell and 88 is top of upperleftrow

System.out.println(shape.getAbsoluteLeft())
//Should prints some like “20” - 20 is padding in cell and 0 is left of upperleftcolumn (because columns A,B,C are hidden)

There is exists some like this methods?

(I have attached image with measurements)

Best regards. Alexey

4

Hi Alexey,

Thanks for your screenshot explaining your requirement and using Aspose.Cells.

We have logged a New Feature request for this issue. We will look into it and implement it if possible. Once, it is implemented or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSJAVA-40955.

5

Hi,

Thanks for using Aspose.Cells for Java.

Please download and try this fix: Aspose.Cells for Java v8.2.0.1 and let us know your feedback.

We have added two methods for your requirement for your needs.

Shape.getLeftToCorner()/getTopToCorner()

6

The issues you have found earlier (filed as CELLSJAVA-40955) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.