spreadjs 中Combox类型的Cell如何显示列表

收藏

如下JSON [
               { name: "Alice", age: 27, birthday: "1985/08/31", position: "PM" },
               { name: "Aimee", age: 28, birthday: "1984/07/31", position: "TL" },
               { name: "Charles", age: 29, birthday: "1983/03/31", position: "QC" },
               { name: "Fred", age: 30, birthday: "1982/02/20", position: "DL" },
               { name: "Angelia", age: 31, birthday: "1981/05/30", position: "QC" },
               { name: "Peter", age: 32, birthday: "1980/11/08", position: "QC" }
            ];

在ComBox下拉中显示，指定Name列绑定到Value上，或者把一行数据返回也可以

dexteryao · dexteryao

重新组合下您的数据源。把内容放到value中
[{ text: "Alice", value: { name: "Alice", age: 27, birthday: "1985/08/31", position: "PM" } },
{ text: "Aimee", value: { name: "Aimee", age: 28, birthday: "1985/08/31", position: "PM" } },

］

aisiwo · aisiwo

spread js 中Combox好像不支持这种JSON数据

dexteryao · dexteryao

关键是这一行 eComboBoxCellType.editorValueType( GcSpread.Sheets.EditorValueType.Value);

var items2 =
[
{
"text": "Alice",
"value": {
"name": "Alice",
"age": 27,
"birthday": "1985/08/31",
"position": "PM"
}
},
{
"text": "Aimee",
"value": {
"name": "Aimee",
"age": 28,
"birthday": "1985/08/31",
"position": "PM"
}
}
];
var eComboBoxCellType = new GcSpread.Sheets.ComboBoxCellType().items(items2).editable(true);
eComboBoxCellType.editorValueType( GcSpread.Sheets.EditorValueType.Value);
activeSheet.getCell(1, 3).cellType(eComboBoxCellType);
activeSheet.setColumnWidth(3,120);
};
function Get(){
var activeSheet = spread.getActiveSheet();
alert( JSON.stringify( activeSheet.getCell(1,3).value()));
}

复制代码

aisiwo · aisiwo

显示不出啦
var items2 =
[
{
      "text": "Alice",
      "value": {
         "name": "Alice",
         "age": 27,
         "birthday": "1985/08/31",
         "position": "PM"
      }
},
{
      "text": "Aimee",
      "value": {
         "name": "Aimee",
         "age": 28,
         "birthday": "1985/08/31",
         "position": "PM"
      }
}
];

var eComboBoxCellType = new GcSpread.Sheets.ComboBoxCellType().items(items2).editable(true);
         eComboBoxCellType.editorValueType( GcSpread.Sheets.EditorValueType.Value);
activeSheet.getCell(1, 3).cellType(eComboBoxCellType);
activeSheet.setColumnWidth(3,120);

};
function Get(){
         var activeSheet = spread.getActiveSheet();
      alert( JSON.stringify( activeSheet.getCell(1,3).value()));
}

dexteryao · dexteryao

什么意思，什么显示不出来?

		自动登录	找回密码
密码			立即注册

[已处理] spreadjs 中Combox类型的Cell如何显示列表

5 个回复

活字格认证

讲师达人

悬赏达人

元老葡萄

SpreadJS 认证

SpreadJS 高级认证

微信认证勋章