LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

data displayed from a spreadsheet not correctly

Solved!
Go to solution

wow i didn't know the reason for the different looks.. 😛

Okay so I did that and the results in strings and in double are attached (the picture)..

Apparently, the strings show a more accurate value, than those in double (no change) but still the values are not 2.98... it's 0.00298..

Your help is very appreciated!

0 Kudos
Message 11 of 13
(1,389 Views)
Solution
Accepted by topic author remapears

The values in the file are e.g. 2.6855000000000000e-02, which is the same as 0.026855000000000000. (make your string indicators wider to show the entire number!)

 

You still have not told us about the decimal delimiter setting in your OS. If your numbers typically display with a comma instead of a decimal point, you need to correct for that, e.g. by wiring a FALSE to the top of fract/exp string to number.

 

You can change the formatting of the numeric indicator to anything you want (e.g. exponential format, number of digits shown, etc.)

Message 12 of 13
(1,380 Views)

Perfect! 

I wired the false constant to that VI and changed the display formating and I got the correct display of the double array 😄

Thank you very much! 😄

 

0 Kudos
Message 13 of 13
(1,367 Views)