how to disable popup caculator in celltype number

Posted by: wwu-sec on 8 September 2017, 12:31 pm EST

  • Posted 8 September 2017, 12:31 pm EST

    dear farpoint professional, i'm in a busy project

    i want to use cell type number, but when i double click the cell, it popup a calculator, what is best way to disable it, just like the text cell dummy style, but with currency validation ( comma , separator + only digit allowed)

    thanks a lot!!
  • Replied 8 September 2017, 12:31 pm EST

    i found some anser


    Public Class Form1

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

    Dim currcell As New FarPoint.Win.Spread.CellType.NumberCellType

    currcell.DecimalPlaces = 0

    currcell.FixedPoint = True

    'currcell.LeadingZero = FarPoint.Win.Spread.CellType.LeadingZero.Yes

    currcell.MaximumValue = 999999

    currcell.MinimumValue = 1

    'currcell.NegativeFormat = FarPoint.Win.Spread.CellType.CurrencyNegativeFormat.SignSymbolSpaceBefore

    'currcell.NegativeRed = True

    'currcell.PositiveFormat = FarPoint.Win.Spread.CellType.CurrencyPositiveFormat.CurrencySymbolBefore

    currcell.Separator = ","

    'currcell.ShowCurrencySymbol = True

    currcell.ShowSeparator = True

    FpSpread1.Sheets(0).Cells(0, 0).CellType = currcell

    FpSpread1.Sheets(0).Cells(0, 0).Value = 443.3482

    End Sub

    Private Sub FpSpread1_CellDoubleClick(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.CellClickEventArgs) Handles FpSpread1.CellDoubleClick

    'e.Cancel = True

    End Sub

    Private Sub FpSpread1_SubEditorOpening(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.SubEditorOpeningEventArgs) Handles FpSpread1.SubEditorOpening

    If (1 = 1) Then

    e.Cancel = True

    End If

    End Sub

    End Class
  • Replied 8 September 2017, 12:31 pm EST

    Finally, i got the only usefull code i want:<FONT color=#006400>e.Cancel = True, </FONT><FONT color=#000000>THX for the Sharing :></FONT>

Need extra support?

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

Learn More

Forum Channels