Writing to spread sheets with more than single precision

[Solar Surfer]

Hi everyone,

Im recording data by using the write to spread sheet VI in Labview 8,

it records single precision which is a problem for me as I require greater 

precision. 

Are there ways around this issue?

Thanks

[AdnanZ]

What do you mean by this? Is it possible for you to post code which only shows what you are trying to explain?

[johnsold · Accepted solution]

The Write to Spreadsheet File.vi has an input for Format String. The default is "%.3f" which will give you less than single precision.  Change it to what you need.  Read the Detailed Help for more information about Format Strings.

Lynn

[Solar Surfer]

Thanks for your input, the change from%.3f to %#g has 

fixed my issue. I do find it confusing when reading the 

help function of the VI as it says "Converts a 2D or 1D 

array of single precision numbers to a text string ... "

[johnsold]

That help file has been changed in newer versions.  The interesting thing is that the VI itself has DBL arrays as inputs in LV 8.0.

Of course the default format may not even save enough precision to take full advantage of SGL data type.

Lynn