Border

This class represents the border of an object.

Properties

Color through getColor

HasBorder through hasBorder and setBorder

InnerLineWidth through getInnerLineWidth and setInnerLineWidth

OuterLineWidth through getOuterLineWidth and setOuterLineWidth

InnerOuterDistance through getInnerOuterDistance and setInnerOuterDistance

Access
  • To get borders of a spreadsheet range, use the borders method in the Range class.
  • To get borders of a table, use the borders method in the TextTable class.
  • To get borders of a table cell, use the borders method in the TextTableCell class.

Usage

When setting width for the inner line or outer line, or setting distance between the inner line and outer line in 1/100th mm, the value of the width or distance is converted to a internal value in twip (1 inch = 1440 twips) which is the internal unit for this property in Lotus Symphony. When getting the width or distance, the internal value in twip is converted to a value in 1/100th mm and the value in 1/100th mm is returned to the user. So the value you get from the width or distance maybe different (a little larger or smaller) from the value you set to the width or distance. The following is the macro of converting a value in twip to 1/100th mm:

((TWIP) >= 0 ? (((TWIP)*127L+36L)/72L) : (((TWIP)*127L-36L)/72L))

The following is the macro of converting a value in 1/100th mm to twip :

((MM100) >= 0 ? (((MM100)*72L+63L)/127L) : (((MM100)*72L-63L)/127L))

See examples

Example: Border