...
方案六、表格设置了冻结窗格，此时冻结区域的背景写死了是白色，可添加宏修改网格线颜色
| 代码块 |
|---|
|
//类型：ClientSide 对象：spreadsheetReport 事件：onRender
function main(spreadsheetReport, isAjaxRefreshCallback) {
//配置处理冻结表格边框的照相机名称。
var executeTables = ["Picture 31"];
//表格冻结后的背景色
var tableBgColor = "#03065B";
spreadsheetReport._ext_handerNum = 0;
var timer = setInterval((function() {
this._ext_handerNum++;
if (this._ext_handerNum > 1000) {
clearInterval(timer);
}
var shapesMap = this.shapesMap;
for (var i = 0; i < executeTables.length; i++) {
if (shapesMap[executeTables[i]]) {
var frame = shapesMap[executeTables[i]];
try {
var table = frame.contentWindow.document.getElementById("mainTable");
if (table) {
table.style.background = tableBgColor;
}
} catch (e) {
return;
}
try {
var table = frame.contentWindow.document.getElementById("frozenRow").getElementsByTagName("table")[0];
if (table) {
table.style.background = tableBgColor;
}
} catch (e) {
return;
}
try {
var table = frame.contentWindow.document.getElementById("frozenColumn").getElementsByTagName("table")[0];
if (table) {
table.style.background = tableBgColor;
}
} catch (e) {
return;
}
try {
var table = frame.contentWindow.document.getElementById("frozenCross").getElementsByTagName("table")[0];
if (table) {
table.style.background = tableBgColor;
}
} catch (e) {
return;
}
}
}
clearInterval(timer);
}).bind(spreadsheetReport), 100);
} |
方案六、表格设置了冻结窗格，通过url集成到仪表盘后，编辑状态正常，预览/打开报表，会有白色网格线，可添加宏修改网格线颜色
| 代码块 |
|---|
|
//类型：ClientSide 对象：spreadsheetReport 事件：onRender
function main(spreadsheetReport, isAjaxRefreshCallback) {
var doc = spreadsheetReport.elemSheetFrame.contentDocument;
var frozenColumn = doc.getElementById('frozenColumn');
var frozenRow = doc.getElementById('frozenRow');
var frozenCross = doc.getElementById('frozenCross');
// -----------------自定义颜色部分------------------------------
frozenColumn.style.backgroundColor = '#000';
frozenRow.style.backgroundColor = '#000';
frozenCross.style.backgroundColor = '#000';
// ----------------------结束-----------------------------------
} |
