To show more than 15 decimal digits in GridControl

[Suganya]

Hi,

I am using Syncfusion.Windows.Forms.Grid.GridControl to show the Pearson Coefficient results. My result has 17 decimal digits.
My value is 0.99999999999999989. when displaying in Grid Control automatically rounds to 1.

I Need to display this full value in the grid

Thanks in Advance,
Suganya. K

[Jisha Joy]

Hi Suganya,

Formula cells supports 15 decimal digits only, after that it will automatically get rounded off. You can see the same behavior with Excel too.

Regards,
Jisha

[shazif]

Hi Jisha,

You are saying the grid will round off at 15 decimal points, Am using the value obj1 = "0.999999999999999678" to display in the grid and tried with two versions of syncfusion grid control 1.5.1.6 and 7.102.0.7. the results are vary.

Code:
this.grdTemplate[1, 1].CellType = "TextBox";
this.grdTemplate[1, 1].CellValue = obj1;
this.grdTemplate[1, 1].CellValueType = typeof(Double);

1.5.1.6: Value in the grid:
----------------------------
I can see the grid contains the following value, contains 17 decimal points. (18th decimal point trimmed off).
"0.99999999999999967"

7.102.0.7: Value in the grid:
----------------------------
When I tried the same code with syncfusion 7 version, I can see the grid contains the following value,The value rounded off at 15th decimal point.
"1.0"

I want to display the value as like 1.5.1.6 version, Kindly help me out on this. This is very urgent task for our client.

Thanks,
Shazif