FIX: FormatString Ignored for Fixed Columns in MSHFlexGrid (197362)

RESOLUTION

Following are two alternatives, both of which have limitations:

If possible, use the Microsoft FlexGrid control. The FlexGrid control is not affected by this problem.
Avoid using fixed columns when using the Hierarchical FlexGrid.

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.

This bug was corrected in Visual Studio 6.0 Service Pack 3.

For more information about Visual Studio 6.0 Service Packs, please see the following articles in the Microsoft Knowledge Base:

194022 INFO: Visual Studio 6.0 Service Packs, What, Where, Why

194295 HOWTO: Tell That Visual Studio 6.0 Service Packs Are Installed

MORE INFORMATION

Steps to Reproduce Behavior

Create a Visual Basic Standard EXE Project. Form1 is created by default.
From the Project menu, choose Components and then select the Microsoft Hierarchical FlexGrid Control 6.0 (OLEDB). Click OK.
Place an instance of the Hierarchical FlexGrid on Form1.

Place the following code in the General Declarations section of Form1:

      Option Explicit

      Private Sub Form_Load()
         Dim strFormat As String
         ' The '^' in strFormat is a Center Justify instruction
         strFormat = "^AAA      |^BBBB      |^CCC      "
         MSHFlexGrid1.Rows = 10
         MSHFlexGrid1.Cols = 3
         For i = 0 To 9
            For j = 0 To 2
               MSHFlexGrid1.TextMatrix(i, j) = "XXX"
            Next j
         Next i
         MSHFlexGrid1.FormatString = strFormat
      End Sub