Gists This is a sample script for copying the date object between Google Spreadsheets with the different time zones using Google Apps Script. One day, you might have a situation in which it is required to copy the date object between Google Spreadsheets with the different time zones using Google Apps Script. In this post, I would like to introduce the sample scripts for achieving this. Sample situation Here, the sample situation is declared.
Gists This is a sample script for moving the selected cell to the top left on Google Spreadsheet to focus it using Google Apps Script. One day, there might be a case where you are required to focus the specific cell on Google Spreadsheet to help edit cells. In this post, I would like to introduce a sample script for achieving this. Sample script Please copy and paste the following script to the script editor of Google Spreadsheet, and save the script.
PDFApp was updated to v1.0.2. v1.0.2 (August 21, 2023) A new method of insertHeaderFooter was added. Ref When this method is used, the custom header and footer can be added when a Google Spreadsheet is exported as PDF. You can see the detail information here https://github.com/tanaikech/PDFApp
Gists This is a sample script for adding header and footer to PDF using Google Apps Script. In the current stage, when Google Spreadsheet is manually exported as a PDF file at “Print settings” on the UI of Spreadsheet, the custom header and footer can be added as shown in the following image. But, unfortunately, in the current stage, this cannot be directly achieved by Google Apps Script. So, I created this sample script.