实际上源码中有一个设置项:
- var combo = new spreadNS.CellTypes.ComboBox();
- combo.items([{ text: "Oranges", value: "11k" }, { text: "Apples", value: "15k" }, { text: "Grape", value: "100k" }])
- .editorValueType(spreadNS.CellTypes.EditorValueType.text);
- sheet.setValue(0, 3, "Result:");
- sheet.getCell(1, 2, spreadNS.SheetArea.viewport).cellType(combo).value("Apples");
- sheet.setValue(1, 1, "ComboBoxCellType");
- sheet.setFormula(1, 3, "=C2");
复制代码
就是这句:
editorValueType(spreadNS.CellTypes.EditorValueType.text);
把这句后边的text改为value即可:
editorValueType(spreadNS.CellTypes.EditorValueType.value); |