页面历史

function main(spreadsheetReport) {
    var D4 = spreadsheetReport.getCell(3, 3);
    var F4 = spreadsheetReport.getCell(3, 5);
    //初始设置单元格背景色、字体颜色以及某个图形展示，隐藏
    D4.style.backgroundColor = '#CE2B2B';   //当前展示的数据颜色
    F4.style.backgroundColor = '#95D0D9';   //可点击展示数据的颜色
    //  D4.style.color = '#ffffff';  设置字体颜色
    //  F4.style.color = '#727272';   
    spreadsheetReport.shapesMap["收入柱图"].style.display = "";
    spreadsheetReport.shapesMap["支出饼图"].style.display = "none";

    //为两个单元格添加点击事件
    spreadsheetReport.addListener(D4, "click", cellClick, spreadsheetReport);
    spreadsheetReport.addListener(F4, "click", cellClick, spreadsheetReport);
    if (!spreadsheetReport.modifyCellValue) {
        var SpreadsheetReport_Modify = jsloader.resolve('smartbi.spreadsheetreport.SpreadsheetReport_Modify');
        new SpreadsheetReport_Modify(spreadsheetReport);
    }
    function cellClick(e) {
        var t = e.target;
        if (!t) return;

        if (t.innerText == '收入') {
            D4.style.backgroundColor = '#CE2B2B';
            F4.style.backgroundColor = '#95D0D9';
            //    D4.style.color = '#ffffff';
            //     F4.style.color = '#727272';
            spreadsheetReport.shapesMap["收入柱图"].style.display = "";
            spreadsheetReport.shapesMap["支出饼图"].style.display = "none";

        } else if (t.innerText == '支出') {
            D4.style.backgroundColor = '#95D0D0';
            F4.style.backgroundColor = '#CE2B2B';
            //    D4.style.color = '#727272';
            //   F4.style.color = '#ffffff';
            spreadsheetReport.shapesMap["收入柱图"].style.display = "none";
            spreadsheetReport.shapesMap["支出饼图"].style.display = "";
        }
    }

}