Skip to content
AppgineeringAppgineering
Shop
Read-only4 posts · 3,576 views · Started 09 Oct 2021, 15:33

CarNumber row identifier for spreadsheets ignores leading zeroes

Archived: discussion moved to DiscordDiscord
Zack R.Original poster
#1

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.

Nick ThissenAppgineering
#2

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?

Nick ThissenAppgineering
#4

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.

This thread is archived.

New replies have moved to Discord.

Continue on Discord