Page 1 of 1

Reformatting of Value

Posted: Sat Apr 04, 2020 8:02 pm
by av686165
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.

Re: Reformatting of Value

Posted: Wed Apr 08, 2020 9:47 am
by vitd
Hello,

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

Code: Select all

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.