B4J Question JPOI Set cell Width

[micro]

Hi to all
How I can set the cell Width?
The PoiCellStyle has only the property Height
Thanks

 

[Erel]

Cells do not have a width of their own.

Sheet.SetColumnWidth(0, 1000) 'set the width of the first column

 

[Daestrum]

As a side note, from the Javadoc, the width value is in units of 1/256th's of a character width, ie 256 = 1 character wide
(unless the library has changed that )

 

[micro]

Cells do not have a width of their own.

Sheet.SetColumnWidth(0, 1000) 'set the width of the first column

As a side note, from the Javadoc, the width value is in units of 1/256th's of a character width, ie 256 = 1 character wide

Thanks

 

[Erel]

As a side note, from the Javadoc, the width value is in units of 1/256th's of a character width, ie 256 = 1 character wide

It should appear in the built-in help: https://www.b4x.com/b4j/help/jpoi.html#poisheet_setcolumnwidth