Can I disable calculator?

Posted by: amit-p on 8 September 2017, 1:20 pm EST

  • Posted 8 September 2017, 1:20 pm EST

    Hi

     Is there any way to disable the calculator (which appears on double click)  for numeric cell type? I want to set the cells as numeric and use my own calculator in the Farpoint spreadsheet - is that possible?

     
    Thanks!

    Amit
     

  • Replied 8 September 2017, 1:20 pm EST

    Amit -

    For example, if you number celltype is in cell 0,0 then you can do the following...

    Private Sub FpSpread1_SubEditorOpening(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.SubEditorOpeningEventArgs) Handles FpSpread1.SubEditorOpening
    If e.Column = 0 And e.Row = 0 Then
    e.Cancel = True
    End If
    End Sub

  • Replied 8 September 2017, 1:20 pm EST

    Thanks Bob - thats a very good work around!

     
    Amit

     

Need extra support?

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

Learn More

Forum Channels