B4J Question jPOI - Setting margins??

[Robert Valentino]

According to web searches the POI supports setting margins on the sheet level

But I am unable to find any routines to do this.

Has anyone been able to set margins?

 

[Erel]

'Margin: 0 = Left, 1 = Right, 2 = Top, 3 = Bottom, 4 = Header, 5 = Footer
Sub GetMargin(Sheet As PoiSheet, Margin As Short) As Double
   Dim jo As JavaObject = Sheet
   Return jo.RunMethod("getMargin", Array(Margin))
End Sub

Sub SetMargin(Sheet As PoiSheet, Margin As Short, Size As Double)
   Dim jo As JavaObject = Sheet
   jo.RunMethod("setMargin", Array(Margin, Size))
End Sub

 

[Robert Valentino]

Thanks so much.

Where would I find information on these fields (or rather what other fields are available - like setting Header / Footer fields

 

[DonManfred]

http://poi.apache.org/apidocs/index.html ?

 

[Robert Valentino]

Trying to setCenter which is part of the interface HeaderFooter Interface but get "setCenter" not found.

How do I point or direction this command to the right interface?

 

[Erel]

Please start a new thread in the questions forum. Post the API you are trying to call, with the code and the error message.