单元格换行处理

收藏

如何在单元格换行设置后单元格保留原有设置，我的表格比较复杂，单元格有样式，我设置单元格换行之后他其余的东西会消失，比如下拉框这些，如何统一了

raym · raym

//var color = sheet.getCell(row, col).backColor();
//var borderRight = sheet.getCell(row, col).borderRight();
//var borderBottom = sheet.getCell(row, col).borderBottom();
//var borderTop = sheet.getCell(row, col).borderTop();
//var style = new GC.Spread.Sheets.Style();
//style.wordWrap = true;//换行
//style.shrinkToFit = true;
//style.locked = false;
//style.backColor = color;
//style.borderRight = borderRight;
//style.borderBottom = borderBottom;
//style.borderTop = borderTop;
//style.hAlign = GC.Spread.Sheets.HorizontalAlign.center;
//style.vAlign = GC.Spread.Sheets.VerticalAlign.center;
//sheet.setStyle(row, col, style, GC.Spread.Sheets.SheetArea.viewport);