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?


Image icon real_string.png2.72 KB

(2) Answers