WPS-JSA窗体实现全局拼音模糊搜索

var 全局数组=$.maxArray("A1:E1")var 搜索数组=FormUtils.formatArray(全局数组,5,"yyyy-MM-dd");function 搜索(key){var 列数组=$.getIndexs(UserForm1.TextEdit3.Text).map(x=>x-1);var rs=$$.filter(搜索数组,x=>{var 整行=x.selectCols(列数组).join("\t")return pinyin.parse(整行).includes(key) || x[2].includes(key)  },1)  FormUtils.listBoxLoadArray(UserForm1.ListBox5,rs,UserForm1.ListBox6)  FormUtils.listboxFormatColumn(UserForm1.ListBox5,5,"yyyy-MM-dd")}function 输入(){var rs=FormUtils.listBoxSelectedValue(UserForm1.ListBox5);  [rs].toRange("H2")}function 显示窗体(){  UserForm1.Show(0)}functionUserForm1_TextEdit2_Change(){  搜索(UserForm1.TextEdit2.Text);}functionUserForm1_CommandButton11_Click(){  搜索(UserForm1.TextEdit2.Text);}functionUserForm1_Initialize(){  搜索(UserForm1.TextEdit2.Text);}functionUserForm1_TextEdit3_Change(){  搜索(UserForm1.TextEdit2.Text);}functionUserForm1_CommandButton12_Click(){  输入();}functionUserForm1_ListBox5_DblClick(cancel){  输入();}