Matrix - Fixed number of columns

Comments

• AlexTZ

  October 2011 edited 10:42AM

  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.
• Turntwo Folsom, CA

  October 2011 edited 10:42AM

  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();
      }