页面历史

function main(spreadsheetReport) {
    var list = spreadsheetReport.getSheetByName("Sheet1").getExpandedPositions("C3")//条形码字段所在单元格
    var cells = spreadsheetReport.workbook.worksheets.get("Sheet1").cells;
    for (var i = 0; i < list.length; i++) {
        var pos = list[i];
        var v = cells.get(pos.row, pos.column).value
        var check = 1;
        if (!v)
            continue;
        for (var j = 0; j < v.length(); j++) {
            var c = v.charCodeAt(j);
            if (c < 135) {
                c -= 32
            } else {
                c -= 100
            }
            check = (check + (j + 1) * c) % 103
        }
        if (check < 95 && check > 0) {
            check += 32
        } else if(check > 94) {
            check += 100
        }
        v = String.fromCharCode(204) + v + String.fromCharCode(check) + String.fromCharCode(206)
        cells.get(pos.row, pos.column).value = v;
    }
}