如何在Google apps脚本中创建动态下拉列表 [英] how to create dynamic dropdown list in the Google apps script

问题描述

我想使用Google Apps脚本动态更改Google Spreadsheet单元格验证功能中候选列表的值。

I would like to dynamically change the value of the candidate list in the cell validation feature of a Google Spreadsheet using the Google Apps Script.

我无法创建动态使用Google公式功能在Google电子表格中下拉列表。在Excel中，可以在Excel Spreadsheet中使用在下拉列表功能工作的单元格中设置的INDIRECT函数，引用单元格的值为动态设置列表范围名称。

I failed to create dynamic dropdown list in a Google Spreadsheet using the Google Formulas Feature. In Excel, it is possible in Excel Spreadsheet using the INDIRECT function set in the cell where the dropdown list feature works, referring the cell the value of which is set the list range name dynamically.

推荐答案

不幸的是，使用Apps脚本管理单元验证是不可能的。有关请求已打开的增强功能。您应该为它保留跟踪更新和投票种类。

Unfortunately it's not possible to manage cell validation using Apps Script. There's an enhancement request opened regarding this. You should star it to keep track of updates and kind of vote for it.

此外，Excel INDIRECT功能不适用于Google Spreadsheets。

Also, Excel INDIRECT feature does not work for Google Spreadsheets.

这篇关于如何在Google apps脚本中创建动态下拉列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！