Matrix - Fixed number of columns

Comments

• AlexTZ

  October 2011 edited 3:09AM

  Hello,
  
  You may access the prepared matrix and do something with its columns (hide some, or adjust width). See the attached example which you can run from the Demo.exe.

  Two_Column_Dimensions.frx 6.4K
• Turntwo Folsom, CA

  October 2011 edited 3:09AM

  Thanks - that is helpful. I've managed to get the Matrix to extend the width of the screen now.
  
  I tried adding columns, and the columns are included (the Columns.Count is higher), but the Columns don't display. What do I have to set to get the added columns to display.
  
  I added them with Matrix1.ResultTable.Columns.Add(new TableColumn());
  
  I also tried,
  TableColumn col = new TableColumn();
  col.Visible = true;
  col.MaxWidth = 200;
  col.Width = 100;
  Matrix1.ResultTable.Columns.Add(col);
• Turntwo Folsom, CA

  October 2011 edited October 2011

  OK - kinda figured it out on my own (posting here for others who have similar requirements).
  
  Using Matrix1.Data.AddValues(), I could add columns of blank values. I wanted to add columns of 0.00 values, but the ManualBuild didn't have the calculated rows available to work with, and I think I needed the headings to get the 0s to show. I tried using AddValues in ModifyResult, but it didn't change anything. With blank values, the only issue I had was getting the blank headers at the end instead of the beginning, and I think I could have figured that out.
  
  Instead I left the extra areas blank by changing the column widths to a fixed value, and then calculating the width for the Total column (right-justified), as the remaining space (needed to increase the MaxWidth also). This lines up the columns across the different Matrixes, stretches them across the available area and gives me the look I needed (except missing the 0 columns, which is just clutter anyway).
  
  Thanks for the help.
  

  private void Matrix4_ModifyResult(object sender, EventArgs e)
      {
        Matrix4.ResultTable.AfterCalcBounds += new EventHandler(ResultTable_AfterCalcBounds);
      }
  
      private void Matrix5_ModifyResult(object sender, EventArgs e)
      {
        Matrix5.ResultTable.AfterCalcBounds += new EventHandler(ResultTable_AfterCalcBounds);
      }
      
      private void ResultTable_AfterCalcBounds(object sender, EventArgs e)
      {
        TableResult resultTable = sender as TableResult;
        float headerWidth = 915f;
        float colWidth = headerWidth/8; // 915 is width of header bar, make room for 8 columns
        
        foreach (TableColumn column in resultTable.Columns)
        {
          column.AutoSize = false;
          column.Width = colWidth;
        }
        
        // Set Total column width to remaining space
        resultTable.Columns[resultTable.ColumnCount-1].MaxWidth = headerWidth;
        resultTable.Columns[resultTable.ColumnCount-1].Width = headerWidth - (colWidth * (resultTable.ColumnCount-1));
        
        // this will recalculate table rows height
        resultTable.CalcHeight();
      }