ITSF`aÎr ý|ª{О  É"æìý|ª{О  É"æì`(s=T þÇ]ˆ,ÿÿÿÿ j’].!Ðù É"æìTÿÿÿÿÿÿÿÿÿÿÿÿ Uncompressed MSCompressed{7FC28940-9D31-11D0LZXCvar m_phost; var m_ilastdisp; var m_aridisp; var m_pselfnt; var m_index; var m_sel; var m_ppanels; var m_psel; var m_finited = false; function init() { if(external != null) { m_phost = external.Host; m_psel = m_phost.Selection; if(m_psel == null) m_phost.Select(); m_ppanels = new Array(); m_ilastdisp = 0; obpicker.This = obpicker; m_aridisp = new Array(0xEC03,0x1405,0x010401,0x20801,0x0409,0x0401,0x0C11,0x0801,0x0421,0x0441,0x0C81,0x0D01,0x0601); initStdPair(mtbgen,mtbgenbar,fngenupdate,m_ppanels,fnnone); initStdPair(mtbaxis,mtbaxisbar,fnaxisupdate,m_ppanels,fnaxisinit); initStdPair(mtbchart,mdivchartbar,fnchartupdate,m_ppanels,fnchartinit); initStdPair(mtberror,mtberrorbar,fnerrorupdate,m_ppanels,fnerrorinit); initStdPair(mtblegend,mtblegendbar,fnlegendupdate,m_ppanels,fnlegendinit); initStdPair(mtbpoint,mtbpointbar,fnpointupdate,m_ppanels,fnpointinit); initStdPair(mtbseries,mtbseriesbar,fnseriesupdate,m_ppanels,fnseriesinit); initStdPair(mtbtitle,mtbtitlebar,fntitleupdate,m_ppanels,fntitleinit); initStdPair(mtbtrend,mtbtrendbar,fntrendupdate,m_ppanels,fntrendinit); initStdPair(mtbwc,mtbwcbar,fnwcupdate,m_ppanels,fnwcinit); initStdPair(mtbpattern,mdivpatternbar,fnpatternupdate,m_ppanels,fnpatinit); initStdPair(mtbfont,mdivfontbar,fnfontupdate,m_ppanels,fnfontinit); initStdPair(mtboptions,mdivoptionsbar,fnoptionsupdate,m_ppanels,fnoptioninit); initStdPair(mtbtg,mtbtgbar,fntgupdate,m_ppanels,fntginit); initStdPair(mtbscale,mtbscalebar,fnscaleupdate,m_ppanels,fnscaleinit); initStdPair(mtbsplit,mtbsplitbar,fnsplitupdate,m_ppanels,fnsplitinit); initStdPair(mtbplot,mtbplotbar,fnnone,m_ppanels,fnplotinit); initStdPair(mtbdlab,mtbdlabbar,fndlabupdate,m_ppanels,fndlinit); if(document.dir == "rtl") fninitrtl(); nav(m_phost.SelectionType); initStdBtn(imgbold,1); initStdBtn(imgitalic,1); initStdBtn(imgunderline,1); initStdBtn(imgcataxis,0); initStdBtn(imgdatalabel,0); initStdBtn(imgdel,0); initStdBtn(imgcharttype,0); initStdBtn(imgerrorbar,0); initStdBtn(imghelp,0); initStdBtn(imgtrendline,0); initStdBtn(imgundo,0); initStdBtn(imgvalueaxis,0); initStdBtn(imgplusmark,0); initStdBtn(imgcirc,0); initStdBtn(imgln,0); initStdBtn(imgdot,0) initStdBtn(imgstar,0); initStdBtn(imgx,0); initStdBtn(imgtri,0); initStdBtn(imgsq,0); initStdBtn(imgdiamond,0); initStdBtn(imgnone,0); initStdBtn(imgttop,0); initStdBtn(imgminus,0); initStdBtn(imgplus,0); initStdBtn(imgboth,0); initStdBtn(imgflipvert,0); initStdBtn(imgfliphor,0); initStdBtn(imgrotclock,0); initStdBtn(imgrotcntclock,0); initStdBtn(imgtldd,0); initStdBtn(imgtlexp,0); initStdBtn(imgtllin,0); initStdBtn(imgtllog,0); initStdBtn(imgtlpoly,0); initStdBtn(imgtlpow,0); document.body.onclick = fnclean; m_finited = true; SelectionChanged(); } } function SelectionChanged() { if(!m_finited) return; if(external != null && external.Host != null) { m_phost = external.Host; m_psel = m_phost.Selection; if(external.HostType != 0) { window.location.href= "../core/pbmain.htm"; return; } if(m_psel == null) m_phost.Select(); nav(m_phost.SelectionType); fnupdate(); fnclean(); fnbgcheck(); initSelectionTool(); } else { m_phost = null; fnclearopts(slselecttool); CollectGarbage(); } } function fnGetSelection() { return m_psel; } function LostFocus() { if(external != null && external.Host != null) { var pae = document.activeElement; if(pae != null) { var pfn = pae.Function; if(pfn != null) { fnFocusState(false); pfn(); fnFocusState(true); } } } } function fninitrtl() { var iln = m_ppanels.length; for(var i=0;i < iln; i++) { var tarr = document.all(m_ppanels[i].id + "arr"); tarr.parentElement.align = "left"; } tdfontlist.align = "right"; tdfontsize.align = "right"; } function fnoptioninit() { initStdEdit(inscale,fnscalecng,false); initStdEdit(inangle,fnang,false); initStdEdit(inholesize,fnholesize,false); initStdEdit(inover,fnover,false); initStdEdit(ingap,fngap,false); } function fntginit() { } function fnscaleinit() { initStdEdit(inscmaxval,fncustmaxval,false); initStdEdit(inscminval,fncustminval,false); initStdEdit(inscmuval,fncustmaval,false); initStdEdit(inscmival,fncustmival,false); initStdEdit(insctml,fntml,false); initStdEdit(insctm,fntm,false); initStdEdit(incrossaxiscusval,fncrossaxiscusval,false); } function fnsplitinit() { initStdEdit(inspbg,fnspbg,false); initStdEdit(inspend,fnspend,false); } function fnaxisinit() { slaxispos.onchange=fnaxispos; imgaxistitle.src = "../core/images/showaxistitle.gif"; imgaxistitle.onclick=fnaxtitle; initStdBtn(imgaxistitle,1); } function fnchartinit() { imgcataxis.src="../core/images/newcat.GIF"; imgcataxis.onclick=fncataxis; imgvalueaxis.src="../core/images/newval.GIF"; imgvalueaxis.onclick=fnvalaxis; inleg.onclick=fnleg; inleglabel.onclick=inleg.click; intitle.onclick=fntit; intitleleg.onclick=intitle.click; } function fnerrorinit() { tbetype.onclick=fnebtype; tbetype.onmouseover=new Function("splitover(tbetype,tdeo1,tdeo2)"); tbetype.onmouseout=new Function("splitout(tbetype,tdeo1,tdeo2) "); imgerror. src="../core/images/disperror.gif"; tdeo2.src="../core/images/splitbuttondrop.gif"; tbecap.onmouseover=new Function("splitover(tbecap,tdec1,tdec2)"); tbecap.onmouseout=new Function("splitout(tbecap,tdec1,tdec2)"); tbecap.onclick=fnectype; imgebcap.src="../core/images/dispmark.gif"; tdec2.src="../core/images/splitbuttondrop.gif"; initStdEdit(infv,fnfv,false); sldir.onchange=fnsldir; } function fnlegendinit() { sllegpos.onchange=fnlegpos; } function fnpointinit() { initStdEdit(inexp1,fnexp1,false); } function fnseriesinit() { imgdatalabel.src="../core/images/Datalabels.GIF"; imgdatalabel.onclick=fnadddatalabel; imgerrorbar.onclick=fnadderrorbar; imgerrorbar.src="../core/images/Errorbar.GIF"; imgtrendline.onclick=fnaddtrendline; imgtrendline.src="../core/images/Trendline.GIF"; inseriesname.onkeypress=fninputkey; inseriesname.onselectstart="event.cancelBubble = true"; inseriesname.onchange=fnseriesname; initStdEdit(inexp2,fnexp2,false); } function fntitleinit() { initStdEdit(incap,fncaption,false); slplace.onchange=fnplace; } function fntrendinit() { imgtldd.src="../core/images/addtl.GIF"; imgtldd.onclick=fnshowtl; sltlorder.onchange=fntlorder; indispeq.onclick=fndispeq; spdispeqlabel.onclick=indispeq.click; indispr2.onclick=fndispr2; spdispr2label.onclick=indispr2.click; incusttl.onclick=fncusttl; spcusttllabel.onclick=incusttl.click; initStdEdit(intlname,fncusttlname,false); } function fnplotinit() { imgfliphor.onclick=fnfliphor; imgfliphor.src="../core/images/fliphor.GIF"; imgflipvert.onclick=fnflipvert; imgflipvert.src="../core/images/flipvert.GIF"; imgrotclock.onclick=fnrotclock; imgrotclock.src="../core/images/rotclock.gif"; imgrotcntclock.onclick=fnrotcntclock; imgrotcntclock.src="../core/images/rotcntclock.gif"; } function fnwcinit() { sllayout.onchange=fnlayoutchange; inmaxcharts.onchange = fnmaxcharts; splegwclabel.onclick=inlegwc.click; inlegwc.onclick=fnlegwc; intitlewc.onclick=fntitwc; sptitlewclabel.onclick=intitlewc.click; } function fnpatinit() { slbordweight.onchange=fnsetbline; mtbbcolor.onmouseover=new Function("splitover(mtbbcolor,tdbo1,tdbo2)"); mtbbcolor.onmouseout=new Function("splitout(mtbbcolor,tdbo1,tdbo2)"); mtbbcolor.onclick=fnapplybord; tdbo1.onclick=new Function("opencp(mtbbcolor,obpicker,tdbbox,fnapplybord,divdefault.innerText, -1 ,divnone.innerText, -2)"); tdbo2.src="../core/images/splitbuttondrop.gif"; mtbicolor.onmouseover=new Function("splitover(mtbicolor,tdio1,tdio2)"); mtbicolor.onmouseout=new Function("splitout(mtbicolor,tdio1,tdio2)"); mtbicolor.onclick=fnicolor; tdio1.onclick=new Function("opencp(mtbicolor,obpicker,tdibox,fnicolor,divdefault.innerText, -1 ,divnone.innerText, -2)"); tdio2.src="../core/images/splitbuttondrop.gif"; sllweight.onchange=fnlweight; mtblcolor.onmouseover=new Function("splitover(mtblcolor,tdlo1,tdlo2)"); mtblcolor.onmouseout=new Function("splitout(mtblcolor,tdlo1,tdlo2)"); mtblcolor.onclick=fnlinecolor; tdlo1.onclick=new Function("opencp(mtblcolor,obpicker,tdlbox,fnlinecolor,divdefault.innerText, -1 ,divnone.innerText, -2)"); tbmarkpal.onmouseover=new Function("splitover(tbmarkpal,tdmo1,tdmo2)"); tbmarkpal.onmouseout=new Function("splitout(tbmarkpal,tdmo1,tdmo2)"); tbmarkpal.onclick=fnmarkpal; slmarksize.onchange=fnmarksize; } function fnfontinit() { fnclearopts(slfontlist); fnFontInit(slfontlist,m_phost); imgunderline.onclick=fnunderline; imgunderline.src="../core/images/underline.GIF"; imgitalic.src="../core/images/italic.GIF"; imgitalic.onclick=fnintal; imgbold.onclick=fnbold; imgbold.src="../core/images/bold.GIF"; mtbfontcolor.onmouseover=new Function("splitover(mtbfontcolor,tdfo1,tdfo2)"); mtbfontcolor.onmouseout=new Function("splitout(mtbfontcolor,tdfo1,tdfo2)"); mtbfontcolor.onclick=fnfont; tdfo1.onclick=new Function("opencp(mtbfontcolor,obpicker,tdfontbox,fnfont,divdefault.innerText, -1)"); tdfo2.src="../core/images/splitbuttondrop.gif"; slfontlist.onchange=fnfontcng; slfontsize.onchange=fnfontsize; slnfmt.onchange=fnnumfmtchange; } function fndlinit() { spdlcnlabel.onclick=indlcn.click; indlcn.onclick=fndlcn; indlsn.onclick=fndlsn; spdlsnlabel.onclick=indlsn.click; indlval.onclick=fndlval; spdlvallabel.onclick=indlval.click; indlbs.onclick=fndlbs; spdlbslabel.onclick=indlbs.click; indlval2.onclick=fndlval2; spdlval2label.onclick=indlval2.click; indlper.onclick=fndlper; spdlperlabel.onclick=indlper.click; indlval3.onclick=fndlval3; spdlval3label.onclick=indlval3.click; sldlpos.onchange=fndlpos; initStdEdit(insep,fnsep,false); } function fntrendupdate() { var psel=m_psel; fnsetselect(psel.Order,sltlorder); indispr2.checked = psel.IsDisplayingRSquared; indispeq.checked = psel.IsDisplayingEquation; intlname.value = psel.Caption; incusttl.checked = !psel.HasAutoCaption; } function fnscaleupdate() { var i,iln,pchart,sz,index,inum,itype; var psel= m_psel.Scaling; if(psel == null) return; if(m_psel.LastErrorValue != 0) return; inscvalrev.checked = psel.Orientation; if(psel.Type == 1) { insclog.checked = true; fnsetselect(psel.LogBase,sltickbase); } else { insclog.checked = false; sltickbase.selectedIndex = 0; } inum = psel.Maximum; inscmaxval.value = external.DecodeNumber(inum); inum = psel.Minimum; inscminval.value = external.DecodeNumber(inum); inscmax.checked=!psel.HasAutoMaximum; inscmin.checked=!psel.HasAutoMinimum; psel = m_psel; inum = psel.MajorUnit; inscmuval.value = external.DecodeNumber(inum); inum = psel.MinorUnit; inscmival.value = external.DecodeNumber(inum); inscmu.checked=!psel.HasAutoMajorUnit; inscmi.checked=!psel.HasAutoMinorUnit; inum = psel.TickMarkSpacing; insctm.value = external.DecodeNumber(inum); inum = psel.TickLabelSpacing; insctml.value=external.DecodeNumber(inum); if(psel.Crosses == 3) { incrossaxiscus.checked = true; inum = psel.CrossesAtValue; incrossaxiscusval.value= external.DecodeNumber(inum); } else { incrossaxismax.checked = true; incrossaxiscusval.value=""; } fnclearopts(slcrossax); addopt(slcrossax,"",-1,-1,""); pchart = psel.Parent; iln = psel.Parent.Axes.Count; itype = fntypefromval(pchart.Type); if(psel.Type == 0 || !(itype == 0 || itype == 1 || itype == 2 || itype==6 || itype==9)) sz = divvalaxis.innerText; else sz = divcataxis.innerText; index = 0; var iAxisPos = 1; for(i=0;i 0) return 1; else return 0; } function addopt(pselect,stext,vvalue,ipos,pobj) { var eoption; eoption = document.createElement("OPTION"); eoption.text = stext; eoption.value = vvalue; eoption.Ptr = pobj; if(ipos < 0) { if(m_phost.SelectionType !=6) { if(m_psel != null && m_psel.Object == pobj.Object) { m_index = pselect.options.length; } } else { if(external.GetObjectType(pobj) == "WCLegend" && m_psel.Parent.Object == pobj.Parent.Object) { m_index = pselect.options.length; } } pselect.options.add(eoption); } else { if(m_psel.Object == pobj.Object) { m_index = ipos; } else { if(m_index >= ipos) m_index++; } pselect.options.add(eoption,ipos); } } function initSelectionTool() { var i; var schart; m_sel = m_psel; schart = divchartspace.innerText; fnclearopts(slselecttool); for(i=0;i < m_phost.Charts.Count;i++ ) { populatechart(m_phost.Charts(i),i); } if(slselecttool.selectedIndex != m_index) slselecttool.selectedIndex = m_index; else { slselecttool.selectedIndex = -1; slselecttool.selectedIndex = m_index; } } function populatechart(pchart,ix) { var i; var eoption = document.createElement("OPTION"); var itype = fntypefromval(pchart.Type); var val = 0, cat = 0; schart = divchart.innerText + (ix+1) +" "; addopt(slselecttool,schart,0,-1,pchart); if(pchart.HasTitle) { addopt(slselecttool,schart + divtitle.innerText,0,-1,pchart.Title); } if(pchart.HasLegend) { addopt(slselecttool,schart + divlegend.innerText,0,-1,pchart.Legend); } if(pchart.PlotArea != null || itype != 3|| itype != 7|| itype != 8 || itype != 10) { addopt(slselecttool,schart + divplotarea.innerText,0,-1,pchart.PlotArea); } var iplace = slselecttool.options.length; for(i=0;i 0) { addopt(slselecttool,schart + divseries.innerText +ix + " " + divdatalabel.innerText,0,-1,pseries.DataLabelsCollection(0)); } pcol = pseries.ErrorBarsCollection; if(pcol != null && pcol.Count > 0) { addopt(slselecttool,schart +divseries.innerText +ix + " " + diverrorbar.innerText,0,-1,pseries.ErrorBarsCollection(0)); } var pcol = pseries.Trendlines; if(pcol != null && pcol.Count > 0) { addopt(slselecttool,schart +divseries.innerText +ix + " " + divtrendline.innerText,0,-1,pseries.Trendlines(0)); } } function nav(loc) { fnselectdisp(m_aridisp[loc]); switch (loc) { case 0: m_pselfnt = m_psel.Font; fndispaxis(); break; case 1: fndispchart(); break; case 2: fndispplot(); break; case 3: m_pselfnt = m_psel.Font; fndispdatal(); break; case 4: fndisperror(); break; case 5: fndispgridline(); break; case 6: m_pselfnt = m_psel.Font; fndisplegend(); break; case 7: m_pselfnt = m_psel.Font; fndisplegentry(); break; case 8: fndisppoint(); break; case 9: fndispseries(); break; case 10: m_pselfnt = m_psel.Font; fndisptitle(); break; case 11: m_pselfnt = m_psel.DataLabel.Font; fndisptrendline(); break; case 12: fndispwebchart(); break; default: break; } } function fnclean() { obpicker.Close(); mtbErrorBarPicker.style.display = "none"; mtbEndCapPicker.style.display = "none"; mtbMarkerPicker.style.display = "none"; mtbTrendlinePicker.style.left = -1200; sltlorder.style.display = ""; sltype.style.display = ""; } function fndispaxis() { imgdel.style.display = ""; tbaxtitle.style.display = ""; var istype = fntypefromval(m_psel.Parent.Type); if(m_psel.Type != 1) { divnfmt.style.display = "none"; mtbsplit.style.display = "none"; mtbsplit.Panel.style.display = "none"; divval1.style.display = "none"; tbval2.style.display = "none"; tbcat1.style.display = ""; } else { mtbsplit.style.display = ""; divval1.style.display = ""; tbval2.style.display = ""; divnfmt.style.display = ""; tbcat1.style.display = "none"; if(mtbsplit.State) mtbsplit.Panel.style.display = ""; } if(istype == 8 || istype == 10) { tbaxtitle.style.display = "none"; m_ilastdisp = m_ilastdisp & (0xFFFFFFFF - (1 << mtbaxis.Index)); mtbaxis.style.display = "none"; mtbaxis.Panel.style.display = "none"; if(istype == 10) { mtbsplit.style.display = "none"; mtbsplit.Panel.style.display = "none"; } } tbbordpat.style.display = "none"; divintpat.style.display = "none"; hrlinepat.style.display = "none"; tblinepat.style.display = ""; tbmarker.style.display = "none"; fnupdate(); } function fndispchart() { imgdel.style.display = ""; divnfmt.style.display = "none"; tbbordpat.style.display = ""; divintpat.style.display = ""; tblinepat.style.display = "none"; tbmarker.style.display = "none"; tbnewaxis.style.display = ""; var itype = fntypefromval(m_psel.Type); if(itype == 3 || itype == 7 || itype == 8 || itype == 10) { mtbplot.style.display = "none"; mtbplot.Panel.style.display = "none"; if(itype != 10) { tbnewaxis.style.display = "none"; } } if(itype == 0 || itype == 1) { tbbubble.style.display = "none"; tbpie_doughnut.style.display = "none"; tbdoughnut.style.display = "none"; tbbar_line.style.display = ""; } else { if(itype == 5) { tbbubble.style.display = ""; tbpie_doughnut.style.display = "none"; tbdoughnut.style.display = "none"; tbbar_line.style.display = "none"; } else { if(itype == 3) { tbbubble.style.display = "none"; tbpie_doughnut.style.display = ""; tbdoughnut.style.display = "none"; tbbar_line.style.display = "none"; } else { if(itype == 7) { tbbubble.style.display = "none"; tbpie_doughnut.style.display = ""; tbdoughnut.style.display = ""; tbbar_line.style.display = "none"; } else { mtboptions.style.display ="none"; mtboptions.Panel.style.display ="none"; } } } } if(itype == 0 || itype == 1 || itype == 2 || itype==6 || itype==9) { tdcatbtnlabel.innerHTML = divnewcat.innerText; tdvalbtnlabel.innerHTML = divnewval.innerText; imgcataxis.alt = divnewcat.innerText; imgvalueaxis.alt = divnewval.innerText; } else { tdcatbtnlabel.innerHTML = divnewx.innerText; tdvalbtnlabel.innerHTML = divnewy.innerText; imgcataxis.alt = divnewx.innerText; imgvalueaxis.alt = divnewy.innerText; } fnupdate(); } function fndispdatal() { divnfmt.style.display = ""; imgdel.style.display = ""; var istype = m_psel.Parent.Parent.Type; var itype = fntypefromval(istype); if(itype == 5) { tbdlall.style.display = "none"; tbdlbub.style.display = ""; tbdlpie.style.display = "none"; } else { if(itype == 7) { tbdlall.style.display = ""; tbdlbub.style.display = "none"; tbdlpie.style.display = "none"; } else { if( itype == 3 || istype == 2 || istype == 5 || istype == 10 || istype == 11 || istype == 16 || istype == 17|| istype == 31 ) { tbdlall.style.display = "none"; tbdlbub.style.display = "none"; tbdlpie.style.display = ""; } else { tbdlall.style.display = ""; tbdlbub.style.display = "none"; tbdlpie.style.display = "none"; } } } fnupdate(); } function fndisperror() { divnfmt.style.display = "none"; var itype= fntypefromval(m_phost.SelectionType); imgdel.style.display = ""; tbbordpat.style.display = "none"; divintpat.style.display = "none"; hrlinepat.style.display = "none"; tblinepat.style.display = ""; tbmarker.style.display = "none"; if(itype == 5 || itype == 10 || itype == 4) tbebdir.style.display ="none"; else tbebdir.style.display =""; fnupdate(); } function fndispgridline() { divnfmt.style.display = "none"; imgdel.style.display = ""; tbbordpat.style.display = "none"; divintpat.style.display = "none"; hrlinepat.style.display = "none"; tblinepat.style.display = ""; tbmarker.style.display = "none"; fnupdate(); } function fndisplegend() { divnfmt.style.display = "none"; imgdel.style.display = ""; tbbordpat.style.display = ""; divintpat.style.display = ""; tblinepat.style.display = "none"; tbmarker.style.display = "none"; fnupdate(); } function fndisplegentry() { divnfmt.style.display = "none"; imgdel.style.display = ""; fnupdate(); } function fndisppoint() { divnfmt.style.display = "none"; imgdel.style.display = "none"; tbbordpat.style.display = ""; divintpat.style.display = ""; tblinepat.style.display = "none"; tbmarker.style.display = "none"; var itype = fntypefromval(m_psel.Parent.Parent.Type); if(itype == 3 || itype == 7) { mtbpoint.style.display = ""; if(mtbpoint.State) mtbpoint.Panel.style.display = ""; } else { mtbpoint.style.display = "none"; mtbpoint.Panel.style.display = "none"; } fnupdate(); } function fndispseries() { divnfmt.style.display = "none"; imgdel.style.display = ""; tbbordpat.style.display = ""; divintpat.style.display = ""; tblinepat.style.display = "none"; tbmarker.style.display = "none"; var istype = m_psel.Type; var itype = fntypefromval(istype); if(itype == 2 || itype == 5 || itype == 8 || itype == 9 || itype == 10 || istype==25|| istype==24|| istype==26 || istype==23 || istype==22 ) { hrlinepat.style.display = ""; tblinepat.style.display = ""; } if( istype == 7 || istype == 9 || istype == 13|| istype == 15|| istype == 17|| istype == 35|| istype == 38|| istype==24|| istype==22|| istype==21|| istype == 39|| istype == 41|| istype == 43|| istype == 45) { tbmarker.style.display = ""; } if( istype == 6|| istype == 8|| istype == 10|| istype == 12|| istype == 14|| istype == 16|| istype == 34|| istype == 37|| istype == 42|| istype == 44 ) { tbbordpat.style.display = "none"; divintpat.style.display = "none"; } if(itype == 3 || itype == 7) tbpie.style.display = ""; else tbpie.style.display = "none"; fnupdate(); } function fndisptitle() { divnfmt.style.display = "none"; imgdel.style.display = ""; var psel = m_psel; tbbordpat.style.display = ""; divintpat.style.display = ""; tblinepat.style.display = "none"; tbmarker.style.display = "none"; if(fnWrapTypeName(psel.Parent) == "WCAxis") tbtitlepos.style.display = "none"; else tbtitlepos.style.display = ""; fnupdate(); } function fndisptrendline() { divnfmt.style.display = "none"; imgdel.style.display = ""; tbbordpat.style.display = "none"; divintpat.style.display = "none"; hrlinepat.style.display = "none"; tblinepat.style.display = ""; tbmarker.style.display = "none"; fnupdate(); } function fndispwebchart() { divnfmt.style.display = "none"; imgdel.style.display = "none"; tbbordpat.style.display = ""; divintpat.style.display = ""; tblinepat.style.display = "none"; tbmarker.style.display = "none"; fnupdate(); } function fnupdate() { fnUpdate(m_ppanels); fninitsize(m_ppanels); } function fnselectdisp(idisp) { var dispmap,i; var iln = m_ppanels.length; for(i=0;i> i) & 1) { if(((dispmap & idisp) >> i) & 1) { m_ppanels[i].style.display = ""; if(m_ppanels[i].State) { m_ppanels[i].Panel.style.display = ""; } } else { m_ppanels[i].style.display = "none"; m_ppanels[i].Panel.style.display = "none"; } } } m_ilastdisp = idisp; } function fntypefromval(ival) { switch(ival) { case -1: return 0; case 0: case 1: case 2: return 0; case 3: case 4: case 5: return 1; case 6: case 7: case 8: case 9: case 10: case 11: case 12: case 13: case 14: case 15: case 16: case 17: return 2; case 18: case 19: case 20: return 3; case 21: case 22: case 23: case 24: case 25: case 26: return 4; case 27: case 28: return 5; case 29: case 30: case 31: return 6; case 32: case 33: return 7; case 34: case 35: case 36: case 37: case 38: return 8; case 39: case 40: return 9; case 41: case 42: case 43: case 44: case 45: return 10; default: return 999; } } function fncatfromval(ival) { if(ival < 27) return 0; else return 1; } function fndlabupdate() { var psel=m_psel; fnpoppos(); indlcn.checked = psel.HasCategoryName; indlsn.checked = psel.HasSeriesName; indlbs.checked = psel.HasBubbleSize; indlper.checked = psel.HasPercentage; indlval3.checked = psel.HasValue; indlval.checked = indlval3.checked; indlval2.checked = indlval.checked; fnsetselect(psel.Position,sldlpos); insep.value = psel.Separator; } function fndispplot() { var itype = fntypefromval(m_psel.Parent.Type); imgdel.style.display = "none"; if(itype == 3 || itype == 8 || itype == 7 || itype == 10) { mtbpattern.style.display="none"; m_ilastdisp = m_ilastdisp & (0xFFFFFFFF - (1 << mtbpattern.Index)); tbbordpat.style.display = "none"; divintpat.style.display = "none"; tblinepat.style.display = "none"; tbmarker.style.display = "none"; } else { tbbordpat.style.display = ""; divintpat.style.display = ""; tblinepat.style.display = "none"; tbmarker.style.display = "none"; } fnupdate(); } function fnpoppos() { var itype = fntypefromval(m_psel.Parent.Parent.Type); var opt; tbdlpos.style.display = ""; fnclearopts(sldlpos); if(itype < 2) { opt = document.createElement("OPTION"); opt.text = divinend.innerText; opt.value = 2; sldlpos.options.add(opt); opt = document.createElement("OPTION"); opt.text = divoutend.innerText; opt.value = 4; sldlpos.options.add(opt); opt = document.createElement("OPTION"); opt.text = divinbase.innerText; opt.value = 3; sldlpos.options.add(opt); opt = document.createElement("OPTION"); opt.text = divoutbase.innerText; opt.value = 5; sldlpos.options.add(opt); opt = document.createElement("OPTION"); opt.text = divcenter.innerText; opt.value = 1; sldlpos.options.add(opt); } else { if(itype == 3 || itype == 7) { tbdlpos.style.display = "none"; } else { opt = document.createElement("OPTION"); opt.text = divoutleft.innerText; opt.value = 6; sldlpos.options.add(opt); opt = document.createElement("OPTION"); opt.text = divoutright.innerText; opt.value = 7; sldlpos.options.add(opt); opt = document.createElement("OPTION"); opt.text = divouttop.innerText; opt.value = 8; sldlpos.options.add(opt); opt = document.createElement("OPTION"); opt.text = divoutbottom.innerText; opt.value = 9; sldlpos.options.add(opt); opt = document.createElement("OPTION"); opt.text = divcenter.innerText; opt.value = 1; sldlpos.options.add(opt); } } } function fnseriesname() { var po = m_psel; po.Caption = inseriesname.value; fnerrorchk(po); } function fnsetbline() { var po = m_psel.Border; po.Weight = slbordweight.value; fnerrorchk(po); } function fnadddatalabel() { var pdl = m_psel.DataLabelsCollection; pdl.Add(); fnerrorchk(pdl); } function fnadderrorbar() { var peb = m_psel.ErrorBarsCollection; var itype = fntypefromval(m_psel.Parent.Type); if (itype == 3 || itype == 7) { external.IgnoreFocus(); alert(divnoeb.innerHTML); } else { peb.Add(); fnerrorchk(peb); } } function fnaddtrendline() { var ptl = m_psel.Trendlines; var itype = fntypefromval(m_psel.Parent.Type); if (itype == 3 || itype == 7) { external.IgnoreFocus(); alert(divnotl.innerHTML); } else { ptl.Add(); fnerrorchk(ptl); } } function fnapplybord() { var po = m_psel.Border; if(tdbbox.clrVal == null) po.Color = tdbbox.style.backgroundColor; else po.Color = tdbbox.clrVal; fnerrorchk(po); } function fnexp2() { if(external != null && m_phost != null) { var po = m_psel; po.Explosion = inexp2.value; fnerrorchk(po); } } function fnicolor() { var po = m_psel.Interior; if(tdibox.clrVal == null) po.Color = tdibox.style.backgroundColor; else po.Color = tdibox.clrVal; fnerrorchk(po); } function fnlinecolor() { var po = m_psel.Line; if(tdlbox.clrVal == null) po.Color = tdlbox.style.backgroundColor; else po.Color = tdlbox.clrVal; fnerrorchk(po); } function fnundo() { m_phost.Undo(); if(!fnerrorchk(m_phost)) fnupdate(); } function fnmajorgird() { var pob = m_psel; pob.HasMajorGridlines = inmagrid.checked; fnerrorchk(pob); } function fnminorgrid() { var pob = m_psel; pob.HasMinorGridlines = inmigrid.checked; fnerrorchk(pob); } function fntit() { var po = m_psel; po.HasTitle = intitle.checked; fnerrorchk(po); } function fntitwc() { var po = m_psel; po.HasChartspaceTitle = intitlewc.checked; fnerrorchk(po); } function fnunderline() { if (m_pselfnt.Underline == 1) m_pselfnt.Underline = 0; else m_pselfnt.Underline = 1; fnerrorchk(m_pselfnt); } function fnintal() { var fstate = m_pselfnt.Italic; if (fstate == true || fstate == null) m_pselfnt.Italic = false; else m_pselfnt.Italic = true; fnerrorchk(m_pselfnt); } function fnleg() { var po = m_psel; po.HasLegend = inleg.checked; fnerrorchk(po); } function fnlegwc() { var po = m_psel; po.HasChartspaceLegend = inlegwc.checked; fnerrorchk(po); } function fnfontcng() { m_pselfnt.Name = slfontlist.value; fnerrorchk(m_pselfnt); } function fnfontsize() { m_pselfnt.Size = slfontsize.value; fnerrorchk(m_pselfnt); } function fnbold() { var fstate = m_pselfnt.Bold; if (fstate == true || fstate == null) m_pselfnt.Bold = false; else m_pselfnt.Bold = true; fnerrorchk(m_pselfnt); } function fnaxispos() { var pob = m_psel; pob.Position = slaxispos.value; fnerrorchk(pob); } function fncataxis() { var itype = fntypefromval(m_psel.Type); var psel = m_psel.Axes; switch(itype) { case 0: case 2: case 6: case 9: var pscale = fngetScalings(0); if (pscale != null) { psel.Add(pscale,-1,0); initSelectionTool(); } break; case 1: var pscale = fngetScalings(0); if (pscale != null) { psel.Add(pscale,-3,0); initSelectionTool(); } break; case 7: case 3: case 5: case 4: var pscale = fngetScalings(1); if (pscale != null) { psel.Add(pscale,-1,1); initSelectionTool(); } break; case 10: external.IgnoreFocus(); alert(divnoaxis.innerText); } fnerrorchk(psel); } function fnvalaxis() { var psel = m_psel.Axes; var itype = fntypefromval(m_psel.Type); switch(itype) { case 0: case 2: case 6: case 9: var pscale = fngetScalings(1); if (pscale != null) { psel.Add(pscale,-3,1); initSelectionTool(); } break; case 1: var pscale = fngetScalings(1); if (pscale != null) { psel.Add(pscale,-1,1); initSelectionTool(); } break; case 7: case 3: case 5: case 4: var pscale = fngetScalings(1); if (pscale != null) { psel.Add(pscale,-3,1); initSelectionTool(); } break; case 10: external.IgnoreFocus(); alert(divnoaxis.innerText); } fnerrorchk(psel); } function fnsizecng() { var psel = m_psel; psel.SizeRepresents = slsizerep.value; fnerrorchk(psel); } function fnsldir() { var psel = m_psel; psel.Direction = sldir.value; fnerrorchk(psel); } function fnslminortick() { var psel = m_psel; psel.MinorTickMarks = slmitick.value; fnerrorchk(psel); } function fnsltype() { var psel = m_psel; psel.Type = sltype.value; tdebtypestr.innerHTML = sltype.options(sltype.selectedIndex).text + ":"; if(sltype.value == 0) { var psc = fngetScalings(psel.Parent); if(psc != null) infv.value = external.DecodeNumber(psel.Amount = ((psc.Maximum - psc.Minimum)/10)); else infv.value = external.DecodeNumber(psel.Amount); spper.innerHTML = ""; } else { infv.value = external.DecodeNumber(psel.Amount * 100); spper.innerHTML = divpercent.innerText; } if(tbfvEdit.style.display == "none") { tbfvEdit.style.display = ""; fninitsize(m_ppanels); } fnerrorchk(psel); } function fnang() { if(external != null && m_phost != null) { var psel = m_psel; psel.FirstSliceAngle = inangle.value; fnerrorchk(psel); } } function fnexp1() { if(external != null && m_phost != null) { var psel = m_psel; psel.explosion = inexp1.value; fnerrorchk(psel); } } function fnfv() { if(external != null && m_phost != null) { var psel = m_psel; var ival = external.ParseNumber(infv.value); if(psel.Type ==0) psel.Amount =ival; else psel.Amount =(ival / 100); fnerrorchk(psel); } } function fncaption() { if(external != null && m_phost != null) { var psel = m_psel; if(incap.value != "") { psel.Caption = incap.value; fnerrorchk(psel); } else fndel(); } } function fngap() { if(external != null && m_phost != null) { var psel = m_psel; psel.GapWidth = ingap.value; fnerrorchk(psel); } } function fnlayoutchange() { var psel = m_psel; psel.ChartLayout = sllayout.value; fnupdate(); fnerrorchk(psel); } function fnlegpos() { var psel = m_psel; psel.Position = sllegpos.value; fnerrorchk(psel); } function fnmajortick() { var psel = m_psel; psel.MajorTickMarks = slmatick.value; fnerrorchk(psel); } function fnmarksize() { var psel = m_psel.Marker; psel.Size = slmarksize.value; fnerrorchk(psel); } function fnmaxcharts() { if(external != null && m_phost != null) { m_phost.ChartWrapCount = external.ParseNumber(inmaxcharts.value); fnerrorchk(m_phost); } } function fnover() { if(external != null && m_phost != null) { var psel = m_psel; psel.Overlap = inover.value; fnerrorchk(psel); } } function fnplace() { var psel = m_psel; psel.Position = slplace.value; fnerrorchk(psel); } function fnscalecng() { if(external != null && m_phost != null) { var psel = m_psel; psel.BubbleScale = external.ParseNumber(inscale.value); fnerrorchk(psel); } } function fnvarcol() { var psel = m_psel; psel.HasVariedColors = invarcol.checked; fnerrorchk(psel); } function fnholesize() { if(external != null && m_phost != null) { var psel = m_psel; psel.HoleSize = inholesize.value; fnerrorchk(psel); } } function fnspax() { var psel = m_psel.Scaling; psel.HasSplit = inspax.checked; fnerrorchk(psel); } function fnspbg() { if(external != null && m_phost != null) { var psel = m_psel.Scaling; psel.SplitMinimum = inspbg.value; fnerrorchk(psel); } } function fnspend() { if(external != null && m_phost != null) { var psel = m_psel.Scaling; psel.SplitMaximum = inspend.value; fnerrorchk(psel); } } function fnnewchart() { var pch = m_phost.Charts; var cht; cht = pch.Add(); if(!fnerrorchk(pch)) cht.Wizard(0); } function fnlweight() { var psel = m_psel.Line; psel.Weight = sllweight.value; fnerrorchk(psel); } function fnttop() { var psel=m_psel; psel.EndStyle = 2; fnerrorchk(psel); } function fnebnone() { var psel=m_psel; psel.EndStyle = 1; fnerrorchk(psel); } function fneb1() { var psel=m_psel; psel.Include = 2; fnerrorchk(psel); } function fneb2() { var psel=m_psel; psel.Include = 0; fnerrorchk(psel); } function fneb3() { var psel=m_psel; psel.Include = 1; fnerrorchk(psel); } function fnmarkpal() { if(mtbMarkerPicker.style.display != "") { event.cancelBubble = true; fnclean(); position(tbmarkpal,mtbMarkerPicker,15,-40,-2,1); mtbMarkerPicker.style.display = ""; } else mtbMarkerPicker.style.display = "none"; } function fnebtype() { if(mtbErrorBarPicker.style.display != "") { fnclean(); event.cancelBubble = true; mtbErrorBarPicker.style.display = ""; position(tbetype,mtbErrorBarPicker,0,0,1,-2); } else mtbErrorBarPicker.style.display = "none"; } function fnectype() { if( mtbEndCapPicker.style.display != "") { fnclean(); event.cancelBubble = true; mtbEndCapPicker.style.display = ""; position(tbecap,mtbEndCapPicker,0,-3,-2,-2); } else mtbEndCapPicker.style.display = ""; } function fnhelp() { external.ShowHelp(0); } function fncharttype() { var psel = m_psel; while(fnWrapTypeName(psel) != "WCChart") { if(psel == null || fnWrapTypeName(psel) == "WCWebChart") return; psel = psel.Parent; } psel.Wizard(1); } function fnfont() { if(tdfontbox.clrVal == null) m_pselfnt.Color = tdfontbox.style.backgroundColor; else m_pselfnt.Color = tdfontbox.clrVal; fnerrorchk(m_pselfnt); } function fnmajorgrid() { var psel=m_psel; psel.HasMajorGridlines = inmagrid.checked; fnerrorchk(psel); inmagrid.checked = psel.HasMajorGridlines; } function fnminorgrid() { var psel=m_psel; psel.HasMinorGridlines = inmigrid.checked; fnerrorchk(psel); inmigrid.checked = psel.HasMinorGridlines; } function fnmarknone() { var psel=m_psel; psel.Marker.Style = 0; fnerrorchk(psel); } function fnmarkdiamond() { var psel=m_psel; psel.Marker.Style = 2; fnerrorchk(psel); } function fnmarksq() { var psel=m_psel; psel.Marker.Style = 1; fnerrorchk(psel); } function fnmarktriangle() { var psel=m_psel; psel.Marker.Style= 3; fnerrorchk(psel); } function fnmarkx() { var psel=m_psel; psel.Marker.Style= 4; fnerrorchk(psel); } function fnmarkstar() { var psel=m_psel; psel.Marker.Style= 5; fnerrorchk(psel); } function fnmarklittledash() { var psel=m_psel; psel.Marker.Style= 6; fnerrorchk(psel); } function fnmarkdash() { var psel=m_psel; psel.Marker.Style= 7; fnerrorchk(psel); } function fnmarkcircle() { var psel=m_psel; psel.Marker.Style = 8; fnerrorchk(psel); } function fnmarkcross() { var psel=m_psel; psel.Marker.Style = 9; fnerrorchk(psel); } function fnselecttool() { var pfn = slselecttool.options(slselecttool.selectedIndex).Ptr; pfn.Select(); fnerrorchk(pfn); } function fndlcn() { var psel = m_psel; psel.HasCategoryName = indlcn.checked; fnerrorchk(psel); } function fndlsn() { var psel = m_psel; psel.HasSeriesName = indlsn.checked; fnerrorchk(psel); } function fndlval() { var psel = m_psel; psel.HasValue = indlval.checked; fnerrorchk(psel); } function fndlbs() { var psel = m_psel; psel.HasBubbleSize = indlbs.checked; fnerrorchk(psel); } function fndlval2() { var psel = m_psel; psel.HasValue = indlval2.checked; fnerrorchk(psel); } function fndlper() { var psel = m_psel; psel.HasPercentage = indlper.checked; fnerrorchk(psel); } function fndlval3() { var psel = m_psel; psel.HasValue = indlval3.checked; fnerrorchk(psel); } function fndlpos() { var psel = m_psel; psel.Position = sldlpos.value; fnerrorchk(psel); } function fnsep() { if(external != null && m_phost != null) { var psel = m_psel; psel.Separator = insep.value; fnerrorchk(psel); } } function fntlorder() { var psel = m_psel; psel.Order = sltlorder.value; fnerrorchk(psel); } function fntlpal() { } function fndispeq() { var psel = m_psel; psel.IsDisplayingEquation = indispeq.checked; fnerrorchk(psel); } function fndispr2() { var psel = m_psel; psel.IsDisplayingRSquared = indispr2.checked; fnerrorchk(psel); } function fncusttl() { var psel = m_psel; if(incusttl.checked) { psel.Caption = intlname.value; } else { psel.HasAutoCaption = true; } fnerrorchk(psel); } function fncusttlname() { if(external != null && m_phost != null) { var psel = m_psel; psel.Caption = intlname.value; incusttl.checked = true; } } function fncustmax() { var psc = m_psel.Scaling; if(inscmax.checked) fncustmaxval(); else psc.HasAutoMaximum = true; } function fncustmaxval() { if(external != null && m_phost != null) { var psc = m_psel.Scaling; if(inscmax.checked) { if(inscmaxval.value != "") psc.Maximum = inscmaxval.value; else { psc.HasAutoMaximum = false; inscmaxval.value = external.DecodeNumber(psc.Maximum); } } else { psc.HasAutoMaximum = true; } fnerrorchk(psc); } } function fncustmin() { var psc = m_psel.Scaling; if(inscmin.checked) fncustminval(); else psc.HasAutoMinimum = true; } function fncustminval() { if(external != null && m_phost != null) { var psc = m_psel.Scaling; if(inscmin.checked) { if(inscminval.value != "") psc.Minimum = inscminval.value; else { psc.HasAutoMinimum = false; inscminval.value = external.DecodeNumber(psc.Minimum); } } else { psc.HasAutoMinimum = true; } fnerrorchk(psc); } } function fncustmu() { var psc = m_psel; if(inscmu.checked) fncustmaval(); else psc.HasAutoMajorUnit = true; } function fncustmaval() { if(external != null && m_phost != null) { var psc = m_psel; if(inscmu.checked) { if(inscmuval.value != "") psc.MajorUnit = inscmuval.value; else { psc.HasAutoMajorUnit = false; inscmuval.value = external.DecodeNumber(psc.MajorUnit); } } else { if(inscmuval.value != "") { psc.HasAutoMajorUnit = true; } } fnerrorchk(psc); } } function fncustmi() { var psc = m_psel; if(inscmi.checked) fncustmival(); else psc.HasAutoMinorUnit = true; } function fncustmival() { if(external != null && m_phost != null) { var psc = m_psel; if(inscmi.checked) { if(inscmival.value !="") psc.MinorUnit = inscmival.value; else { psc.HasAutoMajorUnit = false; inscmival.value = external.DecodeNumber(psc.MinorUnit); } } else { if(inscmival.value !="") { psc.HasAutoMajorUnit = true; } } fnerrorchk(psc); } } function fncrossaxismax() { var psc = m_psel; psc.Crosses = 0; fnerrorchk(psc); } function fncrossaxiscus() { var psel = m_psel; psel.Crosses = 3; if(incrossaxiscusval.value != "") psel.CrossesAtValue = incrossaxiscusval.value; else incrossaxiscusval.value = psel.CrossesAtValue; fnerrorchk(psel); if(slcrossax.options.length == 2) { slcrossax.selectedIndex = 1; psel.CrossingAxis = slcrossax.options(1).Ptr.Object; } fnerrorchk(psel); } function fncrossaxiscusval() { if(external != null && m_phost != null) { incrossaxiscus.click(); } } function fnrotcntclock() { var psel = m_psel; psel.RotateCounterClockwise(); fnerrorchk(psel); } function fnrotclock() { var psel = m_psel; psel.RotateClockwise(); fnerrorchk(psel); } function fnflipvert() { var psel = m_psel; psel.FlipVertical(); fnerrorchk(psel); } function fnfliphor() { var psel = m_psel; psel.FlipHorizontal(); fnerrorchk(psel); } function fnrevord() { var psel = m_psel.Scaling; psel.Orientation = (new Number(inscvalrev.checked)); fnerrorchk(psel); } function fntml() { var psel = m_psel; psel.TickLabelSpacing = insctml.value; return psel; } function fntm() { var psel = m_psel; psel.TickMarkSpacing=insctm.value; return psel; } function fndel() { switch (m_phost.SelectionType) { case 0: var psel = m_psel; var pparent = psel.Parent; pparent.Axes.Delete(psel.Index); pparent.Select; break; case 1: var psel = m_psel; var pparent = psel.Parent; pparent.Charts.Delete(psel.Index); pparent.Select; break; case 2: break; case 3: var pparent = m_psel.Parent; pparent.DataLabelsCollection.Delete(0); pparent.Select; break; case 4: var psel = m_psel; var pparent = psel.Parent; pparent.ErrorBarsCollection.Delete(psel.Index); pparent.Select; break; case 5: var psel = m_psel; var pparent = psel.Parent; if(psel.Object == pparent.MajorGridlines.Object) pparent.HasMajorGridlines = false; else { if(psel.Object == pparent.MinorGridlines.Object) pparent.HasMinorGridlines = false; } pparent.Select; break; case 6: var psel = m_psel; var pparent = psel.Parent; var ptype = external.GetObjectType(pparent); if(ptype == "WCChart" || ptype == "WCAxis") pparent.HasLegend = false; else pparent.HasChartspaceLegend = false; pparent.Select; break; case 7: var psel = m_psel; var pparent = psel.Parent; psel.Visible = false; pparent.Select; break; case 8: break; case 9: var psel = m_psel; var pparent = psel.Parent; pparent.SeriesCollection.Delete(psel.Index); pparent.Select; break; case 10: var psel = m_psel; var pparent = psel.Parent; var ptype = external.GetObjectType(pparent); if(ptype == "WCChart" || ptype == "WCAxis") pparent.HasTitle = false; else pparent.HasChartspaceTitle = false; pparent.Select; break; case 11: var psel = m_psel; var pparent = psel.Parent; var ptrend = pparent.Trendlines; ptrend.Delete(psel.Index); pparent.Select; break; case 12: break; default: return; } SelectionChanged(); } function fntlpow() { var psel = m_psel; psel.Type = 4; fnerrorchk(psel); } function fntlpoly() { var psel = m_psel; if(psel.Type != 3) { psel.Type = 3; if(sltlorder.selectedIndex < 1) sltlorder.selectedIndex = 1; psel.Order = sltlorder.value; fnerrorchk(psel); } } function fntllog() { var psel = m_psel; psel.Type = 2; fnerrorchk(psel); } function fntllin() { var psel = m_psel; psel.Type = 1; fnerrorchk(psel); } function fntlexp() { var psel = m_psel; psel.Type = 0; fnerrorchk(psel); } function fnshowtl() { if(mtbTrendlinePicker.style.left != -1200) { fnclean(); event.cancelBubble = true; position(imgtldd,mtbTrendlinePicker,0,0,-1,-1); sltlorder.style.display = "none"; } else mtbTrendlinePicker.style.left = -1200; } function fnlogscale() { var psel = m_psel.Scaling; if(insclog.checked) { if(sltickbase.selectedIndex != 0) { psel.LogBase = sltickbase.value; } else { psel.Type = 0; insclog.checked = true; } } else { if(sltickbase.selectedIndex != 0) { psel.LogBase = sltickbase.value; insclog.checked = true; } else psel.Type = 0; } fnerrorchk(psel); } function fnlogcheck() { var psel = m_psel.Scaling; if(insclog.checked) { sltickbase.selectedIndex = 1; psel.LogBase = sltickbase.value; } else { sltickbase.selectedIndex = 0; psel.Type = 0; } fnerrorchk(psel); } function fnnumfmtchange() { var psel = m_psel; psel.NumberFormat = slnfmt.value; fnerrorchk(psel); } function fnslcrossax() { if(slcrossax.value != -1) { var psel = m_psel; psel.CrossingAxis = slcrossax.options(slcrossax.selectedIndex).Ptr.Object; fnerrorchk(psel); } } function fnaxtitle() { var psel = m_psel; psel.HasTitle = !(psel.HasTitle); fnerrorchk(psel); fnBtnUpdate(imgaxistitle,psel.HasTitle); } function fngetScalings(vaxis) { var iChartType = m_phost.Charts(0).Type; var iAxisType; if(typeof(vaxis) =="number") iAxisType = vaxis; else iAxisType = vaxis.Type; var pscale = null; psc = m_phost.Charts(0); if(psc !=null) { switch (iChartType) { case -1: case 0: case 1: case 2: case 3: case 4: case 5: case 6: case 8: case 10 : case 7: case 9: case 11 : case 12 : case 14 : case 16 : case 13 : case 15 : case 17 : case 29 : case 30 : case 31 : case 34 : case 35 : case 36 : case 37 : case 38 : if(iAxisType == 1) pscale = psc.Scalings(2).Object; else pscale = psc.Scalings(1).Object; break; case 21 : case 25 : case 24 : case 26 : case 23 : case 22 : case 27 : case 28 : if(psc.Position == -1 || psc.Position == -2) pscale = psc.Scalings(4).Object; else pscale = psc.Scalings(3).Object; break; case 39 : case 40 : if(iAxisType == 1) pscale = psc.Scalings(6).Object; else pscale = psc.Scalings(1).Object; break; case 41 : case 42 : case 43 : case 44 : case 45 : if(psc.Position == -5) pscale = psc.Scalings(10).Object; else pscale = psc.Scalings(11).Object; break; case 18 : case 19 : case 20 : case 32 : case 33 : default: pscale = null; break; } } return pscale; }
 General
