tanaike

v1.2.3 (October 31, 2019) An option for inputting the directory to save the downloaded files was added. $ goodls -u [URL] -d [directory] The detail information and how to get this are https://github.

Gists Description I have already reported about “Automatic Recalculation of Custom Function on Spreadsheet Part 1” at here. Here, I would like to introduce other workaround for forcibly recalculating the custom functions and built-in functions using Class TextFinder. Class TextFinder has added at April 5, 2019. By this, this workaround can be proposed. Sample scripts Pattern 1 If you want to refresh all functions of all sheets in a Spreadsheet, you can use the following script.

GetEditType was updated to v1.0.1. v1.0.1 (October 25, 2019) Updated: This answer was reflected. You can see the detail information here https://github.com/tanaikech/GetEditType

ZipFolder was updated to v1.0.1. v1.0.1 (October 15, 2019) The option for preventing the duplicated filenames when the Google Docs is converted was added. You can see the detail information here https://github.com/tanaikech/ZipFolder

Overview This is a sample script for uploading multiple files with large size (> 50 MB) at the sidebar, dialog of Google Docs and Web Apps using the resumable upload of the asynchronous process with Javascript and Google Apps Script (GAS). Demo This is a demonstration of this script. As a demonstration, it uploads 5 files with the size of 100 MB to own Google Drive. When the files were selected and the upload button is clicked, those are uploaded by the resumable upload with the asynchronous process.