设置全边框单元格，上下有隐藏行，只会出现三个边框。

收藏

你好

  确认这是spreadjs的一个bug

  我在一个单元格用api设置全边框，这个单元格上下行都是有隐藏行的，就会出现没有下边框的情况。

  有一个特定的条件是上下行的边框的颜色是白色的。

  1. 刚加载完出现的效果

   image.png466056212.png

2. 设置第三行，二列的单元格的全边框为黑色

image.png658962401.png

代码如下：

<!DOCTYPE html>
<html>
<head>
<title></title>
<meta charset="utf-8" />
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1" />
<meta name="spreadjs culture" content="zh-cn" />
<link
href="vendor/gcspread.sheets.excel2013white.9.40.20161.8.css"
rel="stylesheet"
type="text/css"
/>
<script
src="vendor/jquery-1.8.2.min.js"
type="text/javascript"></script>
<script type="text/javascript"
src="vendor/gcspread.sheets.all.9.40.20161.0.min.js"></script>
</head>
<body>
<div class="sample-turtorial">
<button id="btnSetBorder">Set Border</button>
<div
id="ss"
style="width:100%; height:370px;border: 1px solid gray;"></div>
</div>
<script>
var getRange = function (startAt, size) {
return [...Array(size).keys()].map(i => i + startAt);
}
window.onload = function() {
var spread = new GcSpread.Sheets.Spread(document.getElementById("ss"), {
sheetCount: 1
});
var sheet = spread.getActiveSheet();
sheet.reset();
var listIndexes = Array.from(Array(10).keys());
var listData = listIndexes.map(x => ({ index: x, value: -(x + 1) }));
listData.forEach(item => {
try {
sheet.getCell(item.index, 1).value(item.value);
} catch (err) {
console.log(err);
}
});
var borderRange1 = new GcSpread.Sheets.Range(0, 1, 1, 1);
sheet.setBorder(borderRange1, new GcSpread.Sheets.LineBorder("#FFFFFF", GcSpread.Sheets.LineStyle.thin), { all: true }, 3);
var borderRange2 = new GcSpread.Sheets.Range(4, 1, 1, 1);
sheet.setBorder(borderRange2, new GcSpread.Sheets.LineBorder("#FFFFFF", GcSpread.Sheets.LineStyle.thin), { all: true }, 3);
sheet.getRow(1).visible(false);
sheet.getRow(3).visible(false);
$("#btnSetBorder").click(function() {
var borderRange = new GcSpread.Sheets.Range(2, 1, 1, 1);
sheet.setBorder(borderRange, new GcSpread.Sheets.LineBorder("black", GcSpread.Sheets.LineStyle.thin), { all: true }, 3);
});
};
</script>
</body>
</html>