页面历史

function main(spreadsheetReport) {
    if (spreadsheetReport.outputType !== "EXCEL2007" || spreadsheetReport.outputType == "LIST_EXCEL") return; {
        spreadsheetReport.cacheable = false;
        var workbook = spreadsheetReport.workbook;
        var worksheets = workbook.worksheets;
        for (var i = 0; i < worksheets.count; i++) {
            var worksheet = worksheets.get(i);
            var cells = worksheet.cells;
            var maxDisplayRange = cells.maxDisplayRange;
            for (var x = 0; x < maxDisplayRange.rowCount; x++) {
                for (var y = 0; y < maxDisplayRange.columnCount; y++) {
                    var cell = cells.get(x, y);
                    if (cell.isFormula()) {
                        cell.value = cell.value;
                    }
                }
            }
        }
    }
}