Reformatting of Value

CloverDX Platform
1

Could you please let me know how to formatting for below types of records,
2.44266E+21

When I am using Format cell functionality in MS excel , the below value has been transformed into 2442660018000190000000.

I want to achieve the same in CloverDX. Please assist.

2

Hello,

then double precision values are stored in number type variables in CTL2. This can be easily formatted by:


number value = 2.44266E+21;
string formatted = num2str(value, "#") ;
printLog(info, formatted) ;

Please note that the resulting value might differ between Excel and CloverDX because of the different rounding. In order to save the precise values, the decimal data type is rather recommended.