php-google-spreadsheet-client icon indicating copy to clipboard operation
php-google-spreadsheet-client copied to clipboard

Leading zero stripped off when trying to write to Google spreadsheet

Open mbaric opened this issue 8 years ago • 1 comments

In my Google spreadsheet I have a column for zip code, when I try to write 04001 from the PHP backend API to google spreadsheet with this library I get written in 4001, so first zero is stripped of. I though maybe the problem was in that column so I turned it to Plain text, but still it's the same. I see I am sending to library good value "040001" but it still writes to google spreadsheet without 0, please help me out here.

mbaric avatar Sep 11 '17 13:09 mbaric

Same problem here. I tried to add ' to the value before call editCell() but it didn't work.

henryonsoftware avatar Jul 24 '20 11:07 henryonsoftware