Has anyone gotten TableBorder to work putting a border around a range of cells?
From what I read this should work but I don’t see a border when run.
aRange = ThisComponent.CurrentController.ActiveSheet.getCellRangeByName("B2:C3")
setRangeBorder(aRange)
Sub setRangeBorder(oRange) ' doesn't seem to be working for me, don't see why
Dim oBorder, oTBorder
oBorder = CreateUnoStruct("com.sun.star.table.BorderLine")
oBorder.Color = RGB(150, 150, 150)
oBorder.OuterLineWidth = 35
oBorder.InnerLineWidth = 35
oBorder.LineDistance = 3
oTBorder = CreateUnoStruct("com.sun.star.table.TableBorder")
oTBorder.IsLeftLineValid = True
oTBorder.IsTopLineValid = True
oTBorder.IsRightLineValid = True
oTBorder.IsBottomLineValid = True
oTBorder.LeftLine = oBorder
oTBorder.TopLine = oBorder
oTBorder.RightLine = oBorder
oTBorder.BottomLine = oBorder
oRange.TableBorder = oTBorder
End Sub
I’m hoping someone will show me the error of my ways or point me towards a working example.
To further complicate matters, Pitonyak’s OOME Listing 411 when I run it doesn’t give me the blue boxes only 2 red lines. Can there be something I’ve set to prevent it from running for me as it did for him?
Thanks,
Mike