javascript - 设置背景 RGB 不接受函数参数

Question

我想做什么

Make a function in google sheets that will allow me to select a cell and enter "=rgbcolour", select 3 separate cells containing numbers between 0 and 255 to act as rgb values so that the cell that I entered "=rgbcolour" into will turn the appropriate colour as per the 3 separate rgb inputs

我的研究

setBackGroundRGB not accepting stringThis person ran into the same error put his desired result, his methods used and the solution to his problem would not seem to apply

This setBackground() or setFontColor not working in GAS helped me try and figure out how to pass the cell, that the function would be entered into, into the setBackgroundRGB method. I ended up using var cell = sheet.getActiveCell();Although I may have been unsuccessful in this endeavour which may be contributing to my problems

I have been using https://developers.google.com/apps-script/guides/sheets/functions#using_a_custom_function as a guide

这是我的代码

function RGBCOLOUR(r,g,b)
{
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheets()[0];
  var cell = sheet.getActiveCell();
  
  return cell.setBackgroundRGB(r,g,b);
}

这是我的错误

Cannot find method setBackgroundRGB((class),(class),(class)). (line7, file "RGB Colour Cell")

Answer 1

这是不可能的。根据文档，自定义函数只能返回值。不操纵格式。

https://developers.google.com/apps-script/guides/sheets/functions#return_values

如果我错了，请有人纠正我，以便我可以学到新的东西。