05-05-2018 09:54 AM
The format string of Spreadsheet String to Array makes sure the data is converted properly that you are getting the needed decimal places from the string.
The display format of the array indicator is so that you can see all of those decimal places that are present in the data. If you don't change the display format, the data has all those decimal places in the background, just that they are rounded off for display purposes on the front panel.
05-05-2018 01:53 PM - edited 05-05-2018 01:56 PM
@RavensFan wrote:
The format string of Spreadsheet String to Array makes sure the data is converted properly that you are getting the needed decimal places from the string.
Not quite sure what you mean by "needed decimal places", but it is somewhat misleading. Quote from e.g. here:
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
All you can basically tell it is if the string is floating point, integer (decimal, hex, oct, bin), or similar. Any "precision" settings are completely ignored. If the string is "3.14159", you get the same values if you scan with "%f", "%10.8f" or "%.1f", for example. (you still might need to define the decimal separator, but that's a separate format statement. You can tell how to recognize decimal digits, but you cannot tell it how many decimal digits you want to read!)
05-05-2018 02:48 PM
@altenbach wrote:
@RavensFan wrote:
The format string of Spreadsheet String to Array makes sure the data is converted properly that you are getting the needed decimal places from the string.
Not quite sure what you mean by "needed decimal places", but it is somewhat misleading. Quote from e.g. here:
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
All you can basically tell it is if the string is floating point, integer (decimal, hex, oct, bin), or similar. Any "precision" settings are completely ignored. If the string is "3.14159", you get the same values if you scan with "%f", "%10.8f" or "%.1f", for example. (you still might need to define the decimal separator, but that's a separate format statement. You can tell how to recognize decimal digits, but you cannot tell it how many decimal digits you want to read!)
The OP stated in an earlier post that he "needed" so many decimal places. They were there. He just had to adjust the display format to show the number he "needed".