FpSpread1.ColumnWidthChanged/FpSpread1.AllowUndo Bug

FpSpread1.ColumnWidthChanged/FpSpread1.AllowUndo Bug

Posted by: kbj on 14 July 2019, 11:23 am EST

• 

  kbj

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 14 July 2019, 11:23 am EST

  When FpSpread1.AllowUndo = False on a sheet with FpSpread1.Sheets(0).RowHeader.Columns(0).Resizable = True, the FpSpread1.ColumnWidthChanged does not fire when the user resizes the width of the RowHeader.
  
  Use the below code on a form with an FPSpread to illustrate:

  
  Imports FarPoint.Win.Spread
  
  Public Class Form1
      Private Sub Form1_Load(sender As Object, e As EventArgs) Handles Me.Load
          FpSpread1.AllowUndo = False 'comment this out to make FpSpread1.ColumnWidthChanged work
          FpSpread1.Sheets(0).RowHeader.Columns(0).Resizable = True
      End Sub
      Private Sub FpSpread1_ColumnWidthChanged(sender As Object, e As ColumnWidthChangedEventArgs) Handles FpSpread1.ColumnWidthChanged
          Console.WriteLine("FpSpread1_ColumnWidthChanged")
      End Sub
  End Class
  
  

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 14 July 2019, 11:22 pm EST

  Hello,

  Thank you for the code. I could too see the same at my end, hence I have reported it to the concerned team [ID: 274164].
  
  I’ll get back to you once we have some information.

  Regards,
  
  Ruchir

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 12 August 2019, 3:48 pm EST

  Hello,

  While the developers work over this, you can handle the Changed event of RowHeaderColumnAxis for detecting change in column header size.

  AddHandler FpSpread1.Sheets(0).Models.RowHeaderColumnAxis.Changed, AddressOf RowHeaderColumnAxis_Changed
  Private Sub RowHeaderColumnAxis_Changed(sender As Object, e As FarPoint.Win.Spread.Model.SheetAxisModelEventArgs)
      Console.WriteLine("RowHeaderColumnAxis_Changed")
  End Sub
  

  Best wishes,
  
  Ruchir