sheet.js

在线ExeclCopyright (c) iRows.com. All rights reserved. Do not copy

else{
var fsco=B1(vfr,vfc)
selimg.style.display='block'
selimg.style.top=fsco.y+"px"
selimg.style.left=fsco.x+"px"
var tsco=B1(vtr,vtc)
selimg.width=tsco.x+tsco.width-fsco.x
selimg.height=tsco.y+tsco.height-fsco.y
}
for(var c=1;c<=F2.maxCol;c++){
var head=itemIndex['HC'+c]
head.className=(c>=vfc&&c<=vtc)?'cellheadSelected':'cellhead'
}
for(var r=1;r<=F2.maxRow;r++){
var head=itemIndex['HR'+r]
head.className=(r>=vfr&&r<=vtr)?'cellheadSelected':'cellhead'
}
var sumfld=document.getElementById("autosum")
sumfld.innerHTML=F5.autosum!=null?"sum="+F5.autosum:""
}
function setCopyHandle(){
var copyhndl=document.getElementById('copyhndl')
if(F5.fromRow==0||
F5.fromCol==0||
Math.min(F5.toRow-F5.fromRow,F5.toCol-F5.fromCol)>0){
copyhndl.style.display='none'
}
else{
var vtco=B2(F5.toRow,F5.toCol)
if(vtco.row<=0||vtco.col<=0||vtco.row>F2.maxRow||vtco.col>F2.maxCol){
copyhndl.style.display='none'
}
else{
var scco=B1(vtco.row,vtco.col)
var y=scco.y+scco.height-3
var x=scco.x+scco.width-3
copyhndl.style.left=x+"px"
copyhndl.style.top=y+"px"
Drag.init(copyhndl,null,FQ+1,winsize.width,FT+1+FP+1,winsize.height)
copyhndl.onDragStart=function(x,y){copyHandleDragStart(x,y)}
copyhndl.onDrag=function(x,y){copyHandleDrag(x,y)}
copyhndl.onDragEnd=function(x,y){copyHandleDragEnd(x,y)}
copyhndl.style.display='block'
}}}
var copyDestEnd=null
function copyHandleDragStart(x,y){
FA='popup'
D4()
}
function copyHandleDrag(x,y){
var pos=B5(x,y)
var mco=B3(pos.row,pos.col)
if(pos.type=='cell'){
if(Math.max(F5.toRow-F5.fromRow,F5.toCol-F5.fromCol)==0){
var dx=Math.abs(mco.col-F5.fromCol)
var dy=Math.abs(mco.row-F5.fromRow)
if(dy>=dx)
copyDestEnd={row:mco.row,col:F5.fromCol}
else
copyDestEnd={row:F5.fromRow,col:mco.col}}
else{
if(F5.toRow-F5.fromRow>0)
copyDestEnd={row:F5.toRow,col:mco.col}
else
copyDestEnd={row:mco.row,col:F5.toCol}}
var fr=Math.min(F5.fromRow,copyDestEnd.row)
var tr=Math.max(F5.fromRow,copyDestEnd.row)
var fc=Math.min(F5.fromCol,copyDestEnd.col)
var tc=Math.max(F5.fromCol,copyDestEnd.col)
var fvco=B2(fr,fc)
var tvco=B2(tr,tc)
var fsco=B1(fvco.row,fvco.col)
var tsco=B1(tvco.row,tvco.col)
var area=document.getElementById('copyhndlarea')
area.style.top=fsco.y+'px'
area.style.left=fsco.x+'px'
area.style.width=(tsco.x-fsco.x+tsco.width-6)+'px'
area.style.height=(tsco.y-fsco.y+tsco.height-6)+'px'
if(area.style.display=='none')
area.style.display='block'
}}
function copyHandleDragEnd(x,y){
if(copyDestEnd){
var iterations=Math.max(Math.abs(copyDestEnd.row-F5.toRow),Math.abs(copyDestEnd.col-F5.toCol))
if(iterations>0){
var stepy=0
var stepx=0
if(copyDestEnd.row>F5.toRow)
stepy=1
else
if(copyDestEnd.row<F5.toRow)
stepy=-1
else
if(copyDestEnd.col>F5.toCol)
stepx=1
else
if(copyDestEnd.col<F5.toCol)
stepx=-1
var dx=0
var dy=0
var U_cmd=""
var R_cmd=""
while(iterations-->0){
dx+=stepx
dy+=stepy
var dtr=F5.fromRow+dy
var dtc=F5.fromCol+dx
var rdtr=dtr+Math.abs(F5.toRow-F5.fromRow)
var rdtc=dtc+Math.abs(F5.toCol-F5.fromCol)
U_cmd+=UR_rectProps(dtr,dtc,rdtr,rdtc)
model.copy(F5.fromRow,F5.fromCol,F5.toRow,F5.toCol,dtr,dtc,dtr,dtc)
R_cmd+=UR_rectProps(dtr,dtc,rdtr,rdtc)
}
UR_add(U_cmd,R_cmd,false)
}}
FA=null
var area=document.getElementById('copyhndlarea')
area.style.display='none'
if(copyDestEnd){
copyDestEnd=null
F6=true
C8(false)
}
else
setCopyHandle()
}
function D6H(){
if(!wrapper)
return
var maxCol=model.cols
maxCol=Math.max(maxCol,viewArea.fromCol+F2.maxCol-2)
var size=model.getColsWidth(maxCol,FO,1)
var visible=Math.min(size,winsize.width-FQ)
var start=model.getColsWidth(viewArea.fromCol-1,FO,1)
if(start+visible>size)
start=size-visible
if(viewArea.fromCol==1)
start=0
var physLen=winsize.width-(2 * 16)
var handleLen=Math.round((visible / size)* physLen)
var handleStart=Math.round((start / size)* physLen)
wrapper.SHUI_setHScrollRange(uiid,handleStart,handleLen)
}
function D6V(){
if(!wrapper)
return
var maxRow=model.rows
var maxRow=Math.max(maxRow,viewArea.fromRow+F2.maxRow-2)
var size=maxRow * FP
var visible=Math.min(size,winsize.height-FT-FP)
var start=(viewArea.fromRow-1)* FP
if(start+visible>size)
start=size-visible
var physLen=winsize.height-(2 * 16)
var handleLen=Math.round((visible / size)* physLen)
var handleStart=Math.round((start / size)* physLen)
wrapper.SHUI_setVScrollRange(uiid,handleStart,handleLen)
}
function HScrollDrag(pct){
D2()
var maxCol=model.cols
maxCol=Math.max(maxCol,viewArea.fromCol+F2.maxCol-2)
var size=model.getColsWidth(maxCol,FO,1)
var pos=Math.round(size * pct)
var c=1
var cpos=0
while(cpos<pos){
var w=colWidth(c)
cpos+=w
c++
}
viewArea.fromCol=Math.max(1,c-1)
F6=true
C8(true)
}
function VScrollDrag(pct){
D2()
var maxRow=model.rows
var maxRow=Math.max(maxRow,viewArea.fromRow+F2.maxRow-2)
var fromRow=Math.round((maxRow-1)* pct)+1
viewArea.fromRow=fromRow
F6=true
C8(false)
}
function scrollPage(dir){
if(dir=='u'||dir=='d'){
if(dir=='u')
viewArea.fromRow=Math.max(1,viewArea.fromRow-(F2.maxRow-2))
else
viewArea.fromRow+=F2.maxRow-2
C8(false)
}
else{
if(dir=='l')
viewArea.fromCol=Math.max(1,viewArea.fromCol-(F2.maxCol-2))
else
viewArea.fromCol+=F2.maxCol-2
C8(true)
}}
var draggedViewColumn
function C9Start(img,x,y){
var col=parseInt(img.id.substring(2))
var w=parseInt(itemIndex['HC'+col].style.width)
draggedViewColumn={col:col,x:x,width:w}
FA='popup'
for(var c=1;c<=F2.maxCol;c++){
if(c!=col)
itemIndex['RC'+c].style.display="none"
}
document.getElementById('copyhndl').style.display="none"
document.getElementById("sel").style.display="none"
}
function C9End(x,y){
FA=null
for(var c=1;c<=F2.maxCol;c++)
itemIndex['RC'+c].style.display='block'
var dx=x-draggedViewColumn.x
var vco=B3(1,draggedViewColumn.col)
var U_cmd=UR_colProps(vco.col)
model.setColWidth(vco.col,draggedViewColumn.width+dx)
var R_cmd=UR_colProps(vco.col)
draggedViewColumn=null
UR_add(U_cmd,R_cmd,true)
C8(true)
}
function C9(x,y){
var dx=x-draggedViewColumn.x
resizeColumn(draggedViewColumn.col,draggedViewColumn.width+dx)
}
function resizeColumn(col,newWidth){
var cell=itemIndex['VR1C'+col]
var newX=[]
var x=parseInt(cell.style.left)+newWidth+1
for(var c=col+1;c<=F2.maxCol;c++){
newX[c]=x
var cell=itemIndex['VR1C'+c]
var w=parseInt(cell.style.width)
x+=w+1
}
var cell=itemIndex['HC'+col]
cell.style.width=newWidth+'px'
for(var c=col+1;c<=F2.maxCol;c++){
var cell=itemIndex['HC'+c]
cell.style.left=newX[c]+'px'
}
for(var r=1;r<=F2.maxRow;r++){
var cell=itemIndex['VR'+r+'C'+col]
cell.style.width=newWidth+'px'
for(var c=col+1;c<=F2.maxCol;c++){
var cell=itemIndex['VR'+r+'C'+c]
cell.style.left=newX[c]+'px'
}}}
function D8(viewFld,errors){
var m=""
m+="<table border='0'>"
for(var i=0;i<Math.min(5,errors.length);i++){
m+="<tr height='4'><td></td></tr>"
var err=errors[i]
var cellId=colLabel(err.col)+err.row
m+="<tr valign='top'>"
m+="<td style='font-size:10pt; font-family:verdana,arial,sans-serif; color:#333333;'><span style='position:relative'>&nbsp;"+cellId+"&nbsp;</span></td>"
m+="<td nowrap='true' style='font-size:10pt; font-family:verdana,arial,sans-serif; color:#333333;'><span style='position:relative'><b>"
var formulaCell=model.getCell(err.row,err.col)
var formulaText=''
if(formulaCell)
formulaText=formulaCell.text.substring(1)
var pref=formulaText.substring(0,err.start)
var suf=formulaText.substring(err.length+err.start)
var mid=formulaText.substring(err.start,err.length+err.start)
var fmtText="="+pref+"<span style='background-color:#ff6d74; border:1px solid red'>"+mid+"</span>"+suf
m+="<span style='font-size:10pt; font-family:monospace; font-weight:bold;'>"+fmtText+"</span>"
m+="</b><br />"
m+=err.message
m+="</span></td><td>"
m+="</tr>"
m+="<tr height='4'><td></td></tr>"
}
m+="</table>"
var errwin=document.getElementById("errmsg")
var errtxt=document.getElementById("errmsgs")
errtxt.innerHTML=m
var x=parseInt(viewFld.style.left)
var y=parseInt(viewFld.style.top)+FP
errwin.style.top=y+"px"
errwin.style.left=x+"px"
errwin.style.display="block"
Drag.init(errwin,null,0,winsize.width,0,winsize.height)
errwin.onDragStart=function(x,y){FA='popup'}
errwin.onDrag=function(x,y){window.scrollTo(0,0)}
errwin.onDragEnd=function(x,y){FA=null;window.scrollTo(0,0)}}
function closeErrors(){
var errwin=document.getElementById("errmsg")
errwin.style.display="none"
}
function FC(){
img=document.createElement("img")
img.setAttribute('id','img'+FD.length)
img.style.position='absolute'
img.style.display='none'
img.style.zIndex='96'
document.getElementsByTagName("body").item(0).appendChild(img)
FD[FD.length]={used:true,img:img}
img.style.border='1px solid black'
return img
}
function freeImage(i){
var ime=FD[i]
ime.used=false
ime.img.style.display='none'
}
function freeImageById(id){
for(var i=0;i<FD.length;i++){
var ime=FD[i]
if(ime.img.id==id){
freeImage(i)
break
}}}
function freeAllImages(){
for(var i=0;i<FD.length;i++)
freeImage(i)
}
function buildImages(){
freeAllImages()
var images=model.getImages()
for(var imi=0;imi<images.length;imi++){
var imo=images[imi]
var img=FC()
imo.img=img
if(imo.url)
img.setAttribute('src',imo.url)
}}
function imgDrag(img,x,y){
setChartResize(null)
var cliptop=(FT+FP+1)-y
var clipleft=(FQ+1)-x
if(cliptop<=0&&clipleft<=0)
img.style.clip='rect(auto auto auto auto)'
else
img.style.clip='rect('+(cliptop<=0?'auto':cliptop+'px')+' auto auto '+(clipleft<=0?'auto':clipleft+'px')+')'
}
function imgDragEnd(img,x,y){
var mco=screenToModelCoords(x,y)
var imo=model.getImageByImgId(img.id)
if(imo){
imo.row=mco.row
imo.col=mco.col
imo.offX=mco.dx
imo.offY=mco.dy
model.putImage(imo,false)
setChartResize(img)
C8(false)
}}
function setChartResize(img){
var rsvh=document.getElementById('chrsz')
if(img&&img.src.indexOf('chartfiles')>=0){
rsvh.style.display='block'
var ix=parseInt(img.style.left)
var iy=parseInt(img.style.top)
rsvh.style.top=(iy-16+img.height)+'px'
rsvh.style.left=(ix-16+img.width)+'px'
Drag.init(rsvh,null,ix+60,2000,iy+60,2000)
rsvh.onDrag=function(x,y){FE(x,y)}
rsvh.onDragEnd=function(x,y){FEEnd(x,y)}}
else rsvh.style.display='none'
}
function checkModelChanges(){
var cl=model.G3()
if(cl&&cl.length>0){
for(var ia=0;ia<cl.length;ia++){
var ac=cl[ia]
var vco=B2(ac.row,ac.col)
var avf=B7(vco.row,vco.col)
if(avf&&avf.className!="edit")
C6(avf,model.getCellAttrs(ac.row,ac.col))
}}
setTimeout("checkModelChanges()",1000)
}
function UR_add(cmdUndo,cmdRedo,redraw){
if(cmdUndo==cmdRedo)
return
var FH={undo:cmdUndo,redo:cmdRedo,redraw:redraw,vfr:viewArea.fromRow,vtr:viewArea.toRow,focusRow:F3.row,focusCol:F3.col}
FF[++FFPos]=FH
FFMax=FFPos+1
toolbar.enable('undo',true)
toolbar.enable('redo',false)
}
function UR_cellValue(mr,mc){
var cell=model.getCell(mr,mc)
var cmd="UR_setv("+mr+","+mc+",'"+escape(cell?cell.text:"")+"');"
return cmd
}
function UR_setv(r,c,ev){
setValue(r,c,unescape(ev))
var vco=B2(r,c)
var viewFld=B7(vco.row,vco.col)
if(viewFld){
var cellAttrs=model.getCellAttrs(r,c)
C6(viewFld,cellAttrs)
}}
function UR_props(e){
if(e==null)
return"null,null,null,null,null"
var cmd=""
cmd+=(e.color!=null?("'"+e.color+"'"):"null")
cmd+=","+(e.bgcolor!=null?("'"+e.bgcolor+"'"):"null")
cmd+=","+(e.style!=null?("'"+e.style+"'"):"null")
cmd+=","+(e.align!=null?("'"+e.align+"'"):"null")
cmd+=","+(e.pattern!=null?("'"+e.pattern+"'"):"null")
return cmd
}
function UR_cellProps(mr,mc){
var cell=model.getCell(mr,mc)
var cmd="UR_setp("+mr+","+mc+","
if(cell==null)
cmd+="'',"
else
cmd+="'"+escape(cell?cell.text:"")+"',"
cmd+=UR_props(cell)
cmd+=");"
return cmd
}
function UR_rowProps(mr){
var row=model.getRow(mr)
var cmd="UR_setrp("+mr+","
cmd+=UR_props(row)
cmd+=");"
return cmd
}
function UR_colProps(mc){
var col=model.getCol(mc)
var cmd="UR_setcp("+mc+","
if(col&&col.width)
cmd+=col.width+","
else
cmd+="0,"
cmd+=UR_props(col)
cmd+=");"
return cmd
}
function UR_rectProps(fr,fc,tr,tc){
var cmd=""
for(var r=fr;r<=tr;r++)
for(var c=fc;c<=tc;c++)
cmd+=UR_cellProps(r,c)
return cmd
}
function UR_setp(r,c,ev,color,bgcolor,style,align,pattern){
var text=unescape(ev)
var cell={row:r,col:c,text:'',color:color,bgcolor:bgcolor,style:style,align:align,pattern:pattern}
model.put(cell)
UR_setv(r,c,text)
}
function UR_setrp(r,color,bgcolor,style,align,pattern){
var row={row:r,color:color,bgcolor:bgcolor,style:style,align:align,pattern:pattern}
model.putRow(row)
reshowRow(r)
}
function UR_setcp(c,width,color,bgcolor,style,align,pattern){
var col={col:c,width:width,color:color,bgcolor:bgcolor,style:style,align:align,pattern:pattern}
model.putCol(col)
reshowCol(c)
}
function UR_del(r,c){
var cell={row:r,col:c,text:''}
model.put(cell)
UR_setv(r,c,'')
}
function TB_undo(){
toolbar.close()
closeErrors()
if(FFPos>=0){
var FH=FF[FFPos--]
FG(FH,true)
}}
function TB_redo(){
toolbar.close()
closeErrors()
if(FFPos<FFMax-1){
var FH=FF[++FFPos]
FG(FH,false)
}}
function FG(FH,undo){
var redraw=FH.redraw
var cmd=undo?FH.undo:FH.redo
if(viewArea.fromRow!=FH.vfr||viewArea.toRow!=FH.vtr||cmd.charAt(0)=='<'){
viewArea.fromRow=FH.vfr
viewArea.toRow=FH.vtr
redraw=true
}
if(cmd.charAt(0)=='<')
model.read(cmd)
else
eval(cmd)
toolbar.enable('undo',FFPos>=0)
toolbar.enable('redo',FFPos<FFMax-1)
F6=true
if(redraw){
F3={row:FH.focusRow,col:FH.focusCol}
F5={fromRow:FH.focusRow,fromCol:FH.focusCol,toRow:FH.focusRow,toCol:FH.focusCol}
if(cmd.charAt(0)=='<')
rebuildSheet()
else
C8(true)
}
else{
var vco=B2(F3.row,F3.col)
B9(vco.row,vco.col,false)
}}
function TB_sum(){
if(F5.fromRow!=F5.toRow){
for(var c=F5.fromCol;c<=F5.toCol;c++){
var f="=sum("+colLabel(c)+F5.fromRow+":"+colLabel(c)+F5.toRow+")"
var r=F5.toRow+1
var U_cmd=UR_cellValue(r,c)
setValue(r,c,f)
var R_cmd=UR_cellValue(r,c)
UR_add(U_cmd,R_cmd,false)
var vco=B2(r,c)
var viewFld=B7(vco.row,vco.col)
if(viewFld){
var cellAttrs=model.getCellAttrs(r,c)
C6(viewFld,cellAttrs)
}}}
else if(F5.fromCol!=F5.toCol){
var r=F5.fromRow
var f="=sum("+colLabel(F5.fromCol)+r+":"+colLabel(F5.toCol)+r+")"
var c=F5.toCol+1
setValue(r,c,f)
var vco=B2(r,c)
var viewFld=B7(vco.row,vco.col)
if(viewFld){
var cellAttrs=model.getCellAttrs(r,c)
C6(viewFld,cellAttrs)
}}
else{
var mr=F3.row
var mc=F3.col
var vco=B2(mr,mc)
var viewFld=B7(vco.row,vco.col)
if(viewFld){
var f="=sum()"
var pmr=mr-1
while(pmr>=1){
var cell=model.getCell(pmr,mc)
if(cell&&cell.type=="number")
break
pmr--
}
if(pmr>=1){
while(pmr>=1){
var cell=model.getCell(pmr,mc)
if(!cell||cell.type!="number")
break
pmr--
}
f="=sum("+colLabel(mc)+(pmr+1)+":"+colLabel(mc)+(mr-1)+")"
}
else{
var pmc=mc-1
while(pmc>=1){
var cell=model.getCell(mr,pmc)
if(cell&&cell.type=="number")
break
pmc--
}
if(pmc>=1){
while(pmc>=1){
var cell=model.getCell(mr,pmc)
if(!cell||cell.type!="number")
break
pmc--
}
f="=sum("+colLabel(pmc+1)+mr+":"+colLabel(mc-1)+mr+")"
}}
viewFld.value=f
viewFld.focus()
viewFld.select()
}}}
function D9(props,forcePut){
var addAttrs=true
var fromRow=F5.fromRow
var toRow=F5.toRow
var fromCol=F5.fromCol
var toCol=F5.toCol
var U_cmd=""
var R_cmd=""
if(fromRow==0){
for(var mc=fromCol;mc<=toCol;mc++){
var col=model.getCol(mc)
if(!col){
col={col:mc}
model.putCol(col)
}
U_cmd+=UR_colProps(mc)
for(var p in props)
col[p]=props[p]
R_cmd+=UR_colProps(mc)
reshowCol(mc)
}
fromRow=1
toRow=model.rows
addAttrs=false
}
if(fromCol==0){
for(var mr=fromRow;mr<=toRow;mr++){
var row=model.getRow(mr)
if(!row){
row={row:mr}
model.putRow(row)
}
U_cmd+=UR_rowProps(mr)
for(var p in props)
row[p]=props[p]
R_cmd+=UR_rowProps(mr)
reshowRow(mr)
}
fromCol=1
toCol=model.cols
}
for(var mr=fromRow;mr<=toRow;mr++){
for(var mc=fromCol;mc<=toCol;mc++){
U_cmd+=UR_cellProps(mr,mc)
var cell=model.getCell(mr,mc)
if(!cell&&addAttrs){
cell={row:mr,col:mc,text:''}
model.put(cell)
}