Some of my data has leading and trailing whitespace. I’ve noticed that cell.getValue() trims trailing whitespace (haven’t tested leading) - this is causing some issues. Is there any way around this?
Try to use “edtxt” or “rotxt” types
Some of my data has leading and trailing whitespace. I’ve noticed that cell.getValue() trims trailing whitespace (haven’t tested leading) - this is causing some issues. Is there any way around this?
Try to use “edtxt” or “rotxt” types