numeric cell type acts strange

Posted by: doron on 8 September 2017, 1:19 pm EST

  • Posted 8 September 2017, 1:19 pm EST

    Hi  I have a spread version 2.5.2005.2005


    The spread has a few cells that are numeric type cells 


    myCelltype.MaximumValue = 9999999999999.0


    myCelltype.MinimumValue = 0


    myCelltype.DecimalPlaces = 2


    myCelltype.Separator = ","


    myCelltype.ShowSeparator = True


    When I enter a number that is 13 digits long


    for example 7777777777777.00


    and then I press on the Enter key or TAB key


    the number turns to 7777777777777.01


     it only happens when i use all the 13 digits !!!!!!


    please your help 


    i see the same in the testform i have wrote :


    on a form with a spread


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


    Me.FpSpread1.ActiveSheet.ColumnCount = 1


    Me.FpSpread1.ActiveSheet.RowCount = 3


     


    Dim myCelltype As FarPoint.Win.Spread.CellType.NumberCellType


    myCelltype = New FarPoint.Win.Spread.CellType.NumberCellType()


    myCelltype.MaximumValue = 9999999999999.0


    myCelltype.MinimumValue = 0


    myCelltype.DecimalPlaces = 2


    myCelltype.Separator = ","


    myCelltype.ShowSeparator = True


    Me.FpSpread1.ActiveSheet.Cells(0, 0).CellType = myCelltype


    Me.FpSpread1.ActiveSheet.Cells(1, 0).CellType = myCelltype


    Me.FpSpread1.ActiveSheet.Cells(2, 0).CellType = myCelltype


    End Sub


     


    thanks doron


     


     

  • Replied 8 September 2017, 1:19 pm EST

    doron -

    I tested this with version 2.5.2015 and I do not see this behavior.  I would suggest upgrading to the latest maintenance release.

Need extra support?

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

Learn More

Forum Channels