numeric cell type acts strange

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

  • Posted 8 September 2017, 1:19 pm EST

    <P>Hi  I have a spread version 2.5.2005.2005</P>
    <P>The spread has a few cells that are numeric type cells </P>
    <P><FONT color=#000000>myCelltype.MaximumValue = 9999999999999.0</FONT></P>
    <P><FONT color=#000000>myCelltype.MinimumValue = 0</FONT></P>
    <P><FONT color=#000000>myCelltype.DecimalPlaces = 2</FONT></P>
    <P><FONT color=#000000>myCelltype.Separator = </FONT><FONT size=2><FONT color=#000000>","</FONT></P></FONT><FONT size=2>
    <P><FONT color=#000000>myCelltype.ShowSeparator = </FONT></FONT><FONT size=2><FONT color=#000000>True</FONT></P></FONT>
    <P>When I enter a number that is 13 digits long </P>
    <P>for example 7777777777777.00</P>
    <P>and then I press on the Enter key or TAB key </P>
    <P>the number turns to 7777777777777.01</P>
    <P> it only happens when i use all the 13 digits !!!!!!</P>
    <P>please your help  </P>
    <P><FONT color=#000000></FONT><FONT size=2>i see the same in the testform i have wrote :</FONT></P>
    <P><FONT size=2>on a form with a spread </P>
    <P><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></P>
    <P></FONT><FONT color=#000000 size=2>Me</FONT><FONT size=2><FONT color=#000000>.FpSpread1.ActiveSheet.ColumnCount = 1</FONT></P>
    <P></FONT><FONT color=#000000 size=2>Me</FONT><FONT size=2><FONT color=#000000>.FpSpread1.ActiveSheet.RowCount = 3</FONT></P>
    <P><FONT color=#000000></FONT> </P>
    <P></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></P>
    <P><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></P>
    <P><FONT color=#000000>myCelltype.MaximumValue = 9999999999999.0</FONT></P>
    <P><FONT color=#000000>myCelltype.MinimumValue = 0</FONT></P>
    <P><FONT color=#000000>myCelltype.DecimalPlaces = 2</FONT></P>
    <P><FONT color=#000000>myCelltype.Separator = </FONT></FONT><FONT size=2><FONT color=#000000>","</FONT></P></FONT><FONT size=2>
    <P><FONT color=#000000>myCelltype.ShowSeparator = </FONT></FONT><FONT size=2><FONT color=#000000>True</FONT></P></FONT><FONT size=2>
    <P></FONT><FONT color=#000000 size=2>Me</FONT><FONT size=2><FONT color=#000000>.FpSpread1.ActiveSheet.Cells(0, 0).CellType = myCelltype</FONT></P>
    <P></FONT><FONT color=#000000 size=2>Me</FONT><FONT size=2><FONT color=#000000>.FpSpread1.ActiveSheet.Cells(1, 0).CellType = myCelltype</FONT></P>
    <P></FONT><FONT color=#000000 size=2>Me</FONT><FONT size=2><FONT color=#000000>.FpSpread1.ActiveSheet.Cells(2, 0).CellType = myCelltype</FONT></P>
    <P></FONT><FONT color=#000000><FONT size=2>End</FONT><FONT size=2> </FONT><FONT size=2>Sub</P></FONT></FONT>
    <P><FONT color=#000000></FONT> </P>
    <P>thanks doron</P>
    <P> </P>
    <P> </P>
  • Replied 8 September 2017, 1:19 pm EST

    <p>doron -</p><p>I tested this with version 2.5.2015 and I do not see this behavior.  I would suggest upgrading to the latest maintenance release. <br></p>
Need extra support?

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

Learn More

Forum Channels