B4J Question jPOI : How to draw border on an empty cell?

[incendio]

Hello guys,

I have a borders style :

Private XLBorderS As PoiCellStyle
XLBorderS.Initialize(wb)
XLBorderS.BorderBottom = XLBorderS.BORDER_HAIR
XLBorderS.BorderTop  = XLBorderS.BORDER_HAIR

I want to draw top & bottom border, so it will look like this

Codes like this, will only draw border on cell C4

Private Sub SetStyleToRowCells(row As PoiRow, style As PoiCellStyle)
    For Each cell As PoiCell In row.Cells
        cell.CellStyle = style
    Next
End Sub

Is it possible to draw border on cell A4 & cell B4 ?

 

[Erel]

row.Cells returns a List of the non-empty cells. You should instead use row.GetCell. If the cell returned is not initialized then create a new cell. Now add the style to the existing or new cell.