Posted 8 September 2017, 2:21 pm EST
I use fpspread to display data from Access. I just wanna it displays the correct data format like the data itself ,such as '201006130954', '9.7534',but when it runs, there are something wrong , it can displays '201006130954' right, but '9.7534' was changed into '9.75', I didn't set celltype, they were default (none),because every seconds there new data was created, so I cannot set celltype dynamicly
the following code to achieve these content
Dim file1 As String = "select P1,P2,P3,P4,P5,P6,P7,P8,P9,P10,P11,P12,P13,P14,P15from INPUTDATA1 order by id desc"
Dim filestr1 As String = Nothing
filestr1 = "d:\AutoTest\" & file
Dim oleh As New SQLHelper.OleHelper(filestr1)
Dim input1 As DataSet = oleh.QuerySet(file1)
Me.FpSpread1_Sheet1.DataSource = input1
so I wanna know why I didn't set celltype, the decimal data displays wrong, What I should do for it? just display like Text format.