//合并单元格
$('#mergeCell').bind('click', function(){
var selectedRanges = activeSheet.getSelections();
var column = selectedRanges[0].col;
var colCount =selectedRanges[0].colCount;
var row = selectedRanges[0].row;
var rowCount = selectedRanges[0].rowCount;
activeSheet.addSpan(row, column, rowCount, colCount, GC.Spread.Sheets.SheetArea.viewport);
});
//画边框
$('#drawOutBorder').bind('click', function(){
var range = getCellRange(activeSheet);
var border = getLineStyle();
range.setBorder(border,{outline:true});
});
这上面是对表单合并单元格并画边框线
-------------------------------------------------------------------
//判断隐藏掉的单元格
function isHiddenInSpan(row, col){
var span = activeSheet.getSpan(row, col);
if(span){
if(span.row == row && span.col == col){
return false;
}
else{
return true;
}
}
return false
}
//获取边框值,我是循环整个页面表单的单元格
var rowcount = activeSheet.getRowCount(GC.Spread.Sheets.SheetArea.viewport);
var colcount = activeSheet.getColumnCount(GC.Spread.Sheets.SheetArea.viewport);
for(var i = 0; i < rowcount; i++ ){
for(var j = 0; j < colcount; j++ ){
if(!isHiddenInSpan(i,j)){
var span = activeSheet.getSpans(new GC.Spread.Sheets.Range(i, j, 1, 1));
var cellRange = activeSheet.getRange(i, j, span[0].rowCount, span[0].colCount, GC.Spread.Sheets.SheetArea.viewport);
var temp={};
temp.cellStyleClass = "cellPanelGridTD";
if(cellRange.borderLeft()){
temp.cellStyleClass += "0";
}
if(cellRange.borderTop()){
temp.cellStyleClass += "1";
}
if(cellRange.borderRight()){
temp.cellStyleClass += "2";
}
if(cellRange.borderBottom()){
temp.cellStyleClass += "3";
}
}
}
}
这边对合并过的单元格只能取到left和top
最后得到的 temp.cellStyleClass=“cellPanelGridTD01”,我想要的是temp.cellStyleClass=“cellPanelGridTD0123” |