Weird RowHeader.Column(0).renderer behavior

Weird RowHeader.Column(0).renderer behavior

Posted by: kbj on 14 December 2019, 1:30 pm EST

• 

  kbj

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 14 December 2019, 1:30 pm EST

  Changing the RowHeader.Column(0).renderer to a EnhancedRowHeaderRenderer fails when a SheetView is in the Sheets Collection of a FPSpread.
  
  It will succeed if the SheetView is removed from the collection, changed, and the re added to the FPSpread.

          FpSpread1_Sheet1.RowHeader.Columns(0).Renderer = New EnhancedRowHeaderRenderer
          Console.WriteLine("RowHeaderRenderer isNothing:{0}", IsNothing(FpSpread1_Sheet1.RowHeader.Columns(0).Renderer))
          FpSpread1.Sheets.Remove(FpSpread1_Sheet1)
          FpSpread1_Sheet1.RowHeader.Columns(0).Renderer = New EnhancedRowHeaderRenderer
          FpSpread1.Sheets.Add(FpSpread1_Sheet1)
          Console.WriteLine("RowHeaderRenderer isNothing:{0}", IsNothing(FpSpread1_Sheet1.RowHeader.Columns(0).Renderer))
  

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 16 December 2019, 6:26 am EST

  Hello,

  Actually, Spread for WinForms 12 supports the new style system - Flat Mode Style system that works similar to Excel. Users can access full functions of the new style system with new API set only.

   FpSpread1.LegacyBehaviors = FarPoint.Win.Spread.LegacyBehaviors.All
         FpSpread1_Sheet1.RowHeader.Columns(0).Renderer = New EnhancedRowHeaderRenderer
         Console.WriteLine("RowHeaderRenderer isNothing:{0}", IsNothing(FpSpread1_Sheet1.RowHeader.Columns(0).Renderer))
         FpSpread1.Sheets.Remove(FpSpread1_Sheet1)
         FpSpread1_Sheet1.RowHeader.Columns(0).Renderer = New EnhancedRowHeaderRenderer
         FpSpread1.Sheets.Add(FpSpread1_Sheet1)
         Console.WriteLine("RowHeaderRenderer isNothing:{0}", IsNothing(FpSpread1_Sheet1.RowHeader.Columns(0).Renderer))
  

  Hope it helps.

  Thanks,
  
  Mohit

• 

  kbj

  • Post Options:
  • Link
    Copy

  Posted 16 December 2019, 10:33 am EST

  Hi Mohit,
  
  Ah, the above pattern is a legacy behavior.
  
  Thanks,
  
  Kingman