I found a bug In LabView 2009!!!!!

[Abhimaniu]

When i am using String to Spreadsheet function i observed that there is not effect of "format string" if i declare it as "%.1f", "%.2f","%.3f" and so on. whatever is the input format (Precision) the output will also be of same type. My input data an 2.33545,2.3566,8.56666. I specified "format string" as "%.2f" but my output was same as input. Is this really a bug or not. Anybody help me

[pincpanter]

The precision field is only valid while converting from number to string, not in the opposite case.

So this field is disregarded by the Spreadsheet String to Array, while the reverse function Array to Spreadsheet function takes it into account.

The same - at a lower level - is true for Scan from String and Format into String.

[smercurio_fc]

It's also documented in the LabVIEW Help in the Format Specifier Syntax page:

For functions that scan a string, such as Scan From String and Spreadsheet String to Array, a format specifier uses the following simplified syntax elements.

%[Width]Conversion Code