sheet.js

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

for(var p in props){
if(addAttrs)
cell[p]=props[p]
else
if(cell)
cell[p]=null
}
if(forcePut&&cell)
model.put(cell)
R_cmd+=UR_cellProps(mr,mc)
if(mr!=F3.row||mc!=F3.col){
var vco=B2(mr,mc)
var viewFld=B7(vco.row,vco.col)
if(cell&&viewFld)
C6(viewFld,model.getCellAttrs(cell.row,cell.col))
}}
model.setModified()
}
UR_add(U_cmd,R_cmd,false)
markSelection(true)
var vco=B2(F3.row,F3.col)
var vr=vco.row
var vc=vco.col
var viewFld=B7(vr,vc)
if(viewFld){
viewFld.focus()
}}
function reshowCol(mc){
var attrs=model.getCellAttrs(0,mc)
var vco=B2(1,mc)
for(var vr=viewArea.fromRow;vr<=F2.maxRow;vr++){
var viewFld=B7(vr,vco.col)
C6(viewFld,attrs)
}}
function reshowRow(mr){
var attrs=model.getCellAttrs(mr,0)
var vco=B2(mr,1)
for(var vc=viewArea.fromCol;vc<=F2.maxCol;vc++){
var viewFld=B7(vco.row,vc)
C6(viewFld,attrs)
}}
function TB_color(){
var pos=getPotisionById('tb_color')
pos.top+=FT
var color
var bgcolor
var cell=model.getCell(F3.row,F3.col)
if(cell){
color=cell.color
bgcolor=cell.bgcolor
}
toolbar.openTextColor(pos,color,bgcolor,function(event){setColor(event)})
}
function setColor(event){
D9({color:event.color,bgcolor:event.bgcolor},false)
}
function TB_text(opt){
var ts=''
var cell=model.getCell(F3.row,F3.col)
if(cell&&cell.style)
ts=cell.style
var iop=ts.indexOf(opt)
if(iop<0)
ts+=opt
else
ts=ts.substring(0,iop)+ts.substring(iop+1)
D9({style:ts},false)
}
function TB_align(opt){
D9({align:opt},false)
}
function TB_textStyle(){
var pos=getPotisionById('tb_text')
pos.top+=FT
var styles
var cell=model.getCell(F3.row,F3.col)
if(cell){
var style=cell.style?cell.style:''
styles={align:cell.align,bold:style.indexOf('b')>=0,italic:style.indexOf('i')>=0,underline:style.indexOf('u')>=0,strike:style.indexOf('s')>=0}
color=cell.color
bgcolor=cell.bgcolor
}
toolbar.openTextStyle(pos,styles,function(event){setTextStyle(event)})
}
function setTextStyle(event){
var textStyle=''
if(event.bold)
textStyle+='b'
if(event.italic)
textStyle+='i'
if(event.underline)
textStyle+='u'
if(event.strike)
textStyle+='s'
if(textStyle=='')
textStyle=null
D9({align:event.align,style:textStyle},false)
}
function TB_format(){
var pos=getPotisionById('tb_format')
pos.top+=FT
toolbar.openFormat(pos,function(event){setFormat(event)})
}
function setFormat(event){
D9({pattern:event.pattern},true)
}
function TB_iRows(){
var pos=getPotisionById('tb_irows')
pos.top+=FT
toolbar.openAbout(pos)
}
function selectImportExportOption(event){
if(event.selected=='exp-del')
setTimeout("TB_expDelimitedText()",200)
else
if(event.selected=='exp-html')
setTimeout("TB_expHtml()",200)
}
function TB_expXml(){
var pos=getPotisionById('tb_adddel')
pos.top+=FT
var text=model.toXml()
toolbar.openCopyData(pos,text)
}
function TB_impXml(){
var pos=getPotisionById('tb_adddel')
pos.top+=FT
toolbar.openPasteData(pos,"iRows XML",function(event){importXml(event)})
}
function importXml(event){
model.read(event.text)
model.setModified()
rebuildSheet()
}
function TB_expDelimitedText(){
var pos=getPotisionById('tb_adddel')
pos.top+=FT
var text=model.toXml()
toolbar.openExportDelimitedText(pos,function(event){exportDelimitedText(event)})
}
function exportDelimitedText(event){
var sep=event.sep
var vtype=event.valueType
setTimeout("exportDelimitedTextDo('"+sep+"','"+vtype+"','all')",200)
}
function exportDelimitedTextDo(sep,vtype,what){
var pos=getPotisionById('tb_adddel')
pos.top+=FT
var text=''
var fr=1
var fc=1
var tr=model.rows
var tc=model.cols
if(what=='sel'){
fr=F5.fromRow
fc=F5.fromCol
tr=F5.toRow
tc=F5.toCol
}
for(var r=fr;r<=tr;r++){
for(var c=fc;c<=tc;c++){
if(c>fc)
text+=sep
var val=''
var cell=model.getCell(r,c)
if(cell){
val=cell.text
if(cell.value&&vtype=='value')
val=''+cell.value
}
if(val.indexOf(sep)>=0||val.indexOf('"')==0){
var encval='"'
for(var i=0;i<val.length;i++){
var ch=val.charAt(i)
encval+=ch
if(ch=='"')
encval+=ch
}
encval+='"'
val=encval
}
text+=val
}
text+='\n'
}
toolbar.openCopyData(pos,text)
}
function TB_pasteDelimitedText(){
var pos=getPotisionById('tb_paste')
pos.top+=FT
toolbar.openPasteData(pos,"delimited text",function(event){pasteDelimitedText(event)})
}
function pasteDelimitedText(event){
parseDelimitedText(event.text,F3.row,F3.col)
C8(false)
}
function parseDelimitedText(text,toRow,toCol){
text+='\n'
var sep=text.indexOf('\t')>=0?'\t':','
var mr=toRow
var mc=toCol
var U_cmd=""
var R_cmd=""
var val=''
var p=0
var val=''
var c
while(p<text.length){
c=text.charAt(p)
if(c==sep){
mc++
}
else
if(c=='\n'){
mr++
mc=toCol
}
else
if(c=='"'){
val=''
var FL=true
p++
while(p<text.length){
c=text.charAt(p)
if((c==sep||c=='\n')&&!FL){
p--
break
}
if(c=='"'){
if(p+1<text.length&&text.charAt(p+1)=='"'){
p++
val+=c
}
else
FL=false
}
else
val+=c
p++
}
U_cmd+=UR_cellValue(mr,mc)
model.put({row:mr,col:mc,text:val})
R_cmd+=UR_cellValue(mr,mc)
}
else{
val=c
p++
while(p<text.length){
c=text.charAt(p)
if(c==sep||c=='\n'){
p--
break
}
val+=c
p++
}
U_cmd+=UR_cellValue(mr,mc)
model.put({row:mr,col:mc,text:val})
R_cmd+=UR_cellValue(mr,mc)
}
p++
}
UR_add(U_cmd,R_cmd,false)
}
function TB_expHtml(){
var pos=getPotisionById('tb_adddel')
pos.top+=FT
var tb='<table border="0" cellpadding="1" cellspacing="1" bgcolor="#a0a0a0">\n'
for(var r=1;r<=model.rows;r++){
tb+=' <tr bgcolor="#ffffff">\n'
for(var c=1;c<=model.cols;c++){
var cell=model.getCellAttrs(r,c)
if(cell){
var align=null
var color=null
var bgcolor=null
value=cell.formattedValue
if(value==null)
value=cell.value
if(value==null)
value=cell.text
if(value==null||value=='')
value='&nbsp;'
if(cell.bgcolor)
bgcolor=cell.bgcolor
if(cell.align)
align=cell.align
else
if(cell.type=='number')
align='right'
else
if(cell.type=='boolean')
align='center'
if(cell.formattedColor)
color=cell.formattedColor
else
if(cell.color)
color=cell.color
else
if(cell.formulaErrorType)
color='red'
var style=''
if(color)
style+='color:'+color+';'
if(bgcolor)
style+='background-color:'+bgcolor+';'
if(cell.style){
if(cell.style.indexOf('b')>=0)
style+='font-weight:bold;'
if(cell.style.indexOf('i')>=0)
style+='font-style:italic;'
if(cell.style.indexOf('u')>=0)
style+='text-decoration:underline;'
if(cell.style.indexOf('s')>=0)
style+='text-decoration:line-through;'
}
tb+='  <td'
if(align)
tb+=' align="'+align+'"'
if(style)
tb+=' style="'+style+'"'
tb+='>'+value+'</td>\n'
}
else{
var style=''
tb+='  <td'
if(style)
tb+=' style="'+style+'"'
tb+='>&nbsp;</td>\n'
}}
tb+=' </tr>\n'
}
tb+='</table>\n'
toolbar.openCopyData(pos,tb)
}
function TB_cut(){
handleCopyPaste("cut")
}
function TB_copy(){
handleCopyPaste("copy")
}
function TB_paste(){
handleCopyPaste("paste")
}
function handleCopyPaste(action){
if(action=='cut'||action=='copy'){
var ms=F5
var sfr=ms.fromRow
var sfc=ms.fromCol
var str=ms.toRow
var stc=ms.toCol
if(sfr==0){
sfr=1
str=model.rows
}
if(sfc==0){
sfc=1
stc=model.cols
}
FK={fromRow:sfr,fromCol:sfc,toRow:str,toCol:stc,cut:action=='cut'}}
else
if(action=='paste'&&FK!=null){
var dfr=F5.fromRow
var dfc=F5.fromCol
var dtr=F5.toRow
var dtc=F5.toCol
if(dfr==0){
dfr=1
dtr=model.rows
}
if(dfc==0){
dfc=1
dtc=model.cols
}
var U_cmd=""
var R_cmd=""
if(FK.cut){
var U_cmd=model.toXml()
model.move(FK.fromRow,FK.fromCol,FK.toRow,FK.toCol,dfr,dfc)
R_cmd="model.move("+FK.fromRow+","+FK.fromCol+","+FK.toRow+","+FK.toCol+","+dfr+","+dfc+");restoreFocus=true;drawSheet(false);"
FK=null
}
else{
var rdtr=dtr
var rdtc=dtc
if(dfr==dtr&&dfc==dtc){
rdtr=dfr+Math.abs(FK.toRow-FK.fromRow)
rdtc=dfc+Math.abs(FK.toCol-FK.fromCol)
}
U_cmd=UR_rectProps(dfr,dfc,rdtr,rdtc)
model.copy(FK.fromRow,FK.fromCol,FK.toRow,FK.toCol,dfr,dfc,dtr,dtc)
R_cmd=UR_rectProps(dfr,dfc,rdtr,rdtc)
}
UR_add(U_cmd,R_cmd,false)
F6=true
C8(false)
}
else
if(action=='copy-del')
setTimeout("exportDelimitedTextDo('\t','value','sel')",200)
else
if(action=='paste-del')
setTimeout("TB_pasteDelimitedText()",200)
}
function TB_adddel(){
var pos=getPotisionById('tb_adddel')
pos.top+=FT
var fr=F5.fromRow
var tr=F5.toRow
var fc=F5.fromCol>0?colLabel(F5.fromCol):null
var tc=F5.toCol>0?colLabel(F5.toCol):null
toolbar.openAddDelMenu(pos,fr,tr,fc,tc,function(event){handleAddDel(event)})
}
function handleAddDel(event){
var rebuild=false
var U_cmd=model.toXml()
if(event.selected=='del-rows')
model.delRows(F5.fromRow,F5.toRow)
else if(event.selected=='del-cols')
model.delCols(F5.fromCol,F5.toCol)
else if(event.selected=='insr-before')
model.addRows(F5.fromRow,1)
else if(event.selected=='insr-after')
model.addRows(F5.toRow+1,1)
else if(event.selected=='insc-before')
model.addCols(F5.fromCol,1)
else if(event.selected=='insc-after')
model.addCols(F5.toCol+1,1)
if(event.selected=='del-cols'||event.selected=='insc-before'||event.selected=='insc-after')
rebuild=true
var R_cmd=model.toXml()
UR_add(U_cmd,R_cmd,true)
F6=true
C8(rebuild)
}
function TB_chart(){
var pos=getPotisionById('tb_chart')
pos.top+=FT
var hasSelChart=false
if(F5.image){
var imo=model.getImageByImgId(F5.image.id)
if(imo&&imo.chart)
hasSelChart=true
}
toolbar.openChartMenu(pos,hasSelChart,function(event){handleChart(event)})
}
function handleChart(event){
if(event.selected=='addimgurl')
setTimeout("TB_loadImage()",200)
else
if(event.selected=='pie'||event.selected=='columns'||event.selected=='bars'||event.selected=='line')
setTimeout("TB_genChart('"+event.selected+"')",200)
else
if(event.selected=='edit-chart')
setTimeout("TB_editChart()",200)
}
function TB_loadImage(){
var pos=getPotisionById('tb_chart')
pos.top+=FT
toolbar.openUrl(pos,function(event){loadImage(event)})
}
function loadImage(event){
var imo={row:F3.row,col:F3.col,offX:10,offY:10,url:event.url}
model.putImage(imo,true)
var img=FC()
imo.img=img
img.setAttribute('src',imo.url)
C8(false)
}
function TB_genChart(type){
var pos=getPotisionById('tb_chart')
pos.top+=FT
var range=''
var incols=true
if(F5.fromRow>0&&F5.toRow>0&&(F5.toRow!=F5.fromRow||F5.toCol!=F5.fromCol)){
var fr=Math.min(F5.fromRow,F5.toRow)
var tr=Math.max(F5.fromRow,F5.toRow)
var fc=Math.min(F5.fromCol,F5.toCol)
var tc=Math.max(F5.fromCol,F5.toCol)
range=colLabel(fc)+fr+':'+colLabel(tc)+tr
if(tc-fc>tr-fr)
incols=false
}
var defs={isnew:true,type:type,range:range,incols:incols}
toolbar.openChart(pos,defs,function(event){addChart(event)})
}
function TB_editChart(){
if(F5.image){
var imo=model.getImageByImgId(F5.image.id)
if(imo&&imo.chart){
var pos=getPotisionById('tb_chart')
pos.top+=FT
range=colLabel(imo.fromCol)+imo.fromRow+':'+colLabel(imo.toCol)+imo.toRow
var defs={isnew:false,type:imo.chart,range:range,incols:imo.incols,d3:imo.d3,legend:imo.legend,title:imo.title,titlex:imo.titlex,titley:imo.titley,stacked:imo.stacked}
toolbar.openChart(pos,defs,function(event){addChart(event)})
}}}
function addChart(event){
var co=null
if(event.isnew){
co={row:F3.row,col:F3.col,offX:10,offY:10,chart:event.type,fromRow:event.fromRow,fromCol:event.fromCol,toRow:event.toRow,toCol:event.toCol,d3:event.d3,legend:event.legend,title:event.title,incols:event.incols,titlex:event.titlex,titley:event.titley,stacked:event.stacked}
var img=FC()
co.img=img
}
else{
if(F5.image){
var imo=model.getImageByImgId(F5.image.id)
if(imo&&imo.chart){
co={id:imo.id,width:imo.width,height:imo.height,img:imo.img,row:imo.row,col:imo.col,offX:imo.offX,offY:imo.offY,chart:event.type,fromRow:event.fromRow,fromCol:event.fromCol,toRow:event.toRow,toCol:event.toCol,d3:event.d3,legend:event.legend,title:event.title,incols:event.incols,titlex:event.titlex,titley:event.titley,stacked:event.stacked}}}}
if(co){
model.putImage(co,true)
C8(false)
}}
function FE(x,y){
var img=F5.image
if(img){
var ix=parseInt(img.style.left)
var iy=parseInt(img.style.top)
img.width=x-ix+16
img.height=y-iy+16
}}
function FEEnd(x,y){
var img=F5.image
if(img){
var ix=parseInt(img.style.left)
var iy=parseInt(img.style.top)
var w=x-ix+16
var h=y-iy+16
var imo=model.getImageByImgId(F5.image.id)
imo.width=w
imo.height=h
model.putImage(imo,true)
C8(false)
}}
function TB_sort(){
var pos=getPotisionById('tb_sort')
pos.top+=FT
var cols=[]
var fc=F5.fromCol
var tc=F5.toCol
if(fc==0){
fc=1
tc=model.cols
}
for(var c=fc;c<=tc;c++)
cols[cols.length]={col:c,id:colLabel(c)}
toolbar.openSort(pos,cols,function(event){handleSort(event)})
}
function handleSort(event){
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=UR_rectProps(fr,fc,tr,tc)
model.sort(fr,fc,tr,tc,event[0].by,event[0].asc,event[1].by,event[1].asc,event[2].by,event[2].asc)
var R_cmd=UR_rectProps(fr,fc,tr,tc)
UR_add(U_cmd,R_cmd,false)
C8(true)
}
function TB_context(x,y,type){
var pos={top:y,left:x}
var ctxdata={type:type,canPaste:FK!=null}
var c=model.getCell(F5.fromRow,F5.fromCol)
if(c){
var t=c.text
if(t&&t.length>8&&t.toLowerCase().substring(0,7)=="http://")
ctxdata.link=1
var dyns=c.requiresDyns
if(dyns){
for(var dyn in dyns){
if(dyn.length>14&&dyn.substring(0,10)=="stockprice"){
var sym=dyn.substring(12)
sym=sym.substring(0,sym.length-2)
if(ctxdata.stocks)
ctxdata.stocks[ctxdata.stocks.length]=sym
else
ctxdata.stocks=[sym]
}}}}
toolbar.openContextMenu(pos,ctxdata,function(event){handleContextEvent(event)})
}
function handleContextEvent(event){
var opt=event.selected
if(opt=="cut"||opt=="copy"||opt=="paste"||opt=="paste-del"||opt=="copy-del")
handleCopyPaste(opt)
else
if(opt=="pie"||opt=="columns"||opt=="bars"||opt=="line")
handleChart(event)
else
if(opt=="color")
setTimeout("TB_color()",200)
else
if(opt=="text")
setTimeout("TB_textStyle()",200)
else
if(opt=="format")
setTimeout("TB_format()",200)
else
if(opt=="clear")
delSelection()
else
if(opt=="sum")
TB_sum()
else
if(opt=="sort")
setTimeout("TB_sort()",200)
else
if(opt.length>6&&opt.substring(0,6)=="stock-"){
var url="http://finance.yahoo.com/q?s="+opt.substring(6)
window.open(url)
}
else
if(opt=="link"){
var c=model.getCell(F5.fromRow,F5.fromCol)
if(c){
var url=c.text
window.open(url)
}}}