search

bubakazouba / autoauto

1 stars 0 forks source link

Create a `_numToCol` that works for all columns #65

Closed bubakazouba closed 3 years ago

bubakazouba commented 3 years ago

currently _numToCol method in contentutils.js only works for columns A->Z

// TODO: this only works for A->Z
    function _numToCol(colNum) {
        return String.fromCharCode(colNum + "A".charCodeAt(0) - 1);
    }
bubakazouba commented 3 years ago

contentutils.js: function colNumAndRowToCell

bubakazouba commented 3 years ago

[27,3] -> "Z3"

[28,3] -> "AA3"