May 2015 – Poor Coding

Excel:A1 <-> Coord:(1,1)

// 0 | 1 case 0: (0,0) -> A1 case 1: (1,1) -> A1
var coordinationIndexBase = 1;

var reRow = new RegExp("(\\d+)$");
var reCol = new RegExp("^([A-Z]+)");

var getRowName = function(cellName) {
    var found = cellName.match(reRow);
    if(!found){
        throw new Error("Parameter \"cellName\" has no convertable row name. cellName = " + cellName + "");
    }
    return found[0];
};

var getColName = function(cellName) {
    var found = cellName.match(reCol);
    if(!found){
        throw new Error("Parameter \"cellName\" has no convertable column name. cellName = " + cellName + "");
    }
    return found[0];
};

var getRowIndex= function(cellName) {
    var rowIndex = parseInt(getRowName(cellName));
    rowIndex -= 1 - coordinationIndexBase;
    return rowIndex;
};

var getColIndex  = function(cellName){
    var colName = getColName(cellName);
    var colIndex = 0;
    for (var i = 0, iLen = colName.length; i < iLen ; i++) {
        colIndex *= 26;
        colIndex += alpha2number(colName[i]) + 1;
    }
    colIndex -= 1 - coordinationIndexBase;
    return colIndex;
};

var getCellName = function(rowIndex , colIndex){
    if(rowIndex < coordinationIndexBase){
         throw new Error("Parameter \"rowIndex\" can't less then "+coordinationIndexBase  +". rowIndex = " + rowIndex + "");
    }
    
    if(colIndex < coordinationIndexBase){
         throw new Error("Parameter \"colIndex\" can't less then "+coordinationIndexBase  +". colIndex = " + colIndex + "");
    }
    
    rowIndex -= coordinationIndexBase - 1;
    colIndex -= coordinationIndexBase - 1;
    var colName = '';
    while (true) {
        colIndex -= 1 
        colName = number2alpha(colIndex % 26) + colName;
        colIndex = Math.floor(colIndex / 26);
        if (colIndex <= 0) {
            break;
        }
    }
    return cellName = colName + rowIndex;
}
// A -> 0
var alpha2number = function(alpha) {
    var number = alpha.charCodeAt(0) - 65;
    return number;
}
    
// 0 -> A
var number2alpha = function(number) {
    if (number < 0) {
        return "";
    }
    var alpha = String.fromCharCode(65 + number);
    return alpha;
}

// 0 | 1 case 0: (0,0) -> A1 case 1: (1,1) -> A1

var coordinationIndexBase = 1;

var reRow = new RegExp("(\\d+)$");

var reCol = new RegExp("^([A-Z]+)");

var getRowName = function(cellName) {

var found = cellName.match(reRow);

if(!found){

throw new Error("Parameter \"cellName\" has no convertable row name. cellName = " + cellName + "");

}

return found[0];

};

var getColName = function(cellName) {

var found = cellName.match(reCol);

if(!found){

throw new Error("Parameter \"cellName\" has no convertable column name. cellName = " + cellName + "");

}

return found[0];

};

var getRowIndex= function(cellName) {

var rowIndex = parseInt(getRowName(cellName));

rowIndex -= 1 - coordinationIndexBase;

return rowIndex;

};

var getColIndex = function(cellName){

var colName = getColName(cellName);

var colIndex = 0;

for (var i = 0, iLen = colName.length; i < iLen ; i++) {

colIndex *= 26;

colIndex += alpha2number(colName[i]) + 1;

}

colIndex -= 1 - coordinationIndexBase;

return colIndex;

};

var getCellName = function(rowIndex , colIndex){

if(rowIndex < coordinationIndexBase){

throw new Error("Parameter \"rowIndex\" can't less then "+coordinationIndexBase +". rowIndex = " + rowIndex + "");

}

if(colIndex < coordinationIndexBase){

throw new Error("Parameter \"colIndex\" can't less then "+coordinationIndexBase +". colIndex = " + colIndex + "");

}

rowIndex -= coordinationIndexBase - 1;

colIndex -= coordinationIndexBase - 1;

var colName = '';

while (true) {

colIndex -= 1

colName = number2alpha(colIndex % 26) + colName;

colIndex = Math.floor(colIndex / 26);

if (colIndex <= 0) {

break;

}

return cellName = colName + rowIndex;

}

// A -> 0

var alpha2number = function(alpha) {

var number = alpha.charCodeAt(0) - 65;

return number;

}

// 0 -> A

var number2alpha = function(number) {

if (number < 0) {

return "";

}

var alpha = String.fromCharCode(65 + number);

return alpha;

}

When I test canvas animation used createJS,
I found afterimage.

I can find afterimage use setTimeout.
Canvas’s parent div changed after canvas’s animation started.

Devices error found is below.
Sharp AQUOS PHONE SHL24（Android　4.2.2)
Sony XperiaA SO-04E (Android 4.2.2)

pseudo code

<div id="scr01">
   // ... some images
</div> 
<div id="scr02">
   <canvas id="anime"></canvas>
</div>

$("#anime")[some animation started by CreateJS]
setTimeout(function(){
    $("#scr01").hide();
    $("#scr02").show();
},1000);

// ... some images

</div>

</div>

$("#anime")[some animation started by CreateJS]

setTimeout(function(){

$("#scr01").hide();

$("#scr02").show();

},1000);

JavaScript Excel coordination changer

git filename is too long

Android 4.2.2 default browser canvas bug