Article Details
Id:19959
Product:finPOWER Connect
Type:FIX
Version:4.00.01
Opened:08/02/2023
Closed:09/02/2023
Released:20/03/2023
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.