JS改变下拉框展示值,比如我想展示的下拉框是 今年以前是年份,以及今年的月份,例如2021,2022,2023,2024-01,2024-02
自定义下拉框值或者数据里面构造
=split(CONCATENATE(YEAR(today()),",",UNIQUEARRAY(MAPARRAY(RANGE(DATEINYEAR(today(),1),DATEINYEAR(today(),-1),1),FORMAT(item,"yyyy-MM")))),",")