02-21-2024 01:55 PM - last edited on 02-21-2024 10:17 PM by markwni
Hello i need help with spreadsheet to array i recive data from serial and i wanna use function spreadsheet to array to have all values in array instead of string but i lose floating points in the process but before that function it is all okay i tried to change represatation of array display but it doesnt work
Solved! Go to Solution.
02-21-2024 02:05 PM
Try changing the format string from %g to %f.
02-21-2024 02:09 PM
If your data is separated by commas all you need to do is this:
02-21-2024 02:09 PM
i tried that also didnt work i also tried setting %5.3f to display 3 floating point numbers but also didnt work
02-21-2024 02:15 PM - edited 02-21-2024 02:15 PM
@Adweqweq wrote:
i tried that also didnt work i also tried setting %5.3f to display 3 floating point numbers but also didnt work
Post your code and a sample of the data string you are receiving.
02-21-2024 02:42 PM - edited 02-21-2024 02:42 PM
Are you from Germany or another region that uses a decimal comma as default decimal character?
02-21-2024 03:48 PM
What does that have to do with a manure spreader?
02-21-2024 04:30 PM
maybe try to set %.;%f
02-21-2024 04:35 PM
Thank you very much brudka_kotlet_cardinale this worked for me !