search

asimlqt / php-google-spreadsheet-client

A PHP library for accessing and manipulating Google Spreadsheets
Other
544 stars 152 forks source link

Leading zero stripped off when trying to write to Google spreadsheet #178

Open mbaric opened 7 years ago

mbaric commented 7 years ago

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.

henryonsoftware commented 4 years ago

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