Converting real to string rounds input
I need to perform some manipulations of real type values that requires them to be converted to strings first.
The issue is that Spotfire is rounding the real input to 2 decimal places when performing the conversion.
I am using Spotfire version 6.5. In the attached screenshot the real column is shown with 'general' formatting along with the string output.
I would expect string(-0.0793)='-0.0793', not '-0.08'
Can anyone suggest a solution or know what's going on here?