Converting Real to String in TIBCO Spotfire rounds to 2 decimal places

Product:TIBCO Cloud Spotfire
Versions:All

Summary:
When converting a Real column to String not all decimals are included

Details:
When using the String() function to cast a Real column to a String column, only two decimals are included regardless of how many decimals are displayed under Column Properties/Formatting.

For example, if a Real column called [Values] included a value for Pi of 3.14159265, using String([Values]) would output 3.14.

Resolution:
To avoid the undesired rounding, use the Concatenate() function to convert the entire Real number to a String column when a space is added before the column. For example:

Concatenate(" ", [Values])

In the above example, Concatenate(" ", [Values]) will produce 3.14159265