Google Web App无法将光标正确放置在Google Sheet中 [英] Google Web App failing to properly place cursor in Google Sheet
本文介绍了Google Web App无法将光标正确放置在Google Sheet中的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我正在创建一个Google Web App，以打开一个我要附加一行的Google表格，然后将光标放在脚本已在其中添加新文本的单元格中.除了最后一步-光标放置，一切都正常.
I am creating a Google Web App to open a Google Sheet that I have appended a row to and then place the cursor in the cell into which the script has added the new text. Everything works but the last step--the cursor placement.
代码如下:
function doGet() {
return HtmlService
.createTemplateFromFile('Index')
.evaluate();
}
function addSong(objArgs) {
var ss = SpreadsheetApp.openById('id');
var url = ss.getUrl();
var sheet = ss.getActiveSheet();
var lastRow = sheet.getLastRow()
sheet.appendRow([lastRow+1]);
SpreadsheetApp.flush();
var range = sheet.getRange(sheet.getLastRow(), 1);
var songTitle = objArgs.songTitle;
Logger.log('songTitle: ' + songTitle)
var namedRange = sheet.getRange("Title");
var newRange = sheet.getRange(sheet.getLastRow(), namedRange.getColumn())
newRange.setValue(songTitle);
SpreadsheetApp.setActiveSpreadsheet(ss);
SpreadsheetApp.setActiveSheet(sheet);
SpreadsheetApp.setActiveRange(newRange);
//I suspect the error is in the lines below
return {
url: url,
newRange: newRange
};
}
Index.html
<!DOCTYPE html>
<html>
<head>
<base target="_top">
</head>
<body>
<br>Fill in field below with Song Title.<br>
Then click button to add new song to Catalog.<br><br>
<input id="idSongTitle" type="text" placeholder="Song Title"><br><br>
<button onclick="saveUserInput()">Add song to Catalog</button>
<script>
window.saveUserInput = function() {
var songTitle = document.getElementById('idSongTitle').value;
console.log('songTitle: ' + songTitle)
google.script.run
.withSuccessHandler(openCatalog)
.addSong({songTitle:songTitle})
}
// This function is detritus left over from something else. Doesn't seem to be impacting the rest of this.
function openCatalog(results){
window.open(results.url, '_blank').focus();
}
</script>
</body>
</html>
修改后的代码:
Code.gs
function doGet() {
return HtmlService
.createTemplateFromFile('Index')
.evaluate();
}
function addSong(objArgs) {
var id= "1-yN6yAGUuOp84apeN2Cwaq25rPD63qb_m2Oe-MSMaIM"
var ss = SpreadsheetApp.openById(id);
var url = ss.getUrl();
var sheet = ss.getActiveSheet();
var lastRow = sheet.getLastRow()
sheet.appendRow([lastRow+1]);
SpreadsheetApp.flush();
var range = sheet.getRange(sheet.getLastRow(), 1);
var songTitle = objArgs.songTitle;
Logger.log('songTitle: ' + songTitle)
var namedRange = sheet.getRange("Title");
var newRange = sheet.getRange(sheet.getLastRow(), namedRange.getColumn())
newRange.setValue(songTitle);
Logger.log(url)
return {
url: url
};
}
Index.html
<!DOCTYPE html>
<html>
<head>
<base target="_top">
</head>
<body>
<br>Fill in field below with Song Title.<br>
Then click button to add new song to Catalog.<br><br>
<input id="idSongTitle" type="text" placeholder="Song Title"><br><br>
<button onclick="saveUserInput()">Add song to Catalog</button>
<script>
window.saveUserInput = function() {
var songTitle = document.getElementById('idSongTitle').value;
console.log('songTitle: ' + songTitle)
google.script.run
.withSuccessHandler(openCatalog)
.addSong({songTitle:songTitle})
}
function openCatalog(results){
window.open(results.url, '_blank').focus();
}
</script>
</body>
</html>
最终脚本
Code.gs
function doGet() {
return HtmlService
.createTemplateFromFile('Index')
.evaluate();
}
function addSong(objArgs) {
var id= "1-yN6yAGUuOp84apeN2Cwaq25rPD63qb_m2Oe-MSMaIM"
var ss = SpreadsheetApp.openById(id);
var url = ss.getUrl();
var sheet = ss.getActiveSheet();
var lastRow = sheet.getLastRow()
sheet.appendRow([lastRow+1]);
SpreadsheetApp.flush();
var range = sheet.getRange(sheet.getLastRow(), 1);
var songTitle = objArgs.songTitle;
var namedRange = sheet.getRange("Title");
var newRange = sheet.getRange(sheet.getLastRow(), namedRange.getColumn())
var newLastRow = lastRow+1
newRange.setValue(songTitle);
url = url + "#gid=1286827341" + "&range=" + newLastRow + ":" + newLastRow;
Logger.log('url: ' + url)
return {
url: url
};
}
Index.html
<!DOCTYPE html>
<html>
<head>
<base target="_top">
</head>
<body>
<br>Fill in field below with Song Title.<br>
Then click button to add new song to Catalog.<br><br>
<input id="idSongTitle" type="text" placeholder="Song Title"><br><br>
<button onclick="saveUserInput()">Add song to Catalog</button>
<script>
window.saveUserInput = function() {
var songTitle = document.getElementById('idSongTitle').value;
console.log('songTitle: ' + songTitle)
google.script.run
.withSuccessHandler(openCatalog)
.addSong({songTitle:songTitle})
}
function openCatalog(url){
window.open(url);
}
</script>
</body>
</html>
轻微编辑
我退出了...
Slight Edit
I switched out...
return {
url: url
};
用于...
return url;
因为前者会产生400(错误请求)错误.
because the former was producing 400 (Bad Request) errors.
推荐答案
问题:
-
Issue:
Server-side:
newRangeis a inbuilt range object and not a legal return value1.客户端:尚未完成使
newRange处于活动范围的任何操作.Client-side: Nothing has been done to make the
newRangethe active range.- 请勿发送内置范围对象
newRange作为返回值. - 制作一个具有有效范围的URL作为url片段，并发送给它.
- Do not send
newRange, inbuilt range object as a return value. - Craft a url with active range as url fragment and send it instead.
//Url : https:docs.google.com/spreadsheets/[ID]/edit //Url fragment : #gid=[SHEET_ID]&range=[RANGE_A1_NOTATION] url = url + "#gid=" + sheet.getSheetId() + "&range=" + newRange.getA1Notation(); return url; //typeof url === "string"; No illegal return values present.Index.html:
function openCatalog(url){ window.open(url); }这篇关于Google Web App无法将光标正确放置在Google Sheet中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
- 请勿发送内置范围对象
查看全文
