页面实现报表的超链接效果

function main(spreadsheetReport) {
    spreadsheetReport.printExpandedPositions()
}

function main(spreadsheetReport) {
    //左侧报表超链接所在sheet页名称和单元格名称
    var linkCell = "B2";
    var sheetName = "Sheet1";
    if (!spreadsheetReport || (spreadsheetReport.outputType != "refresh" && spreadsheetReport.outputType != "HTML")) return;
    var sheet = spreadsheetReport.getSheetByName(sheetName);
    var positions = linkCell.split(",");
    for (var i = 0; i < positions.length; i++) {
        var position = positions[i].trim();
        var expandedPositions = sheet.getExpandedPositions(position);
        for (var j = 0; j < expandedPositions.length; j++) {
            var cell = sheet.getCell(expandedPositions[j]);
            if (true) {
                addLink(spreadsheetReport, sheet, cell, linkCell);
            }
        }
    }
}
function addLink(spreadsheetReport, sheet, cell, linkCell) {
    sheet.addRuleLink(cell.cellPosition, "anyRuleName", [
        getCellValue(cell.getRelativeCells(linkCell))
    ]);
}
function getCellValue(cell) {
    if (!cell) return null;
    if (typeof cell.length == 'number') {
        var ret = [];
        for (var i = 0; i < cell.length; i++) {
            ret.push(cell[i].value);
        }
        return ret;
    } else {
        return cell.value;
    }
}
function checkValue(v1, v2, op) {
    if (v1 && typeof v1.length == 'number') {
        for (var i = 0; i < v1.length; i++) {
            if (checkValue(v1[i], v2, op)) return true;
        }
        return false;
    }
    if (v2.match(/^d+(.d+)?$/)) {
        v2 = parseFloat(v2);
    }
    switch (op) {
        case 'EQUAL':
            return (v1 == v2) || (v2.match(/^\d+(\.\d+)?$/) && v1 == parseFloat(v2));
        case 'GREATER':
            return v1 > v2;
        case 'LESS':
            return v1 < v2;
        case 'INCLUDE':
            return v1 && v1.indexOf(v2) >= 0;
        case 'PREFIX':
            return v1 && v1.indexOf(v2) == 0;
        case 'SUFFIX':
            return v1 && v1.indexOf(v2) == (v1.length - v2.length);
    }
}

function paramToString(v) {
    return v == null ? null : v.toString();
}

function main(spreadsheetReport, ruleName, params, page, pageContext) {
    //配置目标单元格（员工姓名扩展字段所在单元格）
    var actionCell = "B3";
    //配置右侧报表的节点Id
    var targetResId = "I402882fd015b21fa21fa98e7015b220a522c00c0";
    var newReport = false;
    var dashlet = page.findDashletByReportId(targetResId);
    if (!dashlet)
        return;
    var portlet = dashlet.currentPortlet;
    if (!portlet) {
        return;
    }
    //获取右侧报表电子表格对象
    var actionReport = portlet.getPortletObject();
    var list = actionReport.getExpandedPositions(actionCell);
    //获取目标单元格
    var cell = getInsCell(params, list, actionReport);
    var doc = cell.ownerDocument;
    var c = cell;
    var top = -1;
    var scale = doc._scale || 1;
    var posScale = domutils.isMobile() ? 1 : scale;
    while (c) {
        top += c.offsetTop;
        c = c.offsetParent;
    }
    var frozenColumn = doc.getElementById('frozenColumn');
    var frozenTop = frozenColumn ? frozenColumn.clientHeight : 0;
    var el;
    /*if (domutils.isIE()) {
        el = doc.documentElement;
    } else {
        el = doc.scrollingElement;
    }*/
    el = doc.documentElement || doc.scrollingElement;
    
    var bodyWidth = doc.documentElement.clientWidth;
    var bodyHeight = doc.documentElement.clientHeight;
    if (doc.divScroll) {
        doc.divScroll.scrollTop = (top + cell.clientHeight + 2) * posScale;
        if (top - doc.divScroll.scrollTop / posScale < frozenTop) {
            doc.divScroll.scrollTop = (top - frozenTop + 1) * posScale;
        }
    } else {
        el.scrollTop = (top - 2 * cell.clientHeight + 2) * posScale;
        if (top - el.scrollTop / posScale < frozenTop) {
            el.scrollTop = (top - frozenTop + 1) * posScale;
        }
    }
    
    
    //获取目标单元格
    function getInsCell(params, list, actionReport) {
        var cellLight;
        for (var i = 0; i < list.length; i++) {
            var pos = actionReport.parseCellIndex(list[i]);
            var cell = actionReport.getCell(pos[0], pos[1]);
            if (cell.bgColor) {
                cell.bgColor = "";
            }
            //高亮目标单元格
            if (cell.innerHTML == params[0][0]) {
                cellLight = actionReport.getCell(pos[0], pos[1]);
                cellLight.bgColor = "yellow";
            }
        }
        return cellLight;
    }
}