kreja

name: Values and formulas
description: Gets and sets values and formulas for a range.
author: kreja
host: EXCEL
api_set: {}
script:
    content: |
        $("#setup").click(() => tryCatch(setup));

        async function setup() {

kreja

name: delete table rows doesn’t trigger onChanged
description: delete table rows doesn’t trigger onChanged
author: kreja
host: EXCEL
api_set: {}
script:
    content: |
        $("#create-table").click(createTable);

        async function createTable() {

kreja

name: 锁定
description: lock a range
author: kreja
host: EXCEL
api_set: {}
script:
    content: |
        $("#setup").click(setup);
        async function setup() {
            await Excel.run(async (context) => {

kreja

// https://github.com/MostlyAdequate/mostly-adequate-guide
// https://llh911001.gitbooks.io/mostly-adequate-guide-chinese/content/ch5.html
// this is my practice while reading the book


var compose = function(){
    var args = arguments;

    return function(x){
        var res = x;

kreja

/* 后端数据 */
var data = {
    "10;20;30": {
        price: 5,
        count: 1
    },
    "10;20;31": {
        price: 10,
        count: 2
    },

kreja

/**
 * 执行语句： node --trace_opt --trace_deopt --allow-natives-syntax test.js
 */

// 包含需要审查的用法的函数 (这里是 with 语句)
function containsHeight() {
    return 3;
    // with({}) { } // with 注释掉之后，又可以优化了
}

kreja

/*
* 疑问：看别人的代码里也没这样写。。。这真的有必要吗？
*/
var ele = $('#page')[0];
var id = ele.id;

ele.onclick = function(){
    console.log(id); // 不要在这里引用 ele, 因为是闭包，ele 会占内存
}

kreja

function specialString(){
    var values = new String(arguments[0]);

    values.startWith= function(text){
        if(values.indexOf(text) == 0){
            return true;
        }else{
            console.log(values,values.indexOf(text));
            return false;
        }

kreja

var rectangle = {
    _h: 1,
    _w: 1,
    _area: 1
};

Object.defineProperties(rectangle,{
    h: {
        get: function(){
            return this._h;