[Situation]
From around last week, the script that was available until now suddenly disappeared when I opened the spreadsheet.
[Error Contents]
When I opened the script editor and asked them to run the target script, they said, "A server error has occurred.Please try again in a few moments.
[Script Purpose]
This is a script that uses the questionnaire function on a per-office basis and writes stamping information to a spreadsheet, but copies formulas as a subsequent process.
Script Contents
function onOpen(e){
vararr = [
{name:"Copy Formula", functionName:"copy"}
];
var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
spreadsheet.addMenu("Administrator Menu",arr);
}
function copy() {
varobjSpreadsheet=SpreadsheetApp.getActiveSpreadsheet();
varsheet=objSpreadsheet.getSheetByName("Original data for editing)");
rangeToCopy=sheet.getRange('F2:S2');
targetToCopy=sheet.getRange('F3:S');
rangeToCopy.copyTo(targetToCopy);
}
The script was not written by myself, but taken over from my predecessor, and I have no experience in scripting, so I have not been able to investigate the cause.
Thank you for your cooperation.
From Comments
I added a new project to the existing spret and copied the code to it, and it worked.I guess the new project is under my authority. I was able to deal with it without any problems.Thank you very much。 – user13569December 10, 2015 1:58
574 Who developed the "avformat-59.dll" that comes with FFmpeg?
613 GDB gets version error when attempting to debug with the Presense SDK (IDE)
916 When building Fast API+Uvicorn environment with PyInstaller, console=False results in an error
573 rails db:create error: Could not find mysql2-0.5.4 in any of the sources
© 2024 OneMinuteCode. All rights reserved.