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 


    <FONT color=#000000>myCelltype.MaximumValue = 9999999999999.0</FONT>


    <FONT color=#000000>myCelltype.MinimumValue = 0</FONT>


    <FONT color=#000000>myCelltype.DecimalPlaces = 2</FONT>


    <FONT color=#000000>myCelltype.Separator = </FONT><FONT size=2><FONT color=#000000>","</FONT>

    </FONT><FONT size=2>

    <FONT color=#000000>myCelltype.ShowSeparator = </FONT></FONT><FONT size=2><FONT color=#000000>True</FONT>

    </FONT>

    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 


    <FONT color=#000000></FONT><FONT size=2>i see the same in the testform i have wrote :</FONT>


    <FONT size=2>on a form with a spread


    <FONT color=#000000>Private</FONT></FONT><FONT color=#000000><FONT size=2> </FONT><FONT size=2>Sub</FONT><FONT size=2> Form1_Load(</FONT><FONT size=2>ByVal</FONT><FONT size=2> sender </FONT><FONT size=2>As</FONT><FONT size=2> </FONT><FONT size=2>Object</FONT><FONT size=2>, </FONT><FONT size=2>ByVal</FONT><FONT size=2> e </FONT><FONT size=2>As</FONT><FONT size=2> System.EventArgs) </FONT><FONT size=2>Handles</FONT><FONT size=2> </FONT><FONT size=2>Me</FONT></FONT><FONT size=2><FONT color=#000000>.Load</FONT>


    </FONT><FONT color=#000000 size=2>Me</FONT><FONT size=2><FONT color=#000000>.FpSpread1.ActiveSheet.ColumnCount = 1</FONT>


    </FONT><FONT color=#000000 size=2>Me</FONT><FONT size=2><FONT color=#000000>.FpSpread1.ActiveSheet.RowCount = 3</FONT>


    <FONT color=#000000></FONT> 


    </FONT><FONT color=#000000><FONT size=2>Dim</FONT><FONT size=2> myCelltype </FONT><FONT size=2>As</FONT></FONT><FONT size=2><FONT color=#000000> FarPoint.Win.Spread.CellType.NumberCellType</FONT>


    <FONT color=#000000>myCelltype = </FONT></FONT><FONT color=#000000 size=2>New</FONT><FONT size=2><FONT color=#000000> FarPoint.Win.Spread.CellType.NumberCellType()</FONT>


    <FONT color=#000000>myCelltype.MaximumValue = 9999999999999.0</FONT>


    <FONT color=#000000>myCelltype.MinimumValue = 0</FONT>


    <FONT color=#000000>myCelltype.DecimalPlaces = 2</FONT>


    <FONT color=#000000>myCelltype.Separator = </FONT></FONT><FONT size=2><FONT color=#000000>","</FONT>

    </FONT><FONT size=2>

    <FONT color=#000000>myCelltype.ShowSeparator = </FONT></FONT><FONT size=2><FONT color=#000000>True</FONT>

    </FONT><FONT size=2>

    </FONT><FONT color=#000000 size=2>Me</FONT><FONT size=2><FONT color=#000000>.FpSpread1.ActiveSheet.Cells(0, 0).CellType = myCelltype</FONT>


    </FONT><FONT color=#000000 size=2>Me</FONT><FONT size=2><FONT color=#000000>.FpSpread1.ActiveSheet.Cells(1, 0).CellType = myCelltype</FONT>


    </FONT><FONT color=#000000 size=2>Me</FONT><FONT size=2><FONT color=#000000>.FpSpread1.ActiveSheet.Cells(2, 0).CellType = myCelltype</FONT>


    </FONT><FONT color=#000000><FONT size=2>End</FONT><FONT size=2> </FONT><FONT size=2>Sub

    </FONT></FONT>

    <FONT color=#000000></FONT> 


    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