ChildViewCreated problem

ChildViewCreated problem

Posted by: patrik on 10 October 2023, 8:30 am EST

• 

  patrik

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 10 October 2023, 8:30 am EST - Updated 10 October 2023, 8:39 am EST

  [code]private void FpSpread1_ChildViewCreated(object sender, FarPoint.Win.Spread.ChildViewCreatedEventArgs e)
  
  {
  
  try
  
  {
  
  e.SheetView.ColumnHeader.DefaultStyle.Renderer = new FarPoint.Win.Spread.CellType.ColumnHeaderRenderer();
  
  e.SheetView.RowHeader.DefaultStyle.Renderer = new FarPoint.Win.Spread.CellType.RowHeaderRenderer();
  
  e.SheetView.SheetCorner.DefaultStyle.Renderer = new FarPoint.Win.Spread.CellType.CornerRenderer();
  
  FpSpread1.InterfaceRenderer = null;
  
  FpSpread1.HorizontalScrollBar.Renderer = null;
  
  FpSpread1.VerticalScrollBar.Renderer = null;

      e.SheetView.AlternatingRows[0].BackColor = Color.White;
      e.SheetView.AlternatingRows[1].BackColor = Color.WhiteSmoke;
      e.SheetView.Rows.Default.Resizable = false;
      if (e.SheetView.ColumnCount >= 4 && e.SheetView.RowCount >= 0 && e.SheetView.ColumnHeader.Columns[0].Label == "N2") 
      {
          e.SheetView.Columns[0].Visible = false;
          e.SheetView.Columns[1].Visible = false;
          e.SheetView.SetColumnWidth(2, 185);
          e.SheetView.SetColumnWidth(3, 185);
          e.SheetView.Columns[4].Visible = false;
          //L_svCollection.Add(e.SheetView)
      }
      else if (e.SheetView.ColumnCount >= 7 && e.SheetView.RowCount >= 0 && e.SheetView.ColumnHeader.Columns[0].Label == "N3")
      {
          e.SheetView.Columns[0, 1].Visible = false;
          e.SheetView.SetColumnWidth(2, 120);
          e.SheetView.SetColumnWidth(3, 80);
          e.SheetView.SetColumnWidth(4, 120);
          e.SheetView.SetColumnWidth(5, 80);
          e.SheetView.Columns[6, 7].Visible = false;
      }
      else if (e.SheetView.ColumnCount >= 5 && e.SheetView.RowCount >= 0 && e.SheetView.ColumnHeader.Columns[0].Label == "N4") 
      {
          e.SheetView.Columns[0, 1].Visible = false;
          e.SheetView.SetColumnWidth(2, 200);
          e.SheetView.Columns[3, 5].Visible = false;
      }
      else if (e.SheetView.ColumnCount >= 9 && e.SheetView.RowCount >= 0 && e.SheetView.ColumnHeader.Columns[0].Label == "N5") 
      {
          e.SheetView.Columns[0, 1].Visible = false;
          e.SheetView.SetColumnWidth(2, 100);
          e.SheetView.SetColumnWidth(3, 100);
          e.SheetView.SetColumnWidth(4, 20);
          e.SheetView.Columns[5].Visible = false;
          e.SheetView.SetColumnWidth(6, 110);
          e.SheetView.Columns[7, 9].Visible = false;
          //L_svCollection.Add(e.SheetView)
      }
      else if (e.SheetView.ColumnCount >= 9 && e.SheetView.RowCount >= 0 && e.SheetView.ColumnHeader.Columns[0].Label == "N6")
      {
          e.SheetView.Columns[0, 1].Visible = false;
          e.SheetView.SetColumnWidth(2, 250);
          e.SheetView.Columns[3, 8].Visible = false;
          e.SheetView.SetColumnWidth(9, 50);
          e.SheetView.Columns[9].HorizontalAlignment = CellHorizontalAlignment.Center;
      }
  }
  catch (Exception eA) { MessageBox.Show(eA.Message); }
  

  }[/code]

  I used this code before with version 14 and it’s working perfect.
  
  Now in version 16.1.20231.0 I get error that is not show in the catch
  
  

  

  701×615 26.4 KB

  it’s happend when I have one hierarchy open and go directly to the “+” on next hierarchy

• 

  aastha.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 10 October 2023, 10:36 pm EST

  Hi Patrik,

  This error generally occurs when we try to access a variable whose value has not been set or has been set to null. We implemented your code in a sample application with Spread.NET v16 build but could not replicate the issue. Refer ChildViewCreate.zip

  We request you update the attached sample or provide a stripped down version of your sample application, so that we could replicate the issue on our end. This will help us analyze the issue in a better way and assist you accordingly.

  Thanks & Regards,
  
  Aastha