页面历史

function paramToString(v) {
    return v == null ? null : v.toString();
};
function main(spreadsheetReport, param) {
    // 避免宏代码循环调用
    if (!spreadsheetReport.__init) {
        return;
    }
    if (param.name == "层级") { //判断参数名称是否为"B"
        var destQuery = null;
        var command = spreadsheetReport.command;
        command.close();
        if (param.value == 1) { //如果参数B的值为2，则打开电子表格2
            destQuery = 'I8aa782bd015949814981ce3c01595f0d97f4740a'; //电子表格2的ID
        }
        if (param.value == 2) { //如果参数B的值为2，则打开电子表格2
            destQuery = 'I8aa782bd015949814981ce3c01595f12d1667472'; //电子表格2的ID
        }

        if (param.value == 3) { //如果参数B的值为1，则打开电子表格1    
            destQuery = 'I8aa782bd015949814981ce3c01595f15a03c74c7'; //电子表格1的ID
        }

        command.execute('OPENWITHNOREFRESH', destQuery);
        //spreadsheetReport.autoRefresh = false;
        var report = command.spreadsheetReport;
        if (spreadsheetReport.params.length > 0) {
            report.setParamsInfo(spreadsheetReport.buildParamsInfo()); // 传递所有参数值
        }
        if (spreadsheetReport.autoRefresh == 1) { // 增加电子表格切换参数自动刷新判断
            report.doRefresh();
        }
    }
};