search

jpillora / node-edit-google-spreadsheet

A simple API for editing Google Spreadsheets
304 stars 101 forks source link

Problem with leading zero #66

Closed larsha closed 9 years ago

larsha commented 9 years ago

I'm having problems with leading zeros getting removed from data in the spreadsheet. I have formatted the spreadsheet to plain text and also making sure the data that I send is a string. Am I missing something?

larsha commented 9 years ago

If anyone stumbles upon same issue, just prefix the input data with a leading ' (single quote). Maybe everyone except me knows this and are more comfortable in Excel etc. Anyway, great package!