node-google-spreadsheet icon indicating copy to clipboard operation
node-google-spreadsheet copied to clipboard

feat(worksheet): allow change valueInputOption for header row

Open MathRobin opened this issue 2 years ago • 0 comments

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

MathRobin avatar Jul 01 '22 16:07 MathRobin