Delete
 Axis
 Error Bar
 Legend
 Data Label
 Series
 Title
 Trendlines
 Plot Area
 Format
 Options
 Ticks and Gridlines
 Scale
 Split Axis
You cannot use error bars in pie or doughnut chart. To use error bars, create a chart that uses a different chart type, such as a column or xy (scatter) chart.
Trendlines are not supported for this chart type.
Axis cannot be added to a polar chart.
Value Axis
Category Axis
%
Chart Workspace
Title
Legend
Chart
Plot Area
Major Gridlines
Minor Gridlines
Series
Data Labels
Error Bars
Trendline
Add new category axis
Add new value axis
Add new x value axis
Add new y value axis
Inside End
Outside End
Inside Base
Outside Base
Outside Right
Outside Bottom
Outside Left
Outside Top
Center
None
Default
This Property Toolbox section cannot be expanded on your 640x480 screen. To use this section of the toolbox, use a higher resolution display, such as 800x600.
.sbuttonpanel { color: buttontext; font-family: tahoma; font-size: 8pt; font-weight: bold; border-top: solid 1 activeborder; border-left: solid 1 activeborder; border-right: solid 1 activeborder; border-bottom: Solid 1 activeborder; background-color: buttonface; padding: 0; } .sbuttonup { color: buttontext; font-family: tahoma; font-size: 8pt; font-weight: bold; border-top: solid 1 threedhighlight; border-left: solid 1 threedhighlight; border-right: solid 1 threedshadow; border-bottom: Solid 1 threedshadow; padding: 0; } .sbuttonflat { color: buttontext; font-family: tahoma; font-size: 8pt; border-top: solid 1 buttonface; border-left: solid 1 buttonface; border-right: solid 1 buttonface; border-bottom: Solid 1 buttonface; padding: 0; } .sinputbox { color: buttontext; font-family: tahoma; font-size: 8pt; padding: 0; } .sreadbox { color: buttontext; font-family: tahoma; font-size: 8pt; padding: 0; background-color: buttonface; } .slabel { color: buttontext; cursor: default; font-family: tahoma; font-size: 8pt; border-top: solid 1 buttonface; border-left: solid 1 buttonface; border-right: solid 1 buttonface; border-bottom: Solid 1 buttonface; padding: 0; } .sdispbox { color: buttontext; cursor: default; font-family: tahoma; font-size: 8pt; padding: 0; background-color: buttonface; } .sbuttondown { color: buttontext; font-family: tahoma; font-size: 8pt; border-top: solid 1 threeddarkshadow; border-left: solid 1 threeddarkshadow; border-right: solid 1 threedhighlight; border-bottom: Solid 1 threedhighlight; background-color: buttonhighlight; padding: 0; } .sbuttondownover { color: buttontext; font-family: tahoma; font-size: 8pt; border-top: solid 1 threeddarkshadow; border-left: solid 1 threeddarkshadow; border-right: solid 1 threedhighlight; border-bottom: Solid 1 threedhighlight; background-color: buttonshadow; padding: 0; } .sbuttonset { color: buttontext; font-family: tahoma; font-size: 8pt; font-weight: bold; border-top: solid 1 activeborder; border-left: solid 1 activeborder; border-right: solid 1 activeborder; border-bottom: Solid 1 activeborder; background-color: buttonface; padding: 0; } .stabup { color: menutext; cursor: default; font-family: tahoma; font-size: 8pt; font-weight: bold; border-top: solid 1 threedhighlight; border-left: solid 1 threedhighlight; border-right: solid 1 threeddarkshadow; border-bottom: Solid 1 threeddarkshadow; padding: 0; width: 100%; } .stabflat { color: menutext; cursor: default; font-family: tahoma; font-size: 8pt; font-weight: bold; border-top: solid 1 threedlightshadow; border-left: solid 1 inactivecaption; border-right: solid 1 inactivecaption; border-bottom: Solid 1 threedshadow; padding: 0; width: 100%; } .stabdown { color: menutext; cursor: default; font-family: tahoma; font-size: 8pt; font-weight: bold; border-top: solid 1 threeddarkshadow; border-left: solid 1 threeddarkshadow; border-right: solid 1 threedhighlight; border-bottom: Solid 1 threedhighlight; background-color: buttonshadow; padding: 0; width: 100%; } .stabarrowdown { color: menutext; } .sbuttonsplit { border-left: solid 1 threedshadow; background-color: threedhighlight; } .sdialog { color: menutext; font-family: tahoma; font-size: 8pt; border-top: solid 1 threedshadow; border-left: solid 1 threedshadow; border-right: solid 1 threeddarkshadow; border-bottom: Solid 1 threeddarkshadow; background-color: menu; padding: 0; } .spickup { color: threedhighlight; font-family: tahoma; font-size: 8pt; border-top: solid 1 threedhighlight; border-left: solid 1 threedhighlight; border-right: solid 1 threeddarkshadow; border-bottom: Solid 1 threeddarkshadow; padding: 0; } .spickflat { color: threedhighlight; font-family: tahoma; font-size: 8pt; border-top: solid 1 menu; border-left: solid 1 menu; border-right: solid 1 menu; border-bottom: Solid 1 menu; padding: 0; } .spicktb { color: menutext; font-family: tahoma; font-size: 8pt; border-top: solid 1 threeddarkshadow; border-left: solid 1 threeddarkshadow; border-right: solid 1 threeddarkshadow; border-bottom: Solid 1 threeddarkshadow; padding: 0; } .spickdown { color: menutext; font-family: tahoma; font-size: 8pt; border-top: solid 1 threeddarkshadow; border-left: solid 1 threeddarkshadow; border-right: solid 1 threedhighlight; border-bottom: Solid 1 threedhighlight; padding: 0; } .scolor { border-top: solid 1 threedshadow; border-left: solid 1 threedshadow; border-right: solid 1 threedshadow; border-bottom: Solid 1 threedshadow; } .ssplitflat { border-left: solid 1 buttonface; } .ssplitup2 { border-left: solid 1 threedhighlight; } .ssplitup1 { border-left: solid 1 threedshadow; } var m_iHeight = 153; var m_iWidth = 270; var m_arOpenPanels = new Array(); var m_pWait = 0; var pPanelsTemp; var m_fFocusState = false; function fnnone(){} function fnUpdate(ppanels) { m_phost = external.Host; var iln = ppanels.length; for(var i=0;i < iln;i++) { if(ppanels[i].Panel.style.display == "") ppanels[i].Panel.Update(); } } function fninitsize(ppanels) { var x=0; var iln = ppanels.length; pPanelsTemp = ppanels; for(var i=0;i (window.screen.availHeight - 5)) { var icurpanel = 0; var i; var iln = (m_arOpenPanels.length -1); var panel,tab,tarr; for(i = 0;i=5) pin.onblur = new Function("fnnewcmdroute(true,true)"); } function initStdEdit2(pin,pfn,fundo) { var sz; pin.onkeypress=new Function("fndirty();fninputkey();"); pin.onselectstart = fncancelbubble; pin.fDirty = false; pin.fUndo = fundo; pin.onchange= fncmdroute2; pin.pFunction= pfn; sz = pin.id + ".blur()"; pin.Function= new Function(sz); if(msieversion() >=5) pin.onblur = new Function("fncmdroute2(true)"); } function msieversion() { var ua = window.navigator.userAgent var msie = ua.indexOf ( "MSIE " ) if ( msie > 0 ) return parseInt (ua.substring (msie+5, ua.indexOf (".", msie ))) else return 0 } function fncancelbubble(){event.cancelBubble = true;} function fndirty() {document.activeElement.fDirty=true;} function tabevents() { var sztype = event.type; switch (sztype) { case "mouseover": gettable(event.srcElement).className = "stabup"; break; case "mouseout": if(!issameelement(event.srcElement,event.toElement)) gettable(event.srcElement).className = "stabflat"; break; case "mouseup": if(!issameelement(event.srcElement,event.toElement) && gettable(event.srcElement).className != "stabup") gettable(event.srcElement).className = "stabflat"; break; case "mousedown": if(event.button == 1) gettable(event.srcElement).className = "stabdown"; break; } } function tabclick() { var ppanels = fnGetPanels(); var tble = gettable(event.srcElement); var panel = tble.Panel; var tarr = document.all(tble.id + "arr"); if(panel.style.display == "none") { if(!panel.Inited) { panel.Init(); panel.Inited = true; } panel.Update(); panel.style.display = ""; tble.State = 1; m_iHeight += panel.offsetHeight; fnRemove(tble.Index); m_arOpenPanels[m_arOpenPanels.length] = tble.Index; tarr.src = "../core/images/ChevronDown.gif"; fnResize(ppanels); } else { m_iHeight -= panel.offsetHeight; tble.State = 0; panel.style.display = "none"; fnRemove(tble.Index); external.Resize(m_iWidth,m_iHeight); tarr.src = "../core/images/ChevronRight.gif"; } } function AddOpenPanel(ppanel) { fnRemove(ppanel.Index); m_arOpenPanels[m_arOpenPanels.length] = ppanel.Index; } function buttonover() { event.srcElement.oldclass = event.srcElement.className; if(event.srcElement.className != "sbuttondown") event.srcElement.className = "sbuttonup"; else event.srcElement.className = "sbuttondownover"; } function buttonout() { event.srcElement.className = "sbuttonflat"; } function buttonup() { if(event.button == 1) { event.srcElement.className = "sbuttonup"; } } function stateclick() { event.srcElement.fClick = true; } function statebuttonout() { if(!event.srcElement.fClick) event.srcElement.className = event.srcElement.oldclass; event.srcElement.fClick = false; } function buttondown() { if(event.button == 1) { event.srcElement.fClick = false; if(event.srcElement.className != "sbuttondownover" && event.srcElement.className != "sbuttondown") event.srcElement.className = "sbuttondown"; else event.srcElement.className = "sbuttonflat"; } } function buttonclick() { if(event.button == 1) { if(event.srcElement.className == "sbuttondown") event.srcElement.className = "sbuttonflat"; else event.srcElement.className = "sbuttondown"; } } function opencp(pbtn,pctl,pbox,pfn,szb1,ibv1,szb2,ibv2) { if(!pbtn.fState) { var ictlh = pctl.offsetHeight; var ictlw = pctl.offsetWidth; var iwindowh = document.body.offsetHeight; var iwindoww = document.body.offsetWidth; var ibtnh = pbtn.offsetHeight; var ibtnw = pbtn.offsetWidth; var ibtntop = topposition(pbtn); var ibtnleft = leftposition(pbtn); var idif; fnclean(); pbtn.className="sbuttondown"; pbtn.fState = true; pctl.ColorBox = pbox; pctl.Func = pfn; pctl.Button = szb1; pctl.cBtn = pbtn; pctl.ButtonValue = ibv1; if(szb2) { pctl.ButtonCount = 2; pctl.Button2 = szb2; pctl.Button2Value= ibv2; } else pctl.ButtonCount = 1; idif = (ibtntop + ibtnh + ictlh - iwindowh); if(idif < 0) pctl.style.top = (ibtntop + ibtnh); else if(ictlh < ibtntop) pctl.style.top = (ibtntop - ictlh); else { pctl.style.top = (ibtntop + ibtnh); pctl.fResize = true; pctl.pSize = fnclsize; external.Resize(m_iWidth,m_iHeight +idif); } idif = ((ibtnleft + ibtnw) - ictlw); if(idif > 0) pctl.style.left = ibtnleft - ictlw + 2 + ibtnw; else pctl.style.left = ibtnleft - ictlw + ibtnw - idif; obpicker.Display(); } else pctl.Close(); event.cancelBubble = true; } function fnclsize() { external.Resize(m_iWidth,m_iHeight); } function fncopyerrorobj(pobj) { var pretobj = new Object(); pretobj.LastErrorValue = pobj.LastErrorValue; pretobj.LastErrorString = pobj.LastErrorString; return pretobj; } function fnclearopts(psl) { var i; var iln = psl.options.length; for(i = 0; i < iln;i++) { psl.remove(0); } } function killevent() { window.event.returnValue = false; } function gettable(ele) { while(ele.tagName != "TABLE") { if(ele.tagName == "BODY") return false; ele = ele.parentElement; if(ele == null) return false; } return ele; } function issameelement(ele1,ele2) { if(ele2 == null) return false; while(ele1.tagName != "TABLE") { if(ele1.tagName == "BODY") return false; ele1 = ele1.parentElement; if(ele1 == null) return false; } while(ele2.tagName != "TABLE") { if(ele2.tagName == "BODY") return false; ele2 = ele2.parentElement; if(ele2 == null) return false; } return (ele1.id == ele2.id); } function fnBtnUpdate(btn,val) { if(val) btn.className = "sbuttondown"; else btn.className = "sbuttonflat"; } function fnerrorchk(pid) { var pe = document.activeElement; if (pid.LastErrorValue != 0) { external.IgnoreFocus(); alert(pid.LastErrorString); if(m_fFocusState) pe.focus(); return true; } else return false; } function fnFocusState(ffocus) { m_fFocusState = ffocus; } function fncmdroute(fn,fundo,fnoscroll) { if(external != null && m_phost != null) { if(!fundo) m_phost.BeginUndo(); var pobj = fn(); if(external == null || m_phost == null) return; var pobjcpy = fncopyerrorobj(pobj); if(!fundo) m_phost.EndUndo(); if(!fnerrorchk(pobj)) { if(!fnoscroll && pobj.Object != m_phost.Object && pobj.Object != m_phost.ActiveSheet.Object && external.GetObjectType(pobj) != "Protection") m_phost.Selection.Show(); } if(external != null) external.GiveFocus(); } } function fnnewcmdroute(fsrc,fblur) { var pobj; if(!fblur) pobj=document.activeElement; else pobj=event.srcElement; if(external != null && m_phost != null && pobj != null && (pobj.fDirty || !fblur)) { pobj.fDirty = false; var perror = pobj.pFunction(); if(external == null || m_phost == null) return; if(perror) fnerrorchk(perror); if(pobj.fFocus && !fsrc && (external != null)) external.GiveFocus(); } } function fncmdroute2(fblur) { var pobj; var sz = ""; if(!fblur) pobj=document.activeElement; else pobj=event.srcElement; if(event) sz= event.type; if(external != null && m_phost != null && pobj != null && (pobj.fDirty || sz=="change")) { pobj.fDirty = false; if(!pobj.fUndo) m_phost.BeginUndo(); var pobj1 = pobj.pFunction(); if(external == null || m_phost == null) return; var perror = fncopyerrorobj(pobj1); if(!pobj.fUndo) m_phost.EndUndo(); if(perror) { if(!fnerrorchk(perror)) { var szObj = external.GetObjectType(pobj1); if(pobj1.Object != m_phost.Object && pobj1.Object != m_phost.ActiveSheet.Object && szObj != "Protection") m_phost.Selection.Show(); } } if(external != null) external.GiveFocus(); } } function fnsetselect(val,psl) { var i; var opts = psl.options; var isel = psl.selectedIndex; for(i =0; i < opts.length;i++) { if(typeof(val) == "string" && typeof(opts(i).value) == "string") { if(val.toUpperCase() == opts(i).value.toUpperCase()) { if(i != isel) psl.selectedIndex = i; break; } } else { if(val == opts(i).value) { if(i != isel) psl.selectedIndex = i; break; } } } if (i == opts.length) { psl.selectedIndex = -1; } } function fnFontInit(psl,phost) { var arFont = (new VBArray(external.SystemFonts).toArray()); var i; var iln = arFont.length; var opt; for(i = 0;i < iln;i++) { opt = document.createElement("OPTION"); opt.text = arFont[i]; opt.value = arFont[i]; psl.options.add(opt); } } function fnbgcheck() { var ibgc = external.ResolveColor("buttonface"); var i; var pimgs = document.images; var iln = pimgs.length; if(ibgc == 0x000000) { for(i = 0; i < iln;i++) { pimgs(i).style.filter = "invert"; } } else { for(i = 0; i < iln;i++) { pimgs(i).style.filter = ""; } } } function fnWrapTypeName(y) { if(y!=null) return external.GetObjectType(y); } function fnesc() { if((event.keyCode == 110 || event.keyCode == 78) && event.ctrlKey) return false; } function fninputkey() { if(event.keyCode == 13) event.srcElement.blur(); } function leftposition(elmt) { var lft = elmt.offsetLeft; while(elmt.offsetParent.tagName !="BODY") { elmt = elmt.offsetParent; lft = lft + elmt.offsetLeft; } return lft; } function topposition(elmt) { var top = elmt.offsetTop; while(elmt.offsetParent.tagName !="BODY") { elmt = elmt.offsetParent; top = top + elmt.offsetTop; } return top; } function position(btn,ctl,xpos,ypos,vset,hset) { var top = btn.offsetTop; var lft = btn.offsetLeft; var cbtn =btn; while(cbtn.offsetParent.tagName !="BODY") { cbtn = cbtn.offsetParent; top = top +cbtn.offsetTop; } cbtn =btn; while(cbtn.offsetParent.tagName !="BODY") { cbtn = cbtn.offsetParent; lft = lft +cbtn.offsetLeft; } switch(vset) { case -2: top = top - ctl.height; break; case -1: top = top - ctl.height + btn.offsetHeight; break; case 0: top = top - (.5 * ctl.height) + (.5 * btn.offsetHeight); break; case 1: break; case 2: top = top + btn.offsetHeight; break; default: break; } switch(hset) { case -2: lft = lft + btn.offsetWidth; break; case -1: break; case 0: lft = lft - (.5 * ctl.width) + (.5 * btn.offsetWidth); break; case 1: lft = lft - ctl.width + btn.offsetWidth; break; case 2: lft = lft - ctl.width; break; default: break; } ctl.style.top = top + ypos; ctl.style.left = lft +1 +xpos; } function splitover(btn,s1,s2) { if(btn.className != "sbuttonup" && !btn.fState) { s1.className ="ssplitup1" s2.className ="ssplitup2" btn.className = "sbuttonup"; } } function splitout(btn,s1,s2) { if(window.event) { if(!issameelement(btn,window.event.toElement) && !btn.fState) { btn.className = "sbuttonflat"; s1.className ="ssplitflat" s2.className ="ssplitflat" } } else { if(!btn.fState) { btn.className = "sbuttonflat"; s1.className ="ssplitflat" s2.className ="ssplitflat" } } } Property Browser
Spreadsheet Property Toolbox
Chart Property Toolbox
PivotTable Property Toolbox
Black Brown Olive Green Dark Green Dark Teal Dark Blue Indigo Gray-80%
Dark Red Orange Dark Yellow Green Teal Blue Blue-Gray Gray-50%
Red Light Orange Lime Sea Green Aqua Light Blue Violet Gray-40%
Pink Gold Yellow Bright Green Turquoise Sky Blue Plum Gray-25%
Rose Tan Light Yellow Light Green Light Turquoise Pale Blue Lavender White
GIF89a¢ÿÀÀÀÀÀÀ€€€ÿÿ!ù,@8ºÜÎ$ òªUÂ’-7½ à]ÞŠR:`ÆBÛ+ÏИ!aï÷éÙ#V (2×,8SžŽPš#;GIF89a‘ÿÀÀÀ!ù,@9„©›'Œc*ÊG3›ÆjÀyÜG–¤g"è"´ÌšÆòœ,ãš ج»µ\” jè!l% “" ;GIF89a‘ÿÀÀÀ!ù,@'„©&ëØT|/„3Åf÷ L¤T2†'³¤`.Ù3£/’r@¾:;GIF89a‘ÿÀÀÀ!ù,@'„©&ëØT|/„3Åf÷ L¤T2†'³¤`.Ù3£/’r@¾:;GIF89a‘ÿÿÿÿ€€€ÀÀÀ!ù,@Gœ©*m¥†s¶HûÊÍ$A`ˆ¦¢•ÏÉ5ÒE0v±K ê SQ7yùP£¤i9ÐtIX”AXEéð 6;GIF89a€ÿÀÀÀ!ù,@ „©  £œÐ¥G³²S®…âH~Îyfบ" —ò¼;GIF89aZ€ÿÀÀÀ!ù,Z@„©Ëía;‹³Þ¼û†âH–扦êʶî ÇòL×öçúÎ÷þ ‡Ä¢ñˆL*—̦ó J§ÔªõŠÍj·Ü®÷ ‹Çä²ùŒN«×ì¶û Ëçôúª;GIF89a‘ÀÀÀ„„„!ù,@(„©Ù¼€˜´ÒØ2Ðz½óaDbÎém*§¦Ð[ÆòL×öçúÎ÷F;GIF89aZ€ÿÀÀÀ!ù,Z@„©Ëía;GIF89a€ÿÀÀÀ!ù,@&„©m–œ´RøœÝ_y G–æ¹Aj”jã´j–(Ã1‹æºT;GIF89aPA€ÿÀÀÀ!ù,PA@N„©Ëí£œ´Ú‹³Þ¼û†âH–扦êʶî ÇòL×öçúÎ÷þ ‡Ä¢ñˆL*—̦ó J§ÔªõŠÍj·Ü®÷ ‹Çä²ùŒN× ;GIF89a_K‘ÿÀÞîÈÈÈ!ù,_K@ø„©Ëíã²:jsºû†âH–扦êʶî ÇòL×öçúΣœûk{Ä¢ñˆL*—̦ó J§Ôª•5\eUÛ«÷ ‹ÇÊ®/f&«×ì¶Zäô¹½Ž¿ëñð~þ¿à‘frX’H3×(áøé2éPÉr¹’¹°™Ò‰ò‰j2ZRÊ(sz:Â*²ªáB û˜ aûÁ뛪;Fl'ˆ<(Øw¬ìœ~ÿžÜÿ@ÏOÜ´b/ùöÌ3 ’æ&¢Ä;GIF89a_K‘ÿÀÀÀÈÈÈ!ù,_K@è„©Ëíã²:jsºû†âH–扦êʶî ÇòL×öçúÎ÷þ ‡Ä¢ñˆL*—̦ó J§ÔªõŠÍjW·õÝŠÇäòS€Ôìµ» Ëáèzü>ÏãöHxõ§¨°SørøزÈÒÈð¨™2™Pyri’i°IÒ9Òù)"C bjx*úáê¡ŠÈÛa«!ë‚›¡ËH Ák!\á묈ü[«|̼ ܼbL=½@ÜzM¸R-Ùý«Óìµ» Ëãô3¹ëÀKõŒ³ÕH%è@(eØw…¸°øÔ˜ðØy0¹T‰ö'q™t¹‰Ô©¨áyšI:¨úPjtZ;(ŠºZÛÊZ˜ÛàZ$;õ{H+Áe¬pW·<×ÌüìlW&F]mR;GIF89aK€ÿÀÀÀ!ù,K@„©Ëíß ;GIF89a_K‘ÀÞîÈÈÈÀÀÀ!ù,_K@É”©Ëí£œ´Ú‹³Þ¼û†âH–扦êʶî ÇòL×öçúÎ÷þ ‡Ä¢ñˆL*—̦ó J§ÔªõŠÍj·Ò€À þŠÃä±9¬(«Ïì5—ãUÅSóGýt7å{Rô—2Rhpè‘Ø‘¸·Ò)á¸Q©)7 q™Ñ‰‘I·i7Š÷ö¸–ÚÆ–¶ªú*vŠYª'ñyqkŠ’[±kªII[ò[Ì9ìg› ¸|Ìë,úìÐKQ=QLÌ,+ ëÍ*è*Ë]nNQ;GIF89a_K€ÿÀÀÀ!ù,_K@‘„©Ëíã ²:jsºû†âH–扦êʶî ÇòL×öçúΣœûk{Ä¢ñˆL*—̦ó J§Ôª•5\eUÛ«÷ ‹ÇÊ®/f&«×ì¶:ÂãX:$m—ôî¾ÿ(8HXhxø†¦1'×XÇÇ7")B‰x‰™©¹ÉÙéù c 2úiÇ5Wjñê:V;GIF89a_K€ÿÀÀÀ!ù,_K@~„©Ëíã ²:jsºû†âH–扦êʶî ÇòL×öçúÎ÷þ ‡Ä¢ñˆL*—̦ó J§ÔªõŠÍjW·õÝŠÇäò3€£Ó¬µ$¼‚«äæºýŽÏë÷ü¾ÿ(8HXhxˆ˜¨¸ÈØxC‡‰àÖ¶6)R鸹T;GIF89a_K€ÿÀÀÀ!ù,_K@„©Ëíã ²Ú{)Þ¼û†âH–扦êʶî ÇòL×öçú©íbï ‡Ä¢ñˆL*—̦ó J§ õ`½j·Ü®÷{Ë^Åà²ùŒ¦ÖÛ5Yñ–ÆÓôºýŽÏë÷ü¾ß8hàÖÆ1è”øÇØèø)9IY‰±È”X¨µiéyU;GIF89a_K€ÿÀÀÀ!ù,_K@r„©Ëíã ²Ú{)Þ¼û†âH–扦êʶî ÇòL×öçúÎ÷þ ‡Ä¢ñˆL*—̦ó J§ÔªõŠ-jªÛ¬÷ ?ä)¹ë@KÕâ¶û ËçôºýŽÏë÷ü¾ÿ(8HXÁ…¨pfVfø¨T;GIF89a7€ÿÀÀÀ!ù,7@„©Ëí;GIF89a€ÿÀÀÀ!ù,@$„©Ø÷ˆÓI²ÞTñUuQfˆ†çX’˜úmª+Jë›æ;;GIF89ad€ÿÀÀÀ!ù,d@&„©Ëí£œ´Ú‹³Þ¼û†âH–扦êʶî ÇòL×öçúT;GIF89aF€ÿÀÀÀ!ù,F@„©Ëí ;GIF89a³ÿÿÿÿÿÿÆÃÆÀÀÀ„‚„„‚„ÿ!ù,@SpÈI«±‘ÿr}9˜¨‚€x½0µ‚„›x®á;¯#OIx"ÆŽH™mdh:½” @­V„Vjuèz£) ‡C(ojÉtIÆöM(Ër®>F;GIF89a¢ÿÀÀÀ€€€ÿ!ù,@LºÜ®D²H’:2ºÿ`£=dea×äeû#cÅ"z¦7Íu° 4—pH+­™GÊn¶M •¦DÀdÁ~v¿F.›EE;GIF89a³ÿÀÀÀÿÿÿ„‚„„‚„ÿ„!ù,@cÈI«•Œ P"GeHÚ¥[Šl—Š¹×ô"†qx Hšµ`LÃá…V@L'·û„F%ËiôE+®¬V&ìÖ’ÞŽ¸óãªèzBgVðTW…Ê7T¸]Š7¤>)vI/^`a;GIF89a €ÿÀÀÀ!ù, @„© ±`’²™5«} b—;€Û‰;GIF89a €ÿÀÀÀ!ù, @„©a½d.¢9oÅ»ZS;•;GIF89a€ÿÀÀÀ!ù,@ „ ÙÈ`{gI M;GIF89a€ÿÀÀÀ!ù,@„ ¶œš§5·.5;GIF89a €ÿÀÀÀ!ù, @„¡œ»ˆ‡6+³Î7Ý9R;Qèȶ@;Y;GIF89a€ÿÀÀÀ!ù,@„©Ëí];GIF89a³ÿÿÿÿÿÿÿÿßìÀÀÀ€€€€€€€0r‹t˜ÀÀÀ ÿ€!ù ,@i°$CéWqLãáÇ¢lQµ¡nš:c€£ BIÀ@‚¶©XIé”ÚØB9ÏéºX)*£¶!*(ÇÉd°(Ó~ÇJ´lÆ,DÚ¬@"}¦xæ—Sv8ƒ83 †‹†3;GIF89a¢ÿÿÿÿÿ€€€€ÀÀÀ!ù,@EHºÜ*ÀAG¸aŒG»°—¡=@ TX¶9 x$MŸª’RçÞlïk@Ë2ƒAL¨€'+¡–Lmg4j˜QaËíz >V;GIF89a¢ÿÿÿÿÿ€€€€ÀÀÀ!ù,@EHºÜ*ÀAG¸aŒG»°—¡=@ TX¶9 x$MŸª’RçÞlïk@Ë2ƒAL¨€'+¡–Lmg4j˜QaËíz >V;GIF89a³ÿÿÿÿÿÿÿÿÀÀÀ€€€€€€€ÿ€ÀÀÀ!ù ,@`PÉI«• %vOAñ%Õ ñÕèº×›Z˜iÊo¬qž`Ç‚D8]I1«!s˨tÚ €k{Uš8Ø°˜A(ïÄ3æØ’-3‡v¼A£Í:è:{T‚ƒ ;GIF89a‘ÿÀ•¼„!ù,@4„©(þ¢L!5s—…S yÚH–c(‰¦´­‚®òL›h|b)rý£T`:ÅëpÁÕ–‰;GIF89a‘ÿÀÀÀ„!ù,@4„©(`\Q¾si[™;…ÞH–F€¢ h¶ØJîLÓªÂ&÷ —Y7ê) Ü RìÕ–ˆ;GIF89a‘ÿÿÿÿÀÀÀ€!ù,@.Œ©+Ý°bP½I¥«áÊ:™á…"§•Ç¶î #g¢2ën°^[5Î@ņÄ@;GIF89a‘ÿÀÀÀ€€€!ù,@&„©{Áß t’ÑŠóÍFxŽlàH扦˜È±˜'0 ¸ëšæ';GIF89a‘ÿÀÀÀ€€€!ù,@&„©{Áo„„ÏQf/¼û|Z3*b‰¦•jœ£«Á!»±’ Þ4T;GIF89a €ÿÀ~ã!ù, @„i¡íS˜3Ú«¨n{[;GIF89a¢ÿÀðÞÀÀÀÿ€!ù,@BºÜÞ#ÊÝ‚„Í;±X(Š˜uhð=l«PðÔ^#ij)·º|ïÇ@SmTò_ÃP‘!!8ŸPç-§›RU–Ht»;>;9)”1!ÎJ1ÆB)½1ÆJ1s)¥9!ÎJ)ÖJ)ÿ9Þ”{­9){J9Î1ÎZ1Îc9Öc1ÎZ)Öµ¥ÆkBÿïçœkRÞ1R!Þs9Öc)ç”c｜פּƄZÞs11­R¥kBÞ{9Ös1Þ{1Þs!÷έÖ{1Æk!Ös!ï¥cç”JÞ„1œR”Œ„Þ{­c÷ÆŒœ{R÷Þ½½¥„ÿÞ­„c1½ŒBÆ{Î{猔„kç”Ö„ÞŒç½s¥„JÎ¥ZÖ”Z9ÆœJ÷µ1ï¥Þ½s÷ÆZçµBï¥ÿÞŒÿÖs¥„1ï½B½”1÷½)kRB1ç­¥{÷µsR”k­{ÆŒï­÷ÆBcJ÷µ÷Æ)½”çµ÷½çµcZ1ÿÎÿÞνœ”)Ƶ¥œÎν99s{œ­)µÎ„ÎÞµ{¥B¥Æ{¥Îs”½c”­{Œ½Z„µRœÆs{­Jœ¥”k¥9sµ9µÖœ„­cs¥Jcœ9½Ö­Zœ1k¥J”ÞkŒœ„s„ks¥Z1R!R”1ÎçÆJ”11k!BŒ1RŒJ9„19Œ1){!kœkZ”Z)J)B„B91{11{91s9J!k!1sBZ)9sJ)c9)sBk)9sRB„c9{Z1sR1sZkJR„sÎÖÖ­µµ!ckZ„ŒBcB„Æ!Js9Z!9c”1cœZs”9cœ!J„c„µZ{­9ZŒ)B)9RJk¥Bcœ1RŒ{”ÆsŒ½Rkœs{Œk„½ŒœÆBZ”JZŒœœ¥BBkRJZcZcsZccRZ„ksBBBÿûð  ¤€€€ÿÿÿÿÿÿÿÿÿÿÿÿ,_H° Áƒ*TH ¡Ã‡ àG±¢ÅŠ$^ÜH1cAˆ .y0dD„9vL˜R¥G‚ÈœIS¦F~æüHq'BŸS58ô€P7‹,³¦S’P£ ;GIF89a³ÿÿÿÿÿÿÿÿÀÀÀ€€€€€€€€Z*;0ˆªÀÀÀ!.ÿ€!ù ,@aP)öx˜É­yóAñc¢=†‘¦`hcßx n ð]0܆ÁN†Ç± z\ŸC]Ly``p•xZÚØlø JÈ[§lD£Uùq½‹Þ2ºSÿj€ƒ ;GIF89a€ÿÀÀÀ!ù,@&„©{Áß t’Ѳ޼‚ë5Y˜€ä‰N©a’­§­/¼~‡wõQ;GIF89a‘ÿÀÀÀ€€€!ù,@„©&½Uˆ´Z0o¾¼ó&X ÆmI€¦êZ;GIF89a‘ÿÀÀÀ€€€!ù,@„©&½žœ(Òc¯Ö¡û>Ù5N ÛÊJ;GIF89a‘ÿÀÀÀ€€€!ù,@!„©&½”*Rd¯Éšã†¢øx”ù4‚¨,€–åH‡;GIF89a‘ÿ€€€ÀÀÀ!ù,@'Œ© °D¢Z¸jÄHÝIM$ NÈ)š—níز™WÖlP'ÙB;GIF89a¢ÿÀÀÀÿÿÆÆÆ„„!ù,@LºÜ®d„)ƒ$/;Âñ¾ÀdyЃ@Lä†u%*Å–Q%Ösìµ–oHüB£X¤·²ô|ÍÊ@ØX:M*#w‘ð´šÕ·hJqÈh_;GIF89a¢ÿÿÿÿÀÀÀÿÿ„„!ù,@HºÜîdb /7Âùî†0œÑT ¤æB…æp½\\¹­¨÷¯ p8$Ž;m"*µîç,±¨ë õ{Œ¾[q,L;GIF89a¢ÿÿÿÿÆÆÆÀ Ó„„„„!ù,@C(ºÜÞ%b$?FD!Å°=á0‹8*¡®D\Y7T ›¨ÿ› ¸\!`ð‰ÔlŽenׂ’t—“b ¡F ;¼¸œ6ßù†DÛ ¨(;GIF89a¢ÿÿÿÿÿÿÆÆÆÀÀÀ„„„„„!ù,@E8ºÜî¦E@0ó=¬›  u$eq¦®Y9|m\m'Ï3Z´ëÿ¾AÆÁ­æd–LG¦s­NQ 5«í¿àA;GIF89a‘ÿÀÀÀÆÃÆ„„!ù,@6„©:16Ä[´Z0çmÁAj׸ ™XqY˜š.äšäL×µŒ¡©‡I£úñí:+V©C mÌæ¥;GIF89a‘ÿÀÀÀÆÃÆ„„!ù,@0„©Ëí¯Æt@ …Öö&ùHÔX9Ò‰‚ž‘uë 7¢kN$¥iìeÛ†«y*žqQ;Ìæ¥;GIF89a‘ÿÀÀÀ„„„„!ù,@(„©)í²"p½óZµ{iÝMЀṔj”Íz–ÆʘK6I³[;>@!¡ â80X¢ùZ* ;GIF89a€ÿÀÀÀ!ù,@D;GIF89a‘ÿÿÿÿ€€€ÀÀÀ!ù,@Nœ©&¢Œ0ˆÔžÛÀå‹|÷aÞ4Uà!´î ¯Ì‰R<|µmañßZ‡Ä"ãÖInT>` ƒÜ•BÑÚ”UE]–æ펽ói,;GIF89a¢ÿÿÿÿÿÿÆÆÆÀÀÀ„„„„!ù,@\8ºÜÎ@)dòú0†÷IYÛMTQœ© ÎtØ­€:Ê9¸öÖ"¨˜hÉl*¦¨ Xâ¹ ŠR´^>UirÉj‹Ü“:L=MXìaN7¶ÎOž™;GIF89a‘ÿÀÀÀ„„„!ù,@!„©{"Á¢œ”9Xs¾ð†âH9f8`*¬ªfžäL';GIF89a€ÿÀÀÀ!ù,@„©íÿ–œZ·î¥|êÆ}Aøu扦êʶî ÇG;GIF89a€ÿÀÀÀ!ù,@„©íÿ–œZ·î¥<ëÀ} %v扦êʶî ÇI;GIF89a€ÿÀÀÀ!ù,@„©íÿ–œZ·î¥œëæ}¡Ö•æ‰¦êʶî ;GIF89a‘ÿ„„„!ù,@.„©(ëW‹nÒ‹->zƒî…¢Ò€‰žª”˜ˆK¶2›ÖküÎø=£²¥FDE;GIF89a€ÿÀÀÀ!ù,@"„©ëØT|/Ìylf7v™aTÌ¢m©#²”†­% ›O;GIF89a¢ÿÿÿÿÿÿ€€€€€€ÀÀÀ!ù,@/hºÜþªB ¼¦è‚»wEpŸ4QO5D§õAáøBL–À9K•ëñ(e•©f³;GIF89a¢ÿÿÿÿÀÀÀ€€€ÀÀÀ!ù,@T8ºÜÞ$"yLÍ» 6t"3& iw•°C¬[ O`hໜ­ŠGñA\HclÉ|̆J‘¥(i’›ë`y[=.T.Bè´Ú…ÁérѦ";ïʬ䪣úÿQ ;GIF89a¢ÿ€€€ÀÀÀ+!ù,@/ºÜ ŒáÖ\¤Þ«oy³5ݧt§ZÓ •Ø\[*Q5Ç:UÉ(µˆª;GIF89a‘ÿÿÿÿ€€€ÀÀÀ!ù,@2”yí?Ò¯…¨æ»êÜSAH@•Úµî‹h— ê*.wƒäÝó¥6Á({;GIF89a‘ÿÿÿÿÀÀÀ!ù,@*Œiíß„ ȉêÅ+N†Q~·„hZ®ÚJIA Ž¤iÁ/Ì);GIF89a‘ÿÿÿÿÀÀÀ!ù,@Œiíß„š´ZË –·û âH’‹¶-å*‚î;GIF89a‘ÿÿÿÿÀÀÀ!ù,@Œ™í ”œ´ZÄ^‹·û â8J™Æ-$ ¶n;GIF89a¢ÿÿÿÿÀÀÀ! !ù,@4ºÜJÈIA ÎÝ‹R0x ÔyZeŸj$“%]¯tº±èö-×+ã Í‘mq$;GIF89a‘ÿÿÿÿÀÀÀ!ù,@(Œyí/{4.Z¥Ø¼[3aÍ„"©¤ê Šib°;J40Ӱdzj;GIF89a¢ÿÿÿÿÀÀÀ€€€ÀÀÀ!ù,@=8ºÜ,È ˆpJ ñÐ1XÜåifC¬ìIJÏFuªè¬žbçK´çɯ'£L ˆÑ‚ BdÃQ€™!Lyž;GIF89a‘ÿÿÿÿ€€€ÀÀÀ!ù,@5”oƒ›àkN®s[ŽAßj9¤êºNÁpH´,ÐÏíÖ?óe€9¡†§3íb¸E;GIF89a‘ÿÿÿÿÀÀÀ!ù,@/Œe©¨ÿXј.k|„5au–™¹fKIb÷.ʦ5|«´Œ;Ã\¢;GIF89a‘ÿÿÿÿÿÿÀÀÀ!ù,@Dœ©&@œRŠ$²Þü¢j˜UÔä-êÚ<ŽK¾)£¦5>ö9¯þ ²bDØå»J¯Å¼QžéíkFzÂî¯;GIF89a€ÿÌÝ „„„!ù,@&„©Ù¼@›²ÒE³ïtóE"ç”ئ…ž¹Žî ÇòL×öçúQ;GIF89a³ÿÿÿÿÿÿÿÿÀÀÀ€€€€€€€ÿ€ÀÀÀ!ù ,@ZPÉI«• hTúA‘FGe›yY¨¦zßÚrÉ$áX®ºÜÞD½ø‹£Sffä²)Ü㕧÷Mb`ð©ïgk–›à/×òA@¼W(w‘Ñn)iºœZyXS;GIF89a¢ÿÀTHÿÿÿÿÀÀÀ€€€€€€€!ù,@UºÜ®'ÄŽåCÙµøx …Ô5Nçd[7ÎÛ]ï×Ø•Ç»Ò u \´¤rI”-)%™oàôT®½gw•b4[kjჅÉ]ò\…b›*¦\ž;GIF89a¢ÿÿÿÿÿÿ€ÀÀÀÿ!ù,@K8ºÜ¾ÈIii±jyYÞUšøœgF¬@á¾& tûº±'¼}稠p¹2ÀŠ@2 T,3C4“Õ«À hGÜžs,»ˆÁ;GIF89a³ÿÿÿÿÿÿÿÿÀÀÀ€€€€€€€ÀÀÀÿ€!ù,@eðÈI«½ h†ºSF(ÊHš%Qeо®ûa€‡$\P(‚1ƒ@+{ý,™ ·#C5ÅÉóaœØì3È=h¿[o <¾‚±AÒ&  CQÔ^X$űwrÚAb“ä*+„…#]\;GIF89a¢ÿÿÿÿÀÀÀ€€€ÀÀÀ!ù,@J8ºÜ¾"ÊII#8ëmýSQAišâ£ªÂÙšo™`õÜÀœÛ?Àî6[È$ËÅD5b(ÔÇ mÔ›•—ò®½gõËUšÍ ;GIF89a‘ÿÀÀÀÿÿÀÀÀ!ù,@;”©9ƒàŠlØ+ÏuWå)| Ö‘ƒ>”¹²F6) ºöýÊ5Ïâ~ÑY4& B&C˜’ç$‹î”Ô;GIF89a‘ÿÿÿÿÀÀÀ€!ù,@?Œ©8àßX´³ÞªÅLÖ˜l¦ÖŸÈ¨KÆòL @vc¹-¤®”CCaf8—Ç “ØL§T#í:*;GIF89a‘ÿÀÀÀûùù€€€!ù,@>„©- TðEÙ(¾6èÐEÝB–‡€¦êú…Õ”¬²jÖöm¼#:×clDÁÜð×Úñ2‰‘é;n’»®T;>(');GIF89a¢ÿÿÿÿÀÀÀ€€€ÀÀÀ!ù,@J8ºÜ¾"ÊII#8ëmýSQAišâ£ªÂ)0ðÆéК3Ä@}—9ÀŽ¶*Hä/ ú\ä'0-LS@MÑ˵zMz{ ;GIF89a³ÿÿÿÿÿÿÿÿÀÀÀ€€€€€€€ÀÀÀÿ€!ù,@WpÉI':g©d—A±†´}¨…­ë’láXV´te§7ÅHïû.˜ˆ´`a$ a²(€gú¼q8ЬÖÚÑB$«gÝïË,+ƒl¢1“Iäó<&;GIF89a€ÀÀÀ!ù,@„‰;GIF89a€ÿÀÀÀ!ù,@„o¡Šícˆ´Ú¶®>;GIF89a‘ÿƒ„„„!ù,@'„©Ëí£œ´Ú‹3¼ûΉˆŠi €zˆî ¿‹J‡ã=Ǻ¬i;GIF89a³ÿÿÿÿÿÿÿÿÀÀÀ€€€€€€€ÿ€ÀÀÀ!ù ,@ZPÉI«• hTúA‘FGe›yY¨¦zßÚrÉ$áX®^“}'W"EcBLFBe›>¦<1˜[´µ3;GIF89a¢ÿÿÿÿ€€€ÀÀÀÿ€!ù,@M(ºÜ® È8‹"ävçÖ³ dYfbê é²j,rtmaxãí ìÿ?— öÀsª€r¹ ˆI2½Ò¬ô0¿NÑ—ÖŒ•e *;;GIF89a‘ÿÀÀÀ„„„!ù,@2„©(Ë£i‘*ë°ÜSêó%!0‚܉fÂʶk–"ŒÈÏÒÈ:°šmÂÅf8—±”J" ;GIF89a‘ÿÀÀÀ!ù,@.„©qbÚ0º‰‘4•Ý¾eâ¸t¤9¢äʶÚŹÔÎœÊ*@f=©eÄQ;GIF89a‘ÿÀÀÀ€€€!ù,@ DŽ©ÀÍᢄ²[)vz?ß"ø‘—Ùyé¶bm% d,;GIF89a‘ÿÀÀÀ„„„!ù,@)„©+r½¢œ”¶¬\nðYŽv扦\±£ø¼0)O_i»Ë«¾T;GIF89a‘ÿÀz£„‚„„!ù,@%„©('íš´Zõròúoi –扦^ÆU@2;žA¬æy;GIF89a¢ÿÿÿÿÀÀÀ€€€ÀÀÀ!ù,@Q8ºÜ¾‚ÈIã|ƒ€Í; !SaŠ˜âÊr FÅèBµ£º|7"p8œåŽÈdku:Þhä3™òt|ZuUb»ÈÈûcXfAY‡FS1 ;GIF89a‘ÿÿÿÿÿÿÀÀÀ!ù,@Dœ©&@€’Î$²Þ\àf˜c•Ñµ¤êÐ<ŽK¾†ãsšÕÊ÷þŸjµ`ÄÙ¡º5"KS)qJ $ÊŒ6©Àîª;GIF89a³ÿÿÿÿÿÿÆÃÆÀÀÀ„‚„„‚„ÿ!ù,@`pÈI«•ˆ 2†N©–—5reÎ'F G÷´yÕ-—†ã‰H>Ô-WäJÀ .`ƒØ¬6ØÛF7]²„›G¨lÃÜ¥“¶)úû„—:#¶žÝ¤Ydv^^;
General
Selection: Help
PivotTable title:
Background:
Format
AutoFit
Width
Total all items
Total orientation:
Display Empty Items
Detail Data Format
Sort
Title Bar Format
Drop Area Captions
Advanced
General
None
Item
Subtotal
Totals
Entire PivotTable
Column field
Row field
Filter field
Detail data field
Format
Captions
Expression
Total Function
Total Caption
Field Label Format
Each Value
Years
Quarters
Months
Weeks
Days
Hours
Minutes
Seconds
Prefix Char
Interval
Yes
No
[Use Connection]
No Data Sources
Sum
Count
Min
Max
Empty
Null
Integer
Long
Single
Double
Currency
Date
Text
IDispatch
Error
Yes/No
Variant
Unknown
Decimal
Byte
Byte
Integer
Long
Big Integer
Big Integer
File Time
Guid
Binary
Text
Text
Numeric
User Defined
Date
Time
Time Stamp
Chapter
File Time
Property Variant
Numeric
Text
Memo
Memo
Memo
Binary
Binary
Regular
Calculated
Time
Years
Half Years
Quarters
Months
Weeks
Days
Hours
Minutes
Seconds
Undefined
Unknown
User Defined
Unknown
Time
User Defined
Other
None
Column
Row
Filter
Data
Default
This Property Toolbox section cannot be expanded on your 640x480 screen. To use this section of the toolbox, use a higher resolution display, such as 800x600.
var m_phost; var m_ilastdisp; var m_aridisp; var m_aridispRuntime; var m_iseltype; var m_fDesign; var m_paridispUse; var m_ppanels; var m_pDSC; var m_strConn; var m_Selection; var m_Selection0; var m_strCommand; var m_iDSC; var m_strDataMember; var m_finited = false; function init() { m_ppanels = new Array(); m_phost = external.Host; obpicker.This = obpicker; m_ilastdisp = 0; m_aridisp = new Array(0xF333,0x149D,0x141D,0x1015,0x15,0x11,0x11,0x11); m_aridispRuntime = new Array(0x233,0x49D,0x41D,0x015,0x15,0x11,0x11,0x11); initStdPair(mtbgen,mtbgenbar,fngenupdate,m_ppanels,fnnone); initStdPair(mtbplformat,mdivplformatbar,fnplformatupdate,m_ppanels,fnformatinit); initStdPair(mtbfiformat,mdivfiformatbar,fnfiformatupdate,m_ppanels,fnfiinit); initStdPair(mtbcaption,mtbcaptionbar,fncapupdate,m_ppanels,fncapinit); initStdPair(mtbshow,mtbshowbar,fnshowupdate,m_ppanels,fnshowinit); initStdPair(mtbtotals,mtbtotalsbar,fntotalsupdate,m_ppanels,fntotalsinit); initStdPair(mtbgrp,mtbgrpbar,fngrpupdate,m_ppanels,fngrpinit); initStdPair(mtbsortfilter,mtbsortfilterbar,fnsfupdate,m_ppanels,fnsfinit); initStdPair(mtbdsf,mtbdsfbar,fndsfupdate,m_ppanels,fndsfinit); initStdPair(mtbaxis,mtbaxisbar,fnaxisupdate,m_ppanels,fnaxisinit); initStdPair(mtbexp,mtbexpbar,fnexpupdate,m_ppanels,fnexpinit); initStdPair(mtbgfformat,mtbgfformatbar,fngfupdate,m_ppanels,fngfinit); initStdPair(mtbpladvanced,mdivpladvancedbar,fnadvupdate,m_ppanels,fnadvinit); initStdPair(mtbtitleformat,mdivtitleformatbar,fntbupdate,m_ppanels,fntbinit); initStdPair(mtbpac,mdivpac,fnpacupdate,m_ppanels,fnpacinit); initStdPair(mtbdata,mtbdatabar,fndataupdate,m_ppanels,fndatainit); if(document.dir == "rtl") fninitrtl(); initStdBtn(imgtoolbar,1,fntoolbar); initStdBtn(imgbold,1,fnbold); initStdBtn(imgitalic,1,fnital); initStdBtn(imgunderline,1,fnunderline); initStdBtn(imgtitlebold,1,fntitlebold); initStdBtn(imgtitleitalic,1,fntitleital); initStdBtn(imgtitleunderline,1,fntitleunderline); initStdBtn(imgpacbold,1,fncapbold); initStdBtn(imgpacitalic,1,fncapital); initStdBtn(imgpacunderline,1,fncapunderline); initStdBtn(imgexpand,1,fnshowexpand); initStdBtn(imgfieldlist,1,fnshowfieldlist); initStdBtn(imgtitle,1,fnshowtitle); initStdBtn(imghelp,0,fnhelp); initStdBtn(imgdrop,1,fnshowdrop); m_fDesign = external.UserMode; if (m_fDesign) m_paridispUse = m_aridisp; else m_paridispUse = m_aridispRuntime; fnfiinit(); mtbfiformat.style.display = ""; mtbfiformat.Panel.style.display = ""; mtbfiformat.State = 1; fnformatinit(); mtbplformat.style.display = ""; mtbplformat.Panel.style.display = ""; mtbplformat.State = 1; m_ilastdisp=6; AddOpenPanel(mtbplformat); AddOpenPanel(mtbfiformat); AddOpenPanel(mtbgen); fnclearopts(slfontlist); fnFontInit(slfontlist,m_phost); fnclearopts(sltitlefontlist); fnFontInit(sltitlefontlist,m_phost); fnclearopts(slcapfontlist); fnFontInit(slcapfontlist,m_phost); document.body.onclick = fnclean; m_finited = true; SelectionChanged(); } function fnclean() { obpicker.Close(); } function fninitrtl() { var iln = m_ppanels.length; for(var i=0;i < iln; i++) { var tarr = document.all(m_ppanels[i].id + "arr"); tarr.parentElement.align = "left"; } tdfontlist.align = "right"; tdfontsize.align = "right"; tdtitlefontlist.align = "right"; tdtitlefontsize.align = "right"; tdcapfontlist.align = "right"; tdcapfontsize.align = "right"; } function SelectionChanged() { if(!m_finited) return; if(external != null && external.Host != null) { m_phost = external.Host; if(external.HostType != 2 || (external.UserMode ^ m_fDesign)) { window.location.href= "../core/pbmain.htm"; return; } m_Selection = m_phost.Selection; m_Selection0 = m_phost.Selection(0); switch (fnWrapTypeName(m_Selection)) { case "PivotView": m_iseltype = 0; fnselectdisp(m_paridispUse[0]); fndispview(); break; case "PivotFields": m_iseltype = 1; fnselectdisp(m_paridispUse[1]); fndispfield(); break; case "PivotTotals": m_iseltype = 2; fnselectdisp(m_paridispUse[2]); fndisptot(); break; case "PivotMembers": if(m_Selection.Count == 1 && m_Selection0.IsTotal) { m_iseltype = 4; fnselectdisp(m_paridispUse[4]); fndispsub(); } else { m_iseltype = 3; fnselectdisp(m_paridispUse[3]); fndispmem(); } break; case "PivotAggregates": m_iseltype = 5; fnselectdisp(m_paridispUse[5]); inplSelection.value=divSelGen.innerText; break; case "PivotRange": m_iseltype = 6; fnselectdisp(m_paridispUse[6]); inplSelection.value=divSelGen.innerText; break; case "PivotDetailRange": m_iseltype = 7; fnselectdisp(m_paridispUse[7]); inplSelection.value=divSelGen.innerText; break; default: m_iseltype = -1; inplSelection.value=divSelNone.innerText; if (m_fDesign) { fnselectdisp(0x9011); } else { fnselectdisp(0x11); } fnnothingsel(); break; } fnUpdate(m_ppanels); fnsize(); fnclean(); fnbgcheck(); } else { m_phost = null; m_Selection = null; m_Selection0 = null; CollectGarbage(); } } function LostFocus() { if(external != null && external.Host != null) { var pae = document.activeElement; if(pae != null) { var pfn = pae.Function; if(pfn != null) { fnFocusState(false); pfn(); fnFocusState(true); } } } } function fnsize() { fninitsize(m_ppanels); } function fnformatinit() { initStdEdit(inpltitle,fnpltitle,false); } function fnfiinit() { initStdEdit(insfmtwd,fnsfmtwd,false); } function fncapinit() { initStdEdit(infldcap,fnfldcap,false); initStdEdit(infldsetcap,fnfldsetcap,false); } function fnshowinit() { } function fntotalsinit() { } function fngrpinit() { } function fnsfinit() { } function fndsfinit() { initStdEdit(indsfmaxwd,fndsfmaxwd,false); initStdEdit(indsfmaxht,fndsfmaxht,false); initStdEdit(indsfwidth,fndsfwidth,false); initStdEdit(indsfrwht,fndsfrwht,false); } function fnaxisinit() { } function fnexpinit() { } function fngfinit() { initStdEdit(ingfwidth,fngfwidthchange,false); } function fnadvinit() { initStdEdit(inadvmaxheight,fnadvheight,false); initStdEdit(inadvmaxwidth,fnadvwidth,false); initStdEdit(inplheight,fnplheight,false); initStdEdit(inplwidth,fnplwidth,false); } function fntbinit() { } function fnpacinit() { initStdEdit(inadvrowcap,fnadvrowcap,false); initStdEdit(inadvcolcap,fnadvcolcap,false); initStdEdit(inadvdatacap,fnadvdatacap,false); initStdEdit(inadvfilcap,fnadvfilcap,false); } function fndatainit() { initStdEdit(inadvconn,fnadvconn,false); initStdEdit(inadvcommand,fnadvcommand,false); } function fndispmem() { divtotadv.style.display = "none"; divpladv.style.display = "none"; divfiadv.style.display = "none"; divmemadv.style.display = ""; tdfflabel.innerText = divFormat.innerText; tdexptab.innerHTML = divTotFunc.innerText; tbfun.style.display = ""; tbfldcap.style.display = "none"; tbcap.style.display = ""; tbcapalign.style.display = "none"; tbsfmtfont.style.display = ""; tbsfmtfont2.style.display = ""; tbsfmtbg.style.display = ""; tbsfmtalign.style.display = ""; tbsfmtnfmt.style.display = "none"; tbsfmtsize.style.display = "none"; inplSelection.value = divSelItem.innerText; } function fndispsub() { tdfflabel.innerHTML = divFormat.innerText; tbsfmtfont.style.display = ""; tbsfmtfont2.style.display = ""; tbsfmtbg.style.display = ""; tbsfmtalign.style.display = "none"; tbsfmtnfmt.style.display = "none"; tbsfmtsize.style.display = "none"; inplSelection.value=divSelSubtot.innerText; } function fndisptot() { tdcaplab.innerHTML = divTotCap.innerText; divtotadv.style.display = ""; divpladv.style.display = "none"; divfiadv.style.display = "none"; divmemadv.style.display = "none"; var psel = m_Selection0; if(m_iseltype == 2) { tbfun.style.display = ""; tdexptab.innerHTML = divTotFunc.innerText; } tdfflabel.innerText = divFormat.innerText; tbfldcap.style.display = "none"; tbcap.style.display = ""; tbcapalign.style.display = ""; tbsfmtfont.style.display = ""; tbsfmtfont2.style.display = ""; tbsfmtbg.style.display = ""; tbsfmtalign.style.display = ""; tbsfmtnfmt.style.display = ""; tbsfmtsize.style.display = ""; inplSelection.value=divSelTots.innerText; if(m_phost.ProviderType == 3 || m_iseltype == 1) { mtbexp.style.display ="none"; mtbexp.Panel.style.display ="none"; m_ilastdisp = m_ilastdisp & (0xFFFF - (1 << mtbexp.Index)); } tbfmtlabel.width = 126; } function fnnothingsel() { mtbfiformat.style.display ="none"; mtbfiformat.Panel.style.display ="none"; m_ilastdisp = m_ilastdisp & (0xFFFF - (1 << mtbfiformat.Index)); divtotadv.style.display = "none"; divpladv.style.display = ""; divfiadv.style.display = "none"; divmemadv.style.display = "none"; } function fndispview() { divtotadv.style.display = "none"; divpladv.style.display = ""; divfiadv.style.display = "none"; divmemadv.style.display = "none"; mtbfiformat.style.display ="none"; mtbfiformat.Panel.style.display ="none"; m_ilastdisp = m_ilastdisp & (0xFFFF - (1 << mtbfiformat.Index)); tdfflabel.innerText = divFiLabFormat.innerText; if(m_phost.ProviderType != 2) { mtbdsf.style.display ="none"; mtbdsf.Panel.style.display ="none"; m_ilastdisp = m_ilastdisp & (0xFFFF - (1 << mtbdsf.Index)); } tbplshow.style.display = ""; tbplshow2.style.display = ""; tbplshow3.style.display = ""; tbsfmtfont.style.display = ""; tbsfmtfont2.style.display = ""; tbsfmtbg.style.display = ""; tbsfmtalign.style.display = "none"; tbsfmtnfmt.style.display = "none"; tbsfmtsize.style.display = "none"; inplSelection.value=divSelPL.innerText; } function fndispfield() { var pfs = m_Selection0.FieldSet; var psel = m_Selection0; tdfflabel.innerHTML = divFormat.innerText; tdcaplab.innerHTML = divCaps.innerText; divtotadv.style.display = "none"; divpladv.style.display = "none"; divfiadv.style.display = ""; divmemadv.style.display = "none"; tbplshow.style.display = ""; tbplshow2.style.display = ""; tbplshow3.style.display = ""; tbcap.style.display = ""; tbfldcap.style.display = ""; tbcapalign.style.display = "none"; { mtbexp.style.display = "none"; mtbexp.Panel.style.display = "none"; m_ilastdisp = m_ilastdisp & (0xFFFF - (1 << mtbexp.Index)); } if(pfs.Orientation & 3) { tbsfmtalign.style.display = "none"; tbsfmtnfmt.style.display = "none"; tbsfmtsize.style.display = ""; mtbsortfilter.style.display = ""; tbfmtlabel.width = 86; if (pfs.Orientation & 1) inplSelection.value=divSelColF.innerText; else inplSelection.value=divSelRowF.innerText; } else { if(pfs.Orientation & 4) { tbsfmtalign.style.display = "none"; tbsfmtnfmt.style.display = "none"; tbsfmtsize.style.display = "none"; inplSelection.value=divSelFilter.innerText; mtbsortfilter.style.display = "none"; mtbsortfilter.Panel.style.display = "none"; m_ilastdisp = m_ilastdisp & (0xFFFF - (1 << mtbsortfilter.Index)); mtbgfformat.style.display = "none"; mtbgfformat.Panel.style.display = "none"; m_ilastdisp = m_ilastdisp & (0xFFFF - (1 << mtbgfformat.Index)); } else { inplSelection.value=divSelDetailF.innerText; tbfmtlabel.width = 126; tbsfmtalign.style.display = ""; tbsfmtnfmt.style.display = ""; tbsfmtsize.style.display = ""; mtbsortfilter.style.display = ""; } } tbsfmtfont.style.display = ""; tbsfmtfont2.style.display = ""; tbsfmtbg.style.display = ""; } function fnpivotaddopts(control, string, value) { var opt; opt = document.createElement("OPTION"); opt.text = string; opt.value = value; control.options.add(opt); } function fngrpupdate() { } function fnpacupdate() { var prc = m_phost.ActiveView.RowAxis.Label; var pcc = m_phost.ActiveView.ColumnAxis.Label; var pdc = m_phost.ActiveView.DataAxis.Label; var pfc = m_phost.ActiveView.FilterAxis.Label; inadvrowcap.value = prc.Caption; inadvcolcap.value = pcc.Caption; inadvfilcap.value = pfc.Caption; inadvdatacap.value = pdc.Caption; var ffnt = true; if(!prc.Font.Bold || !pcc.Font.Bold || !pdc.Font.Bold || !pfc.Font.Bold) ffnt = false; fnBtnUpdate(imgpacbold,ffnt); ffnt = true; if(!prc.Font.Italic || !pcc.Font.Italic || !pdc.Font.Italic || !pfc.Font.Italic ) ffnt = false; fnBtnUpdate(imgpacitalic ,ffnt); ffnt = true; if(!prc.Font.Underline || !pcc.Font.Underline || !pdc.Font.Underline || !pfc.Font.Underline ) ffnt = false; fnBtnUpdate(imgpacunderline ,ffnt); if((prc.Font.Name == pcc.Font.Name) && (pdc.Font.Name == pfc.Font.Name) && (prc.Font.Name == pfc.Font.Name)) fnsetselect(prc.Font.Name,slcapfontlist); if((prc.Font.Size == pcc.Font.Size) && (pdc.Font.Size == pfc.Font.Size) && (prc.Font.Size == pfc.Font.Size )) fnsetselect(prc.Font.Size ,slcapfontsize); } function fnadvupdate() { var psel; if (m_iseltype > 0) { psel = m_Selection0; } if(m_iseltype == 0 || m_iseltype == -1) { idadvdet.checked = m_phost.AllowDetails; inadvfil.checked = !m_phost.AllowFiltering; inadvgrp.checked = !m_phost.AllowGrouping; inadvprop.checked = m_phost.AllowPropertyToolbox ; inadvautofit.checked = m_phost.AutoFit; inadvmaxheight.value = external.DecodeNumber(m_phost.MaxHeight); inadvmaxwidth.value = external.DecodeNumber(m_phost.MaxWidth); inplheight.value = external.DecodeNumber(m_phost.Height); inplwidth.value = external.DecodeNumber(m_phost.Width); if (m_phost.HasDetails) inadvdetavail.innerHTML = divYes.innerText; else inadvdetavail.innerHTML = divNo.innerText; inadvrtl.checked = m_phost.RightToLeft; inmemadvae.value = m_phost.MemberExpand; } else { if(m_iseltype == 1) { var pfs = psel.FieldSet; if(pfs == null) return; tdadvfibfn.innerHTML = psel.BaseName; tdadvfidf.innerHTML = psel.DataField; tdadvfidt.innerHTML = fnDataTypeStr(psel.DataType); tdadvfifn.innerHTML = psel.Name; tdadvfift.innerHTML = fnFieldTypeStr(psel.Type); tdadvfifst.innerHTML = fnFieldSetTypeStr(pfs.Type); tdadvfifsn.innerHTML = psel.FieldSet.Name; tdadvfifsc.innerHTML = fnFieldSetOrientation(pfs.Orientation); } else { if(m_iseltype == 2) { if (psel.Field != null) tdadvtottsf.innerHTML = psel.Field.DataField; tdadvtottn.innerHTML = psel.Name; tdadvtottt.innerHTML = fnFieldTypeStr(psel.Type); } else { if(m_iseltype == 3) { tdadvmemname.innerHTML = psel.Name; tdadvmemuiquename.innerHTML = psel.UniqueName; initemcap.innerHTML = psel.Caption; } } } } } var fInDataUpdate; function fndataupdate() { inadvconn.value = m_phost.ConnectionString; fInDataUpdate = true; fnpopulatedatasources(); fInDataUpdate = false; } function fntbupdate() { var pfn = m_phost.ActiveView.TitleBar.Font; fnBtnUpdate(imgtitlebold,pfn.Bold); fnBtnUpdate(imgtitleitalic,pfn.Italic); fnBtnUpdate(imgtitleunderline,pfn.Underline); fnsetselect(pfn.Name,sltitlefontlist); fnsetselect(pfn.Size,sltitlefontsize); } function fnaxisupdate() { inemprowb.checked = m_phost.ActiveView.RowAxis.DisplayEmptyMembers; inempcolb.checked = m_phost.ActiveView.ColumnAxis.DisplayEmptyMembers; } function fnexpupdate() { var psel = m_Selection0; var enumDataType; if(m_iseltype == 2) { enumDataType = psel.Field.DataType; fnclearopts(slfunc); if (IsFunctionValid(enumDataType, 1)) fnpivotaddopts(slfunc, divTotSum.innerText,1); if (IsFunctionValid(enumDataType, 2)) fnpivotaddopts(slfunc, divTotCount.innerText,2); if (IsFunctionValid(enumDataType, 3)) fnpivotaddopts(slfunc, divTotMin.innerText,3); if (IsFunctionValid(enumDataType, 4)) fnpivotaddopts(slfunc, divTotMax.innerText,4); fnsetselect(psel.Function,slfunc); } } function fnsfupdate() { var psel = m_Selection0; var pfn; fnsetselect(psel.SortDirection,slsortdir); } function fndsfupdate() { var psel = m_Selection; indsfrwht.value = external.DecodeNumber(psel.DetailRowHeight); indsfautofit.checked = psel.DetailAutoFit; indsfwidth.value = external.DecodeNumber(psel.DetailWidth); indsfmaxwd.value = external.DecodeNumber(psel.DetailMaxWidth); indsfmaxht.value = external.DecodeNumber(psel.DetailMaxHeight); } function fngfupdate() { var psel = m_Selection0; ingfautofit.checked = psel.GroupedAutoFit; ingfwidth.value = external.DecodeNumber(psel.GroupedWidth); } function fnfiformatupdate() { if (m_iseltype > 4) return; pfn = fnfontsel(); if(typeof(pfn.Count) == "number") { fnBtnUpdate(imgbold,fnfontswitch(pfn(0)).Bold); fnBtnUpdate(imgitalic,fnfontswitch(pfn(0)).Italic); fnBtnUpdate(imgunderline,fnfontswitch(pfn(0)).Underline); fnsetselect(fnfontswitch(pfn(0)).Name,slfontlist); fnsetselect(fnfontswitch(pfn(0)).Size,slfontsize); } else { fnBtnUpdate(imgbold,fnfontswitch(pfn).Bold); fnBtnUpdate(imgitalic,fnfontswitch(pfn).Italic); fnBtnUpdate(imgunderline,fnfontswitch(pfn).Underline); fnsetselect(fnfontswitch(pfn).Name,slfontlist); fnsetselect(fnfontswitch(pfn).Size,slfontsize); } if(m_iseltype == 1) { fnsetselect(m_Selection0.NumberFormat,slnfmt); fnsetselect(m_Selection0.DetailHAlignment,slhalign); } else if(m_iseltype == 2) { fnsetselect(m_Selection0.NumberFormat,slnfmt); fnsetselect(m_Selection0.HAlignment,slhalign); } else if (m_iseltype == 3) { fnsetselect(m_phost.ActiveView.MemberHAlignment,slhalign); } if(m_iseltype == 1) { if (m_Selection0.FieldSet.Orientation & 7) { insfautofit.checked = m_Selection0.GroupedAutoFit; insfmtwd.value = external.DecodeNumber(m_Selection0.GroupedWidth); } else { insfmtwd.value = external.DecodeNumber(m_Selection0.DetailWidth); insfautofit.checked = m_Selection0.DetailAutoFit; } } else { if(m_iseltype == 2) { insfmtwd.value = external.DecodeNumber(m_Selection0.Width); insfautofit.checked = m_Selection0.AutoFit; } } } function fnplformatupdate() { inpltitle.value= m_phost.ActiveView.TitleBar.Caption; fnsetselect(m_phost.ActiveView.TotalOrientation,sltotalori); } function fntotalsupdate() { var psel=m_Selection; inflsub.checked = psel.TotalAllMembers; fnsetselect(psel.TotalOrientation,sltotalori); } function fngenupdate() { } function fnshowupdate() { fnBtnUpdate(imgexpand,m_phost.DisplayExpandIndicator); fnBtnUpdate(imgfieldlist,m_phost.DisplayFieldList); fnBtnUpdate(imgtoolbar,m_phost.DisplayToolbar); if (m_phost.ActiveView != null) { tbplshowtitle.style.display = ""; tbplshowdrop.style.display = ""; fnBtnUpdate(imgtitle,m_phost.ActiveView.Label.Visible); f1 = m_phost.ActiveView.RowAxis.Label.Visible; f2 = m_phost.ActiveView.ColumnAxis.Label.Visible; f3 = m_phost.ActiveView.FilterAxis.Label.Visible; f4 = m_phost.ActiveView.DataAxis.Label.Visible; fSet = (f1 || f2 || f3 || f4); fnBtnUpdate(imgdrop,fSet); } else { tbplshowtitle.style.display = "none"; tbplshowdrop.style.display = "none"; } } function fncapupdate() { var psel = m_Selection0; if(psel.FieldSet != null) infldsetcap.value = psel.FieldSet.Caption; infldcap.value = psel.Caption; if(m_iseltype == 2) fnsetselect(psel.CaptionHAlignment,slcapalign); else fnsetselect(psel.CaptionAlignment,slcapalign); } function fntoolbar() { var fnewstate = !(m_phost.DisplayToolbar); m_phost.DisplayToolbar = fnewstate; fnerrorchk(m_phost); fnBtnUpdate(imgtoolbar,fnewstate); } function fnhelp() { external.ShowHelp(0); } function fnplcolor() { m_phost.BackColor = tdplbox.style.backgroundColor; fnerrorchk(m_phost); } function fnplheight() { m_phost.Height = inplheight.value; inadvautofit.checked = false; fnerrorchk(m_phost); } function fnplwidth() { m_phost.Width = inplwidth.value; inadvautofit.checked = false; fnerrorchk(m_phost); } function fnpltitle() { var ptitle = m_phost.ActiveView.TitleBar; ptitle.Caption = inpltitle.value; fnerrorchk(ptitle); } function fnshowtitle() { m_phost.ActiveView.Label.Visible = !(m_phost.ActiveView.Label.Visible); fnerrorchk(m_phost); } function fnshowexpand() { m_phost.DisplayExpandIndicator = !(m_phost.DisplayExpandIndicator); fnerrorchk(m_phost); } function fnshowdrop() { f1 = m_phost.ActiveView.RowAxis.Label.Visible; f2 = m_phost.ActiveView.ColumnAxis.Label.Visible; f3 = m_phost.ActiveView.FilterAxis.Label.Visible; f4 = m_phost.ActiveView.DataAxis.Label.Visible; fSet = !(f1 || f2 || f3 || f4); m_phost.ActiveView.RowAxis.Label.Visible = fSet; m_phost.ActiveView.ColumnAxis.Label.Visible = fSet; m_phost.ActiveView.FilterAxis.Label.Visible = fSet; m_phost.ActiveView.DataAxis.Label.Visible = fSet; fnerrorchk(m_phost); } function fnshowfieldlist() { m_phost.DisplayFieldList = !(m_phost.DisplayFieldList); fnerrorchk(m_phost); } function fnsubtotalflmem() { event.cancelBubble = true; var psel = m_Selection; psel.TotalAllMembers = inflsub.checked; fnerrorchk(psel); inflsub.checked = psel.TotalAllMembers; } function fntotalorichange() { var psel = m_Selection; psel.TotalOrientation = sltotalori.value; fnerrorchk(psel); } function fndetexp() { event.cancelBubble = true; var psel = m_Selection; fnerrorchk(psel); } function fndsfrwht() { var psel = m_Selection; psel.DetailRowHeight = indsfrwht.value; fnerrorchk(psel); } function fndsfautofit() { event.cancelBubble = true; var psel = m_Selection; psel.DetailAutoFit = indsfautofit.checked; fnerrorchk(psel); indsfautofit.checked = psel.DetailAutoFit; } function fndsfwidth() { var psel= m_Selection; psel.DetailWidth = indsfwidth.value; fnerrorchk(psel); indsfautofit.checked = false; } function fndsfmaxwd() { var psel= m_Selection; psel.DetailMaxWidth = indsfmaxwd.value; fnerrorchk(psel); } function fndsfmaxht() { var psel= m_Selection; psel.DetailMaxHeight = indsfmaxht.value; fnerrorchk(psel); } function fnfont() { } function fnhidefield() { } function fnfldsetcap() { var i; var psel = m_Selection; var pselItem; for(i=0;i < psel.Count;i++) { pselItem = psel(i); pselItem.FieldSet.Caption = infldsetcap.value; fnerrorchk(pselItem); } } function fnfldcap() { var i; var psel = m_Selection; var pselItem; for(i=0;i < psel.Count;i++) { pselItem = psel(i); pselItem.Caption = infldcap.value; fnerrorchk(pselItem); } } function fnsortdir() { var i; var psel = m_Selection; var pselItem; for(i=0;i < psel.Count;i++) { pselItem = psel(i); pselItem.SortDirection = slsortdir.value; fnerrorchk(pselItem); } } function fnfunc() { var i; var psel = m_Selection; var pselItem; for(i=0;i < psel.Count;i++) { pselItem = psel(i); pselItem.Function = slfunc.value; fnerrorchk(pselItem); } } function fnemprowb() { m_phost.ActiveView.RowAxis.DisplayEmptyMembers = inemprowb.checked; } function fnempcolb() { m_phost.ActiveView.ColumnAxis.DisplayEmptyMembers = inempcolb.checked; } function fnback() { var psel = fnfontsel(); var c = psel.Count; var pfnt; if(typeof(c) == "number") { for (i = 0; i < c;i++) { pfnt = fnbgswitch(psel(i),tdbackbox.style.backgroundColor); fnerrorchk(pfnt); } } else { pfnt = fnbgswitch(psel,tdbackbox.style.backgroundColor); fnerrorchk(pfnt); } } function fnfont() { var psel = fnfontsel(); var pfnt; var c = psel.Count; if(typeof(c) == "number") { for (i = 0; i < c;i++) { pfnt = fnfontswitch(psel(i)); pfnt.Color = tdfontbox.style.backgroundColor; fnerrorchk(pfnt); } } else { pfnt = fnfontswitch(psel); pfnt.Color = tdfontbox.style.backgroundColor; fnerrorchk(pfnt); } } function fnbold() { var psel = fnfontsel(); var c = psel.Count; if(typeof(c) == "number") { var fbold = false; for (i = 0; i < c;i++) { var pfnt = fnfontswitch(psel(i)); if(!pfnt.Bold) { fbold = true; break; } } for (i = 0; i < c;i++) { var pfnt = fnfontswitch(psel(i)); pfnt.Bold = fbold; fnerrorchk(pfnt); } } else { var pfnt = fnfontswitch(psel); var fbold = !(pfnt.Bold); pfnt.Bold = !(pfnt.Bold); fnerrorchk(pfnt); } } function fnunderline() { var psel = fnfontsel(); var c = psel.Count; var fnt; if(typeof(c) == "number") { var ful = false; for (i = 0; i < c;i++) { pfnt = fnfontswitch(psel(i)); if(!pfnt.Underline) { ful = true; break; } } for (i = 0; i < c;i++) { pfnt = fnfontswitch(psel(i)); pfnt.Underline = ful; if (ful) pfnt.Underline = 1; else pfnt.Underline = 0; fnerrorchk(pfnt); } } else { pfnt = fnfontswitch(psel); if (pfnt.Underline) pfnt.Underline = 0; else pfnt.Underline = 1; fnerrorchk(pfnt); } } function fnital() { var psel = fnfontsel(); var c = psel.Count; if(typeof(c) == "number") { var fital = false; for (i = 0; i < c;i++) { var pfnt = fnfontswitch(psel(i)); if(!pfnt.Italic) { fital = true; break; } } for (i = 0; i < c;i++) { var pfnt = fnfontswitch(psel(i)); pfnt.Italic = fital; fnerrorchk(pfnt); } } else { var pfnt = fnfontswitch(psel); pfnt.Italic = !(pfnt.Italic); fnerrorchk(pfnt); } } function fnfontcng() { var psel = fnfontsel(); var c = psel.Count; if(typeof(c) == "number") { for (i = 0; i < c;i++) { var pfnt = fnfontswitch(psel(i)); pfnt.Name = slfontlist.value; fnerrorchk(pfnt); } } else { var pfnt = fnfontswitch(psel); pfnt.Name = slfontlist.value; fnerrorchk(pfnt); } } function fnfontsize() { var psel = fnfontsel(); var c = psel.Count; if(typeof(c) == "number") { for (i = 0; i < c;i++) { var pfnt = fnfontswitch(psel(i)); pfnt.Size = slfontsize.value; fnerrorchk(pfnt); } } else { var pfnt = fnfontswitch(psel); pfnt.Size = slfontsize.value; fnerrorchk(pfnt); } } function fncapalign() { var psel = m_Selection; var c = psel.Count; var pselItem; for (i = 0;i < c;i++) { pselItem = psel(i); pselItem.CaptionHAlignment = slcapalign.value; fnerrorchk(pselItem); } } function fnhalignchange() { var psel = fnalignsel(); var c = psel.Count; var pfnt; if(typeof(c) == "number") { for (i = 0; i < c;i++) { pfnt = fnhalignswitch(psel(i),slhalign.value); fnerrorchk(pfnt); } } else { pfnt = fnhalignswitch(psel,slhalign.value); fnerrorchk(pfnt); } } function fnvalignchange() { var psel = fnalignsel(); var c = psel.Count; var pfnt; if(typeof(c) == "number") { for (i = 0; i < c;i++) { pfnt = fnvalignswitch(psel(i),slvalign.value); fnerrorchk(pfnt); } } else { pfnt = fnvalignswitch(psel,slvalign.value); fnerrorchk(pfnt); } } function fnnumfmtchange() { var psel = m_Selection; var c = psel.Count; var pselItem; for (i = 0;i < c;i++) { pselItem = psel(i); pselItem.NumberFormat = slnfmt.value; fnerrorchk(pselItem); } } function fnsfmtwd() { var psel = m_Selection; var c = psel.Count var pselItem; if(m_iseltype == 1) { for(i=0;i= 0) { var ees = m_pDSC[m_iDSC].ElementExtensions; var nCountEES = ees.Count; for (var index = 0; index < nCountEES; index++) { if (ees(index).ElementID == m_phost.Parent.ID) { ees.Delete (index); break; } } } } function fnconneditor() { var strConn; cleardsc(); m_phost.LocateDataSource(); strConn = m_phost.ConnectionString; if (strConn != "" && m_strConn != strConn) { inadvconn.value = strConn; m_strConn = strConn; fnclearopts(sladvdatamember); if (m_phost.DataSource != null) { sladvdatasource.value = -1; fnsetdmopts(m_phost.DataSource); } } } function fnadvconn() { if (m_strConn == inadvconn.value) return; m_strConn = inadvconn.value; m_phost.DataSource=null; cleardsc(); if (inadvconn.value == "") m_phost.ConnectionString = ""; else m_phost.ConnectionString = inadvconn.value; var fError = fnerrorchk(m_phost); fnclearopts(sladvdatamember); if (inadvconn.value != "" && m_phost.DataSource != null) { sladvdatasource.value = -1; if (!fError) fnsetdmopts(m_phost.DataSource); } } function fnadvcommand() { if (m_strCommand == inadvcommand.value) return; m_strCommand = inadvcommand.value; m_phost.CommandText = inadvcommand.value; fnerrorchk(m_phost); sladvdatamember.value = -1; } function fnadvds() { var pDSCCur; if (sladvdatasource.value == -1) { m_phost.DataSource = "" m_phost.ConnectionString = m_strConn; inadvconn.value = m_strConn; fnsetdmopts(m_phost.DataSource); return; } else if (sladvdatasource.value == "") return; cleardsc(); pDSCCur = m_pDSC[sladvdatasource.value]; m_phost.DataSource = pDSCCur.Object; if (fnerrorchk(m_phost)) return; m_phost.ConnectionString = ""; inadvconn.value=""; m_iDSC = sladvdatasource.value; m_pDSC[sladvdatasource.value].ElementExtensions.Add (m_phost.Parent.ID); m_pDSC[sladvdatasource.value].ElementExtensions(m_phost.Parent.ID).ConsumesRecordset = true; fnerrorchk(m_phost); fnsetdmopts(m_pDSC[sladvdatasource.value]); } function fnsetdmopts(pDSCCur) { var i; var nCount; var stName; fnclearopts(sladvdatamember); if (pDSCCur == null) { return; } var strings; var data; strings = null; strings = m_phost.DataMemberStrings; if (fInDataUpdate && m_phost.LastErrorValue != 0) return; if (!fnerrorchk(m_phost) && strings != null) { data = strings.toArray(); var i; var count; for (i = 0, count = data.length ; i < count; i++) fnpivotaddopts(sladvdatamember, data[i], data[i]); } } function fnadvdm() { var pDSCCur; pDSCCur = m_pDSC[sladvdatasource.value]; if ((indatadsc.checked && pDSCCur == null) || (indatastr.checked && m_strConn == "")) return; m_strDataMember = sladvdatamember.value; m_phost.DataMember = ""; m_phost.DataMember = sladvdatamember.value; fnerrorchk(m_phost); inadvcommand.value = ""; } function fnmemadvae() { m_phost.MemberExpand = inmemadvae.value; } function fnfontsel() { switch(m_iseltype) { case 0: return m_phost.ActiveView; case 1: return m_Selection; case 2: return m_phost.ActiveView; case 3: return m_phost.ActiveView; case 4: return m_Selection0.Field; defualt: return null; } } function fnalignsel() { switch(m_iseltype) { case 0: return m_phost.ActiveView; case 1: return m_Selection; case 2: return m_Selection; case 3: return m_phost.ActiveView; defualt: return null; } } function fnfontswitch(psel) { switch(m_iseltype) { case 0: return psel.FieldLabelFont; case 1: var pfs = psel.FieldSet; if(pfs == null) return; if (psel.FieldSet.Orientation & 7) return m_phost.ActiveView.FieldLabelFont; else return psel.DetailFont; case 2: return psel.TotalFont; case 3: return psel.MemberFont; case 4: return psel.SubtotalFont; default: return null; } } function fnbgswitch(psel,clr) { switch(m_iseltype) { case 0: psel.FieldLabelBackColor = clr; return psel; case 1: if (psel.FieldSet.Orientation & 7) m_phost.ActiveView.FieldLabelBackColor = clr; else psel.DetailBackColor = clr; return psel; case 2: psel.TotalBackColor = clr; return psel; case 3: psel.MemberBackColor = clr; return psel; case 4: psel.SubtotalBackColor = clr; return psel; default: return null; } } function fnvalignswitch(psel,val) { switch(m_iseltype) { case 1: psel.DetailVAlignment = val ; break; case 2: psel.TotalVAlignment = val; break; case 3: psel.MemberVAlignment = val; break; case 4: psel.SubtotalVAlignment = val; break; default: break; } return psel; } function fnhalignswitch(psel,val) { switch(m_iseltype) { case 1: psel.DetailHAlignment = val; break; case 2: psel.HAlignment = val; break; case 3: psel.MemberHAlignment = val; break; case 4: psel.SubtotalHAlignment =val; break; default: break; } return psel; } function fnhval(psel) { var val; switch(m_iseltype) { case 1: val = psel.DetailHAlignment; break; case 2: val = psel.TotalHAlignment; break; case 3: val = psel.MemberHAlignment; break; case 4: val = psel.SubtotalHAlignment; break; default: break; } return val; } function fnvval(psel) { var val; switch(m_iseltype) { case 1: val = psel.DetailVAlignment; break; case 2: val = psel.TotalVAlignment; break; case 3: val = psel.MemberVAlignment; break; case 4: val = psel.SubtotalVAlignment; break; default: break; } return val; } function fnselectdisp(idisp) { var dispmap,i; if (window == null) return; if (window.m_ppanels == null) return; var iln = window.m_ppanels.length; for(i=0;i> i) & 1) { if(((dispmap & idisp) >> i) & 1) { window.m_ppanels[i].style.display = ""; if(window.m_ppanels[i].State) window.m_ppanels[i].Panel.style.display = ""; } else { window.m_ppanels[i].style.display = "none"; window.m_ppanels[i].Panel.style.display = "none"; } } } m_ilastdisp = idisp; } function fnGetPanels() { return m_ppanels; } function fnpopulatedatasources() { var par; par = null; if (m_phost == null) { return; } par = m_phost.Parent; if (par == null) { return; } var rgDocCol,i,iln,fHasDSC; var stDisplay, stConn; var dscCur; m_pDSC = new Array(); fnclearopts(sladvdatasource); fnclearopts(sladvdatamember); m_strConn = m_phost.ConnectionString; m_strCommand = m_phost.CommandText; m_iDSC = -1; m_strDataMember = ""; if (m_strConn != "") { indatastr.checked = true; fndatastrrb(); } else { indatadsc.checked = true; fndatasrcrb(); } if (m_phost.Parent.Document == null) { if (m_strCommand != "" && m_phost.ProviderType != 3) { indatatext.checked = true; fndatatextrb(); } else { indatamem.checked = true; fnsetdmopts(m_phost.DataSource); fndatamemrb(); } return; } dscCur = m_phost.DataSource; rgDocCol = m_phost.Parent.Document.All.tags("OBJECT"); fnerrorchk(m_phost); fHasDSC = false; iln = rgDocCol.length; for(i = 0;i < iln;i++) { if (rgDocCol[i] != null && rgDocCol[i].classid.search("0002E530-0000-0000-C000-000000000046") > 0) { m_pDSC[m_pDSC.length] = rgDocCol[i]; fHasDSC = true } } if (fHasDSC || dscCur != null) { iln = m_pDSC.length; for (i = 0; i < iln; i++) { stDisplay = m_pDSC[i].id fnpivotaddopts(sladvdatasource, stDisplay, i); if (dscCur != null && dscCur.ConnectionString == m_pDSC[i].ConnectionString) { sladvdatasource.value = i; m_iDSC = i; } } fnsetdmopts(m_phost.DataSource); } if (m_strCommand != "" && m_phost.ProviderType != 3) { indatatext.checked = true; fndatatextrb(); } else { indatamem.checked = true; fndatamemrb(); if (m_phost.ProviderType == 3) indatatext.disabled = true; else if (!indatadsc.checked) indatatext.disabled = false; } } function IsFunctionValid(enumDataType, enumFunction) { if (enumFunction == 0 || enumFunction == 5 || enumFunction == 6 || enumFunction == 7) return false; switch (enumDataType) { case 16: case 2: case 3: case 20: case 17: case 18: case 19: case 21: case 4: case 5: case 6: case 14: case 131: case 11: case 139: return true; case 7: case 133: case 134: case 135: return (enumFunction == 2 || enumFunction == 3 || enumFunction == 4); } return (enumFunction == 2); } function fnDataTypeStr(enumDataType) { switch (enumDataType) { case 0: return divDTEmpty.innerText; case 1: return divDTNull.innerText; case 2: return divDTSmallInt.innerText; case 3: return divDTInteger.innerText; case 4: return divDTSingle.innerText; case 5: return divDTDouble.innerText; case 6: return divDTCurrency.innerText; case 7: return divDTDate.innerText; case 8: return divDTBSTR.innerText; case 9: return divDTIDispatch.innerText; case 10: return divDTError.innerText; case 11: return divDTBoolean.innerText; case 12: return divDTVariant.innerText; case 13: return divDTIUnknown.innerText; case 14: return divDTDecimal.innerText; case 16: return divDTTinyInt.innerText; case 17: return divDTUnsignedTinyInt.innerText; case 18: return divDTUnsignedSmallInt.innerText; case 19: return divDTUnsignedInt.innerText; case 20: return divDTBigInt.innerText; case 21: return divDTUnsignedBigInt.innerText; case 64: return divDTFileTime.innerText; case 72: return divDTGUID.innerText; case 128: return divDTBinary.innerText; case 129: return divDTChar.innerText; case 130: return divDTWChar.innerText; case 131: return divDTNumeric.innerText; case 132: return divDTUserDefined.innerText; case 133: return divDTDBDate.innerText; case 134: return divDTDBTime.innerText; case 135: return divDTDBTimeStamp.innerText; case 136: return divDTChapter.innerText; case 137: return divDTDBFileTime.innerText; case 138: return divDTPropVariant.innerText; case 139: return divDTVarNumeric.innerText; case 200: return divDTVarChar.innerText; case 201: return divDTLongVarChar.innerText; case 202: return divDTVarWChar.innerText; case 203: return divDTLongVarWChar.innerText; case 204: return divDTVarBinary.innerText; case 205: return divDTLongVarBinary.innerText; default: return ""; } } function fnFieldTypeStr(enumDataType) { switch (enumDataType) { case 1: return divDTTypeRegular.innerText; case 2: return divDTTypeCalculated.innerText; case 3: return divDTTypeTime.innerText; case 4: return divDTTypeTimeYears.innerText; case 5: return divDTTypeTimeHalfYears.innerText; case 6: return divDTTypeTimeQuarters.innerText; case 7: return divDTTypeTimeMonths.innerText; case 8: return divDTTypeTimeWeeks.innerText; case 9: return divDTTypeTimeDays.innerText; case 10: return divDTTypeTimeHours.innerText; case 11: return divDTTypeTimeMinutes.innerText; case 12: return divDTTypeTimeSeconds.innerText; case 13: return divDTTypeTimeUndefined.innerText; case 14: return divDTTypeUnknown.innerText; case 15: return divDTTypeUserDefined.innerText; default: return ""; } } function fnFieldSetTypeStr(enumDataType) { switch (enumDataType) { case 3: return divDTFieldSetTypeUnknown.innerText; case 1: return divDTFieldSetTypeTime.innerText; case 4: return divDTFieldSetTypeUserDefined.innerText; case 2: return divDTFieldSetTypeOther.innerText; default: return ""; } } function fnFieldSetOrientation(enumDataType) { switch (enumDataType) { case 0: return divDTOrientationNone.innerText; case 1: return divDTOrientationColumnAxis.innerText; case 2: return divDTOrientationRowAxis.innerText; case 4: return divDTOrientationFilterAxis.innerText; case 8: return divDTOrientationDataAxis.innerText; default: return ""; } }
General
Selection: Help
PivotTable title:
Background:
Format
AutoFit
Width
Total all items
Total orientation:
Display Empty Items
Detail Data Format
Sort
Title Bar Format
Drop Area Captions
Advanced
General
None
Item
Subtotal
Totals
Entire PivotTable
Column field
Row field
Filter field
Detail data field
Format
Captions
Expression
Total Function
Total Caption
Field Label Format
Each Value
Years
Quarters
Months
Weeks
Days
Hours
Minutes
Seconds
Prefix Char
Interval
Yes
No
[Use Connection]
No Data Sources
Sum
Count
Min
Max
Empty
Null
Integer
Long
Single
Double
Currency
Date
Text
IDispatch
Error
Yes/No
Variant
Unknown
Decimal
Byte
Byte
Integer
Long
Big Integer
Big Integer
File Time
Guid
Binary
Text
Text
Numeric
User Defined
Date
Time
Time Stamp
Chapter
File Time
Property Variant
Numeric
Text
Memo
Memo
Memo
Binary
Binary
Regular
Calculated
Time
Years
Half Years
Quarters
Months
Weeks
Days
Hours
Minutes
Seconds
Undefined
Unknown
User Defined
Unknown
Time
User Defined
Other
None
Column
Row
Filter
Data
Default
This Property Toolbox section cannot be expanded on your 640x480 screen. To use this section of the toolbox, use a higher resolution display, such as 800x600.
var m_phost; var m_ilastdisp; var m_aridisp; var m_aridispRuntime; var m_iseltype; var m_fDesign; var m_paridispUse; var m_ppanels; var m_pDSC; var m_strConn; var m_Selection; var m_Selection0; var m_strCommand; var m_iDSC; var m_strDataMember; var m_finited = false; function init() { m_ppanels = new Array(); m_phost = external.Host; obpicker.This = obpicker; m_ilastdisp = 0; m_aridisp = new Array(0xF333,0x149D,0x141D,0x1015,0x15,0x11,0x11,0x11); m_aridispRuntime = new Array(0x233,0x49D,0x41D,0x015,0x15,0x11,0x11,0x11); initStdPair(mtbgen,mtbgenbar,fngenupdate,m_ppanels,fnnone); initStdPair(mtbplformat,mdivplformatbar,fnplformatupdate,m_ppanels,fnformatinit); initStdPair(mtbfiformat,mdivfiformatbar,fnfiformatupdate,m_ppanels,fnfiinit); initStdPair(mtbcaption,mtbcaptionbar,fncapupdate,m_ppanels,fncapinit); initStdPair(mtbshow,mtbshowbar,fnshowupdate,m_ppanels,fnshowinit); initStdPair(mtbtotals,mtbtotalsbar,fntotalsupdate,m_ppanels,fntotalsinit); initStdPair(mtbgrp,mtbgrpbar,fngrpupdate,m_ppanels,fngrpinit); initStdPair(mtbsortfilter,mtbsortfilterbar,fnsfupdate,m_ppanels,fnsfinit); initStdPair(mtbdsf,mtbdsfbar,fndsfupdate,m_ppanels,fndsfinit); initStdPair(mtbaxis,mtbaxisbar,fnaxisupdate,m_ppanels,fnaxisinit); initStdPair(mtbexp,mtbexpbar,fnexpupdate,m_ppanels,fnexpinit); initStdPair(mtbgfformat,mtbgfformatbar,fngfupdate,m_ppanels,fngfinit); initStdPair(mtbpladvanced,mdivpladvancedbar,fnadvupdate,m_ppanels,fnadvinit); initStdPair(mtbtitleformat,mdivtitleformatbar,fntbupdate,m_ppanels,fntbinit); initStdPair(mtbpac,mdivpac,fnpacupdate,m_ppanels,fnpacinit); initStdPair(mtbdata,mtbdatabar,fndataupdate,m_ppanels,fndatainit); if(document.dir == "rtl") fninitrtl(); initStdBtn(imgtoolbar,1,fntoolbar); initStdBtn(imgbold,1,fnbold); initStdBtn(imgitalic,1,fnital); initStdBtn(imgunderline,1,fnunderline); initStdBtn(imgtitlebold,1,fntitlebold); initStdBtn(imgtitleitalic,1,fntitleital); initStdBtn(imgtitleunderline,1,fntitleunderline); initStdBtn(imgpacbold,1,fncapbold); initStdBtn(imgpacitalic,1,fncapital); initStdBtn(imgpacunderline,1,fncapunderline); initStdBtn(imgexpand,1,fnshowexpand); initStdBtn(imgfieldlist,1,fnshowfieldlist); initStdBtn(imgtitle,1,fnshowtitle); initStdBtn(imghelp,0,fnhelp); initStdBtn(imgdrop,1,fnshowdrop); m_fDesign = external.UserMode; if (m_fDesign) m_paridispUse = m_aridisp; else m_paridispUse = m_aridispRuntime; fnfiinit(); mtbfiformat.style.display = ""; mtbfiformat.Panel.style.display = ""; mtbfiformat.State = 1; fnformatinit(); mtbplformat.style.display = ""; mtbplformat.Panel.style.display = ""; mtbplformat.State = 1; m_ilastdisp=6; AddOpenPanel(mtbplformat); AddOpenPanel(mtbfiformat); AddOpenPanel(mtbgen); fnclearopts(slfontlist); fnFontInit(slfontlist,m_phost); fnclearopts(sltitlefontlist); fnFontInit(sltitlefontlist,m_phost); fnclearopts(slcapfontlist); fnFontInit(slcapfontlist,m_phost); document.body.onclick = fnclean; m_finited = true; SelectionChanged(); } function fnclean() { obpicker.Close(); } function fninitrtl() { var iln = m_ppanels.length; for(var i=0;i < iln; i++) { var tarr = document.all(m_ppanels[i].id + "arr"); tarr.parentElement.align = "left"; } tdfontlist.align = "right"; tdfontsize.align = "right"; tdtitlefontlist.align = "right"; tdtitlefontsize.align = "right"; tdcapfontlist.align = "right"; tdcapfontsize.align = "right"; } function SelectionChanged() { if(!m_finited) return; if(external != null && external.Host != null) { m_phost = external.Host; if(external.HostType != 2 || (external.UserMode ^ m_fDesign)) { window.location.href= "../core/pbmain.htm"; return; } m_Selection = m_phost.Selection; m_Selection0 = m_phost.Selection(0); switch (fnWrapTypeName(m_Selection)) { case "PivotView": m_iseltype = 0; fnselectdisp(m_paridispUse[0]); fndispview(); break; case "PivotFields": m_iseltype = 1; fnselectdisp(m_paridispUse[1]); fndispfield(); break; case "PivotTotals": m_iseltype = 2; fnselectdisp(m_paridispUse[2]); fndisptot(); break; case "PivotMembers": if(m_Selection.Count == 1 && m_Selection0.IsTotal) { m_iseltype = 4; fnselectdisp(m_paridispUse[4]); fndispsub(); } else { m_iseltype = 3; fnselectdisp(m_paridispUse[3]); fndispmem(); } break; case "PivotAggregates": m_iseltype = 5; fnselectdisp(m_paridispUse[5]); inplSelection.value=divSelGen.innerText; break; case "PivotRange": m_iseltype = 6; fnselectdisp(m_paridispUse[6]); inplSelection.value=divSelGen.innerText; break; case "PivotDetailRange": m_iseltype = 7; fnselectdisp(m_paridispUse[7]); inplSelection.value=divSelGen.innerText; break; default: m_iseltype = -1; inplSelection.value=divSelNone.innerText; if (m_fDesign) { fnselectdisp(0x9011); } else { fnselectdisp(0x11); } fnnothingsel(); break; } fnUpdate(m_ppanels); fnsize(); fnclean(); fnbgcheck(); } else { m_phost = null; m_Selection = null; m_Selection0 = null; CollectGarbage(); } } function LostFocus() { if(external != null && external.Host != null) { var pae = document.activeElement; if(pae != null) { var pfn = pae.Function; if(pfn != null) { fnFocusState(false); pfn(); fnFocusState(true); } } } } function fnsize() { fninitsize(m_ppanels); } function fnformatinit() { initStdEdit(inpltitle,fnpltitle,false); } function fnfiinit() { initStdEdit(insfmtwd,fnsfmtwd,false); } function fncapinit() { initStdEdit(infldcap,fnfldcap,false); initStdEdit(infldsetcap,fnfldsetcap,false); } function fnshowinit() { } function fntotalsinit() { } function fngrpinit() { } function fnsfinit() { } function fndsfinit() { initStdEdit(indsfmaxwd,fndsfmaxwd,false); initStdEdit(indsfmaxht,fndsfmaxht,false); initStdEdit(indsfwidth,fndsfwidth,false); initStdEdit(indsfrwht,fndsfrwht,false); } function fnaxisinit() { } function fnexpinit() { } function fngfinit() { initStdEdit(ingfwidth,fngfwidthchange,false); } function fnadvinit() { initStdEdit(inadvmaxheight,fnadvheight,false); initStdEdit(inadvmaxwidth,fnadvwidth,false); initStdEdit(inplheight,fnplheight,false); initStdEdit(inplwidth,fnplwidth,false); } function fntbinit() { } function fnpacinit() { initStdEdit(inadvrowcap,fnadvrowcap,false); initStdEdit(inadvcolcap,fnadvcolcap,false); initStdEdit(inadvdatacap,fnadvdatacap,false); initStdEdit(inadvfilcap,fnadvfilcap,false); } function fndatainit() { initStdEdit(inadvconn,fnadvconn,false); initStdEdit(inadvcommand,fnadvcommand,false); } function fndispmem() { divtotadv.style.display = "none"; divpladv.style.display = "none"; divfiadv.style.display = "none"; divmemadv.style.display = ""; tdfflabel.innerText = divFormat.innerText; tdexptab.innerHTML = divTotFunc.innerText; tbfun.style.display = ""; tbfldcap.style.display = "none"; tbcap.style.display = ""; tbcapalign.style.display = "none"; tbsfmtfont.style.display = ""; tbsfmtfont2.style.display = ""; tbsfmtbg.style.display = ""; tbsfmtalign.style.display = ""; tbsfmtnfmt.style.display = "none"; tbsfmtsize.style.display = "none"; inplSelection.value = divSelItem.innerText; } function fndispsub() { tdfflabel.innerHTML = divFormat.innerText; tbsfmtfont.style.display = ""; tbsfmtfont2.style.display = ""; tbsfmtbg.style.display = ""; tbsfmtalign.style.display = "none"; tbsfmtnfmt.style.display = "none"; tbsfmtsize.style.display = "none"; inplSelection.value=divSelSubtot.innerText; } function fndisptot() { tdcaplab.innerHTML = divTotCap.innerText; divtotadv.style.display = ""; divpladv.style.display = "none"; divfiadv.style.display = "none"; divmemadv.style.display = "none"; var psel = m_Selection0; if(m_iseltype == 2) { tbfun.style.display = ""; tdexptab.innerHTML = divTotFunc.innerText; } tdfflabel.innerText = divFormat.innerText; tbfldcap.style.display = "none"; tbcap.style.display = ""; tbcapalign.style.display = ""; tbsfmtfont.style.display = ""; tbsfmtfont2.style.display = ""; tbsfmtbg.style.display = ""; tbsfmtalign.style.display = ""; tbsfmtnfmt.style.display = ""; tbsfmtsize.style.display = ""; inplSelection.value=divSelTots.innerText; if(m_phost.ProviderType == 3 || m_iseltype == 1) { mtbexp.style.display ="none"; mtbexp.Panel.style.display ="none"; m_ilastdisp = m_ilastdisp & (0xFFFF - (1 << mtbexp.Index)); } tbfmtlabel.width = 126; } function fnnothingsel() { mtbfiformat.style.display ="none"; mtbfiformat.Panel.style.display ="none"; m_ilastdisp = m_ilastdisp & (0xFFFF - (1 << mtbfiformat.Index)); divtotadv.style.display = "none"; divpladv.style.display = ""; divfiadv.style.display = "none"; divmemadv.style.display = "none"; } function fndispview() { divtotadv.style.display = "none"; divpladv.style.display = ""; divfiadv.style.display = "none"; divmemadv.style.display = "none"; mtbfiformat.style.display ="none"; mtbfiformat.Panel.style.display ="none"; m_ilastdisp = m_ilastdisp & (0xFFFF - (1 << mtbfiformat.Index)); tdfflabel.innerText = divFiLabFormat.innerText; if(m_phost.ProviderType != 2) { mtbdsf.style.display ="none"; mtbdsf.Panel.style.display ="none"; m_ilastdisp = m_ilastdisp & (0xFFFF - (1 << mtbdsf.Index)); } tbplshow.style.display = ""; tbplshow2.style.display = ""; tbplshow3.style.display = ""; tbsfmtfont.style.display = ""; tbsfmtfont2.style.display = ""; tbsfmtbg.style.display = ""; tbsfmtalign.style.display = "none"; tbsfmtnfmt.style.display = "none"; tbsfmtsize.style.display = "none"; inplSelection.value=divSelPL.innerText; } function fndispfield() { var pfs = m_Selection0.FieldSet; var psel = m_Selection0; tdfflabel.innerHTML = divFormat.innerText; tdcaplab.innerHTML = divCaps.innerText; divtotadv.style.display = "none"; divpladv.style.display = "none"; divfiadv.style.display = ""; divmemadv.style.display = "none"; tbplshow.style.display = ""; tbplshow2.style.display = ""; tbplshow3.style.display = ""; tbcap.style.display = ""; tbfldcap.style.display = ""; tbcapalign.style.display = "none"; { mtbexp.style.display = "none"; mtbexp.Panel.style.display = "none"; m_ilastdisp = m_ilastdisp & (0xFFFF - (1 << mtbexp.Index)); } if(pfs.Orientation & 3) { tbsfmtalign.style.display = "none"; tbsfmtnfmt.style.display = "none"; tbsfmtsize.style.display = ""; mtbsortfilter.style.display = ""; tbfmtlabel.width = 86; if (pfs.Orientation & 1) inplSelection.value=divSelColF.innerText; else inplSelection.value=divSelRowF.innerText; } else { if(pfs.Orientation & 4) { tbsfmtalign.style.display = "none"; tbsfmtnfmt.style.display = "none"; tbsfmtsize.style.display = "none"; inplSelection.value=divSelFilter.innerText; mtbsortfilter.style.display = "none"; mtbsortfilter.Panel.style.display = "none"; m_ilastdisp = m_ilastdisp & (0xFFFF - (1 << mtbsortfilter.Index)); mtbgfformat.style.display = "none"; mtbgfformat.Panel.style.display = "none"; m_ilastdisp = m_ilastdisp & (0xFFFF - (1 << mtbgfformat.Index)); } else { inplSelection.value=divSelDetailF.innerText; tbfmtlabel.width = 126; tbsfmtalign.style.display = ""; tbsfmtnfmt.style.display = ""; tbsfmtsize.style.display = ""; mtbsortfilter.style.display = ""; } } tbsfmtfont.style.display = ""; tbsfmtfont2.style.display = ""; tbsfmtbg.style.display = ""; } function fnpivotaddopts(control, string, value) { var opt; opt = document.createElement("OPTION"); opt.text = string; opt.value = value; control.options.add(opt); } function fngrpupdate() { } function fnpacupdate() { var prc = m_phost.ActiveView.RowAxis.Label; var pcc = m_phost.ActiveView.ColumnAxis.Label; var pdc = m_phost.ActiveView.DataAxis.Label; var pfc = m_phost.ActiveView.FilterAxis.Label; inadvrowcap.value = prc.Caption; inadvcolcap.value = pcc.Caption; inadvfilcap.value = pfc.Caption; inadvdatacap.value = pdc.Caption; var ffnt = true; if(!prc.Font.Bold || !pcc.Font.Bold || !pdc.Font.Bold || !pfc.Font.Bold) ffnt = false; fnBtnUpdate(imgpacbold,ffnt); ffnt = true; if(!prc.Font.Italic || !pcc.Font.Italic || !pdc.Font.Italic || !pfc.Font.Italic ) ffnt = false; fnBtnUpdate(imgpacitalic ,ffnt); ffnt = true; if(!prc.Font.Underline || !pcc.Font.Underline || !pdc.Font.Underline || !pfc.Font.Underline ) ffnt = false; fnBtnUpdate(imgpacunderline ,ffnt); if((prc.Font.Name == pcc.Font.Name) && (pdc.Font.Name == pfc.Font.Name) && (prc.Font.Name == pfc.Font.Name)) fnsetselect(prc.Font.Name,slcapfontlist); if((prc.Font.Size == pcc.Font.Size) && (pdc.Font.Size == pfc.Font.Size) && (prc.Font.Size == pfc.Font.Size )) fnsetselect(prc.Font.Size ,slcapfontsize); } function fnadvupdate() { var psel; if (m_iseltype > 0) { psel = m_Selection0; } if(m_iseltype == 0 || m_iseltype == -1) { idadvdet.checked = m_phost.AllowDetails; inadvfil.checked = !m_phost.AllowFiltering; inadvgrp.checked = !m_phost.AllowGrouping; inadvprop.checked = m_phost.AllowPropertyToolbox ; inadvautofit.checked = m_phost.AutoFit; inadvmaxheight.value = external.DecodeNumber(m_phost.MaxHeight); inadvmaxwidth.value = external.DecodeNumber(m_phost.MaxWidth); inplheight.value = external.DecodeNumber(m_phost.Height); inplwidth.value = external.DecodeNumber(m_phost.Width); if (m_phost.HasDetails) inadvdetavail.innerHTML = divYes.innerText; else inadvdetavail.innerHTML = divNo.innerText; inadvrtl.checked = m_phost.RightToLeft; inmemadvae.value = m_phost.MemberExpand; } else { if(m_iseltype == 1) { var pfs = psel.FieldSet; if(pfs == null) return; tdadvfibfn.innerHTML = psel.BaseName; tdadvfidf.innerHTML = psel.DataField; tdadvfidt.innerHTML = fnDataTypeStr(psel.DataType); tdadvfifn.innerHTML = psel.Name; tdadvfift.innerHTML = fnFieldTypeStr(psel.Type); tdadvfifst.innerHTML = fnFieldSetTypeStr(pfs.Type); tdadvfifsn.innerHTML = psel.FieldSet.Name; tdadvfifsc.innerHTML = fnFieldSetOrientation(pfs.Orientation); } else { if(m_iseltype == 2) { if (psel.Field != null) tdadvtottsf.innerHTML = psel.Field.DataField; tdadvtottn.innerHTML = psel.Name; tdadvtottt.innerHTML = fnFieldTypeStr(psel.Type); } else { if(m_iseltype == 3) { tdadvmemname.innerHTML = psel.Name; tdadvmemuiquename.innerHTML = psel.UniqueName; initemcap.innerHTML = psel.Caption; } } } } } var fInDataUpdate; function fndataupdate() { inadvconn.value = m_phost.ConnectionString; fInDataUpdate = true; fnpopulatedatasources(); fInDataUpdate = false; } function fntbupdate() { var pfn = m_phost.ActiveView.TitleBar.Font; fnBtnUpdate(imgtitlebold,pfn.Bold); fnBtnUpdate(imgtitleitalic,pfn.Italic); fnBtnUpdate(imgtitleunderline,pfn.Underline); fnsetselect(pfn.Name,sltitlefontlist); fnsetselect(pfn.Size,sltitlefontsize); } function fnaxisupdate() { inemprowb.checked = m_phost.ActiveView.RowAxis.DisplayEmptyMembers; inempcolb.checked = m_phost.ActiveView.ColumnAxis.DisplayEmptyMembers; } function fnexpupdate() { var psel = m_Selection0; var enumDataType; if(m_iseltype == 2) { enumDataType = psel.Field.DataType; fnclearopts(slfunc); if (IsFunctionValid(enumDataType, 1)) fnpivotaddopts(slfunc, divTotSum.innerText,1); if (IsFunctionValid(enumDataType, 2)) fnpivotaddopts(slfunc, divTotCount.innerText,2); if (IsFunctionValid(enumDataType, 3)) fnpivotaddopts(slfunc, divTotMin.innerText,3); if (IsFunctionValid(enumDataType, 4)) fnpivotaddopts(slfunc, divTotMax.innerText,4); fnsetselect(psel.Function,slfunc); } } function fnsfupdate() { var psel = m_Selection0; var pfn; fnsetselect(psel.SortDirection,slsortdir); } function fndsfupdate() { var psel = m_Selection; indsfrwht.value = external.DecodeNumber(psel.DetailRowHeight); indsfautofit.checked = psel.DetailAutoFit; indsfwidth.value = external.DecodeNumber(psel.DetailWidth); indsfmaxwd.value = external.DecodeNumber(psel.DetailMaxWidth); indsfmaxht.value = external.DecodeNumber(psel.DetailMaxHeight); } function fngfupdate() { var psel = m_Selection0; ingfautofit.checked = psel.GroupedAutoFit; ingfwidth.value = external.DecodeNumber(psel.GroupedWidth); } function fnfiformatupdate() { if (m_iseltype > 4) return; pfn = fnfontsel(); if(typeof(pfn.Count) == "number") { fnBtnUpdate(imgbold,fnfontswitch(pfn(0)).Bold); fnBtnUpdate(imgitalic,fnfontswitch(pfn(0)).Italic); fnBtnUpdate(imgunderline,fnfontswitch(pfn(0)).Underline); fnsetselect(fnfontswitch(pfn(0)).Name,slfontlist); fnsetselect(fnfontswitch(pfn(0)).Size,slfontsize); } else { fnBtnUpdate(imgbold,fnfontswitch(pfn).Bold); fnBtnUpdate(imgitalic,fnfontswitch(pfn).Italic); fnBtnUpdate(imgunderline,fnfontswitch(pfn).Underline); fnsetselect(fnfontswitch(pfn).Name,slfontlist); fnsetselect(fnfontswitch(pfn).Size,slfontsize); } if(m_iseltype == 1) { fnsetselect(m_Selection0.NumberFormat,slnfmt); fnsetselect(m_Selection0.DetailHAlignment,slhalign); } else if(m_iseltype == 2) { fnsetselect(m_Selection0.NumberFormat,slnfmt); fnsetselect(m_Selection0.HAlignment,slhalign); } else if (m_iseltype == 3) { fnsetselect(m_phost.ActiveView.MemberHAlignment,slhalign); } if(m_iseltype == 1) { if (m_Selection0.FieldSet.Orientation & 7) { insfautofit.checked = m_Selection0.GroupedAutoFit; insfmtwd.value = external.DecodeNumber(m_Selection0.GroupedWidth); } else { insfmtwd.value = external.DecodeNumber(m_Selection0.DetailWidth); insfautofit.checked = m_Selection0.DetailAutoFit; } } else { if(m_iseltype == 2) { insfmtwd.value = external.DecodeNumber(m_Selection0.Width); insfautofit.checked = m_Selection0.AutoFit; } } } function fnplformatupdate() { inpltitle.value= m_phost.ActiveView.TitleBar.Caption; fnsetselect(m_phost.ActiveView.TotalOrientation,sltotalori); } function fntotalsupdate() { var psel=m_Selection; inflsub.checked = psel.TotalAllMembers; fnsetselect(psel.TotalOrientation,sltotalori); } function fngenupdate() { } function fnshowupdate() { fnBtnUpdate(imgexpand,m_phost.DisplayExpandIndicator); fnBtnUpdate(imgfieldlist,m_phost.DisplayFieldList); fnBtnUpdate(imgtoolbar,m_phost.DisplayToolbar); if (m_phost.ActiveView != null) { tbplshowtitle.style.display = ""; tbplshowdrop.style.display = ""; fnBtnUpdate(imgtitle,m_phost.ActiveView.Label.Visible); f1 = m_phost.ActiveView.RowAxis.Label.Visible; f2 = m_phost.ActiveView.ColumnAxis.Label.Visible; f3 = m_phost.ActiveView.FilterAxis.Label.Visible; f4 = m_phost.ActiveView.DataAxis.Label.Visible; fSet = (f1 || f2 || f3 || f4); fnBtnUpdate(imgdrop,fSet); } else { tbplshowtitle.style.display = "none"; tbplshowdrop.style.display = "none"; } } function fncapupdate() { var psel = m_Selection0; if(psel.FieldSet != null) infldsetcap.value = psel.FieldSet.Caption; infldcap.value = psel.Caption; if(m_iseltype == 2) fnsetselect(psel.CaptionHAlignment,slcapalign); else fnsetselect(psel.CaptionAlignment,slcapalign); } function fntoolbar() { var fnewstate = !(m_phost.DisplayToolbar); m_phost.DisplayToolbar = fnewstate; fnerrorchk(m_phost); fnBtnUpdate(imgtoolbar,fnewstate); } function fnhelp() { external.ShowHelp(0); } function fnplcolor() { m_phost.BackColor = tdplbox.style.backgroundColor; fnerrorchk(m_phost); } function fnplheight() { m_phost.Height = inplheight.value; inadvautofit.checked = false; fnerrorchk(m_phost); } function fnplwidth() { m_phost.Width = inplwidth.value; inadvautofit.checked = false; fnerrorchk(m_phost); } function fnpltitle() { var ptitle = m_phost.ActiveView.TitleBar; ptitle.Caption = inpltitle.value; fnerrorchk(ptitle); } function fnshowtitle() { m_phost.ActiveView.Label.Visible = !(m_phost.ActiveView.Label.Visible); fnerrorchk(m_phost); } function fnshowexpand() { m_phost.DisplayExpandIndicator = !(m_phost.DisplayExpandIndicator); fnerrorchk(m_phost); } function fnshowdrop() { f1 = m_phost.ActiveView.RowAxis.Label.Visible; f2 = m_phost.ActiveView.ColumnAxis.Label.Visible; f3 = m_phost.ActiveView.FilterAxis.Label.Visible; f4 = m_phost.ActiveView.DataAxis.Label.Visible; fSet = !(f1 || f2 || f3 || f4); m_phost.ActiveView.RowAxis.Label.Visible = fSet; m_phost.ActiveView.ColumnAxis.Label.Visible = fSet; m_phost.ActiveView.FilterAxis.Label.Visible = fSet; m_phost.ActiveView.DataAxis.Label.Visible = fSet; fnerrorchk(m_phost); } function fnshowfieldlist() { m_phost.DisplayFieldList = !(m_phost.DisplayFieldList); fnerrorchk(m_phost); } function fnsubtotalflmem() { event.cancelBubble = true; var psel = m_Selection; psel.TotalAllMembers = inflsub.checked; fnerrorchk(psel); inflsub.checked = psel.TotalAllMembers; } function fntotalorichange() { var psel = m_Selection; psel.TotalOrientation = sltotalori.value; fnerrorchk(psel); } function fndetexp() { event.cancelBubble = true; var psel = m_Selection; fnerrorchk(psel); } function fndsfrwht() { var psel = m_Selection; psel.DetailRowHeight = indsfrwht.value; fnerrorchk(psel); } function fndsfautofit() { event.cancelBubble = true; var psel = m_Selection; psel.DetailAutoFit = indsfautofit.checked; fnerrorchk(psel); indsfautofit.checked = psel.DetailAutoFit; } function fndsfwidth() { var psel= m_Selection; psel.DetailWidth = indsfwidth.value; fnerrorchk(psel); indsfautofit.checked = false; } function fndsfmaxwd() { var psel= m_Selection; psel.DetailMaxWidth = indsfmaxwd.value; fnerrorchk(psel); } function fndsfmaxht() { var psel= m_Selection; psel.DetailMaxHeight = indsfmaxht.value; fnerrorchk(psel); } function fnfont() { } function fnhidefield() { } function fnfldsetcap() { var i; var psel = m_Selection; var pselItem; for(i=0;i < psel.Count;i++) { pselItem = psel(i); pselItem.FieldSet.Caption = infldsetcap.value; fnerrorchk(pselItem); } } function fnfldcap() { var i; var psel = m_Selection; var pselItem; for(i=0;i < psel.Count;i++) { pselItem = psel(i); pselItem.Caption = infldcap.value; fnerrorchk(pselItem); } } function fnsortdir() { var i; var psel = m_Selection; var pselItem; for(i=0;i < psel.Count;i++) { pselItem = psel(i); pselItem.SortDirection = slsortdir.value; fnerrorchk(pselItem); } } function fnfunc() { var i; var psel = m_Selection; var pselItem; for(i=0;i < psel.Count;i++) { pselItem = psel(i); pselItem.Function = slfunc.value; fnerrorchk(pselItem); } } function fnemprowb() { m_phost.ActiveView.RowAxis.DisplayEmptyMembers = inemprowb.checked; } function fnempcolb() { m_phost.ActiveView.ColumnAxis.DisplayEmptyMembers = inempcolb.checked; } function fnback() { var psel = fnfontsel(); var c = psel.Count; var pfnt; if(typeof(c) == "number") { for (i = 0; i < c;i++) { pfnt = fnbgswitch(psel(i),tdbackbox.style.backgroundColor); fnerrorchk(pfnt); } } else { pfnt = fnbgswitch(psel,tdbackbox.style.backgroundColor); fnerrorchk(pfnt); } } function fnfont() { var psel = fnfontsel(); var pfnt; var c = psel.Count; if(typeof(c) == "number") { for (i = 0; i < c;i++) { pfnt = fnfontswitch(psel(i)); pfnt.Color = tdfontbox.style.backgroundColor; fnerrorchk(pfnt); } } else { pfnt = fnfontswitch(psel); pfnt.Color = tdfontbox.style.backgroundColor; fnerrorchk(pfnt); } } function fnbold() { var psel = fnfontsel(); var c = psel.Count; if(typeof(c) == "number") { var fbold = false; for (i = 0; i < c;i++) { var pfnt = fnfontswitch(psel(i)); if(!pfnt.Bold) { fbold = true; break; } } for (i = 0; i < c;i++) { var pfnt = fnfontswitch(psel(i)); pfnt.Bold = fbold; fnerrorchk(pfnt); } } else { var pfnt = fnfontswitch(psel); var fbold = !(pfnt.Bold); pfnt.Bold = !(pfnt.Bold); fnerrorchk(pfnt); } } function fnunderline() { var psel = fnfontsel(); var c = psel.Count; var fnt; if(typeof(c) == "number") { var ful = false; for (i = 0; i < c;i++) { pfnt = fnfontswitch(psel(i)); if(!pfnt.Underline) { ful = true; break; } } for (i = 0; i < c;i++) { pfnt = fnfontswitch(psel(i)); pfnt.Underline = ful; if (ful) pfnt.Underline = 1; else pfnt.Underline = 0; fnerrorchk(pfnt); } } else { pfnt = fnfontswitch(psel); if (pfnt.Underline) pfnt.Underline = 0; else pfnt.Underline = 1; fnerrorchk(pfnt); } } function fnital() { var psel = fnfontsel(); var c = psel.Count; if(typeof(c) == "number") { var fital = false; for (i = 0; i < c;i++) { var pfnt = fnfontswitch(psel(i)); if(!pfnt.Italic) { fital = true; break; } } for (i = 0; i < c;i++) { var pfnt = fnfontswitch(psel(i)); pfnt.Italic = fital; fnerrorchk(pfnt); } } else { var pfnt = fnfontswitch(psel); pfnt.Italic = !(pfnt.Italic); fnerrorchk(pfnt); } } function fnfontcng() { var psel = fnfontsel(); var c = psel.Count; if(typeof(c) == "number") { for (i = 0; i < c;i++) { var pfnt = fnfontswitch(psel(i)); pfnt.Name = slfontlist.value; fnerrorchk(pfnt); } } else { var pfnt = fnfontswitch(psel); pfnt.Name = slfontlist.value; fnerrorchk(pfnt); } } function fnfontsize() { var psel = fnfontsel(); var c = psel.Count; if(typeof(c) == "number") { for (i = 0; i < c;i++) { var pfnt = fnfontswitch(psel(i)); pfnt.Size = slfontsize.value; fnerrorchk(pfnt); } } else { var pfnt = fnfontswitch(psel); pfnt.Size = slfontsize.value; fnerrorchk(pfnt); } } function fncapalign() { var psel = m_Selection; var c = psel.Count; var pselItem; for (i = 0;i < c;i++) { pselItem = psel(i); pselItem.CaptionHAlignment = slcapalign.value; fnerrorchk(pselItem); } } function fnhalignchange() { var psel = fnalignsel(); var c = psel.Count; var pfnt; if(typeof(c) == "number") { for (i = 0; i < c;i++) { pfnt = fnhalignswitch(psel(i),slhalign.value); fnerrorchk(pfnt); } } else { pfnt = fnhalignswitch(psel,slhalign.value); fnerrorchk(pfnt); } } function fnvalignchange() { var psel = fnalignsel(); var c = psel.Count; var pfnt; if(typeof(c) == "number") { for (i = 0; i < c;i++) { pfnt = fnvalignswitch(psel(i),slvalign.value); fnerrorchk(pfnt); } } else { pfnt = fnvalignswitch(psel,slvalign.value); fnerrorchk(pfnt); } } function fnnumfmtchange() { var psel = m_Selection; var c = psel.Count; var pselItem; for (i = 0;i < c;i++) { pselItem = psel(i); pselItem.NumberFormat = slnfmt.value; fnerrorchk(pselItem); } } function fnsfmtwd() { var psel = m_Selection; var c = psel.Count var pselItem; if(m_iseltype == 1) { for(i=0;i= 0) { var ees = m_pDSC[m_iDSC].ElementExtensions; var nCountEES = ees.Count; for (var index = 0; index < nCountEES; index++) { if (ees(index).ElementID == m_phost.Parent.ID) { ees.Delete (index); break; } } } } function fnconneditor() { var strConn; cleardsc(); m_phost.LocateDataSource(); strConn = m_phost.ConnectionString; if (strConn != "" && m_strConn != strConn) { inadvconn.value = strConn; m_strConn = strConn; fnclearopts(sladvdatamember); if (m_phost.DataSource != null) { sladvdatasource.value = -1; fnsetdmopts(m_phost.DataSource); } } } function fnadvconn() { if (m_strConn == inadvconn.value) return; m_strConn = inadvconn.value; m_phost.DataSource=null; cleardsc(); if (inadvconn.value == "") m_phost.ConnectionString = ""; else m_phost.ConnectionString = inadvconn.value; var fError = fnerrorchk(m_phost); fnclearopts(sladvdatamember); if (inadvconn.value != "" && m_phost.DataSource != null) { sladvdatasource.value = -1; if (!fError) fnsetdmopts(m_phost.DataSource); } } function fnadvcommand() { if (m_strCommand == inadvcommand.value) return; m_strCommand = inadvcommand.value; m_phost.CommandText = inadvcommand.value; fnerrorchk(m_phost); sladvdatamember.value = -1; } function fnadvds() { var pDSCCur; if (sladvdatasource.value == -1) { m_phost.DataSource = "" m_phost.ConnectionString = m_strConn; inadvconn.value = m_strConn; fnsetdmopts(m_phost.DataSource); return; } else if (sladvdatasource.value == "") return; cleardsc(); pDSCCur = m_pDSC[sladvdatasource.value]; m_phost.DataSource = pDSCCur.Object; if (fnerrorchk(m_phost)) return; m_phost.ConnectionString = ""; inadvconn.value=""; m_iDSC = sladvdatasource.value; m_pDSC[sladvdatasource.value].ElementExtensions.Add (m_phost.Parent.ID); m_pDSC[sladvdatasource.value].ElementExtensions(m_phost.Parent.ID).ConsumesRecordset = true; fnerrorchk(m_phost); fnsetdmopts(m_pDSC[sladvdatasource.value]); } function fnsetdmopts(pDSCCur) { var i; var nCount; var stName; fnclearopts(sladvdatamember); if (pDSCCur == null) { return; } var strings; var data; strings = null; strings = m_phost.DataMemberStrings; if (fInDataUpdate && m_phost.LastErrorValue != 0) return; if (!fnerrorchk(m_phost) && strings != null) { data = strings.toArray(); var i; var count; for (i = 0, count = data.length ; i < count; i++) fnpivotaddopts(sladvdatamember, data[i], data[i]); } } function fnadvdm() { var pDSCCur; pDSCCur = m_pDSC[sladvdatasource.value]; if ((indatadsc.checked && pDSCCur == null) || (indatastr.checked && m_strConn == "")) return; m_strDataMember = sladvdatamember.value; m_phost.DataMember = ""; m_phost.DataMember = sladvdatamember.value; fnerrorchk(m_phost); inadvcommand.value = ""; } function fnmemadvae() { m_phost.MemberExpand = inmemadvae.value; } function fnfontsel() { switch(m_iseltype) { case 0: return m_phost.ActiveView; case 1: return m_Selection; case 2: return m_phost.ActiveView; case 3: return m_phost.ActiveView; case 4: return m_Selection0.Field; defualt: return null; } } function fnalignsel() { switch(m_iseltype) { case 0: return m_phost.ActiveView; case 1: return m_Selection; case 2: return m_Selection; case 3: return m_phost.ActiveView; defualt: return null; } } function fnfontswitch(psel) { switch(m_iseltype) { case 0: return psel.FieldLabelFont; case 1: var pfs = psel.FieldSet; if(pfs == null) return; if (psel.FieldSet.Orientation & 7) return m_phost.ActiveView.FieldLabelFont; else return psel.DetailFont; case 2: return psel.TotalFont; case 3: return psel.MemberFont; case 4: return psel.SubtotalFont; default: return null; } } function fnbgswitch(psel,clr) { switch(m_iseltype) { case 0: psel.FieldLabelBackColor = clr; return psel; case 1: if (psel.FieldSet.Orientation & 7) m_phost.ActiveView.FieldLabelBackColor = clr; else psel.DetailBackColor = clr; return psel; case 2: psel.TotalBackColor = clr; return psel; case 3: psel.MemberBackColor = clr; return psel; case 4: psel.SubtotalBackColor = clr; return psel; default: return null; } } function fnvalignswitch(psel,val) { switch(m_iseltype) { case 1: psel.DetailVAlignment = val ; break; case 2: psel.TotalVAlignment = val; break; case 3: psel.MemberVAlignment = val; break; case 4: psel.SubtotalVAlignment = val; break; default: break; } return psel; } function fnhalignswitch(psel,val) { switch(m_iseltype) { case 1: psel.DetailHAlignment = val; break; case 2: psel.HAlignment = val; break; case 3: psel.MemberHAlignment = val; break; case 4: psel.SubtotalHAlignment =val; break; default: break; } return psel; } function fnhval(psel) { var val; switch(m_iseltype) { case 1: val = psel.DetailHAlignment; break; case 2: val = psel.TotalHAlignment; break; case 3: val = psel.MemberHAlignment; break; case 4: val = psel.SubtotalHAlignment; break; default: break; } return val; } function fnvval(psel) { var val; switch(m_iseltype) { case 1: val = psel.DetailVAlignment; break; case 2: val = psel.TotalVAlignment; break; case 3: val = psel.MemberVAlignment; break; case 4: val = psel.SubtotalVAlignment; break; default: break; } return val; } function fnselectdisp(idisp) { var dispmap,i; if (window == null) return; if (window.m_ppanels == null) return; var iln = window.m_ppanels.length; for(i=0;i> i) & 1) { if(((dispmap & idisp) >> i) & 1) { window.m_ppanels[i].style.display = ""; if(window.m_ppanels[i].State) window.m_ppanels[i].Panel.style.display = ""; } else { window.m_ppanels[i].style.display = "none"; window.m_ppanels[i].Panel.style.display = "none"; } } } m_ilastdisp = idisp; } function fnGetPanels() { return m_ppanels; } function fnpopulatedatasources() { var par; par = null; if (m_phost == null) { return; } par = m_phost.Parent; if (par == null) { return; } var rgDocCol,i,iln,fHasDSC; var stDisplay, stConn; var dscCur; m_pDSC = new Array(); fnclearopts(sladvdatasource); fnclearopts(sladvdatamember); m_strConn = m_phost.ConnectionString; m_strCommand = m_phost.CommandText; m_iDSC = -1; m_strDataMember = ""; if (m_strConn != "") { indatastr.checked = true; fndatastrrb(); } else { indatadsc.checked = true; fndatasrcrb(); } if (m_phost.Parent.Document == null) { if (m_strCommand != "" && m_phost.ProviderType != 3) { indatatext.checked = true; fndatatextrb(); } else { indatamem.checked = true; fnsetdmopts(m_phost.DataSource); fndatamemrb(); } return; } dscCur = m_phost.DataSource; rgDocCol = m_phost.Parent.Document.All.tags("OBJECT"); fnerrorchk(m_phost); fHasDSC = false; iln = rgDocCol.length; for(i = 0;i < iln;i++) { if (rgDocCol[i] != null && rgDocCol[i].classid.search("0002E530-0000-0000-C000-000000000046") > 0) { m_pDSC[m_pDSC.length] = rgDocCol[i]; fHasDSC = true } } if (fHasDSC || dscCur != null) { iln = m_pDSC.length; for (i = 0; i < iln; i++) { stDisplay = m_pDSC[i].id fnpivotaddopts(sladvdatasource, stDisplay, i); if (dscCur != null && dscCur.ConnectionString == m_pDSC[i].ConnectionString) { sladvdatasource.value = i; m_iDSC = i; } } fnsetdmopts(m_phost.DataSource); } if (m_strCommand != "" && m_phost.ProviderType != 3) { indatatext.checked = true; fndatatextrb(); } else { indatamem.checked = true; fndatamemrb(); if (m_phost.ProviderType == 3) indatatext.disabled = true; else if (!indatadsc.checked) indatatext.disabled = false; } } function IsFunctionValid(enumDataType, enumFunction) { if (enumFunction == 0 || enumFunction == 5 || enumFunction == 6 || enumFunction == 7) return false; switch (enumDataType) { case 16: case 2: case 3: case 20: case 17: case 18: case 19: case 21: case 4: case 5: case 6: case 14: case 131: case 11: case 139: return true; case 7: case 133: case 134: case 135: return (enumFunction == 2 || enumFunction == 3 || enumFunction == 4); } return (enumFunction == 2); } function fnDataTypeStr(enumDataType) { switch (enumDataType) { case 0: return divDTEmpty.innerText; case 1: return divDTNull.innerText; case 2: return divDTSmallInt.innerText; case 3: return divDTInteger.innerText; case 4: return divDTSingle.innerText; case 5: return divDTDouble.innerText; case 6: return divDTCurrency.innerText; case 7: return divDTDate.innerText; case 8: return divDTBSTR.innerText; case 9: return divDTIDispatch.innerText; case 10: return divDTError.innerText; case 11: return divDTBoolean.innerText; case 12: return divDTVariant.innerText; case 13: return divDTIUnknown.innerText; case 14: return divDTDecimal.innerText; case 16: return divDTTinyInt.innerText; case 17: return divDTUnsignedTinyInt.innerText; case 18: return divDTUnsignedSmallInt.innerText; case 19: return divDTUnsignedInt.innerText; case 20: return divDTBigInt.innerText; case 21: return divDTUnsignedBigInt.innerText; case 64: return divDTFileTime.innerText; case 72: return divDTGUID.innerText; case 128: return divDTBinary.innerText; case 129: return divDTChar.innerText; case 130: return divDTWChar.innerText; case 131: return divDTNumeric.innerText; case 132: return divDTUserDefined.innerText; case 133: return divDTDBDate.innerText; case 134: return divDTDBTime.innerText; case 135: return divDTDBTimeStamp.innerText; case 136: return divDTChapter.innerText; case 137: return divDTDBFileTime.innerText; case 138: return divDTPropVariant.innerText; case 139: return divDTVarNumeric.innerText; case 200: return divDTVarChar.innerText; case 201: return divDTLongVarChar.innerText; case 202: return divDTVarWChar.innerText; case 203: return divDTLongVarWChar.innerText; case 204: return divDTVarBinary.innerText; case 205: return divDTLongVarBinary.innerText; default: return ""; } } function fnFieldTypeStr(enumDataType) { switch (enumDataType) { case 1: return divDTTypeRegular.innerText; case 2: return divDTTypeCalculated.innerText; case 3: return divDTTypeTime.innerText; case 4: return divDTTypeTimeYears.innerText; case 5: return divDTTypeTimeHalfYears.innerText; case 6: return divDTTypeTimeQuarters.innerText; case 7: return divDTTypeTimeMonths.innerText; case 8: return divDTTypeTimeWeeks.innerText; case 9: return divDTTypeTimeDays.innerText; case 10: return divDTTypeTimeHours.innerText; case 11: return divDTTypeTimeMinutes.innerText; case 12: return divDTTypeTimeSeconds.innerText; case 13: return divDTTypeTimeUndefined.innerText; case 14: return divDTTypeUnknown.innerText; case 15: return divDTTypeUserDefined.innerText; default: return ""; } } function fnFieldSetTypeStr(enumDataType) { switch (enumDataType) { case 3: return divDTFieldSetTypeUnknown.innerText; case 1: return divDTFieldSetTypeTime.innerText; case 4: return divDTFieldSetTypeUserDefined.innerText; case 2: return divDTFieldSetTypeOther.innerText; default: return ""; } } function fnFieldSetOrientation(enumDataType) { switch (enumDataType) { case 0: return divDTOrientationNone.innerText; case 1: return divDTOrientationColumnAxis.innerText; case 2: return divDTOrientationRowAxis.innerText; case 4: return divDTOrientationFilterAxis.innerText; case 8: return divDTOrientationDataAxis.innerText; default: return ""; } }
Click to set borders
 General
Help
 Format
 Show/Hide
 Calculations
 Find
 Import Data
URL:
Refresh from URL at run time
 Protection
 Title Bar
 Advanced
The data cannot be found. If you are sure the data exists in the current sheet, check what you typed and try again.
The Internet address you specified is incomplete. You must include the full URL or path (including http: respectively).
The selection contains multiple values. Merging the selection into one cell will keep the value in the upper-left cell only.
The range you are trying to modify is locked and therefore read-only.
Default
No Fill
This Property Toolbox section cannot be expanded on your 640x480 screen. To use this section of the toolbox, use a higher resolution display, such as 800x600.
var m_pHost; var m_ffindset = false; var m_ppanels; var m_icount; var m_fOrigUserMode; var m_psel; var m_pfindrng; var m_ffindcausedselchange = false; var m_finited = false; var HACK=false; function init() { m_icount = 0; m_ppanels = new Array(); m_phost = external.Host; m_psel = m_phost.Selection; m_fOrigUserMode = external.UserMode; initStdPair(mtbanal,mtbanalbar,fnanalupdate,m_ppanels,fnnone); initStdPair(mtbfmt,mdivfmtbar,fnfmtupdate,m_ppanels,fnnone); initStdPair(mtbdisp,mdivdispbar,fndispupdate,m_ppanels,fndispinit); initStdPair(mtbcalc,mtbcalcbar,fncalcupdate,m_ppanels,fncalcinit); initStdPair(mtbfind,mtbfindbar,fnnone,m_ppanels,fnfindinit); initStdPair(mtbimport,mtbimportbar,fnimportupdate,m_ppanels,fnnone); initStdPair(mtbprot,mtbprotbar,fnprotupdate,m_ppanels,fnprotinit); initStdPair(mtbadv,mtbadvbar,fnadvupdate,m_ppanels,fnadvinit); initStdPair(mtbtitle,mdivtitlebar,fntitleupdate,m_ppanels,fntitleinit); initStdBtn(imgundo,0); initStdBtn(imghelp,0); fnfmtinit(); obpicker.This = obpicker; obborders.This = obborders; obborders.Picker = obpicker; if(document.dir == "rtl") fninitrtl(); mtbfmt.click(); fninitsize(m_ppanels); document.body.onclick = fnclean; m_finited = true; SelectionChanged(); } function SelectionChanged() { if(!m_finited) return; if(external != null) { m_phost = external.Host; if(external.HostType != 1 || (external.UserMode != m_fOrigUserMode)) { window.location.href= "../core/pbmain.htm"; return; } if( m_phost != null) { m_psel = m_phost.Selection; if(m_psel == null) return; if(m_ffindcausedselchange == false) { m_pfindrng = null; } m_ffindcausedselchange = false; fnclean(); fnbgcheck(); fnUpdate(m_ppanels); } } else { m_phost = null; m_psel = null; CollectGarbage(); } } function fninitrtl() { var iln = m_ppanels.length; for(var i=0;i < iln; i++) { var tarr = document.all(m_ppanels[i].id + "arr"); tarr.parentElement.align = "left"; } tdfontpick.align = "right"; tdfontsize.align = "right"; tdtifontpick.align = "right"; tdtifontsize.align = "right"; } function fnwcopencp(pbtn,pctl,pbox,pfn,fProt,szb1,ibv1,szb2,ibv2) { var psel = m_phost.Selection; if(!fProt || psel.Locked == false || m_phost.ActiveSheet.Protection.Enabled == false) opencp(pbtn,pctl,pbox,pfn,szb1,ibv1,szb2,ibv2); else { external.IgnoreFocus(); alert(divnoopen.innerText); } event.cancelBubble = true; } function fnGetPanels() { return m_ppanels; } function LostFocus() { if(HACK) return; if(external != null && external.Host != null) { fnclean(); var pae = document.activeElement; if(pae != null) { var pfn = pae.Function; if(pfn != null) pfn(); } } } function fnclean() { obpicker.Close(); obborders.Close(); } function fnfmtinit() { fnclearopts(slFontList); fnFontInit(slFontList,m_phost); slFontList.onchange=new Function("fncmdroute(fnFontNameChange)"); slFontSize.onchange=new Function("fncmdroute(fnFontSizeChange)"); initStdBtn(imgbold,1,new Function("fncmdroute(fnbold)")); initStdBtn(imgunderline,1,new Function("fncmdroute(fnunderline)")); imgunderline.src="../core/images/underline.GIF"; initStdBtn(imgitalic,1,new Function("fncmdroute(fnitalic)")); imgitalic.src="../core/images/italic.GIF" ; initStdBtn(imgmergecells,0); imgmergecells.src="../core/images/mergecells.GIF"; imgmergecells.onclick=new Function("fncmdroute(fnmerge,1)"); initStdBtn(imgunmerge,0); imgunmerge.src="../core/images/unmerge.GIF"; imgunmerge.onclick=new Function("fncmdroute(fnunmerge,1)"); initStdBtn(imgbord,0); imgbord.src="../core/images/allborder.GIF"; imgbord.onclick=fnbord; imgfontcolor.src="../core/images/fontcolor.gif"; mtbfontcolor.onmouseover=new Function("splitover(mtbfontcolor,tdfo1,tdfo2)"); mtbfontcolor.onmouseout=new Function("splitout(mtbfontcolor,tdfo1,tdfo2)"); mtbfontcolor.onclick=new Function("fncmdroute(fnfont)"); tdfo2.onclick=new Function("fnwcopencp(mtbfontcolor,obpicker,tdfontbox,new Function('fncmdroute(fnfont)'),1,divdef.innerText)"); imgfillcolor.src="../core/images/fillcolor.gif"; mtbfillcolor.onmouseover=new Function("splitover(mtbfillcolor,tdfi1,tdfi2)"); mtbfillcolor.onmouseout=new Function("splitout(mtbfillcolor,tdfi1,tdfi2)"); mtbfillcolor.onclick=new Function("fncmdroute(fnfill)"); tdfi1.onclick=new Function("fnwcopencp(mtbfillcolor,obpicker,tdfillbox,new Function('fncmdroute(fnfill)'),1,divnofil.innerText)"); initStdEdit2(incw,fncw,true); initStdEdit2(inrh, fnrh,true); slhalign.onchange=new Function("fncmdroute(fnhalignchange)"); slvalign.onchange=new Function("fncmdroute(fnvalignchange)"); slnfmt.onchange=new Function("fncmdroute(fnnumfmtchange)"); } function fndispinit() { initStdBtn(imgtoolbar,1,new Function("fncmdroute(fntoolbar)")); imgtoolbar.src="../core/images/Toolbar.GIF"; initStdBtn(imgtitlebar,1,new Function("fncmdroute(fntb)")); imgtitlebar.src="../core/images/ShowTitlebar.GIF"; initStdBtn(imggrid,1,new Function("fncmdroute(fngridlines)")); imggrid.src="../core/images/ShowGridlines.GIF"; initStdBtn(imgcolhead,1,new Function("fncmdroute(fncolhead)")); imgcolhead.src="../core/images/ShowColheaders.GIF"; initStdBtn(imgrowhead,1,new Function("fncmdroute(fnrowhead)")); imgrowhead.src="../core/images/ShowRowHeaders.GIF"; } function fnfindinit() { infind.Function = fnfindcng; infind.onchange=fnfindcng; infind.onkeypress=fnfindkey; infind.onselectstart=new Function("window.event.cancelBubble = true;"); infindbtn.onclick=fnfind; } function fncalcinit() { inautocalc.onclick=new Function("fncmdroute(fnautocalc,false,true)"); inmancalc.onclick=new Function("fncmdroute(fnmancalc,false,true)"); btncalcnow.onclick=new Function("fncmdroute(fncalcnow,true,true)"); spmclabel.onclick = inmancalc.click; spaclabel.onclick = inautocalc.click; } function fntitleinit() { mtbtitlefontcolor.onmouseover=new Function("splitover(mtbtitlefontcolor,tdtitlefo1,tdtitlefo2)"); mtbtitlefontcolor.onmouseout=new Function("splitout(mtbtitlefontcolor,tdtitlefo1,tdtitlefo2)"); mtbtitlefontcolor.onclick=new Function("fncmdroute(fntitlefont) "); tdtitlefo1.onclick=new Function("fnwcopencp(mtbtitlefontcolor,obpicker,tdtitlefontbox,new Function('fncmdroute(fntitlefont)'),0,divdef.innerText)"); mtbtitlebackcolor.onclick=new Function("fncmdroute(fntitleback)"); tdtitlebko2.onclick=new Function("fnwcopencp(mtbtitlebackcolor,obpicker,tdtitlebackbox,new Function('fncmdroute(fntitleback)'),0,divdef.innerText)"); fnclearopts(sltitlefontlist); fnFontInit(sltitlefontlist,m_phost); initStdEdit2(intitle,fntitle,true); initStdBtn(imgtitlebold,1); initStdBtn(imgtitleunderline,1); initStdBtn(imgtitleitalic,1); } function fnprotinit() { } function fnadvinit() { initStdEdit2(inmaxh,fnmaxh,true); initStdEdit2(inmaxw,fnmaxw,true); initStdEdit2(inviewrng,fnviewrange,true); } function fnanalupdate() { } function fnfmtupdate() { var psel = m_psel; if(psel == null) return; var pcell = m_phost.ActiveCell; if(pcell == null) return; var pacfnt = pcell.Font; if(pacfnt == null) return; var pfnt = psel.Font; if(pfnt == null) return; fnBtnUpdate(imgbold,pacfnt.Bold); fnBtnUpdate(imgitalic,pacfnt.Italic); fnBtnUpdate(imgunderline,(pacfnt.Underline == 1)); fnsetselect(pfnt.Name,slFontList); fnsetselect(pfnt.Size,slFontSize); fnsetselect(psel.HAlignment,slhalign); fnsetselect(psel.VAlignment,slvalign); if(psel.columnWidth != null) incw.value = external.DecodeNumber(psel.columnWidth); else incw.value = ""; if(psel.rowHeight != null) inrh.value = external.DecodeNumber(psel.rowHeight); else inrh.value = ""; slnfmt.selectedIndex = 0; fnsetselect(psel.NumberFormat,slnfmt); } function fndispupdate() { fnBtnUpdate(imgtoolbar,m_phost.DisplayToolbar); fnBtnUpdate(imggrid,m_phost.DisplayGridlines); fnBtnUpdate(imgcolhead,m_phost.DisplayColHeaders); fnBtnUpdate(imgrowhead,m_phost.DisplayRowHeaders); fnBtnUpdate(imgtitlebar,m_phost.DisplayTitlebar); } function fncalcupdate() { var pac = m_phost.ActiveCell; if(pac == null) return; if(pac.Value != null) tdfmlaval.value = pac.Text; else tdfmlaval.value = ""; if(m_phost.ActiveSheet.EnableAutoCalculate) inautocalc.checked = true; else inmancalc.checked = true; if(pac.Formula != null) infmla.value = pac.FormulaLocal; else infmla.value = ""; tdactcell.innerHTML = pac.Address; if(external.ResolveColor("buttonface") == 0xFFFFFF) { tdfmlaval.style.color = "menutext"; } else { tdfmlaval.style.color = "highlighttext"; } } function fnadvupdate() { fnsetselect(m_phost.RightToLeft,sldisprtl); fnsetselect(m_phost.EnableEvents,slevents); fnsetselect(0,slfreezepanes); fnsetselect(m_phost.DisplayHorizontalScrollBar,slhorscroll); fnsetselect(m_phost.DisplayVerticalScrollBar,slvscroll); fnsetselect(m_phost.AutoFit,slafsheet); fnsetselect(m_phost.MoveAfterReturn,slmoveret); fnsetselect(m_phost.MoveAfterReturnDirection,slmovedir); inviewrng.value = m_phost.ViewableRange; inmaxh.value = m_phost.MaxHeight; inmaxw.value = m_phost.MaxWidth; } function fnprotupdate() { var pas = m_phost.ActiveSheet if(pas == null) return; var pprt= pas.Protection; if(pprt == null) return; var psel = m_psel; inenableprot.checked = pprt.Enabled; inallowprop.checked = m_phost.AllowPropertyToolbox; inallowsort.checked = pprt.AllowSorting; inallowfilter.checked = pprt.AllowFiltering; if(psel.Locked == null) inlockcel.indeterminate = true; else { inlockcel.indeterminate = false; inlockcel.checked = psel.Locked; } } function fnimportupdate() { if(m_phost.DataType == "HTMLURL") inrefresh.checked = true; else inrefresh.checked = false; if(m_phost.HTMLURL == "" || m_phost.HTMLURL == null) { inrefresh.disabled = true; } else { ininput.value = m_phost.HTMLURL; inrefresh.disabled = false; } } function fntitleupdate() { var pfnt = m_phost.TitleBar.Font; if(pfnt != null) { fnBtnUpdate(imgtitlebold,pfnt.Bold); fnBtnUpdate(imgtitleitalic,pfnt.Italic); fnBtnUpdate(imgtitleunderline,pfnt.Underline); fnsetselect(pfnt.Name,sltitlefontlist); fnsetselect(pfnt.Size,sltitlefontsize); intitle.value = m_phost.TitleBar.Caption; } } function fnbold() { var pfnt = m_psel.Font; var pcell = m_phost.ActiveCell.Font; var fstate = pcell.Bold; if (fstate == true || fstate == null) pfnt.Bold = false; else pfnt.Bold = true; fnBtnUpdate(imgbold,pcell.Bold); return pfnt; } function fnitalic() { var pfnt = m_psel.Font; var pcell = m_phost.ActiveCell.Font; var fstate = pcell.Italic; if (fstate == true || fstate == null) pfnt.Italic = false; else pfnt.Italic = true; fnBtnUpdate(imgitalic,pcell.Italic); return pfnt; } function fnunderline() { var pfnt = m_psel.Font; var pcell = m_phost.ActiveCell.Font; if (pcell.Underline == 1) pfnt.Underline = 0; else pfnt.Underline = 1; fnBtnUpdate(imgunderline,(pcell.Underline == 1)); return pfnt; } function fnfont() { var pfnt=m_psel.Font; if (tdfontbox.style.backgroundColor != "") pfnt.Color =tdfontbox.style.backgroundColor; else pfnt.Color = -1; return pfnt; } function fnfill() { var pint=m_psel.Interior; if (tdfillbox.style.backgroundColor != "") pint.Color =tdfillbox.style.backgroundColor; else pint.Color = -1; return pint; } function fnbord() { var psel = m_psel; if(psel.Locked == false || m_phost.ActiveSheet.Protection.Enabled == false) { obborders.Range = m_psel; obborders.Display(); obborders.DefaultSz = divdef.innerHTML; if(document.dir !="rtl") position(imgbord,obborders,-74,0,2,-1); else position(imgbord,obborders,0,0,2,-1); event.cancelBubble = true; obpicker.Close(); } else { external.IgnoreFocus(); alert(divnoopen.innerText); } } function fnFontNameChange() { var pfnt = m_psel.Font; pfnt.Name = slFontList.value; return pfnt; fnsetselect(pfnt.Font.Name,slFontList); } function fnFontSizeChange() { var pfnt = m_psel.Font; pfnt.Size = slFontSize.value; return pfnt; fnsetselect(pfnt.Font.Size,slFontSize); } function fnmerge() { var psel = m_psel; var szfmla; szfmla = "=counta("+psel.Address+")"; var icount = (m_phost.ActiveSheet.Eval(szfmla)); if((psel.Locked != false && m_phost.ActiveSheet.Protection.Enabled == true) || (m_phost.ActiveSheet.AutoFilter && (m_phost.Intersect(psel.Object,m_phost.ActiveSheet.AutoFilter.Range.Object)) != null)) psel.Merge(); else if ((icount > 1 || (icount > 0 && psel.Cells(1).Value == null))) { external.IgnoreFocus(); if(confirm(divmerge.innerText)) psel.Merge(); } else psel.Merge(); return psel; } function fnunmerge() { var psel = m_psel; psel.UnMerge(); return psel; } function fnvalignchange() { var psel = m_psel; psel.VAlignment = slvalign.value; var pcell = m_phost.ActiveCell; fnsetselect(pcell.VAlignment,slvalign); return psel; } function fnhalignchange() { var psel = m_psel; psel.HAlignment = slhalign.value; var pcell = m_phost.ActiveCell; fnsetselect(pcell.HAlignment,slhalign); return psel; } function fnnumfmtchange() { var psel = m_psel; var eo; if(slnfmt.value != "") { psel.NumberFormat = slnfmt.value; eo = fncopyerrorobj(psel); } fnsetselect(psel.NumberFormat,slnfmt); return eo; } function fnrh() { var psel = m_psel; psel.RowHeight = inrh.value; return psel; } function fncw() { var psel = m_psel; psel.ColumnWidth = incw.value; return psel; } function fnhelp() { external.ShowHelp(0); return false; } function fnundo() { if(m_phost.CanUndo) m_phost.Undo(); fnerrorchk(m_phost); external.GiveFocus(); fnUpdate(m_ppanels); } function fntoolbar() { m_phost.DisplayToolbar = !(m_phost.DisplayToolbar); return m_phost; } function fntb() { var f = !(m_phost.DisplayTitleBar); m_phost.DisplayTitleBar = f; fnBtnUpdate(imgtitlebar,f); return m_phost; } function fncolhead() { var f = !(m_phost.DisplayColHeaders); m_phost.DisplayColHeaders = f; fnBtnUpdate(imgcolhead,f); return m_phost; } function fnrowhead() { var f = !(m_phost.DisplayRowHeaders); m_phost.DisplayRowHeaders = f; fnBtnUpdate(imgrowhead,f); return m_phost; } function fngridlines() { var f = !(m_phost.DisplayGridlines); m_phost.DisplayGridlines = f; fnBtnUpdate(imggrid,f); return m_phost; } function fnfind() { var cpass=0; var prngCurCell = m_phost.ActiveCell.Object; var prngFound = null; var pHidden; if(!m_pfindrng) { if(m_psel.Cells.Count == 1 || (m_psel.HasMergeCells && m_psel.Address == m_psel.MergeArea.Address)) m_pfindrng = m_phost.ActiveSheet.Range(m_phost.ViewableRange).Object; else m_pfindrng = m_phost.Selection.Object; } while(prngFound == null && cpass < 2) { prngCurCell = m_pfindrng.Find(infind.value,prngCurCell); if(prngCurCell == null) cpass++; else { if((prngCurCell.ColumnWidth > 0) && (prngCurCell.RowHeight > 0)) prngFound = prngCurCell; else { if(pHidden == null) pHidden = prngFound; else if(pHidden.Address == prngCurCell.Address) break; } } } if(prngFound) { m_ffindcausedselchange = true; prngFound.Select(); } else { external.IgnoreFocus(); alert(divnotfound.innerText); } } function fnfindcng() { } function fnfindkey() { if(event.keyCode == 13) { infind.blur(); fnfind(); infind.focus(); } } function fntitle() { ptitle = m_phost.TitleBar; ptitle.Caption = intitle.value; return ptitle; } function fntitlebold() { var psel = m_phost.TitleBar.Font; psel.Bold = (!psel.Bold); fnBtnUpdate(imgtitlebold,psel.Bold); return psel; } function fntitleunderline() { var pcell = m_phost.TitleBar.Font; if (pcell.Underline == 1) pcell.Underline = 0; else pcell.Underline = 1; fnBtnUpdate(imgtitleunderline,pcell.Underline); return pcell; } function fntitleitalic() { var psel = m_phost.TitleBar.Font; psel.Italic = (!psel.Italic); fnBtnUpdate(imgtitleitalic,psel.Italic); return psel; } function fntitlefont() { var psel = m_phost.TitleBar.Font; psel.Color = tdtitlefontbox.style.backgroundColor; return psel; } function fntitlefontcng() { var psel = m_phost.TitleBar.Font; psel.Name = sltitlefontlist.value; return psel; } function fntitlefontsize() { var psel = m_phost.TitleBar.Font; psel.Size = sltitlefontsize.value; return psel; } function fntitleback() { var psel = m_phost.TitleBar.Interior; psel.Color = tdtitlebackbox.style.backgroundColor; return psel; } function fnenableprot() { var psel = m_phost.ActiveSheet.Protection; psel.Enabled = inenableprot.checked; return psel; } function fnloccel() { if(inlockcel.indeterminate == true) inlockcel.checked = m_psel.Locked = true; else { m_psel.Locked = inlockcel.checked; inlockcel.indeterminate = false; } return m_psel; } function fnallowbrow() { m_phost.AllowPropertyToolbox = inallowprop.checked; return m_phost; } function fnallowsort() { var psel = m_phost.ActiveSheet.Protection; psel.AllowSorting = inallowsort.checked; return psel; } function fnallowfilter() { var psel = m_phost.ActiveSheet.Protection; psel.AllowFiltering = inallowfilter.checked; return psel; } function fnafsheet() { m_phost.AutoFit = slafsheet.value; return m_phost; fnsetselect(m_phost.AutoFit,slafsheet); fnUpdate(m_ppanels); } function fneventcng() { m_phost.EnableEvents = slevents.value; return m_phost; fnsetselect(m_phost.EnableEvents,slevents); } function fnfreezepanescng() { var psel = m_psel; psel.FreezePanes(slfreezepanes.value); return psel; fnsetselect(0,slfreezepanes); } function fnhscrollcng() { m_phost.DisplayHorizontalScrollBar = slhorscroll.value; return m_phost; fnsetselect(m_phost.DisplayHorizontalScrollBar,slhorscroll); } function fnmoveretcng() { m_phost.MoveAfterReturn = slmoveret.value; return m_phost; fnsetselect(m_phost.MoveAfterReturn,slmoveret); } function fnmovedircng() { m_phost.MoveAfterReturnDirection = slmovedir.value; return m_phost; fnsetselect(m_phost.MoveAfterReturnDirection,slmovedir); } function fnvscrollcng() { m_phost.DisplayVerticalScrollBar = slvscroll.value; return m_phost; fnsetselect(m_phost.DisplayVerticalScrollBar,slvscroll); } function fnmaxw() { m_phost.MaxWidth = inmaxw.value; return m_phost; } function fnmaxh() { m_phost.MaxHeight = inmaxh.value; return m_phost; } function fnviewrange() { m_phost.ViewableRange = inviewrng.value; return m_phost; } function fnrtlcng() { m_phost.RightToLeft = sldisprtl.value; return m_phost; fnsetselect(m_phost.RightToLeft,sldisprtl); } function fnrefresh() { if(inrefresh.checked) m_phost.DataType = "HTMLURL"; else m_phost.DataType = "HTMLData"; fnerrorchk(m_phost); } function fnimport() { var retval = m_phost; if(ininput.value.search("^[hH][Tt][Tt][Pp]") || ininput.value.search("^[fF][iI][lL][eE]")) { m_phost.HTMLURL = ininput.value; retval=fncopyerrorobj(m_phost); if(m_phost.HTMLURL) inrefresh.disabled = false; else inrefresh.disabled = true; m_phost.DataType = "HTMLURL"; if(!inrefresh.checked) m_phost.DataType = "HTMLData"; } else { external.IgnoreFocus(); alert(divbadurl.innerText); } return retval; } function fncalcnow() { if(inmancalc.checked == true) { m_phost.ActiveSheet.EnableAutoCalculate = true; m_phost.ActiveSheet.EnableAutoCalculate = false; } else { m_phost.ActiveSheet.EnableAutoCalculate = false; m_phost.ActiveSheet.EnableAutoCalculate = true; } return m_phost; } function fnmancalc() { var psel = m_phost.ActiveSheet; psel.EnableAutoCalculate = false; return psel; } function fnautocalc() { var psel = m_phost.ActiveSheet; psel.EnableAutoCalculate = true; return psel; }
 General
Help
 Format
 Show/Hide
 Calculations
 Find
The data cannot be found. If you are sure the data exists in the current sheet, check what you typed and try again.
The Internet address you specified is incomplete. You must include the full URL or path (including http: respectively).
The selection contains multiple values. Merging the selection into one cell will keep the value in the upper-left cell only.
The range you are trying to modify is locked and therefore read-only.
Default
No Fill
This Property Toolbox section cannot be expanded on your 640x480 screen. To use this section of the toolbox, use a higher resolution display, such as 800x600.
var m_pHost; var m_ffindset = false; var m_ppanels; var m_icount; var m_fOrigUserMode; var m_psel; var m_pfindrng; var m_ffindcausedselchange = false; var m_finited = false; var HACK=false; function init() { m_icount = 0; m_ppanels = new Array(); m_phost = external.Host; m_psel = m_phost.Selection; m_fOrigUserMode = external.UserMode; initStdPair(mtbanal,mtbanalbar,fnanalupdate,m_ppanels,fnnone); initStdPair(mtbfmt,mdivfmtbar,fnfmtupdate,m_ppanels,fnnone); initStdPair(mtbdisp,mdivdispbar,fndispupdate,m_ppanels,fndispinit); initStdPair(mtbcalc,mtbcalcbar,fncalcupdate,m_ppanels,fncalcinit); initStdPair(mtbfind,mtbfindbar,fnnone,m_ppanels,fnfindinit); initStdBtn(imgundo,0); initStdBtn(imghelp,0); fnfmtinit(); obpicker.This = obpicker; obborders.This = obborders; obborders.Picker = obpicker; if(document.dir == "rtl") fninitrtl(); mtbfmt.click(); fninitsize(m_ppanels); document.body.onclick = fnclean; m_finited = true; SelectionChanged(); } function SelectionChanged() { if(!m_finited) return; if(external != null) { m_phost = external.Host; if(external.HostType != 1 || (external.UserMode != m_fOrigUserMode)) { window.location.href= "../core/pbmain.htm"; return; } if( m_phost != null) { m_psel = m_phost.Selection; if(m_psel == null) return; if(m_ffindcausedselchange == false) { m_pfindrng = null; } m_ffindcausedselchange = false; fnclean(); fnbgcheck(); fnUpdate(m_ppanels); } } else { m_phost = null; m_psel = null; CollectGarbage(); } } function fninitrtl() { var iln = m_ppanels.length; for(var i=0;i < iln; i++) { var tarr = document.all(m_ppanels[i].id + "arr"); tarr.parentElement.align = "left"; } tdfontpick.align = "right"; tdfontsize.align = "right"; } function fnwcopencp(pbtn,pctl,pbox,pfn,fProt,szb1,ibv1,szb2,ibv2) { var psel = m_phost.Selection; if(!fProt || psel.Locked == false || m_phost.ActiveSheet.Protection.Enabled == false) opencp(pbtn,pctl,pbox,pfn,szb1,ibv1,szb2,ibv2); else { external.IgnoreFocus(); alert(divnoopen.innerText); } event.cancelBubble = true; } function fnGetPanels() { return m_ppanels; } function LostFocus() { if(HACK) return; if(external != null && external.Host != null) { fnclean(); var pae = document.activeElement; if(pae != null) { var pfn = pae.Function; if(pfn != null) pfn(); } } } function fnclean() { obpicker.Close(); obborders.Close(); } function fnfmtinit() { fnclearopts(slFontList); fnFontInit(slFontList,m_phost); slFontList.onchange=new Function("fncmdroute(fnFontNameChange)"); slFontSize.onchange=new Function("fncmdroute(fnFontSizeChange)"); initStdBtn(imgbold,1,new Function("fncmdroute(fnbold)")); initStdBtn(imgunderline,1,new Function("fncmdroute(fnunderline)")); imgunderline.src="../core/images/underline.GIF"; initStdBtn(imgitalic,1,new Function("fncmdroute(fnitalic)")); imgitalic.src="../core/images/italic.GIF" ; initStdBtn(imgmergecells,0); imgmergecells.src="../core/images/mergecells.GIF"; imgmergecells.onclick=new Function("fncmdroute(fnmerge,1)"); initStdBtn(imgunmerge,0); imgunmerge.src="../core/images/unmerge.GIF"; imgunmerge.onclick=new Function("fncmdroute(fnunmerge,1)"); initStdBtn(imgbord,0); imgbord.src="../core/images/allborder.GIF"; imgbord.onclick=fnbord; imgfontcolor.src="../core/images/fontcolor.gif"; mtbfontcolor.onmouseover=new Function("splitover(mtbfontcolor,tdfo1,tdfo2)"); mtbfontcolor.onmouseout=new Function("splitout(mtbfontcolor,tdfo1,tdfo2)"); mtbfontcolor.onclick=new Function("fncmdroute(fnfont)"); tdfo2.onclick=new Function("fnwcopencp(mtbfontcolor,obpicker,tdfontbox,new Function('fncmdroute(fnfont)'),1,divdef.innerText)"); imgfillcolor.src="../core/images/fillcolor.gif"; mtbfillcolor.onmouseover=new Function("splitover(mtbfillcolor,tdfi1,tdfi2)"); mtbfillcolor.onmouseout=new Function("splitout(mtbfillcolor,tdfi1,tdfi2)"); mtbfillcolor.onclick=new Function("fncmdroute(fnfill)"); tdfi1.onclick=new Function("fnwcopencp(mtbfillcolor,obpicker,tdfillbox,new Function('fncmdroute(fnfill)'),1,divnofil.innerText)"); initStdEdit2(incw,fncw,true); initStdEdit2(inrh, fnrh,true); slhalign.onchange=new Function("fncmdroute(fnhalignchange)"); slvalign.onchange=new Function("fncmdroute(fnvalignchange)"); slnfmt.onchange=new Function("fncmdroute(fnnumfmtchange)"); } function fndispinit() { initStdBtn(imgtoolbar,1,new Function("fncmdroute(fntoolbar)")); imgtoolbar.src="../core/images/Toolbar.GIF"; initStdBtn(imgtitlebar,1,new Function("fncmdroute(fntb)")); imgtitlebar.src="../core/images/ShowTitlebar.GIF"; initStdBtn(imggrid,1,new Function("fncmdroute(fngridlines)")); imggrid.src="../core/images/ShowGridlines.GIF"; initStdBtn(imgcolhead,1,new Function("fncmdroute(fncolhead)")); imgcolhead.src="../core/images/ShowColheaders.GIF"; initStdBtn(imgrowhead,1,new Function("fncmdroute(fnrowhead)")); imgrowhead.src="../core/images/ShowRowHeaders.GIF"; } function fnfindinit() { infind.Function = fnfindcng; infind.onchange=fnfindcng; infind.onkeypress=fnfindkey; infind.onselectstart=new Function("window.event.cancelBubble = true;"); infindbtn.onclick=fnfind; } function fncalcinit() { inautocalc.onclick=new Function("fncmdroute(fnautocalc,false,true)"); inmancalc.onclick=new Function("fncmdroute(fnmancalc,false,true)"); btncalcnow.onclick=new Function("fncmdroute(fncalcnow,true,true)"); spmclabel.onclick = inmancalc.click; spaclabel.onclick = inautocalc.click; } function fnanalupdate() { } function fnfmtupdate() { var psel = m_psel; if(psel == null) return; var pcell = m_phost.ActiveCell; if(pcell == null) return; var pacfnt = pcell.Font; if(pacfnt == null) return; var pfnt = psel.Font; if(pfnt == null) return; fnBtnUpdate(imgbold,pacfnt.Bold); fnBtnUpdate(imgitalic,pacfnt.Italic); fnBtnUpdate(imgunderline,(pacfnt.Underline == 1)); fnsetselect(pfnt.Name,slFontList); fnsetselect(pfnt.Size,slFontSize); fnsetselect(psel.HAlignment,slhalign); fnsetselect(psel.VAlignment,slvalign); if(psel.columnWidth != null) incw.value = external.DecodeNumber(psel.columnWidth); else incw.value = ""; if(psel.rowHeight != null) inrh.value = external.DecodeNumber(psel.rowHeight); else inrh.value = ""; slnfmt.selectedIndex = 0; fnsetselect(psel.NumberFormat,slnfmt); } function fndispupdate() { fnBtnUpdate(imgtoolbar,m_phost.DisplayToolbar); fnBtnUpdate(imggrid,m_phost.DisplayGridlines); fnBtnUpdate(imgcolhead,m_phost.DisplayColHeaders); fnBtnUpdate(imgrowhead,m_phost.DisplayRowHeaders); fnBtnUpdate(imgtitlebar,m_phost.DisplayTitlebar); } function fncalcupdate() { var pac = m_phost.ActiveCell; if(pac == null) return; if(pac.Value != null) tdfmlaval.value = pac.Text; else tdfmlaval.value = ""; if(m_phost.ActiveSheet.EnableAutoCalculate) inautocalc.checked = true; else inmancalc.checked = true; if(pac.Formula != null) infmla.value = pac.FormulaLocal; else infmla.value = ""; tdactcell.innerHTML = pac.Address; if(external.ResolveColor("buttonface") == 0xFFFFFF) { tdfmlaval.style.color = "menutext"; } else { tdfmlaval.style.color = "highlighttext"; } } function fnbold() { var pfnt = m_psel.Font; var pcell = m_phost.ActiveCell.Font; var fstate = pcell.Bold; if (fstate == true || fstate == null) pfnt.Bold = false; else pfnt.Bold = true; fnBtnUpdate(imgbold,pcell.Bold); return pfnt; } function fnitalic() { var pfnt = m_psel.Font; var pcell = m_phost.ActiveCell.Font; var fstate = pcell.Italic; if (fstate == true || fstate == null) pfnt.Italic = false; else pfnt.Italic = true; fnBtnUpdate(imgitalic,pcell.Italic); return pfnt; } function fnunderline() { var pfnt = m_psel.Font; var pcell = m_phost.ActiveCell.Font; if (pcell.Underline == 1) pfnt.Underline = 0; else pfnt.Underline = 1; fnBtnUpdate(imgunderline,(pcell.Underline == 1)); return pfnt; } function fnfont() { var pfnt=m_psel.Font; if (tdfontbox.style.backgroundColor != "") pfnt.Color =tdfontbox.style.backgroundColor; else pfnt.Color = -1; return pfnt; } function fnfill() { var pint=m_psel.Interior; if (tdfillbox.style.backgroundColor != "") pint.Color =tdfillbox.style.backgroundColor; else pint.Color = -1; return pint; } function fnbord() { var psel = m_psel; if(psel.Locked == false || m_phost.ActiveSheet.Protection.Enabled == false) { obborders.Range = m_psel; obborders.Display(); obborders.DefaultSz = divdef.innerHTML; if(document.dir !="rtl") position(imgbord,obborders,-74,0,2,-1); else position(imgbord,obborders,0,0,2,-1); event.cancelBubble = true; obpicker.Close(); } else { external.IgnoreFocus(); alert(divnoopen.innerText); } } function fnFontNameChange() { var pfnt = m_psel.Font; pfnt.Name = slFontList.value; return pfnt; fnsetselect(pfnt.Font.Name,slFontList); } function fnFontSizeChange() { var pfnt = m_psel.Font; pfnt.Size = slFontSize.value; return pfnt; fnsetselect(pfnt.Font.Size,slFontSize); } function fnmerge() { var psel = m_psel; var szfmla; szfmla = "=counta("+psel.Address+")"; var icount = (m_phost.ActiveSheet.Eval(szfmla)); if((psel.Locked != false && m_phost.ActiveSheet.Protection.Enabled == true) || (m_phost.ActiveSheet.AutoFilter && (m_phost.Intersect(psel.Object,m_phost.ActiveSheet.AutoFilter.Range.Object)) != null)) psel.Merge(); else if ((icount > 1 || (icount > 0 && psel.Cells(1).Value == null))) { external.IgnoreFocus(); if(confirm(divmerge.innerText)) psel.Merge(); } else psel.Merge(); return psel; } function fnunmerge() { var psel = m_psel; psel.UnMerge(); return psel; } function fnvalignchange() { var psel = m_psel; psel.VAlignment = slvalign.value; var pcell = m_phost.ActiveCell; fnsetselect(pcell.VAlignment,slvalign); return psel; } function fnhalignchange() { var psel = m_psel; psel.HAlignment = slhalign.value; var pcell = m_phost.ActiveCell; fnsetselect(pcell.HAlignment,slhalign); return psel; } function fnnumfmtchange() { var psel = m_psel; var eo; if(slnfmt.value != "") { psel.NumberFormat = slnfmt.value; eo = fncopyerrorobj(psel); } fnsetselect(psel.NumberFormat,slnfmt); return eo; } function fnrh() { var psel = m_psel; psel.RowHeight = inrh.value; return psel; } function fncw() { var psel = m_psel; psel.ColumnWidth = incw.value; return psel; } function fnhelp() { external.ShowHelp(0); return false; } function fnundo() { if(m_phost.CanUndo) m_phost.Undo(); fnerrorchk(m_phost); external.GiveFocus(); fnUpdate(m_ppanels); } function fntoolbar() { m_phost.DisplayToolbar = !(m_phost.DisplayToolbar); return m_phost; } function fntb() { var f = !(m_phost.DisplayTitleBar); m_phost.DisplayTitleBar = f; fnBtnUpdate(imgtitlebar,f); return m_phost; } function fncolhead() { var f = !(m_phost.DisplayColHeaders); m_phost.DisplayColHeaders = f; fnBtnUpdate(imgcolhead,f); return m_phost; } function fnrowhead() { var f = !(m_phost.DisplayRowHeaders); m_phost.DisplayRowHeaders = f; fnBtnUpdate(imgrowhead,f); return m_phost; } function fngridlines() { var f = !(m_phost.DisplayGridlines); m_phost.DisplayGridlines = f; fnBtnUpdate(imggrid,f); return m_phost; } function fnfind() { var cpass=0; var prngCurCell = m_phost.ActiveCell.Object; var prngFound = null; var pHidden; if(!m_pfindrng) { if(m_psel.Cells.Count == 1 || (m_psel.HasMergeCells && m_psel.Address == m_psel.MergeArea.Address)) m_pfindrng = m_phost.ActiveSheet.Range(m_phost.ViewableRange).Object; else m_pfindrng = m_phost.Selection.Object; } while(prngFound == null && cpass < 2) { prngCurCell = m_pfindrng.Find(infind.value,prngCurCell); if(prngCurCell == null) cpass++; else { if((prngCurCell.ColumnWidth > 0) && (prngCurCell.RowHeight > 0)) prngFound = prngCurCell; else { if(pHidden == null) pHidden = prngFound; else if(pHidden.Address == prngCurCell.Address) break; } } } if(prngFound) { m_ffindcausedselchange = true; prngFound.Select(); } else { external.IgnoreFocus(); alert(divnotfound.innerText); } } function fnfindcng() { } function fnfindkey() { if(event.keyCode == 13) { infind.blur(); fnfind(); infind.focus(); } } function fncalcnow() { if(inmancalc.checked == true) { m_phost.ActiveSheet.EnableAutoCalculate = true; m_phost.ActiveSheet.EnableAutoCalculate = false; } else { m_phost.ActiveSheet.EnableAutoCalculate = false; m_phost.ActiveSheet.EnableAutoCalculate = true; } return m_phost; } function fnmancalc() { var psel = m_phost.ActiveSheet; psel.EnableAutoCalculate = false; return psel; } function fnautocalc() { var psel = m_phost.ActiveSheet; psel.EnableAutoCalculate = true; return psel; } ITSPT ÿÿÿÿÿÿÿÿ j’].!Ðù É"æìTÿÿÿÿÿÿÿÿÿÿÿÿPMGLE !ÿÿÿÿÿÿÿÿ//chart/newchartinit.scr‚:ƒ³~/chart/pbwebchart.htmƒ¶8ƒ‘/core/images/adderror.gifˆÝs/core/images/addtl.gifˆÝsh/core/images/addtrend.gifˆÞ[V/core/images/addtrendline.gifˆß1V/core/images/allborder.GIFˆàv/core/images/autosum.GIFˆà}I/core/images/b1.gifˆáF/core/images/BBorder.GIFˆâHW/core/images/bhor.gifˆã1/core/images/Bold.GIFˆãPO$/core/images/Border_bottom_layer.GIFˆå‚'(/core/images/border_bottom_layer_col.gifˆç=‚(/core/images/border_bottom_layer_row.gifˆéTv+/core/images/border_bottom_layer_single.gifˆëJg!/core/images/border_hor_layer.GIFˆí10/core/images/Border_temp.GIFˆíax!/core/images/Border_top_layer.GIFˆïY:%/core/images/border_top_layer_col.gifˆñ'%/core/images/border_top_layer_row.gifˆò:*(/core/images/border_top_layer_single.gifˆód"/core/images/border_vert_layer.gifˆô//core/images/Borders.GIFˆäw/core/images/btemp.gifˆõ.O/core/images/buttonclear.GIFˆõ}O/core/images/bvert.gifˆöL0/core/images/cataxis.gifˆö|&/core/images/charttype.gifˆø"/core/images/chartwiz.gifˆù)6/core/images/cheverondown.gifˆú_@/core/images/cheveronright.gifˆû>/core/images/chevrondown.gifˆû]6/core/images/chevronright.gifˆü7/core/images/closebox.GIFˆüJI/core/images/colorcell.GIFˆý0/core/images/createchart.gifˆýC</core/images/datalabels.gifˆþ/core/images/datalables.gifˆÿ/core/images/datasource.gif‰€3/core/images/DecDown.GIF‰‚2c/core/images/DecUp.GIF‰ƒc/core/images/delete.gif‰ƒx]/core/images/disperror.gif‰„UU/core/images/dispmark.gif‰…*U/core/images/downarrow.GIF‰…:/core/images/droparea.gif‰†9†z/core/images/editchart.gif‰34/core/images/errorbar.gif‰ŽgO/core/images/errorbarminus.gif‰6I/core/images/errorbarplus.gif‰J/core/images/errorboth.gif‰IP/core/images/Exponential.gif‰‘V/core/images/exportacc.GIF‰‘o/core/images/exportxl.GIF‰’v/core/images/Fillcolor.GIF‰“y/core/images/filter.GIF‰•/core/images/fliphor.gif‰–e/core/images/flipvert.gif‰–me/core/images/Fontcolor.GIF‰—Rh/core/images/forcedraw.GIF‰˜:+/core/images/freezepanes.gif‰˜e}/core/images/help.GIF‰™b/core/images/Italic.GIF‰šyP/core/images/JustCenter.GIF‰›IH/core/images/JustLeft.GIF‰œH/core/images/justright.GIF‰œYG/core/images/Lborder.GIF‰ ]/core/images/Linear.gif‰}K/core/images/linecolor.gif‰žHj/core/images/lock.gif‰Ÿ2/core/images/Logarithmic.gif‰ Mj/core/images/markercircle.gif‰¡7a/core/images/markercross.gif‰¢Y/core/images/markerdashbig.gif‰¢qL!/core/images/markerdashlittle.gif‰£=K/core/images/markerdiamond.gif‰¤o/core/images/markersquare.gif‰¤wW/core/images/markerstar.gif‰¥Nx/core/images/markertriangle.gif‰¦Fd/core/images/markerx.gif‰§*^/core/images/mergecells.gif‰¨s/core/images/NBorder.GIF‰¨{O/core/images/netval.gif‰©J-/core/images/newcat.gif‰ªw)/core/images/newchart.gif‰¬ B/core/images/newchevrondown.gif‰­b@%/core/images/newchevrondownactive.gif‰®"@ /core/images/newchevronright.gif‰®b>&/core/images/newchevronrightactive.gif‰¯ >/core/images/newtl.gif‰¯^g/core/images/newval.gif‰°E-/core/images/none.gif‰±rM/core/images/outerborder.GIF‰²?a/core/images/picker.GIF‰³ 1/core/images/Ploynomial.gif‰³Qo/core/images/Power.gif‰´@W/core/images/publish.gif‰µ;/core/images/Rborder.gif‰¶R]/core/images/rotclock.gif‰·/{/core/images/rotcntclock.gif‰¸*y/core/images/showaxistitle.gif‰¹# /core/images/showchartlegend.gif‰º3/core/images/showcharttitle.gif‰»98/core/images/showcolheaders.gif‰¼q%/core/images/showexpandindicators.gif‰½vj/core/images/showfieldlist.gif‰¾`n/core/images/showgridlines.gif‰¿Nu/core/images/showrowheaders.gif‰ÀC/core/images/showtitlebar.gif‰ÁH /core/images/showtoolbar.gif‰ÂR /core/images/sortacc.GIF‰Ã[/core/images/SortDec.GIF‰Ä[~/core/images/sourcedata.gif‰ÅY*/core/images/spacer.GIF‰Ç- /core/images/splitbuttondrop.GIF‰Ç07/core/images/Tborder.gif‰ÇgV/core/images/temp‰È=-/core/images/temp.gif‰Éj]/core/images/toolbar.gif‰ËG /core/images/touterborder.GIF‰ÌPa/core/images/trendline.gif‰Í1]/core/images/ttop.gif‰ÎO/core/images/Underline.GIF‰Î]X/core/images/undo.gif‰Ï5T/core/images/unlock.gif‰Ð /core/images/unmerge.gif‰Ñs/core/images/valueaxis.gif‰Ò3/core/pbcommon.css†ÇTªr/core/pbcommon.scr†òFüu/core/pbmain.htm‡ï;ˆ/core/picker.ui‡÷Må3/pivot/pbpivot.htm‰Ó;ƒ¾"/pivot/pbpivot.scr‘]ƒ„"/pivot/pbpivotrt.htm•ƒ¾"/pivot/pbpivotrt.scr“Ô!ƒ„"/webxl/border.ui–ØCžF/webxl/pbwebcalc.htm—÷ ð9/webxl/pbwebcalc.scr™çB£[/webxl/pbwebcalcrt.htm›‹„w/webxl/pbwebcalcrt.scrœê_::DataSpace/NameList4<(::DataSpace/Storage/MSCompressed/Content,::DataSpace/Storage/MSCompressed/ControlData‚)::DataSpace/Storage/MSCompressed/SpanInfo‚/::DataSpace/Storage/MSCompressed/Transform/Listp&_::DataSpace/Storage/MSCompressed/Transform/{7FC28940-9D31-11D0-9B27-00A0C91E9C7C}/InstanceData/i::DataSpace/Storage/MSCompressed/Transform/{7FC28940-9D31-11D0-9B27-00A0C91E9C7C}/InstanceData/ResetTableuÄ<Â1”ÿYš ç P ­ ù Y ¦  hÍ1‡èO©ýc–Ã{•