GoogleSheets icon indicating copy to clipboard operation
GoogleSheets copied to clipboard

adjust Time Format for dvl2021.gs

Open yoenoess opened this issue 3 years ago • 2 comments

How to Change the time format?

I type 27 March 1982 on source sheet and this is result on target sheet Sat Mar 27 1982 19:00:00 GMT+0200 (Eastern European Standard Time)

need to make it appear as 27 March 1982. changing display_values: True to False doesnt effect anything

yoenoess avatar Nov 24 '21 13:11 yoenoess

getDisplayValues

https://developers.google.com/apps-script/reference/spreadsheet/range#getdisplayvalues

Max-Makhrov avatar Nov 24 '21 13:11 Max-Makhrov

@Max-Makhrov thankyou for replying, im still confuse how to edit your script, its so high tech.

display_values im talking about is the one on { dict: "'Countries'!A2:C", sheet: "Dropdowns", first_row: 2, display_values: true, columns: [13, 14, 18] // ['M', 'N', 'R'] },

yoenoess avatar Nov 24 '21 14:11 yoenoess