Column headers

Column headers

Posted by: grapecity on 12 September 2017, 12:50 am EST

• 

  gina

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 3:38 am EST

  When you say hide the label text, do you mean have blanks instead of A, B and so on?  If so, you can try this (for rowheader as well).
  
  
  
   FpSpread1.Sheets(0).ColumnHeader.AutoText = FarPoint.Win.Spread.HeaderAutoText.Blank
  
  

• 

  chic00

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 3:38 am EST

  Exactly what I was looking for… thanks!

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 12 September 2017, 12:50 am EST

  I have 3 questions regarding column headers;

  1. I am trying to set the horizontal and vertical grid line properties to None using this code
     
     Dim HGridLine As New FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.None)
     
     Dim VGridLine As New FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.None)
     
     FpSpread1.Sheets(0).HorizontalGridLine = HGridLine
     
     FpSpread1.Sheets(0).VerticalGridLine = VGridLine
     
     However, it does not seem to be making any difference the grid lines still show.

  2. Currently in my application when a cell is selected the column header for the column of the selected cell changes colors. Is there any way to turn that off so that the column header doesn’t change colors?

  3. Currently the backcolor of the column header is lighter at the top of the header and is darker at the bottom. Is there a way to make the background a solid color?