edit.js

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

// Copyright (c) iRows.com. All rights reserved. Do not copy.
var autosaveTime=1000*60
var sessionKeepAliveTime=1000*60*10
var lastModified=0
var tableUI
var req_save=false
var req_setprops=false
var req_saveas=false
var req_keepalive=false
var postSaveUrl=null
var ignorePendingChanges=false
window.onbeforeunload=function(event){checkPendingChanges(event)}
function getModelData(){
if(!tableUI)
return""
var data=tableUI.getModelData()
return data
}
function checkPendingChanges(event){
if(ignorePendingChanges)
return
var isDirty=false
if(tableUI&&tableUI.getLastModified()>0)
isDirty=true
if(isDirty){
var msg="You have unsaved changes. If you continue, unsaved changes will be lost."
if(event)
event.returnValue=msg
if(window.event)
window.event.returnValue=msg
}}
function checkDraftSave(){
if(DS_canSave&&!DS_isNew&&tableUI){
var lm=tableUI.getLastModified()
if(lastModified<lm){
lastModified=lm
saveSheet(true)
}}
window.setTimeout('checkDraftSave()',autosaveTime)
}
function saveSheet(isDraft){
var data=encodeURIComponent(getModelData())
req_save=genHttpRequest()
if(!req_save){
return false
}
var indicator=document.getElementById("saveinfo")
indicator.innerHTML="Saving"+(isDraft?" draft":"")+"&nbsp;<img src='image/active.gif' width='16' height='9' />"
indicator.className="saving"
req_save.onreadystatechange=saveDone
req_save.open('POST','SaveSheet.do',true)
req_save.setRequestHeader('Content-Type','application/x-www-form-urlencoded')
req_save.send('id='+document.getElementById('id').value+'&draft='+(isDraft?'y':'n')+'&data='+data)
}
function saveDone(){
if(req_save.readyState==4){
var indicator=document.getElementById("saveinfo")
if(req_save.status==200||req_save.status==0){
var xmldoc=req_save.responseXML
var successNode=xmldoc.getElementsByTagName('success').item(0)
var errorNode=xmldoc.getElementsByTagName('error').item(0)
if(errorNode!=null)
alert("Save failed:\n"+errorNode.getAttribute("message"))
else{
var now=new Date()
var h=now.getHours()
var m=now.getMinutes()
if(m<10)m="0"+m
var isDraft=indicator.innerHTML.indexOf("draft")>=0
var type=isDraft?"Draft":"Data sheet"
if(!isDraft){
tableUI.resetLastModified()
DS_isDraft=false
}
indicator.innerHTML=type+" saved at "+h+":"+m
indicator.className="saved"
if(!isDraft&&postSaveUrl)
document.location=postSaveUrl
}}
else{
status=req_save.status
if(status==403)
status="You do not have permissions to save this data sheet (probably session expired)"
alert("Could not save document.\nReason:"+status)
indicator.innerHTML=""
indicator.className=""
}}}
function sessionKeepAlive(){
window.setTimeout('sessionKeepAlive()',sessionKeepAliveTime)
req_keepalive=genHttpRequest()
if(!req_keepalive){
return false
}
req_keepalive.onreadystatechange=keepAliveDone
req_keepalive.open('POST','SaveSheet.do',true)
req_keepalive.setRequestHeader('Content-Type','application/x-www-form-urlencoded')
req_keepalive.send('keepAlive=1')
}
function keepAliveDone(){
if(req_keepalive.readyState==4){
if(req_keepalive.status==200||req_save.status==0){
var xmldoc=req_keepalive.responseXML
var sysmsgNode=xmldoc.getElementsByTagName('sysmsg').item(0)
if(sysmsgNode!=null){
var msg=sysmsgNode.getAttribute("message")
msg=msg.split('|').join('\n')
alert(msg)
}}}}
function onDone(){
if(DS_signedIn)
PM_action("save-exit")
else
PM_action("exit")
}
function onCancel(){
document.location=listUrl()
}
function listUrl(){
if(DS_signedIn)
return"RecentSheets.do"
else
return"Welcome.do"
}
function closeSheetPopups(){
if(tableUI&&tableUI.getFrame())
tableUI.getFrame().closePop()
}
PM_onShow=closeSheetPopups
function doSave(){
if(!DS_signedIn)
return
if(DS_canSave)
PM_action("save")
else
PM_action("save-as")
}
function PM_file(){
if(PM_openId=="file")
PM_close()
else{
var menu=PM_openMenu()
if(!DS_isNew)
menu+=PM_option(null,"Save","Ctrl+S","save",DS_signedIn&&DS_canSave,DS_signedIn?"You dot have permissions to save this data sheet":"To save data sheets you have to sign-in")
menu+=PM_option(null,"Save as...",null,"save-as",DS_signedIn,"To save data sheets you have to sign-in")
menu+=PM_seperator()
menu+=PM_option(null,"Save as Excel",null,"save-as-xls",DS_signedIn,"To save data sheets you have to sign-in")
menu+=PM_option(null,"Save as Open Office",null,"save-as-ods",DS_signedIn,"To save data sheets you have to sign-in")
menu+=PM_option(null,"Save as CSV",null,"save-as-csv",DS_signedIn,"To save data sheets you have to sign-in")
menu+=PM_option(null,"Save as HTML (zipped)",null,"save-as-html",DS_signedIn,"To save data sheets you have to sign-in")
menu+=PM_seperator()
menu+=PM_option(null,"View for printing",null,"print",!DS_isNew,"Data sheet has not been saved")
menu+=PM_seperator()
menu+=PM_option(null,"Rename...",null,"props",DS_isOwner&&!DS_isNew,DS_isNew?"Data sheet has not been saved":"Only the data owner can rename this data sheet")
menu+=PM_option(null,"Tags...",null,"props",DS_isOwner&&!DS_isNew,DS_isNew?"Data sheet has not been saved":"Only the data owner can change tags for this data sheet")
menu+=PM_option(null,"Label...",null,"props",DS_isOwner&&!DS_isNew,DS_isNew?"Data sheet has not been saved":"Only the data owner can change the label for this data sheet")
menu+=PM_seperator()
menu+=PM_option(null,"Delete",null,"delete",DS_isOwner&&!DS_isNew,DS_isNew?"Data sheet has not been saved":"Only the data owner can delete this data sheet")
menu+=PM_seperator()
if(DS_canSave&&!DS_isNew)
menu+=PM_option(null,"Save and exit",null,"save-exit",DS_signedIn,"To save data sheets you have to sign-in")
menu+=PM_option(null,"Exit",null,"exit",true,null)
menu+=PM_closeMenu()
PM_show(menu,"menu_file","file")
}}
function PM_edit(){
if(PM_openId=="edit")
PM_close()
else{
var menu=PM_openMenu()
menu+=PM_option("copy","Copy","Ctrl+C","copy",true,null)
menu+=PM_option("cut","Cut","Ctrl+X","cut",true,null)
menu+=PM_seperator()
menu+=PM_option("paste","Paste","Ctrl+V","paste",tableUI.getFrame().canPaste(),"Copy or cut cells first")
menu+=PM_seperator()
menu+=PM_option("undo","Undo","Ctrl+Z","undo",tableUI.getFrame().canUndo(),"Can't Undo")
menu+=PM_option("redo","Redo","Ctrl+Y","redo",tableUI.getFrame().canRedo(),"Can't Repeat")
menu+=PM_seperator()
menu+=PM_option(null,"Copy to delimited text (e.g Excel)",null,"copy-del",true,null)
menu+=PM_option(null,"Paste from delimited text (e.g Excel)",null,"paste-del",true,null)
menu+=PM_seperator()
var sel=tableUI.getFrame().getAddDelArea()
if(sel.type)
menu+=PM_option(null,"Delete selected "+sel.type,null,"del-sel",true,null)
else
menu+=PM_option(null,"Delete selection",null,"",false,"No selected cells, chart or image")
if(sel.fr)
menu+=PM_option(null,'Delete row'+(sel.tr>sel.fr?'s':'')+' '+sel.fr+(sel.tr>sel.fr?'-'+sel.tr:''),null,'del-rows',true,null)
if(sel.fc)
menu+=PM_option(null,'Delete column'+(sel.fc!=sel.tc?'s':'')+' '+sel.fc+(sel.fc!=sel.tc?'-'+sel.tc:''),null,'del-cols',true,null)
menu+=PM_closeMenu()
PM_show(menu,"menu_edit","edit")
}}
function PM_insert(){
if(PM_openId=="insert")
PM_close()
else{
var menu=PM_openMenu()
var sel=tableUI.getFrame().getAddDelArea()
if(sel.fr){
menu+=PM_option(null,'Add a row before row '+sel.fr,null,'insr-before',true,null)
menu+=PM_option(null,'Add a row after row '+sel.tr,null,'insr-after',true,null)
}
if(sel.fc){
menu+=PM_option(null,'Add a column before column '+sel.fc,null,'insc-before',true,null)
menu+=PM_option(null,'Add a column after column '+sel.tc,null,'insc-after',true,null)
}
menu+=PM_seperator()
menu+=PM_option("pic","Add an image from URL",null,"addimgurl",true,null)
menu+=PM_seperator()
menu+=PM_option("pie","Add a pie chart",null,"pie",true)
menu+=PM_option("column","Add a columns chart",null,"columns",true)
menu+=PM_option("bar","Add a bars chart",null,"bars",true)
menu+=PM_option("line","Add a line chart",null,"line",true)
menu+=PM_closeMenu()
PM_show(menu,"menu_insert","insert")
}}
function PM_data(){
if(PM_openId=="data")
PM_close()
else{
var menu=PM_openMenu()
var sel=tableUI.getFrame().getAddDelArea()
var canSort=sel.type&&sel.type=="cells"&&(sel.fr==0||sel.tr>sel.fr)
menu+=PM_option("sort","Sort...",null,"sort",canSort,"Select cells to sort")
menu+=PM_seperator()
menu+=PM_option(null,"Export to an HTML table",null,"exp-html",true,null)
menu+=PM_option(null,"Export to delimited text...",null,"exp-del",true,null)
menu+=PM_closeMenu()
PM_show(menu,"menu_data","data")
}}
function PM_format(){
if(PM_openId=="format")
PM_close()
else{
var menu=PM_openMenu()
menu+=PM_option("text","Text...",null,"fmt-text",true,null)
menu+=PM_option("color","Color...",null,"fmt-color",true,null)
menu+=PM_option("format","Values...",null,"fmt-value",true,null)
menu+=PM_closeMenu()
PM_show(menu,"menu_format","format")
}}
function PM_colab(){
if(PM_openId=="colab")
PM_close()
else{
var menu=PM_openMenu()
menu+=PM_option(null,"Allow others to view or edit this page...",null,"permissions",DS_isOwner&&!DS_isNew,DS_isNew?"Data sheet has not been saved":"Only the data owner can set permissions")
menu+=PM_closeMenu()
PM_show(menu,"menu_colab","colab")
}}
function PM_publish(){
if(PM_openId=="publish")
PM_close()
else{
var menu=PM_openMenu()
menu+=PM_option(null,"Send data sheet by email or message...",null,"email",!DS_isNew&&(DS_isOwner||DS_viewToAll),DS_isNew?"Data sheet has not been saved":"Data has permissions restrictions that prevent you from sending it")
menu+=PM_option(null,"Display data sheet within a web page...",null,"webpost",!DS_isNew&&(DS_isOwner||DS_viewToAll),DS_isNew?"Data sheet has not been saved":"Data has permissions restrictions that prevent you from sending it")
menu+=PM_seperator()
menu+=PM_option(null,"Non-interactive (Static HTML)",null,"view-html",!DS_isNew,"Data sheet has not been saved")
menu+=PM_closeMenu()
PM_show(menu,"menu_publish","publish")
}}
function PM_over_file(){
if(PM_openId&&PM_openId!="file")
PM_file()
}
function PM_over_edit(){
if(PM_openId&&PM_openId!="edit")
PM_edit()
}
function PM_over_insert(){
if(PM_openId&&PM_openId!="insert")
PM_insert()
}
function PM_over_format(){
if(PM_openId&&PM_openId!="format")
PM_format()
}
function PM_over_data(){
if(PM_openId&&PM_openId!="data")