Cell type

Posted by: john-shugart on 8 September 2017, 1:31 pm EST

  • Posted 8 September 2017, 1:31 pm EST

    I have a sheet that isn't caculating the formula's correctly. I believe this is a celltype issue. I want to put in the cell doubleclick() event a messagebox to show me what celltype the active cell is. Is there a way to show the cell type as a string? ie,  FarPoint.Win.Spread.CellType.CurrencyCellType


     


    Thanks in advance,


    John

  • Replied 8 September 2017, 1:31 pm EST

    John -

    The following should do it for you...

    Private Sub FpSpread1_CellDoubleClick(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.CellClickEventArgs) Handles FpSpread1.CellDoubleClick
    Dim ct As FarPoint.Win.Spread.CellType.ICellType
    ct = FpSpread1.ActiveSheet.GetCellType(e.Row, e.Column)
    MsgBox(Convert.ToString(ct))
    End Sub

  • Replied 8 September 2017, 1:31 pm EST

    Thanks Bob,


     That is exactly what I was looking for!


    John

Need extra support?

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

Learn More

Forum Channels