經過咗呢三個月既努力, 返工聯會, 由最基本 html5 開始學起,
跟住再學初階 javascript, 由再不停地鑽研巴打你呢個 post 入面既 codes,
codes,
我終於做到我想做既啦
我終於寫成咗我要既 code,
呢個 code 主要係 4 行格仔加混算模式, 我自己寫成後其實係有
1 - 20 行既唔同 function, 下方 share 咗 4 行模式既 code 俾巴打參詳,
等巴打知道當初我想做既事項, 同埋我亦學識咗自建功能表, 呢個 funtion 真係好正
function bbb_border4(){
var sheet = SpreadsheetApp.getActiveSheet();
var row = sheet.getActiveCell().getRow();
var cell = SpreadsheetApp.getActiveSheet().getActiveSelection();
sheet.getRange(row, 1, 1, 10).activate();
cell.setBorder(true, true, true, true, false, false);
var sheet = SpreadsheetApp.getActiveSheet();
var row = sheet.getActiveCell().getRow();
var cell = SpreadsheetApp.getActiveSheet().getActiveSelection();
sheet.getRange(row, 1, 1, 10).activate();
cell.setBorder(true, true, true, true, false, false);
var sheet = SpreadsheetApp.getActiveSheet();
var row = sheet.getActiveCell().getRow();
var cell = SpreadsheetApp.getActiveSheet().getActiveSelection();
sheet.getRange(row, 1, 1, 7).activate();
cell.setBorder(true, true, true, true, false, false);
var sheet = SpreadsheetApp.getActiveSheet();
var row = sheet.getActiveCell().getRow();
var cell = SpreadsheetApp.getActiveSheet().getActiveSelection();
sheet.getRange(row, 1, 1, 7).activate();
cell.setBorder(true, true, true, true, false, false);
var sheet = SpreadsheetApp.getActiveSheet();
var row = sheet.getActiveCell().getRow();
var cell = SpreadsheetApp.getActiveSheet().getActiveSelection();
sheet.getRange(row, 1, 1, 1).activate();
cell.setBorder(true, true, true, true, false, false);
var sheet = SpreadsheetApp.getActiveSheet();
var row = sheet.getActiveCell().getRow();
var cell = SpreadsheetApp.getActiveSheet().getActiveSelection();
sheet.getRange(row, 1, 1, 1).activate();
cell.setBorder(true, true, true, true, false, false);
sheet.getRange(row+0, 1, 1).setValue("S/O:");
sheet.getRange(row+0, 7, 1).setValue("Date:");
sheet.getRange(row+1, 1, 1).setValue("cm");
sheet.getRange(row+1, 3, 1).setValue("cm");
sheet.getRange(row+1, 5, 1).setValue("cm");
sheet.getRange(row+1, 7, 1).setValue("Volume");
sheet.getRange(row+1, 8, 1).setValue("Unit");
sheet.getRange(row+1, 9, 1).setValue("CBM");
sheet.getRange(row+1, 10, 1).setValue("KGS");
sheet.getRange(row+2, 2, 1).setValue("X");
sheet.getRange(row+2, 4, 1).setValue("X");
sheet.getRange(row+2, 6, 1).setValue("X");
sheet.getRange(row+3, 2, 1).setValue("X");
sheet.getRange(row+3, 4, 1).setValue("X");
sheet.getRange(row+3, 6, 1).setValue("X");
sheet.getRange(row+4, 2, 1).setValue("X");
sheet.getRange(row+4, 4, 1).setValue("X");
sheet.getRange(row+4, 6, 1).setValue("X");
sheet.getRange(row+5, 2, 1).setValue("X");
sheet.getRange(row+5, 4, 1).setValue("X");
sheet.getRange(row+5, 6, 1).setValue("X");
var a = [ ["=(R[0]C[-8])/100"] ];
var b = [ ["*(R[0]C[-6])/100"] ];
var c = [ ["*(R[0]C[-4])/100"] ];
var d = [ ["*(R[0]C[-2])"] ];
var formulas1 = a + b + c + d;
var c = [ ["=(R[-1]C[-0])"] ];
var d = [ ["+(R[-2]C[-0])"] ];
var e = [ ["+(R[-3]C[-0])"] ];
var f = [ ["+(R[-4]C[-0])"] ];
var formulas2 = c + d + e + f;
var c = [ ["=(R[-1]C[-0])"] ];
var d = [ ["+(R[-2]C[-0])"] ];
var e = [ ["+(R[-3]C[-0])"] ];
var f = [ ["+(R[-4]C[-0])"] ];
var formulas3 = c + d + e + f;
var c = [ ["=(R[-1]C[-0])"] ];
var d = [ ["+(R[-2]C[-0])"] ];
var e = [ ["+(R[-3]C[-0])"] ];
var f = [ ["+(R[-4]C[-0])"] ];
var formulas4 = c + d + e + f;
sheet.getRange(row+2, 9).setValue(formulas1);
sheet.getRange(row+3, 9).setValue(formulas1);
sheet.getRange(row+4, 9).setValue(formulas1);
sheet.getRange(row+5, 9).setValue(formulas1);
sheet.getRange(row+6, 9).setValue(formulas2);
sheet.getRange(row+6, 7).setValue(formulas3);
sheet.getRange(row+6, 10).setValue(formulas4);
cell.setHorizontalAlignment("center");
cell.setFontSize("12");