fpspread converts '1302143271814' to '1.302143E+012' which later becomes 1302143000000

Posted by: ijrebecca on 8 September 2017, 12:35 pm EST

  • Posted 8 September 2017, 12:35 pm EST

    I am trying to program my fpspread to accept upto 16 digits data into a cell and fpspread first converts it to '1.302143E+012' and then '1302143000000'. I am so lost. I have tried setting dataautocelltypes property to false. But, still doesn't work. Please help!!!!!!!!!!!!!!!
  • Replied 8 September 2017, 12:35 pm EST

    What celltype are you using and is the control bound?  Are you using Spread for Windows Forms .net or Spread OCX?
  • Replied 8 September 2017, 12:35 pm EST

    Hello,


    If you want to set the DataAutoCellTypes property to False and this is a Number field in the database, then you need to set the CellType of this column to NumberCellType. The GeneralCellType will convert large numbers to scientific notation, but the NumberCellType should not do this.

  • Replied 8 September 2017, 12:35 pm EST

    Initially my celltype was textbox, changed it to numbercelltype then currencycelltype and tried setting dataautocelltype = false, but still no luck. the cell where I type this is not bound to the database. Once I tab out of the cell, immediately it reformats in the scientific format. Please help. It's very common in our company to deal with such large numbers....

    Thanks a lot
  • Replied 8 September 2017, 12:35 pm EST

    Hello,


    What version of Spread for Windows Forms are you using. I am not sure how you got the number to convert using any celltype other than GeneralCellType. Could you send us a small zipped project reproducing this issue for us to debug?

  • Replied 8 September 2017, 12:35 pm EST

    Version 2.5 for windows. I have programmed the column to become a combobox (works fine)when double clicked and numbercelltype while editing. I am having problems when user types in lengthy data. Please help ASAP!!! Thanks a lot

    2007/05/fpspread.JPG
Need extra support?

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

Learn More

Forum Channels