【web电子表格】加号控制隐藏/显示列

function main(page: IPage, portlet: ITableSheetPortlet) {
    let cell = portlet.getCell(0, 0);
    let html = cell.getHtml() || "";
    cell.setHtml("- " + html);
    cell.setStyle({
        cursor: "pointer"
    });

    let collapsed = false;
    cell.addEventListener("click", function () {
        if (collapsed) {
            cell.setHtml("- " + html);
            for (var i = 1; i <= 3; i++) {
                for (var j = 0; j < portlet.getRowCount(); j++) {
                    let currentCell = portlet.getCell(j, i);
                    currentCell.setStyle({ display: ""});
                }
            }
        } else {
            cell.setHtml("+ " + html);
            for (var i = 1; i <= 3; i++) {
                for (var j = 0; j < portlet.getRowCount(); j++) {
                    let currentCell = portlet.getCell(j, i);
                    currentCell.setStyle({ display: "none"});
                }
            }            
        }
        collapsed = !collapsed;
    });
}

function main(page: IPage, portlet: ITableSheetPortlet) {
    let span = appendCollapseElement(portlet, "A1");
    let collapsed = false;
    span.addEventListener('click', function () {
        let spanText = collapsed ? "-" : "+";
        span.setHtml(spanText);
        hideColumns(portlet, 1, 4, !collapsed);
        collapsed = !collapsed;
    });
}

function appendCollapseElement(portlet: ITableSheetPortlet, cellName: string) {
    let cell = portlet.getCell(cellName);
    let text = cell.getText() || "";
    cell.setText("");
    let span = document.createElement("span");
    span.innerHTML = "-";
    span.style.cursor = "pointer";

    let s = cell.appendChild(span);
    cell.appendChild(document.createTextNode(" " + text));
    return s;
}

function hideColumns(portlet: ITableSheetPortlet,
    from: number, to: number, hidden: boolean) { 
    for (let c = from; c < to; c++) {
        var column = portlet.getColumn(c);
        column.setVisible(!hidden)
    }
}