node-google-spreadsheet
node-google-spreadsheet copied to clipboard
feat(worksheet): allow change valueInputOption for header row
Hi,
I suggest this change cause I've a bug on one of my devs.
In France, we mostly use dates with this format : dd/mm/yyyy and the leading 0 is important on day, month and year.
But with USER_ENTERED, at least on french version of google spreadsheet, it removes each time the leading 0 on the month. Don't understand why.
So a solution is to allow developper choose its valueInputOption
.
My PR don't break anything, just add an option which still use by default USER_ENTERED