I have a spreadsheet that contains car numbers and what color their background is supposed to be. If there's a car such as a 01 or 03 however, I think whatever code ATVO uses to get spreadsheet data sees those cells as just a 1 or a 3, so ATVO can't get the data for said cells. Note that of course anything else works correctly for cars with leading zeroes such as using images for those numbers.
How are you using the spreadsheet? You mention background colors but that would probably require a script at least, can you show exactly what you do?
Here's a screenshot of the CSV:
I then use the script from this post as a background color override for a label:
https://atvo.appgineering.com/Forum/Post/2538
Everything works just as expected except for the 00, 01, 03 and 06. Fortunately they're all the same so I just made the default color #131313, but that's only a temporary fix.
I see... somehow I am treating columns with only numbers as a special case and convert them to numbers, which removes the leading zeros. I'll have to see how to handle that, I honestly don't remember why I did that.
For now, a work-around can be to just add one more row to the bottom where you put text (for example just the character 'A') instead of a car number. That should not cause any side effects and should cause the row to get parsed as text instead.
New replies have moved to Discord.
