sheet.js

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

}
function onBodyMouseDown(e){
e.returnValue=true
if(!initdone)return
if(wrapper)
wrapper.onSheetMouseDown()
if(!e)e=window.event
var cx=e.clientX
var cy=e.clientY
if(document.getElementById(FU).style.display!='none'){
F8=false
return
}
if(cy>=FT){
var images=model.getImages()
for(var i=0;i<images.length;i++){
var imo=images[i]
var img=imo.img
var w=(img.width?img.width:16)
var h=(img.height?img.height:16)
var x=parseInt(img.style.left,10)
var y=parseInt(img.style.top,10)
if(cx>=x&&cx<x+w&&cy>=y&&cy<y+h){
F8=false
if(!F5.image||F5.image!=img){
if(F5.image)
F5.image.style.border='1px solid black'
F5.image=img
img.style.border='1px dashed blue'
setChartResize(img)
}
return
}}
if(F5.image){
F5.image.style.border='1px solid black'
F5.image=null
setChartResize(null)
}}
F8=true
var vco=B5(cx,cy)
if(vco){
if(vco.type=='col'){
var c=viewArea.fromCol+vco.col-1
if(e.shiftKey){
if(F5.fromRow==0){
setSelection(0,Math.min(F4,c),0,Math.max(F4,c))
selFocusFld()
}}
else{
F4=c
setSelection(0,c,0,c)
}}
else
if(vco.type=='row'){
var r=viewArea.fromRow+vco.row-1
if(e.shiftKey){
if(F5.fromCol==0){
setSelection(Math.min(F4,r),0,Math.max(F4,r),0)
selFocusFld()
}}
else{
F4=r
setSelection(r,0,r,0)
}}}
return true
}
function onBodyMouseUp(e){
if(!initdone)return
if(!e)e=window.event
F8=false
FA=null
return true
}
function onBodyMouseMove(e){
if(!initdone)return
if(!e)e=window.event
if(document.getElementById(FU).style.display!='none'||FA=='popup')
return
if(F8){
var vco=B5(e.clientX,e.clientY)
if(vco){
if(vco.type=='cell'&&F5.fromRow>0&&F5.fromCol>0){
var mco=B3(vco.row,vco.col)
if(FA=='setname'){
var fco=B3(F3.row,F3.col)
var ve=B7(fco.row,fco.col)
var cellId=colLabel(mco.col)+mco.row
ve.value=addCellRangeEnd(ve.value,cellId)
D3(ve.value)
}
else{
var mr=mco.row
var mc=mco.col
var fr=Math.min(mr,F3.row)
var tr=Math.max(mr,F3.row)
var fc=Math.min(mc,F3.col)
var tc=Math.max(mc,F3.col)
setSelection(fr,fc,tr,tc)
}}
else
if(vco.type=="col"||vco.type=="row"){
if(vco.type=="col"){
var c=viewArea.fromCol+vco.col-1
if(F5.fromRow!=0)
F4=F3.col
setSelection(0,Math.min(F4,c),0,Math.max(F4,c))
}
else{
var r=viewArea.fromRow+vco.row-1
if(F5.fromCol!=0)
F4=F3.row
setSelection(Math.min(F4,r),0,Math.max(F4,r),0)
}
e.returnValue=false
selFocusFld()
}}}
return e.returnValue
}
function onBodyDblClick(e){
if(F5.image)
setTimeout('TB_editChart()',200)
return true
}
function C1(e,vr,vc){
if(!e)e=window.event
if(e.shiftKey){
var mco=B3(vr,vc)
var mr=mco.row
var mc=mco.col
var fr=Math.min(mr,F3.row)
var tr=Math.max(mr,F3.row)
var fc=Math.min(mc,F3.col)
var tc=Math.max(mc,F3.col)
setSelection(fr,fc,tr,tc)
F7=new Date().getTime()+200
e.returnValue=false
e.cancelBubble=true
return false
}
if(F3){
var mco=B3(vr,vc)
var vco=B2(F3.row,F3.col)
var ve=B7(vco.row,vco.col)
if(ve){
var lastChar='?'
if(ve.value.length>0&&ve.value.charAt(0)=='=')
lastChar=ve.value.charAt(ve.value.length-1)
if(FS.indexOf(lastChar)>=0){
ve.value=ve.value+colLabel(mco.col)+mco.row
D3(ve.value)
F8=true
FA='setname'
F7=new Date().getTime()+200
e.returnValue=false
e.cancelBubble=true
return false
}}}
if(e.button==2)
setTimeout("TB_context("+e.clientX+","+e.clientY+", 'cell')",200)
return true
}
function addCellRangeEnd(value,cellId){
var i
for(i=value.length-1;i>=0;i--){
if(FS.indexOf(value.charAt(i))>=0&&value.charAt(i)!=':')
break
}
if(i<0)
return value+':'+cellId
var suf=value.substring(i+1)
if(suf.toUpperCase()==cellId)
return value
var ic=suf.indexOf(':')
if(ic<0)
return value+':'+cellId
return value.substring(0,i+1)+suf.substring(0,ic+1)+cellId
}
function D4(){
if(!F3)
return true
var mr=F3.row
var mc=F3.col
var vco=B2(mr,mc)
var viewFld=B7(vco.row,vco.col)
if(viewFld&&viewFld.className=='edit'){
var value=viewFld.value
var U_cmd=UR_cellValue(mr,mc)
setValue(mr,mc,value)
var R_cmd=UR_cellValue(mr,mc)
UR_add(U_cmd,R_cmd,false)
}}
function setValue(mr,mc,value){
var modelCell=model.getCell(mr,mc)
var vco=B2(mr,mc)
var viewFld=B7(vco.row,vco.col)
var affected
if(value==''){
if(modelCell){
if(modelCell.color||modelCell.bgcolor||modelCell.align||modelCell.style||modelCell.pattern){
modelCell.text=''
var r=model.put(modelCell)
affected=r.affected
}
else{
var r=model.remove(mr,mc)
affected=r.affected
}
if(r.errors.length>0){
success=false
D8(viewFld,r.errors)
}
else{
closeErrors()
}}}
else{
if(!modelCell||modelCell.text!=value||modelCell.formulaErrorType){
var color=modelCell?modelCell.color:null
var bgcolor=modelCell?modelCell.bgcolor:null
var align=modelCell?modelCell.align:null
var style=modelCell?modelCell.style:null
var pattern=modelCell?modelCell.pattern:null
modelCell={row:mr,col:mc,text:value,color:color,bgcolor:bgcolor,align:align,style:style,pattern:pattern}
var r=model.put(modelCell)
affected=r.affected
if(r.errors.length>0){
success=false
D8(viewFld,r.errors)
}
else{
closeErrors()
}}}
if(affected&&affected.length>0){
for(var ia=0;ia<affected.length;ia++){
var ac=affected[ia]
var vco=B2(ac.row,ac.col)
var avf=B7(vco.row,vco.col)
if(avf)
C6(avf,model.getCellAttrs(ac.row,ac.col))
}}}
function D5(mr,mc){
F3={row:mr,col:mc}
setSelection(mr,mc,mr,mc)
}
function delSelection(){
if(F5.image){
var imo=model.getImageByImgId(F5.image.id)
if(imo){
var U_cmd=model.toXml()
model.removeImage(imo.id)
freeImageById(F5.image.id)
var R_cmd=model.toXml()
UR_add(U_cmd,R_cmd,true)
}
F5.image=null
var rsvh=document.getElementById('chrsz')
rsvh.style.display='none'
}
else
if(F5.fromRow!=F5.toRow||F5.fromCol!=F5.toCol||F5.fromRow==0||F5.fromCol==0){
var fr=F5.fromRow
var tr=F5.toRow
var fc=F5.fromCol
var tc=F5.toCol
if(fr==0){
fr=1
tr=model.rows
}
if(fc==0){
fc=1
tc=model.col
}
var U_cmd=""
var R_cmd=""
for(var r=fr;r<=tr;r++){
for(var c=fc;c<=tc;c++){
if(model.getCell(r,c)){
U_cmd+=UR_cellProps(r,c)
model.remove(r,c)
R_cmd+="UR_del("+r+","+c+");"
}}}
UR_add(U_cmd,R_cmd,false)
C8(false)
}}
function wheel(event){
if(!event)event=window.event
var delta=0
if(event.wheelDelta)
delta=event.wheelDelta
else if(event.detail)
delta=-event.detail
if(delta)
delta=delta<0?-1:+1
if(delta){
if(delta>0)
scroll('u',4)
else
scroll('d',4)
}}
if(window.addEventListener)
window.addEventListener('DOMMouseScroll',wheel,false);/* For mozilla. */
window.onmousewheel=document.onmousewheel=wheel;/* IE. */
function onBodyKeyDown(e){
if(!initdone)return
if(document.getElementById(FU).style.display!='none')
return
if(!e)e=window.event
var k=e.keyCode
e.returnValue=true
if(k>=37&&k<=40&&e.shiftKey){
var ddc=[-1,0,1,0 ]
var ddr=[ 0,-1,0,1 ]
var keyInd=k-37
var dc=ddc[keyInd]
var dr=ddr[keyInd]
var maysel=true
if(currFocusFld!=null){
if(document.selection)
allSelected=currFocusFld.value==document.selection.createRange().text
else
allSelected=currFocusFld.selectionStart==0&&currFocusFld.selectionEnd>=currFocusFld.value.length
if(!allSelected)
maysel=false
}
if(maysel){
var sr=F5.fromRow
var sc=F5.fromCol
var er=F5.toRow
var ec=F5.toCol
if(F5.fromRow>0&&F5.fromCol>0){
if(er==F3.row)
er=sr
if(ec==F3.col)
ec=sc
ec=Math.max(1,ec+dc)
er=Math.max(1,er+dr)
sr=F3.row
sc=F3.col
}
if(sr==0){
if(ec==F4)
ec=sc
sc=F4
ec=Math.max(1,ec+dc)
}
else
if(sc==0){
if(er==F4)
er=sr
sr=F4
er=Math.max(1,er+dr)
}
var fr=Math.min(sr,er)
var tr=Math.max(sr,er)
var fc=Math.min(sc,ec)
var tc=Math.max(sc,ec)
setSelection(fr,fc,tr,tc)
e.returnValue=false
e.cancelBubble=true
}}
else
if(k==33||k==34||(k>=37&&k<=40)){
setTimeout("window.scrollTo(0,0)",10)
}
else
if(k==46){
delSelection()
}
else
if(e.ctrlKey&&k==83&&wrapper){
setTimeout("wrapper.doSave()",200)
e.returnValue=false
}
else
if(e.ctrlKey&&(k==67||k==86||k==88||k==89||k==90)){
e.returnValue=(k==67)
if(k==67)
TB_copy()
if(k==86)
TB_paste()
if(k==88)
TB_cut()
if(k==89)
TB_redo()
if(k==90)
TB_undo()
e.cancelBubble=true
}
if(e.ctrlKey&&(k==66||k==73||k==85)){
e.returnValue=false
if(k==66)
TB_text('b')
if(k==73)
TB_text('i')
if(k==85)
TB_text('u')
}
else
if(e.ctrlKey&&(k==35||k==36)){
D4()
if(k==36){
viewArea.fromRow=1
viewArea.fromCol=1
D5(1,1)
}
else{
var fr=model.rows-F2.maxRow+2
viewArea.fromRow=Math.max(1,fr)
D5(model.rows,viewArea.fromCol)
}
F6=true
C8(true)
e.returnValue=false
e.cancelBubble=true
}
else
if(k==75&&e.ctrlKey){
e.returnValue=false
TB_impXml()
}
else
if(k==74&&e.ctrlKey){
e.returnValue=false
TB_expXml()
}
return e.returnValue
}
function C2(e){
if(!e)e=window.event
var k=e.keyCode
var passEvent=true
var evaluate=false
e.returnValue=true
if(k==33||k==34){
D4()
var mr=viewArea.fromRow
var scRows=F2.maxRow-1
if(k==33){
mr=Math.max(1,mr-scRows)
D5(Math.max(1,F3.row-scRows),F3.col)
}
else{
mr+=scRows
D5(F3.row+scRows,F3.col)
}
viewArea.fromRow=mr
F6=true
C8(false)
e.returnValue=false
e.cancelBubble=true
}
else
if(!e.shiftKey&&(k==13||(k>=37&&k<=40))){
if(k==13)
k=40
var allowScroll=true
if(k==37||k==39){
var vco=B2(F3.row,F3.col)
var focusViewFld=B7(vco.row,vco.col)
var allSelected=false
if(focusViewFld){
if(document.selection)
allSelected=focusViewFld.value==document.selection.createRange().text
else
allSelected=focusViewFld.selectionStart==0&&focusViewFld.selectionEnd>=focusViewFld.value.length
}
if(!allSelected)
allowScroll=false
}
if(allowScroll){
D4()
var ddc=[-1,0,1,0 ]
var ddr=[ 0,-1,0,1 ]
var scrollDir=['l','u','r','d']
var keyInd=k-37
var vco=B2(F3.row,F3.col)
var vr=vco.row+ddr[keyInd]
var vc=vco.col+ddc[keyInd]
var viewFld=B7(vr,vc)
if(viewFld){
viewFld.focus()
}
else{
D5(Math.max(1,F3.row+ddr[keyInd]),Math.max(1,F3.col+ddc[keyInd]))
F6=true
scroll(scrollDir[keyInd],1)
}
e.returnValue=false
e.cancelBubble=true
}}
else if(k==27||k==113){
var mr=F3.row
var mc=F3.col
var vco=B2(mr,mc)
var vr=vco.row
var vc=vco.col
var viewFld=B7(vr,vc)
if(viewFld){
var allSelected=false
if(document.selection)
allSelected=viewFld.value==document.selection.createRange().text
else
allSelected=viewFld.selectionStart==0&&viewFld.selectionEnd>=viewFld.value.length
if(allSelected){
B4(viewFld,0,0)
}
else{
F9=true
B9(vr,vc,false)
F9=false
}}}
else
if(e.ctrlKey&&(k==67||k==86||k==88||k==89||k==90)){
e.returnValue=(k==67)
if(k==67)
TB_copy()
if(k==86)
TB_paste()
if(k==88)
TB_cut()
if(k==89)
TB_redo()
if(k==90)
TB_undo()
e.cancelBubble=true
}
return e.returnValue
}
function C3(e){
if(!e)e=window.event
var k=e.keyCode
if(k>40){
var vco=B2(F3.row,F3.col)
var ve=B7(vco.row,vco.col)
if(ve)
D3(ve.value)
}}
function scroll(dir,units){
var dx=0
var dy=0
if(dir=='u')
dy=-units
else if(dir=='d'||dir=='rd')
dy=units
else if(dir=='l')
dx=-units
else if(dir=='r'||dir=='rd')
dx=units
var canScroll=true
var fr=viewArea.fromRow+dy
if(fr<=0){
if(viewArea.fromRow>1)
fr=1
else
canScroll=false
}
var fc=viewArea.fromCol+dx
if(fc<=0){
if(viewArea.fromCol>1)
fc=1
else
canScroll=false
}
if(canScroll){
D4()
F6=true
viewArea={fromRow:fr,fromCol:fc}
C8(dx!=0)
}}
function onSelMouseDown(e){
if(e.button==2){
TB_context(e.clientX,e.clientY,"cells")
e.returnValue=false
e.cancelBubble=true
return false
}
else{
var r=F3.row
var c=F3.col
setSelection(r,c,r,c)
toolbar.close()
return true
}}
function setSelection(fromRow,fromCol,toRow,toCol){
F5={fromRow:fromRow,fromCol:fromCol,toRow:toRow,toCol:toCol}
var fr=fromRow
var tr=toRow
var fc=fromCol
var tc=toCol
if(fr==0){
fr=1
tr=model.rows
}
if(fc==0){
fc=1
tc=model.cols
}
if(fr!=tr||fc!=tc){
var sum=null
var cells=model.getCells(fr,fc,tr,tc)
for(var c in cells){
if(cells[c].type=="number")
sum=sum==null?cells[c].value:sum+cells[c].value
}
F5.autosum=J1(sum)
}
markSelection()
setCopyHandle()
}
function markSelection(){
var vfco=B2(F5.fromRow,F5.fromCol)
var vtco=B2(F5.toRow,F5.toCol)
var vfr=vfco.row
var vtr=vtco.row
var vfc=vfco.col
var vtc=vtco.col
if(F5.fromRow==0){
vfr=1
vtr=F2.maxRow
}
if(F5.fromCol==0){
vfc=1
vtc=F2.maxCol
}
var selimg=document.getElementById("sel")
if(vtr==vfr&&vtc==vfc){
selimg.style.display='none'
}