FIX4.00.01 · Released 20 March 2023
FIXfinPOWER Connect
Released in
4.00.01
20 March 2023
  1. Opened8 Feb
  2. Closed9 Feb
  3. Released20 Mar
Article 19959 Job J030442

Word Documents; enhanced how Borders work for the overall Summary Table

There are several ways to use borders in Summary Tables in a Word Document. Note, some functionality has been obsoleted or removed in finPOWER Connect version 4 so the changes noted below have been made to simplify coding.

To set the border to red on the overall Table you should use code similar to the following:

With SummaryTable.WordDocumentOptions
    .SetBorders(iseWordDocumentSummaryTableBorder.All, "RED")
End With

BUT, this will only set the outside border of the entire table.

To set the borders of the inside cells you can use the SetBordersCells function after creating the table and its contents:

SummaryTable.WordDocumentOptions.SetBordersCells(iseWordDocumentSummaryTableBorder.All, "RED")

NOTE: This must be done after all rows have been added to the Table as it only updates existing cells.

In version 4.0.1 a new property "BordersAllIncludesInside" has been added to SummaryTable.WordDocumentOptions. This simplifies updating all borders by setting both the outside and inside cell borders for the entire table:

With SummaryTable.WordDocumentOptions
    .BordersAllIncludesInside = True
    .SetBorders(iseWordDocumentSummaryTableBorder.All, "RED")
End With

This "SetBordersCells" function can then be omitted.

NOTE: The following properties have been obsoleted, previously they were only commented as deprecated:

  • ISSummaryTableCellWordDocumentOptions
    • BorderColourResolved
      • Use Borders object and BordersEnabled property instead.
    • BorderWidth
      • Use Borders object and BordersEnabled property instead.
    • BorderWidthResolved
      • Use Borders object and BordersEnabled property instead.
    • BorderWidthPointsResolved
      • Use Borders object and BordersEnabled property instead.
  • ISSummaryTableWordDocumentOptions
    • BorderColourCellResolved
      • Use Borders object and BordersEnabled property instead.
    • BorderWidthCell
      • Use Borders object and BordersEnabled property instead.
    • BorderWidthCellPointsResolved
      • Use Borders object and BordersEnabled property instead.