Message-ID: <1878503201.15737.1711640334326.JavaMail.daemon@240b9b9c40b5> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_15736_1411838617.1711640334326" ------=_Part_15736_1411838617.1711640334326 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html =E8=AE=BE=E7=BD=AE=E5=8D=95=E5=85=83=E6=A0=BC=E6=A0=BC=E5=BC=8F<= /title> <!--[if gte mso 9]> <xml> <o:OfficeDocumentSettings> <o:TargetScreenSize>1024x640</o:TargetScreenSize> <o:PixelsPerInch>72</o:PixelsPerInch> <o:AllowPNG/> </o:OfficeDocumentSettings> <w:WordDocument> <w:View>Print</w:View> <w:Zoom>90</w:Zoom> <w:DoNotOptimizeForBrowser/> </w:WordDocument> </xml> <![endif]--> <style> <!-- @page Section1 { size: 8.5in 11.0in; margin: 1.0in; mso-header-margin: .5in; mso-footer-margin: .5in; mso-paper-source: 0; } table { border: solid 1px; border-collapse: collapse; } table td, table th { border: solid 1px; padding: 5px; } td { page-break-inside: avoid; } tr { page-break-after: avoid; } div.Section1 { page: Section1; } /* Confluence print stylesheet. Common to all themes for print medi= a */ /* Full of !important until we improve batching for print CSS */ @media print { #main { padding-bottom: 1em !important; /* The default padding of 6em is to= o much for printouts */ } body { font-family: Arial, Helvetica, FreeSans, sans-serif; font-size: 10pt; line-height: 1.2; } body, #full-height-container, #main, #page, #content, .has-personal-sid= ebar #content { background: #fff !important; color: #000 !important; border: 0 !important; width: 100% !important; height: auto !important; min-height: auto !important; margin: 0 !important; padding: 0 !important; display: block !important; } a, a:link, a:visited, a:focus, a:hover, a:active { color: #000; } #content h1, #content h2, #content h3, #content h4, #content h5, #content h6 { font-family: Arial, Helvetica, FreeSans, sans-serif; page-break-after: avoid; } pre { font-family: Monaco, "Courier New", monospace; } #header, .aui-header-inner, #navigation, #sidebar, .sidebar, #personal-info-sidebar, .ia-fixed-sidebar, .page-actions, .navmenu, .ajs-menu-bar, .noprint, .inline-control-link, .inline-control-link a, a.show-labels-editor, .global-comment-actions, .comment-actions, .quick-comment-container, #addcomment { display: none !important; } /* CONF-28544 cannot print multiple pages in IE */ #splitter-content { position: relative !important; } .comment .date::before { content: none !important; /* remove middot for print view */ } h1.pagetitle img { height: auto; width: auto; } .print-only { display: block; } #footer { position: relative !important; /* CONF-17506 Place the footer at en= d of the content */ margin: 0; padding: 0; background: none; clear: both; } #poweredby { border-top: none; background: none; } #poweredby li.print-only { display: list-item; font-style: italic; } #poweredby li.noprint { display: none; } /* no width controls in print */ .wiki-content .table-wrap, .wiki-content p, .panel .codeContent, .panel .codeContent pre, .image-wrap { overflow: visible !important; } /* TODO - should this work? */ #children-section, #comments-section .comment, #comments-section .comment .comment-body, #comments-section .comment .comment-content, #comments-section .comment p { page-break-inside: avoid; } #page-children a { text-decoration: none; } /** hide twixies the specificity here is a hack because print styles are getting loaded before the base styles. */ #comments-section.pageSection .section-header, #comments-section.pageSection .section-title, #children-section.pageSection .section-header, #children-section.pageSection .section-title, .children-show-hide { padding-left: 0; margin-left: 0; } .children-show-hide.icon { display: none; } /* personal sidebar */ .has-personal-sidebar #content { margin-right: 0px; } .has-personal-sidebar #content .pageSection { margin-right: 0px; } .no-print, .no-print * { display: none !important; } } --> </style> </head> <body> <h1>=E8=AE=BE=E7=BD=AE=E5=8D=95=E5=85=83=E6=A0=BC=E6=A0=BC=E5=BC=8F</h1= > <div class=3D"Section1"> <p>=E4=BD=A0=E5=8F=AF=E4=BB=A5=E4=BD=BF=E7=94=A8=E6=95=B0=E5=AD=97= =EF=BC=8C=E6=97=A5=E6=9C=9F=E6=88=96=E8=80=85=E8=87=AA=E5=AE=9A=E4=B9=89=E6= =A0=BC=E5=BC=8F=E6=9D=A5=E6=A0=BC=E5=BC=8F=E5=8C=96=E5=8D=95=E5=85=83=E6=A0= =BC=E3=80=82</p> <p>=E4=BD=A0=E4=B9=9F=E5=8F=AF=E4=BB=A5=E5=B0=86=E5=8D=95=E5=85=83=E6=A0=BC= =E7=9A=84 culture =E8=AE=BE=E7=BD=AE=E6=88=90 "ja-jp" =E6=88=96=E8=80= =85 "en-us"=E3=80=82</p> <p>=E6=95=B0=E5=AD=97=E4=BC=9A=E5=9F=BA=E4=BA=8E=E5=BD=93=E5=89=8D=E7=9A=84= culture =E8=BF=9B=E8=A1=8C=E6=A0=BC=E5=BC=8F=E5=8C=96=E3=80=82=E9=BB=98=E8= =AE=A4=E4=B8=BA English=E3=80=82</p> <p>=E4=BD=A0=E5=8F=AF=E4=BB=A5=E5=B0=86 culture =E8=AE=BE=E7=BD=AE=E4=B8=BA=  "ja-jp" =E6=88=96=E8=80=85 "en-us"=E3=80=82</p> <p>=E4=BD=A0=E5=8F=AF=E4=BB=A5=E5=8F=AA=E7=BB=99=E6=95=B4=E4=B8=AA=E6=8E=A7= =E4=BB=B6=E8=AE=BE=E7=BD=AE culture=EF=BC=8C=E4=B9=9F=E5=8F=AF=E4=BB=A5=E7= =BB=99=E6=9F=90=E4=B8=AA=E5=8D=95=E5=85=83=E6=A0=BC=E8=AE=BE=E7=BD=AE cultu= re=E3=80=82</p> <p>=E5=8D=95=E5=85=83=E6=A0=BC=E7=9A=84 culture =E4=B8=8D=E4=BC=9A=E5=BD=B1= =E5=93=8D=E6=8E=A7=E4=BB=B6=E7=9A=84 culture=E3=80=82</p> <p>Spread.Sheets =E6=94=AF=E6=8C=81=E6=99=AE=E9=80=9A=E5=88=86=E6=95=B0=E6= =A0=BC=E5=BC=8F=EF=BC=8C=E6=AF=94=E5=A6=82 "# ?/?"=EF=BC=8C"# ??/??"= =EF=BC=8C"# ?/4"=E5=92=8C"#,## ?/?"=E3=80=82</p> <p>=E4=BD=A0=E5=8F=AF=E4=BB=A5=E5=B0=86=E8=B4=9F=E6=95=B0=E8=BD=AC=E6=8D=A2= =E6=88=90=E5=88=86=E6=95=B0=E6=A0=BC=E5=BC=8F=E3=80=82</p> <p>Spread.Sheets =E4=B9=9F=E6=94=AF=E6=8C=81 local ID "$-411"=EF=BC=8C= =E5=92=8C DBNumber=E3=80=82</p> <p>=E8=87=AA=E5=AE=9A=E4=B9=89=E5=8D=95=E5=85=83=E6=A0=BC=E6=A8=A1=E5=BC=8F= =E6=94=AF=E6=8C=81 =E7=BB=84=E5=90=88=E6=A1=86=EF=BC=8C=E6=9D=A1=E4=BB=B6= =E6=A0=BC=E5=BC=8F=E5=92=8C=E5=89=8D=E6=99=AF=E8=89=B2=EF=BC=8C=E4=BD=86=E6= =98=AF=E4=B8=8D=E6=94=AF=E6=8C=81"(", ")", =E5=92=8C "*" =E8=A1=A8=E8=BE=BE= =E5=BC=8F=E3=80=82</p> <p>=E4=BD=A0=E4=B9=9F=E5=8F=AF=E4=BB=A5=E4=BD=BF=E7=94=A8<span style=3D"col= or: rgb(0,0,0);"> </span><a href=3D"http://help.grapecity.com/spread/S= preadSheets10/JavascriptLibrary~GC.Spread.Formatter.FormatterBase.html" cla= ss=3D"external-link" rel=3D"nofollow">FormatterBase</a><span style=3D"color= : rgb(0,0,0);"> </span>=E7=B1=BB=E6=9D=A5=E5=88=9B=E5=BB=BA=E8=87=AA= =E5=AE=9A=E4=B9=89=E6=A0=BC=E5=BC=8F=E3=80=82</p> <p>=E6=9B=B4=E5=A4=9A=E5=85=B3=E4=BA=8E=E6=95=B0=E5=AD=97=E6=A0=BC=E5=BC=8F= =E5=8C=96=EF=BC=8C=E8=AF=B7=E5=8F=82=E9=98=85=EF=BC=9A<a style=3D"text-deco= ration: underline;" href=3D"http://msdn.microsoft.com/en-us/library/dwhawy9= k.aspx" class=3D"external-link" rel=3D"nofollow">http://msdn.microsoft.com/= en-us/library/dwhawy9k.aspx</a>=E3=80=82</p> <h4 id=3D"id-=E8=AE=BE=E7=BD=AE=E5=8D=95=E5=85=83=E6=A0=BC=E6=A0=BC=E5=BC= =8F-=E7=A4=BA=E4=BE=8B=E4=BB=A3=E7=A0=81">=E7=A4=BA=E4=BE=8B=E4=BB=A3=E7=A0= =81</h4> <p>=E4=BB=A5=E4=B8=8B=E4=BB=A3=E7=A0=81=E6=A0=BC=E5=BC=8F=E5=8C=96=E4=BA=86= =E5=8D=95=E5=85=83=E6=A0=BC=E4=B8=AD=E7=9A=84=E5=80=BC=E3=80=82</p> <div class=3D"code panel pdl" style=3D"border-width: 1px;"> <div class=3D"codeHeader panelHeader pdl" style=3D"border-bottom-width: 1px= ;"> <b>JavaScript</b> </div> <div class=3D"codeContent panelContent pdl">=20 <pre class=3D"syntaxhighlighter-pre" data-syntaxhighlighter-params=3D"brush= : js; gutter: false; theme: Confluence" data-theme=3D"Confluence"> var dval= ue=3D 12345.6789; activeSheet.setValue(0,0,dvalue); activeSheet.getCell(0, 1).formatter("M"); activeSheet.setValue(0, 1, new Date(2011, 2, 9)); activeSheet.getCell(0, 2).formatter("m"); activeSheet.setValue(0, 2, new Date(2012, 10, 15)); activeSheet.getCell(0, 3).formatter("General"); activeSheet.setValue(0, 3, new Date(2012, 10, 15)); activeSheet.getCell(0, 4).formatter("#.#%"); activeSheet.setValue(0, 4, 1); activeSheet.getCell(1, 0).formatter("[>2]0.0;[<-3]0.0;zero;"); activeSheet.setValue(1, 0, 3);</pre>=20 </div> </div> <p><span style=3D"font-weight: bold;">=E7=A4=BA=E4=BE=8B=E4=BB=A3=E7=A0=81<= /span></p> <p>=E4=BB=A5=E4=B8=8B=E4=BB=A3=E7=A0=81=E4=BD=BF=E7=94=A8=E4=BA=86=E5=88=86= =E6=95=B0=E6=A0=BC=E5=BC=8F=E6=9D=A5=E6=A0=BC=E5=BC=8F=E5=8C=96=E5=8D=95=E5= =85=83=E6=A0=BC</p> <div class=3D"code panel pdl" style=3D"border-width: 1px;"> <div class=3D"codeHeader panelHeader pdl" style=3D"border-bottom-width: 1px= ;"> <b>JavaScript</b> </div> <div class=3D"codeContent panelContent pdl">=20 <pre class=3D"syntaxhighlighter-pre" data-syntaxhighlighter-params=3D"brush= : js; gutter: false; theme: Confluence" data-theme=3D"Confluence"> var dval= ue=3D 123.89; activeSheet.setValue(0,0,dvalue); activeSheet.getCell(0, 0).formatter("# ??/??");</pre>=20 </div> </div> <p class=3D"auto-cursor-target"><span style=3D"font-weight: bold;">=E7=A4= =BA=E4=BE=8B=E4=BB=A3=E7=A0=81</span></p> <p>=E4=BB=A5=E4=B8=8B=E4=BB=A3=E7=A0=81=E4=BD=BF=E7=94=A8=E4=BA=86 locale I= D "$-411"=E3=80=82</p> <div class=3D"code panel pdl" style=3D"border-width: 1px;"> <div class=3D"codeHeader panelHeader pdl" style=3D"border-bottom-width: 1px= ;"> <b>JavaScript</b> </div> <div class=3D"codeContent panelContent pdl">=20 <pre class=3D"syntaxhighlighter-pre" data-syntaxhighlighter-params=3D"brush= : js; gutter: false; theme: Confluence" data-theme=3D"Confluence">var dvalu= e=3D 123.89; activeSheet.setValue(0,0,dvalue); activeSheet.getCell(0,0).formatter("[$-411]dddd");</pre>=20 </div> </div> <p class=3D"auto-cursor-target"><span style=3D"font-weight: bold;">=E7=A4= =BA=E4=BE=8B=E4=BB=A3=E7=A0=81</span></p> <p>=E4=BB=A5=E4=B8=8B=E4=BB=A3=E7=A0=81=E4=BD=BF=E7=94=A8=E4=BA=86 DBN= umber =E6=9D=A5=E6=A0=BC=E5=BC=8F=E5=8C=96=E5=8D=95=E5=85=83=E6=A0=BC</p> <div class=3D"code panel pdl" style=3D"border-width: 1px;"> <div class=3D"codeHeader panelHeader pdl" style=3D"border-bottom-width: 1px= ;"> <b>JavaScript</b> </div> <div class=3D"codeContent panelContent pdl">=20 <pre class=3D"syntaxhighlighter-pre" data-syntaxhighlighter-params=3D"brush= : js; gutter: false; theme: Confluence" data-theme=3D"Confluence">var dvalu= e=3D 123.89; activeSheet.setValue(0,0,dvalue); activeSheet.getCell(0,0).formatter("[DBNum2][$-411]General");</pre>=20 </div> </div> <p class=3D"auto-cursor-target"><span style=3D"font-weight: bold;">=E7=A4= =BA=E4=BE=8B=E4=BB=A3=E7=A0=81</span></p> <p>=E4=BB=A5=E4=B8=8B=E4=BB=A3=E7=A0=81=E8=AE=BE=E7=BD=AE=E4=BA=86=E6=95=B4= =E4=B8=AA=E5=B7=A5=E4=BD=9C=E8=A1=A8=E7=9A=84=E6=96=87=E5=8C=96=E4=B8=BA ja= -jp=E3=80=82</p> <div class=3D"code panel pdl" style=3D"border-width: 1px;"> <div class=3D"codeHeader panelHeader pdl" style=3D"border-bottom-width: 1px= ;"> <b>JavaScript</b> </div> <div class=3D"codeContent panelContent pdl">=20 <pre class=3D"syntaxhighlighter-pre" data-syntaxhighlighter-params=3D"brush= : js; gutter: false; theme: Confluence" data-theme=3D"Confluence">//widget = setting GC.Spread.Common.CultureManager.culture("ja-jp");</pre>=20 </div> </div> <p class=3D"auto-cursor-target"><span style=3D"font-weight: bold;">=E7=A4= =BA=E4=BE=8B=E4=BB=A3=E7=A0=81</span></p> <p>=E4=BB=A5=E4=B8=8B=E4=BB=A3=E7=A0=81=E7=BB=99=E5=8D=95=E5=85=83=E6=A0=BC= =E8=AE=BE=E7=BD=AE=E4=BA=86=E6=96=87=E5=8C=96=E3=80=82</p> <div class=3D"code panel pdl" style=3D"border-width: 1px;"> <div class=3D"codeHeader panelHeader pdl" style=3D"border-bottom-width: 1px= ;"> <b>JavaScript</b> </div> <div class=3D"codeContent panelContent pdl">=20 <pre class=3D"syntaxhighlighter-pre" data-syntaxhighlighter-params=3D"brush= : js; gutter: false; theme: Confluence" data-theme=3D"Confluence">//cell se= tting //Input date string "2014/01/07" in cell[0,0] and cell[0,1] activeSheet.getCell(0,0).formatter(new GC.Spread.Formatter.GeneralFormatter= ("yyyy/MM/dd dddd", "ja-jp")); activeSheet.getCell(0,1).formatter(new GC.Spread.Formatter.GeneralFormatter= ("yyyy/MM/dd dddd", "en-us"));</pre>=20 </div> </div> <p class=3D"auto-cursor-target"><strong><strong><span style=3D"color: rgb(0= ,51,102);"><strong><strong>=E6=9B=B4=E5=A4=9A=E4=BF=A1=E6=81=AF</strong></s= trong></span></strong></strong></p> <p><a href=3D"http://help.grapecity.com/spread/SpreadSheets10/cultureoption= .html" class=3D"external-link" rel=3D"nofollow">Setting the Culture</a><br>= <a href=3D"http://help.grapecity.com/spread/SpreadSheets10/JavascriptLibrar= y~GC.Spread.Formatter.GeneralFormatter.html" class=3D"external-link" rel=3D= "nofollow">GeneralFormatter class</a><br><a href=3D"http://help.grapecity.c= om/spread/SpreadSheets10/JavascriptLibrary~GC.Spread.Sheets.CellRange~forma= tter.html" class=3D"external-link" rel=3D"nofollow">formatter Method</a></p= > </div> </body> </html> ------=_Part_15736_1411838617.1711640334326--