Author: onealj Date: Mon Feb 12 06:48:12 2018 New Revision: 1823926 URL: http://svn.apache.org/viewvc?rev=1823926&view=rev Log: republish site
Modified: poi/site/publish/changes.html poi/site/publish/changes.rss poi/site/publish/encryption.html poi/site/publish/overview.html poi/site/publish/spreadsheet/quick-guide.html Modified: poi/site/publish/changes.html URL: http://svn.apache.org/viewvc/poi/site/publish/changes.html?rev=1823926&r1=1823925&r2=1823926&view=diff ============================================================================== --- poi/site/publish/changes.html (original) +++ poi/site/publish/changes.html Mon Feb 12 06:48:12 2018 @@ -288,6 +288,8 @@ if (VERSION > 3) { <li>Removal of deprecated classes and methods that were marked for removal in v4.0</li> <li>Removal of deprecated classes and methods that were marked for removal in v3.18</li> + +<li>Provide new ooxml-schemas-1.4.jar</li> </ul> @@ -305,98 +307,150 @@ if (VERSION > 3) { <tbody> <tr class="b"> -<td style="text-align: center;"><img class="icon" alt="fix" src="skin/images/fix.png" title="fix"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61787">61787</a></td><td>HSSF</td><td>Change how deleted content is detected to not incorrectly see too much text as deleted, this was introduced with bug 58067</td> +<td style="text-align: center;"><img class="icon" alt="add" src="skin/images/add.png" title="add"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=55954">55954</a></td><td>XWPF</td><td>Added methods to position table</td> </tr> <tr class="a"> -<td style="text-align: center;"><img class="icon" alt="fix" src="skin/images/fix.png" title="fix"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61798">61798</a></td><td>HSSF</td><td>Fix usage of getLastCellNum() when calculating worksheet dimension during saving</td> +<td style="text-align: center;"><img class="icon" alt="add" src="skin/images/add.png" title="add"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61947">61947</a></td><td>POI Overall</td><td>Remove deprecated classes (POI 4.0.0)</td> </tr> <tr class="b"> -<td style="text-align: center;"><img class="icon" alt="fix" src="skin/images/fix.png" title="fix"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61911">61911</a></td><td>HWPF</td><td>Avoid IndexOutOfBounds access when reading pictures</td> +<td style="text-align: center;"><img class="icon" alt="add" src="skin/images/add.png" title="add"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=55954">55954</a></td><td>XWPF</td><td>Add functions to get, set, remove outer borders for tables</td> </tr> <tr class="a"> -<td style="text-align: center;"><img class="icon" alt="fix" src="skin/images/fix.png" title="fix"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61765">61765</a></td><td>HSSF</td><td>Support third party tool generated files using WorkBook as their POIFS directory name</td> +<td style="text-align: center;"><img class="icon" alt="add" src="skin/images/add.png" title="add"></td><td><a href="https://github.com/apache/poi/pull/72">github-72</a></td><td>XDDF</td><td>Define XDDF user model for shape properties to be shared between XSLF, XSSF and XWPF</td> </tr> <tr class="b"> -<td style="text-align: center;"><img class="icon" alt="fix" src="skin/images/fix.png" title="fix"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61881">61881</a></td><td>HSLF</td><td>Regression in ppt parsing: typeface can't be null or empty</td> +<td style="text-align: center;"><img class="icon" alt="add" src="skin/images/add.png" title="add"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61543">61543</a></td><td>XSSF</td><td><b>Do not fail with "part already exists" when tables are created/removed (breaks backwards compatibility)</b></td> </tr> <tr class="a"> -<td style="text-align: center;"><img class="icon" alt="add" src="skin/images/add.png" title="add"></td><td><a href="https://github.com/apache/poi/pull/68">github-68</a></td><td>XDDF,XSLF,XSSF,XWPF</td><td>Share chart data implementation between XSLFChart, XSSFChart and XWPFChart through XDDF</td> +<td style="text-align: center;"><img class="icon" alt="add" src="skin/images/add.png" title="add"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61550">61550</a></td><td>POI Overall</td><td><b>Add more information to exception text and verify that it is thrown (breaks backwards compatibility)</b></td> </tr> <tr class="b"> -<td style="text-align: center;"><img class="icon" alt="fix" src="skin/images/fix.png" title="fix"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61809">61809</a></td><td>HPSF</td><td>Infinite loop in SectionIDMap.get() and .put()</td> +<td style="text-align: center;"><img class="icon" alt="add" src="skin/images/add.png" title="add"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61609">61609</a></td><td>POI Overall</td><td><b>Add .gitattribute file and set lf for one sample-file (breaks backwards compatibility)</b></td> </tr> <tr class="a"> -<td style="text-align: center;"><img class="icon" alt="add" src="skin/images/add.png" title="add"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=60887">60887</a></td><td>XSSF</td><td>Surface XSSF Header/Footer Attributes</td> +<td style="text-align: center;"><img class="icon" alt="add" src="skin/images/add.png" title="add"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61797">61797</a></td><td>SL Common</td><td><b>Embed Excel / Ole objects into powerpoint (breaks backwards compatibility)</b></td> </tr> <tr class="b"> -<td style="text-align: center;"><img class="icon" alt="add" src="skin/images/add.png" title="add"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61730">61730</a></td><td>SS Common</td><td>CellRangeAddresses support iterating over their CellAddresses</td> +<td style="text-align: center;"><img class="icon" alt="fix" src="skin/images/fix.png" title="fix"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61943">61943</a></td><td>SL Common</td><td>narrow generics definition because of tighter java9 checks</td> </tr> <tr class="a"> -<td style="text-align: center;"><img class="icon" alt="fix" src="skin/images/fix.png" title="fix"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61727">61727</a></td><td>SS Common</td><td>CellRangeUtil merge cell ranges broken for certain orders of arguments</td> +<td style="text-align: center;"><img class="icon" alt="add" src="skin/images/add.png" title="add"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61942">61942</a></td><td>OPC</td><td>Refactor PackagePartName handling and add getUnusedPartIndex method</td> </tr> <tr class="b"> -<td style="text-align: center;"><img class="icon" alt="fix" src="skin/images/fix.png" title="fix"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=57517">57517</a></td><td>HSSF</td><td>Fix various situations that were handled incorrectly in HSSFOptimiser</td> +<td style="text-align: center;"><img class="icon" alt="fix" src="skin/images/fix.png" title="fix"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61941">61941</a></td><td>POIFS</td><td>Move Ole marker generation to Ole10Native</td> </tr> <tr class="a"> -<td style="text-align: center;"><img class="icon" alt="add" src="skin/images/add.png" title="add"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61671">61671</a></td><td>XSLF</td><td>XSLFSlide does not contain isHidden and setHidden like HSLFSlide does</td> +<td style="text-align: center;"><img class="icon" alt="fix" src="skin/images/fix.png" title="fix"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61940">61940</a></td><td>POI Overall</td><td>Replace ClassID statics with enum</td> </tr> <tr class="b"> -<td style="text-align: center;"><img class="icon" alt="update" src="skin/images/update.png" title="update"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61630">61630</a></td><td>XSSF</td><td>Performance improvement to XSSFExportToXML</td> +<td style="text-align: center;"><img class="icon" alt="add" src="skin/images/add.png" title="add"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61939">61939</a></td><td>OPC</td><td>Provide schema for AlternateContent - provide new ooxml-schemas-1.4.jar</td> </tr> <tr class="a"> -<td style="text-align: center;"><img class="icon" alt="add" src="skin/images/add.png" title="add"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=58068">58068</a></td><td>XSSF</td><td>Add a method to pass the actual Color to StylesTable.findFont()</td> +<td style="text-align: center;"><img class="icon" alt="fix" src="skin/images/fix.png" title="fix"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61787">61787</a></td><td>HSSF</td><td>Change how deleted content is detected to not incorrectly see too much text as deleted, this was introduced with bug 58067</td> </tr> <tr class="b"> -<td style="text-align: center;"><img class="icon" alt="fix" src="skin/images/fix.png" title="fix"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61096">61096</a></td><td>POIFS</td><td>Add support for modules in VBAMacroReader</td> +<td style="text-align: center;"><img class="icon" alt="fix" src="skin/images/fix.png" title="fix"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61798">61798</a></td><td>HSSF</td><td>Fix usage of getLastCellNum() when calculating worksheet dimension during saving</td> </tr> <tr class="a"> -<td style="text-align: center;"><img class="icon" alt="fix" src="skin/images/fix.png" title="fix"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61033">61033</a></td><td>XSSF</td><td>Add XSSFWorkbook.setCellFormulaValidation() to control if formulas are validated during Cell.setCellFormula()</td> +<td style="text-align: center;"><img class="icon" alt="fix" src="skin/images/fix.png" title="fix"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61911">61911</a></td><td>HWPF</td><td>Avoid IndexOutOfBounds access when reading pictures</td> </tr> <tr class="b"> -<td style="text-align: center;"><img class="icon" alt="fix" src="skin/images/fix.png" title="fix"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61148">61148</a></td><td>SXSSF</td><td>Fix calculating/setting formula value</td> +<td style="text-align: center;"><img class="icon" alt="fix" src="skin/images/fix.png" title="fix"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61765">61765</a></td><td>HSSF</td><td>Support third party tool generated files using WorkBook as their POIFS directory name</td> </tr> <tr class="a"> -<td style="text-align: center;"><img class="icon" alt="fix" src="skin/images/fix.png" title="fix"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61064">61064</a></td><td>SS Common</td><td>Support behavior of function CEILING in newer versions of Microsoft Excel</td> +<td style="text-align: center;"><img class="icon" alt="fix" src="skin/images/fix.png" title="fix"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61881">61881</a></td><td>HSLF</td><td>Regression in ppt parsing: typeface can't be null or empty</td> </tr> <tr class="b"> -<td style="text-align: center;"><img class="icon" alt="fix" src="skin/images/fix.png" title="fix"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61516">61516</a></td><td>SS Common</td><td>Correctly handle references that end up outside the workbook when cells with formulas are copied</td> +<td style="text-align: center;"><img class="icon" alt="add" src="skin/images/add.png" title="add"></td><td><a href="https://github.com/apache/poi/pull/68">github-68</a></td><td>XDDF,XSLF,XSSF,XWPF</td><td>Share chart data implementation between XSLFChart, XSSFChart and XWPFChart through XDDF</td> </tr> <tr class="a"> -<td style="text-align: center;"><img class="icon" alt="add" src="skin/images/add.png" title="add"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=60737">60737</a></td><td>XSSF</td><td>Add endSheet() to XSSFEventBasedExcelExtractor</td> +<td style="text-align: center;"><img class="icon" alt="fix" src="skin/images/fix.png" title="fix"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61809">61809</a></td><td>HPSF</td><td>Infinite loop in SectionIDMap.get() and .put()</td> </tr> <tr class="b"> -<td style="text-align: center;"><img class="icon" alt="fix" src="skin/images/fix.png" title="fix"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=59747">59747</a></td><td>OPC</td><td>Exchange order of writing parts into Zip to allow some tools to handle files better</td> +<td style="text-align: center;"><img class="icon" alt="add" src="skin/images/add.png" title="add"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=60887">60887</a></td><td>XSSF</td><td>Surface XSSF Header/Footer Attributes</td> </tr> <tr class="a"> -<td style="text-align: center;"><img class="icon" alt="add" src="skin/images/add.png" title="add"></td><td><a href="https://github.com/apache/poi/pull/69">github-69</a></td><td>SS Common</td><td>Support matrix functions</td> +<td style="text-align: center;"><img class="icon" alt="add" src="skin/images/add.png" title="add"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61730">61730</a></td><td>SS Common</td><td>CellRangeAddresses support iterating over their CellAddresses</td> </tr> <tr class="b"> -<td style="text-align: center;"><img class="icon" alt="fix" src="skin/images/fix.png" title="fix"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=60499">60499</a></td><td>OPC</td><td>Deleting a picture that is used twice on a slide corrupt the slide</td> +<td style="text-align: center;"><img class="icon" alt="fix" src="skin/images/fix.png" title="fix"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61727">61727</a></td><td>SS Common</td><td>CellRangeUtil merge cell ranges broken for certain orders of arguments</td> +</tr> + +<tr class="a"> +<td style="text-align: center;"><img class="icon" alt="fix" src="skin/images/fix.png" title="fix"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=57517">57517</a></td><td>HSSF</td><td>Fix various situations that were handled incorrectly in HSSFOptimiser</td> +</tr> + +<tr class="b"> +<td style="text-align: center;"><img class="icon" alt="add" src="skin/images/add.png" title="add"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61671">61671</a></td><td>XSLF</td><td>XSLFSlide does not contain isHidden and setHidden like HSLFSlide does</td> +</tr> + +<tr class="a"> +<td style="text-align: center;"><img class="icon" alt="update" src="skin/images/update.png" title="update"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61630">61630</a></td><td>XSSF</td><td>Performance improvement to XSSFExportToXML</td> +</tr> + +<tr class="b"> +<td style="text-align: center;"><img class="icon" alt="add" src="skin/images/add.png" title="add"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=58068">58068</a></td><td>XSSF</td><td>Add a method to pass the actual Color to StylesTable.findFont()</td> +</tr> + +<tr class="a"> +<td style="text-align: center;"><img class="icon" alt="fix" src="skin/images/fix.png" title="fix"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61096">61096</a></td><td>POIFS</td><td>Add support for modules in VBAMacroReader</td> +</tr> + +<tr class="b"> +<td style="text-align: center;"><img class="icon" alt="fix" src="skin/images/fix.png" title="fix"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61033">61033</a></td><td>XSSF</td><td>Add XSSFWorkbook.setCellFormulaValidation() to control if formulas are validated during Cell.setCellFormula()</td> </tr> <tr class="a"> +<td style="text-align: center;"><img class="icon" alt="fix" src="skin/images/fix.png" title="fix"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61148">61148</a></td><td>SXSSF</td><td>Fix calculating/setting formula value</td> +</tr> + +<tr class="b"> +<td style="text-align: center;"><img class="icon" alt="fix" src="skin/images/fix.png" title="fix"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61064">61064</a></td><td>SS Common</td><td>Support behavior of function CEILING in newer versions of Microsoft Excel</td> +</tr> + +<tr class="a"> +<td style="text-align: center;"><img class="icon" alt="fix" src="skin/images/fix.png" title="fix"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61516">61516</a></td><td>SS Common</td><td>Correctly handle references that end up outside the workbook when cells with formulas are copied</td> +</tr> + +<tr class="b"> +<td style="text-align: center;"><img class="icon" alt="add" src="skin/images/add.png" title="add"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=60737">60737</a></td><td>XSSF</td><td>Add endSheet() to XSSFEventBasedExcelExtractor</td> +</tr> + +<tr class="a"> +<td style="text-align: center;"><img class="icon" alt="fix" src="skin/images/fix.png" title="fix"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=59747">59747</a></td><td>OPC</td><td>Exchange order of writing parts into Zip to allow some tools to handle files better</td> +</tr> + +<tr class="b"> +<td style="text-align: center;"><img class="icon" alt="add" src="skin/images/add.png" title="add"></td><td><a href="https://github.com/apache/poi/pull/69">github-69</a></td><td>SS Common</td><td>Support matrix functions</td> +</tr> + +<tr class="a"> +<td style="text-align: center;"><img class="icon" alt="fix" src="skin/images/fix.png" title="fix"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=60499">60499</a></td><td>OPC</td><td>Deleting a picture that is used twice on a slide corrupt the slide</td> +</tr> + +<tr class="b"> <td style="text-align: center;"><img class="icon" alt="fix" src="skin/images/fix.png" title="fix"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=60279">60279</a></td><td>POI</td><td>Back-off to brute-force search for macro content if macro offset is incorrect</td> </tr> @@ -411,9 +465,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Summary-N101C7"></a> +<a name="Summary-N1029E"></a> <div class="h4"> -<h4>Summary<a title="Permanent link" class="headerlink" href="#Summary-N101C7">#</a> +<h4>Summary<a title="Permanent link" class="headerlink" href="#Summary-N1029E">#</a> </h4> </div> <ul> @@ -430,9 +484,9 @@ if (VERSION > 3) { </ul> -<a name="Changes-N101DD"></a> +<a name="Changes-N102B4"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N101DD">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N102B4">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -538,9 +592,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Summary-N10347"></a> +<a name="Summary-N1041E"></a> <div class="h4"> -<h4>Summary<a title="Permanent link" class="headerlink" href="#Summary-N10347">#</a> +<h4>Summary<a title="Permanent link" class="headerlink" href="#Summary-N1041E">#</a> </h4> </div> <ul> @@ -557,9 +611,9 @@ if (VERSION > 3) { </ul> -<a name="Changes-N1035D"></a> +<a name="Changes-N10434"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N1035D">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N10434">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -697,9 +751,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Summary-N10541"></a> +<a name="Summary-N10618"></a> <div class="h4"> -<h4>Summary<a title="Permanent link" class="headerlink" href="#Summary-N10541">#</a> +<h4>Summary<a title="Permanent link" class="headerlink" href="#Summary-N10618">#</a> </h4> </div> <ul> @@ -712,9 +766,9 @@ if (VERSION > 3) { </ul> -<a name="Changes-N10551"></a> +<a name="Changes-N10628"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N10551">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N10628">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -780,9 +834,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Summary-N1061B"></a> +<a name="Summary-N106F2"></a> <div class="h4"> -<h4>Summary<a title="Permanent link" class="headerlink" href="#Summary-N1061B">#</a> +<h4>Summary<a title="Permanent link" class="headerlink" href="#Summary-N106F2">#</a> </h4> </div> <ul> @@ -795,9 +849,9 @@ if (VERSION > 3) { </ul> -<a name="Changes-N1062B"></a> +<a name="Changes-N10702"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N1062B">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N10702">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -923,9 +977,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Summary-N107E7"></a> +<a name="Summary-N108BE"></a> <div class="h4"> -<h4>Summary<a title="Permanent link" class="headerlink" href="#Summary-N107E7">#</a> +<h4>Summary<a title="Permanent link" class="headerlink" href="#Summary-N108BE">#</a> </h4> </div> <ul> @@ -942,9 +996,9 @@ if (VERSION > 3) { </ul> -<a name="Changes-N107FD"></a> +<a name="Changes-N108D4"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N107FD">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N108D4">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -1134,9 +1188,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Summary-N10AAF"></a> +<a name="Summary-N10B86"></a> <div class="h4"> -<h4>Summary<a title="Permanent link" class="headerlink" href="#Summary-N10AAF">#</a> +<h4>Summary<a title="Permanent link" class="headerlink" href="#Summary-N10B86">#</a> </h4> </div> <ul> @@ -1159,9 +1213,9 @@ if (VERSION > 3) { </ul> -<a name="Changes-N10ACF"></a> +<a name="Changes-N10BA6"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N10ACF">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N10BA6">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -1367,9 +1421,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Summary-N10DC4"></a> +<a name="Summary-N10E9B"></a> <div class="h4"> -<h4>Summary<a title="Permanent link" class="headerlink" href="#Summary-N10DC4">#</a> +<h4>Summary<a title="Permanent link" class="headerlink" href="#Summary-N10E9B">#</a> </h4> </div> <ul> @@ -1386,9 +1440,9 @@ if (VERSION > 3) { </ul> -<a name="Changes-N10DE6"></a> +<a name="Changes-N10EBD"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N10DE6">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N10EBD">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -1582,9 +1636,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Summary-N110A8"></a> +<a name="Summary-N1117F"></a> <div class="h4"> -<h4>Summary<a title="Permanent link" class="headerlink" href="#Summary-N110A8">#</a> +<h4>Summary<a title="Permanent link" class="headerlink" href="#Summary-N1117F">#</a> </h4> </div> <ul> @@ -1601,9 +1655,9 @@ if (VERSION > 3) { </ul> -<a name="Changes-N110CA"></a> +<a name="Changes-N111A1"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N110CA">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N111A1">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -1709,9 +1763,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Summary-N11227"></a> +<a name="Summary-N112FE"></a> <div class="h4"> -<h4>Summary<a title="Permanent link" class="headerlink" href="#Summary-N11227">#</a> +<h4>Summary<a title="Permanent link" class="headerlink" href="#Summary-N112FE">#</a> </h4> </div> <ul> @@ -1737,9 +1791,9 @@ if (VERSION > 3) { </ul> -<a name="Changes-N11255"></a> +<a name="Changes-N1132C"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N11255">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N1132C">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -1917,9 +1971,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N114CF"></a> +<a name="Changes-N115A6"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N114CF">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N115A6">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -2173,9 +2227,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Summary-N11867"></a> +<a name="Summary-N1193E"></a> <div class="h4"> -<h4>Summary<a title="Permanent link" class="headerlink" href="#Summary-N11867">#</a> +<h4>Summary<a title="Permanent link" class="headerlink" href="#Summary-N1193E">#</a> </h4> </div> <ul> @@ -2192,9 +2246,9 @@ if (VERSION > 3) { </ul> -<a name="Changes-N1187A"></a> +<a name="Changes-N11951"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N1187A">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N11951">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -2380,9 +2434,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N11B1E"></a> +<a name="Changes-N11BF5"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N11B1E">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N11BF5">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -2492,9 +2546,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Summary-N11C98"></a> +<a name="Summary-N11D6F"></a> <div class="h4"> -<h4>Summary<a title="Permanent link" class="headerlink" href="#Summary-N11C98">#</a> +<h4>Summary<a title="Permanent link" class="headerlink" href="#Summary-N11D6F">#</a> </h4> </div> <ul> @@ -2507,9 +2561,9 @@ if (VERSION > 3) { </ul> -<a name="Changes-N11CC0"></a> +<a name="Changes-N11D97"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N11CC0">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N11D97">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -2639,9 +2693,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N11E7A"></a> +<a name="Changes-N11F51"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N11E7A">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N11F51">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -2800,9 +2854,9 @@ if (VERSION > 3) { </div> -<a name="Summary-N12098"></a> +<a name="Summary-N1216F"></a> <div class="h4"> -<h4>Summary<a title="Permanent link" class="headerlink" href="#Summary-N12098">#</a> +<h4>Summary<a title="Permanent link" class="headerlink" href="#Summary-N1216F">#</a> </h4> </div> <ul> @@ -2885,9 +2939,9 @@ if (VERSION > 3) { </ul> -<a name="Changes-N12115"></a> +<a name="Changes-N121EC"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N12115">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N121EC">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -2965,9 +3019,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N121FB"></a> +<a name="Changes-N122D2"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N121FB">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N122D2">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -3109,9 +3163,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N123E9"></a> +<a name="Changes-N124C0"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N123E9">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N124C0">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -3153,9 +3207,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Summary-N1244F"></a> +<a name="Summary-N12526"></a> <div class="h4"> -<h4>Summary<a title="Permanent link" class="headerlink" href="#Summary-N1244F">#</a> +<h4>Summary<a title="Permanent link" class="headerlink" href="#Summary-N12526">#</a> </h4> </div> <ul> @@ -3183,9 +3237,9 @@ if (VERSION > 3) { </ul> -<a name="Changes-N12465"></a> +<a name="Changes-N1253C"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N12465">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N1253C">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -3215,9 +3269,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Summary-N1249F"></a> +<a name="Summary-N12576"></a> <div class="h4"> -<h4>Summary<a title="Permanent link" class="headerlink" href="#Summary-N1249F">#</a> +<h4>Summary<a title="Permanent link" class="headerlink" href="#Summary-N12576">#</a> </h4> </div> <ul> @@ -3229,9 +3283,9 @@ if (VERSION > 3) { </ul> -<a name="Changes-N124AC"></a> +<a name="Changes-N12583"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N124AC">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N12583">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -3521,9 +3575,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N128EA"></a> +<a name="Changes-N129C1"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N128EA">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N129C1">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -3697,9 +3751,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N12B60"></a> +<a name="Changes-N12C37"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N12B60">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N12C37">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -3789,9 +3843,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N12C7E"></a> +<a name="Changes-N12D55"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N12C7E">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N12D55">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -3961,9 +4015,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N12EE4"></a> +<a name="Changes-N12FBB"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N12EE4">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N12FBB">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -4317,9 +4371,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Summary-N13423"></a> +<a name="Summary-N134FA"></a> <div class="h4"> -<h4>Summary<a title="Permanent link" class="headerlink" href="#Summary-N13423">#</a> +<h4>Summary<a title="Permanent link" class="headerlink" href="#Summary-N134FA">#</a> </h4> </div> <ul> @@ -4349,9 +4403,9 @@ if (VERSION > 3) { </ul> -<a name="Changes-N13445"></a> +<a name="Changes-N1351C"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N13445">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N1351C">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -4617,9 +4671,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N1381B"></a> +<a name="Changes-N138F2"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N1381B">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N138F2">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -4833,9 +4887,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N13B0A"></a> +<a name="Changes-N13BE1"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N13B0A">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N13BE1">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -5177,9 +5231,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N13FCC"></a> +<a name="Changes-N140A3"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N13FCC">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N140A3">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -5341,9 +5395,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N141E6"></a> +<a name="Changes-N142BD"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N141E6">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N142BD">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -5453,9 +5507,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N1434C"></a> +<a name="Changes-N14423"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N1434C">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N14423">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -5633,9 +5687,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Summary-N145C6"></a> +<a name="Summary-N1469D"></a> <div class="h4"> -<h4>Summary<a title="Permanent link" class="headerlink" href="#Summary-N145C6">#</a> +<h4>Summary<a title="Permanent link" class="headerlink" href="#Summary-N1469D">#</a> </h4> </div> <ul> @@ -5718,9 +5772,9 @@ if (VERSION > 3) { </ul> -<a name="Changes-N14631"></a> +<a name="Changes-N14708"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N14631">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N14708">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -5778,9 +5832,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N146D7"></a> +<a name="Changes-N147AE"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N146D7">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N147AE">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -5958,9 +6012,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N14939"></a> +<a name="Changes-N14A10"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N14939">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N14A10">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -6086,9 +6140,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N14ADC"></a> +<a name="Changes-N14BB3"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N14ADC">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N14BB3">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -6445,9 +6499,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N14FE2"></a> +<a name="Changes-N150B9"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N14FE2">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N150B9">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -6606,9 +6660,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N15210"></a> +<a name="Changes-N152E7"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N15210">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N152E7">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -6845,9 +6899,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N15576"></a> +<a name="Changes-N1564D"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N15576">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N1564D">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -7092,9 +7146,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N15904"></a> +<a name="Changes-N159DB"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N15904">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N159DB">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -7275,9 +7329,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N15B86"></a> +<a name="Changes-N15C5D"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N15B86">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N15C5D">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -7382,9 +7436,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N15CE4"></a> +<a name="Changes-N15DBB"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N15CE4">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N15DBB">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -7417,9 +7471,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N15D2A"></a> +<a name="Changes-N15E01"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N15D2A">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N15E01">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -7488,9 +7542,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N15DF0"></a> +<a name="Changes-N15EC7"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N15DF0">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N15EC7">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -7539,9 +7593,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N15E62"></a> +<a name="Changes-N15F39"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N15E62">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N15F39">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -7950,9 +8004,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N16418"></a> +<a name="Changes-N164EF"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N16418">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N164EF">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -8077,9 +8131,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N165C2"></a> +<a name="Changes-N16699"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N165C2">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N16699">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -8172,9 +8226,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N166F8"></a> +<a name="Changes-N167CF"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N166F8">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N167CF">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -8492,9 +8546,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N16B7A"></a> +<a name="Changes-N16C51"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N16B7A">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N16C51">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -8603,9 +8657,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N16CEC"></a> +<a name="Changes-N16DC3"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N16CEC">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N16DC3">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -8658,9 +8712,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N16D7E"></a> +<a name="Changes-N16E55"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N16D7E">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N16E55">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -8814,9 +8868,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N16F7C"></a> +<a name="Changes-N17053"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N16F7C">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N17053">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -8882,9 +8936,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N17032"></a> +<a name="Changes-N17109"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N17032">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N17109">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -8926,9 +8980,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N17090"></a> +<a name="Changes-N17167"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N17090">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N17167">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -8954,9 +9008,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N170B6"></a> +<a name="Changes-N1718D"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N170B6">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N1718D">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -8990,9 +9044,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N170F8"></a> +<a name="Changes-N171CF"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N170F8">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N171CF">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -9026,9 +9080,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N17136"></a> +<a name="Changes-N1720D"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N17136">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N1720D">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -9066,9 +9120,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N1718C"></a> +<a name="Changes-N17263"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N1718C">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N17263">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -9098,9 +9152,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N171C2"></a> +<a name="Changes-N17299"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N171C2">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N17299">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -9126,9 +9180,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N171E8"></a> +<a name="Changes-N172BF"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N171E8">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N172BF">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -9178,9 +9232,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N1725A"></a> +<a name="Changes-N17331"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N1725A">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N17331">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -9334,9 +9388,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N17484"></a> +<a name="Changes-N1755B"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N17484">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N1755B">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -9379,9 +9433,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N174DA"></a> +<a name="Changes-N175B1"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N174DA">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N175B1">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -9431,9 +9485,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N1753C"></a> +<a name="Changes-N17613"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N1753C">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N17613">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -9526,9 +9580,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N1762E"></a> +<a name="Changes-N17705"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N1762E">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N17705">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -9561,9 +9615,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N1766C"></a> +<a name="Changes-N17743"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N1766C">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N17743">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -9614,9 +9668,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N176DA"></a> +<a name="Changes-N177B1"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N176DA">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N177B1">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -9645,9 +9699,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N1770C"></a> +<a name="Changes-N177E3"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N1770C">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N177E3">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -9676,9 +9730,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N1773E"></a> +<a name="Changes-N17815"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N1773E">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N17815">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -9723,9 +9777,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N177A0"></a> +<a name="Changes-N17877"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N177A0">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N17877">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -9750,9 +9804,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N177C6"></a> +<a name="Changes-N1789D"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N177C6">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N1789D">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -9793,9 +9847,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N17810"></a> +<a name="Changes-N178E7"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N17810">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N178E7">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -9820,9 +9874,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N17836"></a> +<a name="Changes-N1790D"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N17836">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N1790D">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -9847,9 +9901,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N1785C"></a> +<a name="Changes-N17933"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N1785C">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N17933">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -9874,9 +9928,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N17882"></a> +<a name="Changes-N17959"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N17882">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N17959">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -9919,9 +9973,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N178CC"></a> +<a name="Changes-N179A3"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N178CC">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N179A3">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -9946,9 +10000,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N178F2"></a> +<a name="Changes-N179C9"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N178F2">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N179C9">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -9999,9 +10053,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N17954"></a> +<a name="Changes-N17A2B"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N17954">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N17A2B">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -10028,9 +10082,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N1797A"></a> +<a name="Changes-N17A51"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N1797A">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N17A51">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -10073,9 +10127,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N179D0"></a> +<a name="Changes-N17AA7"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N179D0">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N17AA7">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -10118,9 +10172,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N17A1A"></a> +<a name="Changes-N17AF1"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N17A1A">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N17AF1">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -10151,9 +10205,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N17A4C"></a> +<a name="Changes-N17B23"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N17A4C">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N17B23">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -10178,9 +10232,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N17A72"></a> +<a name="Changes-N17B49"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N17A72">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N17B49">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -10205,9 +10259,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N17A98"></a> +<a name="Changes-N17B6F"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N17A98">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N17B6F">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -10232,9 +10286,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N17ABE"></a> +<a name="Changes-N17B95"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N17ABE">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N17B95">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> @@ -10259,9 +10313,9 @@ if (VERSION > 3) { </h3> </div> -<a name="Changes-N17AE4"></a> +<a name="Changes-N17BBB"></a> <div class="h4"> -<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N17AE4">#</a> +<h4>Changes<a title="Permanent link" class="headerlink" href="#Changes-N17BBB">#</a> </h4> </div> <table class="ForrestTable" cellspacing="1" cellpadding="4"> Modified: poi/site/publish/changes.rss URL: http://svn.apache.org/viewvc/poi/site/publish/changes.rss?rev=1823926&r1=1823925&r2=1823926&view=diff ============================================================================== --- poi/site/publish/changes.rss (original) +++ poi/site/publish/changes.rss Mon Feb 12 06:48:12 2018 @@ -1,6 +1,19 @@ <?xml version="1.0" encoding="ISO-8859-1"?> <!DOCTYPE rss PUBLIC "-//Netscape Communications//DTD RSS 0.91//EN" "http://my.netscape.com/publish/formats/rss-0.91.dtd"> <rss version="0.91"><channel><title>Apache POI Changes</title><link>https://poi.apache.org/changes.html</link><description>Apache POI Changes</description><language>en-us</language> +<item><title>XWPF: add(bug 55954)</title><link>https://poi.apache.org/changes.html</link><description>add by POI Developers (bug 55954) - XWPF: Added methods to position table</description></item> +<item><title>POI Overall: add(bug 61947)</title><link>https://poi.apache.org/changes.html</link><description>add by POI Developers (bug 61947) - POI Overall: Remove deprecated classes (POI 4.0.0)</description></item> +<item><title>XWPF: add(bug 55954)</title><link>https://poi.apache.org/changes.html</link><description>add by POI Developers (bug 55954) - XWPF: Add functions to get, set, remove outer borders for tables</description></item> +<item><title>XDDF: add(bug github-72)</title><link>https://poi.apache.org/changes.html</link><description>add by POI Developers (bug github-72) - XDDF: Define XDDF user model for shape properties to be shared between XSLF, XSSF and XWPF</description></item> +<item><title>XSSF: add(bug 61543)</title><link>https://poi.apache.org/changes.html</link><description>add by POI Developers (bug 61543) - XSSF: Do not fail with "part already exists" when tables are created/removed</description></item> +<item><title>POI Overall: add(bug 61550)</title><link>https://poi.apache.org/changes.html</link><description>add by POI Developers (bug 61550) - POI Overall: Add more information to exception text and verify that it is thrown</description></item> +<item><title>POI Overall: add(bug 61609)</title><link>https://poi.apache.org/changes.html</link><description>add by POI Developers (bug 61609) - POI Overall: Add .gitattribute file and set lf for one sample-file</description></item> +<item><title>SL Common: add(bug 61797)</title><link>https://poi.apache.org/changes.html</link><description>add by POI Developers (bug 61797) - SL Common: Embed Excel / Ole objects into powerpoint</description></item> +<item><title>SL Common: fix(bug 61943)</title><link>https://poi.apache.org/changes.html</link><description>fix by POI Developers (bug 61943) - SL Common: narrow generics definition because of tighter java9 checks</description></item> +<item><title>OPC: add(bug 61942)</title><link>https://poi.apache.org/changes.html</link><description>add by POI Developers (bug 61942) - OPC: Refactor PackagePartName handling and add getUnusedPartIndex method</description></item> +<item><title>POIFS: fix(bug 61941)</title><link>https://poi.apache.org/changes.html</link><description>fix by POI Developers (bug 61941) - POIFS: Move Ole marker generation to Ole10Native</description></item> +<item><title>POI Overall: fix(bug 61940)</title><link>https://poi.apache.org/changes.html</link><description>fix by POI Developers (bug 61940) - POI Overall: Replace ClassID statics with enum</description></item> +<item><title>OPC: add(bug 61939)</title><link>https://poi.apache.org/changes.html</link><description>add by POI Developers (bug 61939) - OPC: Provide schema for AlternateContent - provide new ooxml-schemas-1.4.jar</description></item> <item><title>HSSF: fix(bug 61787)</title><link>https://poi.apache.org/changes.html</link><description>fix by POI Developers (bug 61787) - HSSF: Change how deleted content is detected to not incorrectly see too much text as deleted, this was introduced with bug 58067</description></item> <item><title>HSSF: fix(bug 61798)</title><link>https://poi.apache.org/changes.html</link><description>fix by POI Developers (bug 61798) - HSSF: Fix usage of getLastCellNum() when calculating worksheet dimension during saving</description></item> <item><title>HWPF: fix(bug 61911)</title><link>https://poi.apache.org/changes.html</link><description>fix by POI Developers (bug 61911) - HWPF: Avoid IndexOutOfBounds access when reading pictures</description></item> Modified: poi/site/publish/encryption.html URL: http://svn.apache.org/viewvc/poi/site/publish/encryption.html?rev=1823926&r1=1823925&r2=1823926&view=diff ============================================================================== --- poi/site/publish/encryption.html (original) +++ poi/site/publish/encryption.html Mon Feb 12 06:48:12 2018 @@ -537,7 +537,7 @@ fos.close(); <ul> -<li>BouncyCastle bcpkix and bcprov (tested against 1.58)</li> +<li>BouncyCastle bcpkix and bcprov (tested against 1.59)</li> <li>Apache Santuario "xmlsec" (tested against 2.1.0)</li> Modified: poi/site/publish/overview.html URL: http://svn.apache.org/viewvc/poi/site/publish/overview.html?rev=1823926&r1=1823925&r2=1823926&view=diff ============================================================================== --- poi/site/publish/overview.html (original) +++ poi/site/publish/overview.html Mon Feb 12 06:48:12 2018 @@ -716,8 +716,8 @@ if (VERSION > 3) { <td colspan="1" rowspan="1"><a href="https://search.maven.org/#artifactdetails|org.apache.xmlbeans|xmlbeans|2.6.0|jar">xmlbeans</a> <br> For signing: - <a href="https://search.maven.org/#artifactdetails|org.bouncycastle|bcpkix-jdk15on|1.58|jar">bcpkix-jdk15on</a>, - <a href="https://search.maven.org/#artifactdetails|org.bouncycastle|bcprov-jdk15on|1.58|jar">bcprov-jdk15on</a>, + <a href="https://search.maven.org/#artifactdetails|org.bouncycastle|bcpkix-jdk15on|1.59|jar">bcpkix-jdk15on</a>, + <a href="https://search.maven.org/#artifactdetails|org.bouncycastle|bcprov-jdk15on|1.59|jar">bcprov-jdk15on</a>, <a href="https://search.maven.org/#artifactdetails|org.apache.santuario|xmlsec|2.1.0|bundle">xmlsec</a>, <a href="https://search.maven.org/#artifactdetails|org.slf4j|slf4j-api|1.7.25|jar">slf4j-api</a> </td> Modified: poi/site/publish/spreadsheet/quick-guide.html URL: http://svn.apache.org/viewvc/poi/site/publish/spreadsheet/quick-guide.html?rev=1823926&r1=1823925&r2=1823926&view=diff ============================================================================== --- poi/site/publish/spreadsheet/quick-guide.html (original) +++ poi/site/publish/spreadsheet/quick-guide.html Mon Feb 12 06:48:12 2018 @@ -466,7 +466,7 @@ if (VERSION > 3) { Sheet sheet = wb.createSheet("new sheet"); // Create a row and put some cells in it. Rows are 0 based. - Row row = sheet.createRow((short)0); + Row row = sheet.createRow(0); // Create a cell and put a value in it. Cell cell = row.createCell(0); cell.setCellValue(1); @@ -537,7 +537,7 @@ if (VERSION > 3) { <pre class="code"> Workbook wb = new HSSFWorkbook(); Sheet sheet = wb.createSheet("new sheet"); - Row row = sheet.createRow((short)2); + Row row = sheet.createRow(2); row.createCell(0).setCellValue(1.1); row.createCell(1).setCellValue(new Date()); row.createCell(2).setCellValue(Calendar.getInstance()); @@ -620,16 +620,16 @@ if (VERSION > 3) { Workbook wb = new XSSFWorkbook(); //or new HSSFWorkbook(); Sheet sheet = wb.createSheet(); - Row row = sheet.createRow((short) 2); + Row row = sheet.createRow(2); row.setHeightInPoints(30); - createCell(wb, row, (short) 0, CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_BOTTOM); - createCell(wb, row, (short) 1, CellStyle.ALIGN_CENTER_SELECTION, CellStyle.VERTICAL_BOTTOM); - createCell(wb, row, (short) 2, CellStyle.ALIGN_FILL, CellStyle.VERTICAL_CENTER); - createCell(wb, row, (short) 3, CellStyle.ALIGN_GENERAL, CellStyle.VERTICAL_CENTER); - createCell(wb, row, (short) 4, CellStyle.ALIGN_JUSTIFY, CellStyle.VERTICAL_JUSTIFY); - createCell(wb, row, (short) 5, CellStyle.ALIGN_LEFT, CellStyle.VERTICAL_TOP); - createCell(wb, row, (short) 6, CellStyle.ALIGN_RIGHT, CellStyle.VERTICAL_TOP); + createCell(wb, row, 0, HorizontalAlignment.CENTER, VerticalAlignment.BOTTOM); + createCell(wb, row, 1, HorizontalAlignment.CENTER_SELECTION, VerticalAlignment.BOTTOM); + createCell(wb, row, 2, HorizontalAlignment.FILL, VerticalAlignment.CENTER); + createCell(wb, row, 3, HorizontalAlignment.GENERAL, VerticalAlignment.CENTER); + createCell(wb, row, 4, HorizontalAlignment.JUSTIFY, VerticalAlignment.JUSTIFY); + createCell(wb, row, 5, HorizontalAlignment.LEFT, VerticalAlignment.TOP); + createCell(wb, row, 6, HorizontalAlignment.RIGHT, VerticalAlignment.TOP); // Write the output to a file FileOutputStream fileOut = new FileOutputStream("xssf-align.xlsx"); @@ -645,8 +645,9 @@ if (VERSION > 3) { * @param row the row to create the cell in * @param column the column number to create the cell in * @param halign the horizontal alignment for the cell. + * @param valign the vertical alignment for the cell. */ - private static void createCell(Workbook wb, Row row, short column, short halign, short valign) { + private static void createCell(Workbook wb, Row row, int column, HorizontalAlignment halign, VerticalAlignment valign) { Cell cell = row.createCell(column); cell.setCellValue("Align It"); CellStyle cellStyle = wb.createCellStyle(); @@ -871,21 +872,21 @@ if (VERSION > 3) { Sheet sheet = wb.createSheet("new sheet"); // Create a row and put some cells in it. Rows are 0 based. - Row row = sheet.createRow((short) 1); + Row row = sheet.createRow(1); // Aqua background CellStyle style = wb.createCellStyle(); style.setFillBackgroundColor(IndexedColors.AQUA.getIndex()); - style.setFillPattern(CellStyle.BIG_SPOTS); - Cell cell = row.createCell((short) 1); + style.setFillPattern(FillPatternType.BIG_SPOTS); + Cell cell = row.createCell(1); cell.setCellValue("X"); cell.setCellStyle(style); // Orange "foreground", foreground being the fill foreground not the font color. style = wb.createCellStyle(); style.setFillForegroundColor(IndexedColors.ORANGE.getIndex()); - style.setFillPattern(CellStyle.SOLID_FOREGROUND); - cell = row.createCell((short) 2); + style.setFillPattern(FillPatternType.SOLID_FOREGROUND); + cell = row.createCell(2); cell.setCellValue("X"); cell.setCellStyle(style); @@ -907,8 +908,8 @@ if (VERSION > 3) { Workbook wb = new HSSFWorkbook(); Sheet sheet = wb.createSheet("new sheet"); - Row row = sheet.createRow((short) 1); - Cell cell = row.createCell((short) 1); + Row row = sheet.createRow(1); + Cell cell = row.createCell(1); cell.setCellValue("This is a test of merging"); sheet.addMergedRegion(new CellRangeAddress( @@ -962,8 +963,7 @@ if (VERSION > 3) { </pre> <p> - Note, the maximum number of unique fonts in a workbook is limited to 32767 ( - the maximum positive short). You should re-use fonts in your applications instead of + Note, the maximum number of unique fonts in a workbook is limited to 32767. You should re-use fonts in your applications instead of creating a font for each cell. Examples: </p> @@ -975,7 +975,7 @@ Examples: <pre class="code"> for (int i = 0; i < 10000; i++) { Row row = sheet.createRow(i); - Cell cell = row.createCell((short) 0); + Cell cell = row.createCell(0); CellStyle style = workbook.createCellStyle(); Font font = workbook.createFont(); @@ -997,7 +997,7 @@ Examples: style.setFont(font); for (int i = 0; i < 10000; i++) { Row row = sheet.createRow(i); - Cell cell = row.createCell((short) 0); + Cell cell = row.createCell(0); cell.setCellStyle(style); } </pre> @@ -1018,8 +1018,8 @@ Examples: <pre class="code"> HSSFWorkbook wb = new HSSFWorkbook(); HSSFSheet sheet = wb.createSheet(); - HSSFRow row = sheet.createRow((short) 0); - HSSFCell cell = row.createCell((short) 0); + HSSFRow row = sheet.createRow(0); + HSSFCell cell = row.createCell(0); cell.setCellValue("Default Palette"); //apply some colors from the standard palette, @@ -1028,7 +1028,7 @@ Examples: HSSFCellStyle style = wb.createCellStyle(); style.setFillForegroundColor(HSSFColor.LIME.index); - style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); + style.setFillPattern(FillPatternType.SOLID_FOREGROUND); HSSFFont font = wb.createFont(); font.setColor(HSSFColor.RED.index); @@ -1080,7 +1080,7 @@ Examples: XSSFCellStyle style1 = wb.createCellStyle(); style1.setFillForegroundColor(new XSSFColor(new java.awt.Color(128, 0, 128))); - style1.setFillPattern(CellStyle.SOLID_FOREGROUND); + style1.setFillPattern(FillPatternType.SOLID_FOREGROUND); </pre> @@ -1135,7 +1135,7 @@ Examples: row.setHeightInPoints((2*sheet.getDefaultRowHeightInPoints())); //adjust column width to fit the content - sheet.autoSizeColumn((short)2); + sheet.autoSizeColumn(2); FileOutputStream fileOut = new FileOutputStream("ooxml-newlines.xlsx"); wb.write(fileOut); @@ -1157,8 +1157,8 @@ Examples: DataFormat format = wb.createDataFormat(); Row row; Cell cell; - short rowNum = 0; - short colNum = 0; + int rowNum = 0; + int colNum = 0; row = sheet.createRow(rowNum++); cell = row.createCell(colNum); @@ -1287,26 +1287,21 @@ Examples: sheet1.addMergedRegion( region ); // Set the border and border colors. - final short borderMediumDashed = BorderStyle.MEDIUM_DASHED; - RegionUtil.setBorderBottom( borderMediumDashed, - region, sheet1, wb ); - RegionUtil.setBorderTop( borderMediumDashed, - region, sheet1, wb ); - RegionUtil.setBorderLeft( borderMediumDashed, - region, sheet1, wb ); - RegionUtil.setBorderRight( borderMediumDashed, - region, sheet1, wb ); + RegionUtil.setBorderBottom( BorderStyle.MEDIUM_DASHED, region, sheet1, wb ); + RegionUtil.setBorderTop( BorderStyle.MEDIUM_DASHED, region, sheet1, wb ); + RegionUtil.setBorderLeft( BorderStyle.MEDIUM_DASHED, region, sheet1, wb ); + RegionUtil.setBorderRight( BorderStyle.MEDIUM_DASHED, region, sheet1, wb ); RegionUtil.setBottomBorderColor(IndexedColors.AQUA.getIndex(), region, sheet1, wb); - RegionUtil.setTopBorderColor(IndexedColors.AQUA.getIndex(), region, sheet1, wb); - RegionUtil.setLeftBorderColor(IndexedColors.AQUA.getIndex(), region, sheet1, wb); - RegionUtil.setRightBorderColor(IndexedColors.AQUA.getIndex(), region, sheet1, wb); + RegionUtil.setTopBorderColor( IndexedColors.AQUA.getIndex(), region, sheet1, wb); + RegionUtil.setLeftBorderColor( IndexedColors.AQUA.getIndex(), region, sheet1, wb); + RegionUtil.setRightBorderColor( IndexedColors.AQUA.getIndex(), region, sheet1, wb); // Shows some usages of HSSFCellUtil CellStyle style = wb.createCellStyle(); style.setIndention((short)4); CellUtil.createCell(row, 8, "This is the value of the cell", style); Cell cell2 = CellUtil.createCell( row2, 8, "This is the value of the cell"); - CellUtil.setAlignment(cell2, wb, CellStyle.ALIGN_CENTER); + CellUtil.setAlignment(cell2, HorizontalAlignment.CENTER); // Write out the workbook FileOutputStream fileOut = new FileOutputStream( "workbook.xls" ); @@ -1684,8 +1679,8 @@ Examples: // Create a couple of lines in the group. HSSFSimpleShape shape1 = group.createShape(new HSSFChildAnchor(3,3,500,500)); shape1.setShapeType(HSSFSimpleShape.OBJECT_TYPE_LINE); - ( (HSSFChildAnchor) shape1.getAnchor() ).setAnchor((short)3,3,500,500); - HSSFSimpleShape shape2 = group.createShape(new HSSFChildAnchor((short)1,200,400,600)); + ( (HSSFChildAnchor) shape1.getAnchor() ).setAnchor(3,3,500,500); + HSSFSimpleShape shape2 = group.createShape(new HSSFChildAnchor(1,200,400,600)); shape2.setShapeType(HSSFSimpleShape.OBJECT_TYPE_LINE); </pre> @@ -1882,9 +1877,9 @@ Examples: sheet1.groupRow( 7, 14 ); sheet1.groupRow( 16, 19 ); - sheet1.groupColumn( (short)4, (short)7 ); - sheet1.groupColumn( (short)9, (short)12 ); - sheet1.groupColumn( (short)10, (short)11 ); + sheet1.groupColumn( 4, 7 ); + sheet1.groupColumn( 9, 12 ); + sheet1.groupColumn( 10, 11 ); FileOutputStream fileOut = new FileOutputStream(filename); wb.write(fileOut); @@ -1897,7 +1892,7 @@ Examples: <pre class="code"> sheet1.setRowGroupCollapsed( 7, true ); - sheet1.setColumnGroupCollapsed( (short)4, true ); + sheet1.setColumnGroupCollapsed( 4, true ); </pre> <p> @@ -2031,7 +2026,7 @@ Examples: String sname = "TestSheet", cname = "TestName", cvalue = "TestVal"; Workbook wb = new HSSFWorkbook(); Sheet sheet = wb.createSheet(sname); - sheet.createRow(0).createCell((short) 0).setCellValue(cvalue); + sheet.createRow(0).createCell(0).setCellValue(cvalue); // 1. create named range for a single cell using areareference Name namedCell = wb.createName(); @@ -2185,7 +2180,7 @@ Examples: </p> <pre class="code"> - Cell cell = sheet.get(3).getColumn((short)1); + Cell cell = sheet.get(3).getColumn(1); Comment comment = cell.getCellComment(); if (comment != null) { RichTextString str = comment.getString(); @@ -2286,7 +2281,7 @@ Examples: <pre class="code"> Sheet sheet = workbook.getSheetAt(0); - Cell cell = sheet.getRow(0).getCell((short)0); + Cell cell = sheet.getRow(0).getCell(0); Hyperlink link = cell.getHyperlink(); if(link != null){ System.out.println(link.getAddress()); @@ -2315,7 +2310,7 @@ Examples: Cell cell; Sheet sheet = wb.createSheet("Hyperlinks"); //URL - cell = sheet.createRow(0).createCell((short)0); + cell = sheet.createRow(0).createCell(0); cell.setCellValue("URL Link"); Hyperlink link = createHelper.createHyperlink(Hyperlink.LINK_URL); @@ -2324,7 +2319,7 @@ Examples: cell.setCellStyle(hlink_style); //link to a file in the current directory - cell = sheet.createRow(1).createCell((short)0); + cell = sheet.createRow(1).createCell(0); cell.setCellValue("File Link"); link = createHelper.createHyperlink(Hyperlink.LINK_FILE); link.setAddress("link1.xls"); @@ -2332,7 +2327,7 @@ Examples: cell.setCellStyle(hlink_style); //e-mail link - cell = sheet.createRow(2).createCell((short)0); + cell = sheet.createRow(2).createCell(0); cell.setCellValue("Email Link"); link = createHelper.createHyperlink(Hyperlink.LINK_EMAIL); //note, if subject contains white spaces, make sure they are url-encoded @@ -2344,9 +2339,9 @@ Examples: //create a target sheet and cell Sheet sheet2 = wb.createSheet("Target Sheet"); - sheet2.createRow(0).createCell((short)0).setCellValue("Target Cell"); + sheet2.createRow(0).createCell(0).setCellValue("Target Cell"); - cell = sheet.createRow(3).createCell((short)0); + cell = sheet.createRow(3).createCell(0); cell.setCellValue("Worksheet Link"); Hyperlink link2 = createHelper.createHyperlink(Hyperlink.LINK_DOCUMENT); link2.setAddress("'Target Sheet'!A1"); --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@poi.apache.org For additional commands, e-mail: commits-h...@poi.apache.org