ButtonDrawMode and RowHeader columns

Posted by: j2associates on 8 September 2017, 12:40 pm EST

  • Posted 8 September 2017, 12:40 pm EST

    Hello all,


    If you set a RowHeader column cell type to ComboBoxCellType and then set ButtonDrawMode to CurrentRow the setting appears to be ignored for RowHeader columns. To see this behavior, drop the following code in a form's load event code

    With Me.FpSpread1
    With .ActiveSheet
    .RowHeader.Columns.Add(1, 1)
    .RowHeader.Columns(0).CellType = New CellType.ComboBoxCellType
    End With
    .ButtonDrawMode = FarPoint.Win.Spread.ButtonDrawModes.CurrentRow
    End With

    Is this a bug or is there an equivalent header property I'm missing or should I turn this in as an enhancement request? Thanks in advance for any ideas and/or suggestions!

     
  • Replied 8 September 2017, 12:40 pm EST

    Hello,


    Celltypes are not meant to be used in the headers. The headers are meant for display only and no editing. Thus, the ButtonDrawMode property is only meant to affect the buttons in the data area of the Spread. If anything, this would be an enhancement request, but I think the better request would be to allow editable headers. Then, CellType objects in the headers would make sense and ButtonDrawMode should affect all cells at that point.

  • Replied 8 September 2017, 12:40 pm EST

    Thanks, Scott! I'll turn that in as an enhancement request.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels