The problem of numerical calculation with decimal.

[Mark Li]

In the Control GridControl ,The number A1:10.251 and A2:3.575, set NumberDecimalDigits=2, the cell displays the values A1:10.25 and A2:3.58.

Then apply the formula "=A1+A2" result was 13.83. results from their raw values as 13.826. 

How can I get 13.826 instead of 13.83?

[Kanimozhi Bharathi]

 

Hi Mark,

 

Thank you for contacting Syncfusion Support.

 

We have analysed your query. If you set the Number of Decimal Digits to be 2, then it will be rounded and will be displayed with 2 decimal digits only. If you want to display 3 digits after the decimal point then set the NumberDecimalDigits to be 3.

You can also refer our Dashboard sample “Formula Range Selection Demo” which is under the below path in Syncfusion Dashboard.

Path: WPF Dashboard -> CellGrid -> Formula Support -> Formula Range Selection Demo

Please let us know if you have any queries.

 

Thanks

Kanimozhi B

[Mark Li]

Hi Mark,

 

Thank you for contacting Syncfusion Support.

 

We have analysed your query. If you set the Number of Decimal Digits to be 2, then it will be rounded and will be displayed with 2 decimal digits only. If you want to display 3 digits after the decimal point then set the NumberDecimalDigits to be 3.

You can also refer our Dashboard sample “Formula Range Selection Demo” which is under the below path in Syncfusion Dashboard.

Path: WPF Dashboard -> CellGrid -> Formula Support -> Formula Range Selection Demo

Please let us know if you have any queries.

 

Thanks

Kanimozhi B

According to what you mean,If I set the Number of Decimal Digits, It is equal to the applications of the function Round (number, num_digits)?

[Kanimozhi Bharathi]

Hi Mark,

 

Apologize for the delay.

 

We have analyzed your query. Setting the Number of Decimal digits is not equal to the Round() function. The Round() function returns a number rounded to a specified number of digits.

 

For Eg: Round(23.0001,2) will return the rounded value as 23, while when we set the Number of Decimal Digits to be 2, then it returns the value as 23.00 with two decimal digits.

 

Please let us know if you need any clarifications.

 

Thanks

Kanimozhi B

[Mark Li]

Hi Kanimozhi,

   

Please Take a look at this picture,I open Excel input values and calculatestheir sum.A1,B1 is A2,B2 after setting up two decimal values,Can I get C1='12.728'?

Thanks

Mark Li

[Kanimozhi Bharathi]

Hi Mark,

 

Apologize for the delay.

 

We have analyzed your query. You can get three decimal digits for the resultant value by setting the Number of Decimal digits to be 3.

 

For Eg:

Let us take,

A1= 10.2015 and set the NumberDecimalDigits be 2

B1 = 2.523 and  set the NumberDecimalDigits be 2

 

For the resultant value C1 = A1+B1, Set the NumberDecimalDigits to 3 then you can get your expected output 12.728.

 

Please let us know if you have any queries.

 

Thanks

Kanimozhi B

[Mark Li]

Hi Mark,

 

Apologize for the delay.

 

We have analyzed your query. You can get three decimal digits for the resultant value by setting the Number of Decimal digits to be 3.

 

For Eg:

Let us take,

A1= 10.2015 and set the NumberDecimalDigits be 2

B1 = 2.523 and  set the NumberDecimalDigits be 2

 

For the resultant value C1 = A1+B1, Set the NumberDecimalDigits to 3 then you can get your expected output 12.728.

 

Please let us know if you have any queries.

 

Thanks

Kanimozhi B

But,The Cell "C1" is a FormulaCell, Set the NumberDecimalDigits has no effect.If you have a example it will be even better.

Thanks

Mark Li

[Kanimozhi Bharathi]

Hi Mark,

 

Apologize for the delay

 

We were able to reproduce the Number Format issue in Formula cell and have logged defect report regarding this. The fix for this issue will be included in any our upcoming releases.

 

Please let me know if you have any questions.

 

Thanks

Kanimozhi B