setValue或setFormula不起作用(setValue or setFormula not working)

setValue或setFormula不起作用(setValue or setFormula not working)

调试器似乎向我显示正确设置的所有变量。 不确定为什么它没有正确粘贴这些值。

var ss = SpreadsheetApp.getActiveSpreadsheet(); var budgetsheet = ss.getSheets()[1]; var lastcol = budgetsheet.getLastColumn(); var prevrange = budgetsheet.getRange(4, lastcol); var prevdate = budgetsheet.getRange(4, lastcol).getValue(); var mydateformula = "=" + prevrange.getA1Notation() + "+7"; var futurerange = budgetsheet.getRange(4, lastcol +1); //insert the columns and copy the fomatting budgetsheet.insertColumnsAfter(lastcol, 1); //paste the date as a value futurerange.setFormula(mydateformula); //neither setValue or setFormula seem to work

The debugger seems to show me all the variables setting correctly. Not really sure why its not pasting the values correctly.

var ss = SpreadsheetApp.getActiveSpreadsheet(); var budgetsheet = ss.getSheets()[1]; var lastcol = budgetsheet.getLastColumn(); var prevrange = budgetsheet.getRange(4, lastcol); var prevdate = budgetsheet.getRange(4, lastcol).getValue(); var mydateformula = "=" + prevrange.getA1Notation() + "+7"; var futurerange = budgetsheet.getRange(4, lastcol +1); //insert the columns and copy the fomatting budgetsheet.insertColumnsAfter(lastcol, 1); //paste the date as a value futurerange.setFormula(mydateformula); //neither setValue or setFormula seem to work

最满意答案

代码似乎起作用。 也许是缓存问题。

The code seems to function. Perhaps a cache issue.