在不合并单元格情况下隐藏两单元格之间的竖线,之前的想法是将竖线设为白色,但是出现缺口如下图所示,不知如何解决
var lineGray_W = new GC.Spread.Sheets.LineBorder('white', GC.Spread.Sheets.LineStyle.thin);
sheet.getRange(1, 1, 1, 2, GC.Spread.Sheets.SheetArea.viewport).setBorder(lineGray_W, {inside:true});
sheet.getRange(2, 1, 1, 2, GC.Spread.Sheets.SheetArea.viewport).setBorder(lineGray_W, {inside:true});
sheet.getRange(3, 1, 1, 2, GC.Spread.Sheets.SheetArea.viewport).setBorder(lineGray_W, {inside:true});
想了很多办法,后来问了服务人员才知道,将线条设为透明的(transparent)就可以解决,哎~
var lineGray_W = new GC.Spread.Sheets.LineBorder('transparent', GC.Spread.Sheets.LineStyle.thin);
sheet.getRange(1, 1, 1, 2, GC.Spread.Sheets.SheetArea.viewport).setBorder(lineGray_W, { inside: true });
sheet.getRange(2, 1, 1, 2, GC.Spread.Sheets.SheetArea.viewport).setBorder(lineGray_W, { inside: true });
sheet.getRange(3, 1, 1, 2, GC.Spread.Sheets.SheetArea.viewport).setBorder(lineGray_W, { inside: true });