Flexgrid Text - Bold and Font

Flexgrid Text - Bold and Font

Posted by: tobyschlank on 22 February 2018, 12:22 am EST

• 

  tobyschlank

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 22 February 2018, 12:22 am EST

  Hi,

  I am using VB.Net and ComponentOne 2017.2.1.5.

  1. With C1Flexgrid, is there a way to get FontBold and FontName of a particular cell?
  2. With C1Flexgrid, is there a way to set FontBold and FontName of a cell range?

  Any help is greatly appreciated.

  Thanks

• 

  sonu.singh

  

  • Post Options:
  • Link
    Copy

  Posted 22 February 2018, 4:56 am EST

  Hi,
  
  For setting and getting the information about the font of a Row, Col, CellRange and a single Cell use the below code:

          'setting font for row, col, cellrange and cell 
          Dim cs As CellStyle = C1FlexGrid1.Styles.Add("Verified")
          cs.Font = New Font(Me.Font.Name, 11)
          C1FlexGrid1.Rows(4).Style = cs
          C1FlexGrid1.Cols(1).Style = cs
          Dim crg As CellRange = C1FlexGrid1.GetCellRange(1, 1, 2, 2)
          crg.Style = cs
          C1FlexGrid1.SetCellStyle(1, 1, cs)
  
          'Getting font from row, col, cellrange and cell
          Dim style = C1FlexGrid1.Rows(2).Style
          style = C1FlexGrid1.Cols(2).Style
          style = C1FlexGrid1.GetCellRange(1, 1, 2, 2).Style
          style = C1FlexGrid1.GetCellStyle(1, 1)
          Dim fontName As String = ""
          If style Is Nothing Then
              fontName = C1FlexGrid1.Styles.Normal.Font.Name
          Else
              fontName = style.Font.Name
          End If
  

  For more information read the documentation at below links:
  
  http://helpcentral.componentone.com/nethelp/c1flexgrid/cellappearance.html
  
  http://helpcentral.componentone.com/nethelp/c1flexgrid/settingthefontofasinglecell.html
  
  http://helpcentral.componentone.com/nethelp/c1flexgrid/formattingcellsbasedoncontents.html
  
  http://helpcentral.componentone.com/nethelp/c1flexgrid/ownerdrawncells.html

  Thanks,
  
  Singh

• 

  tobyschlank

  • Post Options:
  • Link
    Copy

  Posted 22 February 2018, 8:25 pm EST

  Thank you Singh.