js web excel 0.56 改进版

darkfox123 2008-11-25 06:33:27

新的修正说明:
//------------------------------------------------------------------------------------



//------------------------------------------------------------------------------------

excel/e_e.js



function ie_setup ()::

callbackReClick::oCurFocusCell.setAttribute( "to_hint", 1 );  

//优化,只有当单元存在这个属性时才刷新与本单元关联单元的样式



//------------------------------------------------------------------------------------        

excel/matrix.js

        

        this.alphaToInt = function ( utag )             //根据字母编号获取位置

        {   var xlat = "ABCDEFGHIJKLMNOPQRSTUVWXYZ";

            var alpha = 0;

            utag = utag.toUpperCase();

            for(var i=0;i<utag.length;i++)

            {   if( isNaN( parseInt(utag.charAt(i) )) ) 

                    alpha += xlat.indexOf(utag.charAt(i)) + Math.pow(26,i); //<---[改动]

                else

                    break;

            }

            return alpha-1;  //<---[改动]

        }

        //-----------------------------------------

        this.getCol = function ( utag )             //根据编号获取表格单元

        {

            var xlat = "ABCDEFGHIJKLMNOPQRSTUVWXYZ";

            var alpha = 0;

            var p="";

            utag = utag.toUpperCase();

            

            for(var i=0;i<utag.length;i++)

            {   if( isNaN( parseInt(utag.charAt(i) )) ) 

                    alpha += xlat.indexOf(utag.charAt(i))+ Math.pow(26,i);//<---[改动]

                else

                    p+= utag.charAt(i);

            }

            p = parseInt(p);

            if( p       > 0 )p      --;

            var cells = 0;

            var oTd   = null;

            for( var i=0; i < alpha; i++ ) //<---[改动]

                cells += myself.tp[p][i];

            if( cells   > 0 )cells  --;

            try{

                oTd = myself.otable.rows.item( p ).cells.item( cells );

            }

            catch(err)

            {   alert( "err:matrix:getCol()" + err + "|" + p + "|" + cells );

            }

            return oTd;

        }