Posted 28 August 2018, 11:19 pm EST - Updated 30 September 2022, 3:11 am EST
Hi,
I have an active x control that I am using on vb6:
We currently updated this control from vaSpread version: 2.5.0.1, to the new fpSpread version 8.0.28.
We have a column in the spread control (the fourth column), that it’s values are:
18
18
2
18
17
18
18
18
18
2
2
We have 11 rows.
We are running the code:
spread.Col = 4
spread.Row = 1
spread.Col2 = 4
spread.Row2 = 11
dim s as string = spread.Clip
In the old control we are getting:
18
18
2
18
17
18
18
18
18
2
2
In the new control we are getting:
2
2
2
The CellType of this column when we build the grid is:
spread.CellType = 3 'SS_CELL_TYPE_INTEGER
Why in the new control we cannot see the numbers of 2 digits: 17 and 18 ?
When I searched in the internet, I found the attached Spread 8 documentation, that describes all cell types.
When I compare it to our application cell types I have seen that:
3 'SS_CELL_TYPE_INTEGER does not exist.
2 'SS_CELL_TYPE_FLOAT does not exist.
There is: 15 'Scientific, that I don’t know what it means. What does it mean ?
I have a lot of code using the cell types: SS_CELL_TYPE_INTEGER and SS_CELL_TYPE_FLOAT. What should I do ? Use the cell type: 13 'Number instead ?
If I will correct all my application by using 13 'Number instead of 3 'SS_CELL_TYPE_INTEGER and 2 'SS_CELL_TYPE_FLOAT, how will the user see the differences between integer value and floating value ?
Please answer all my questions.
Thanks,
Dror Farhi