You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@poi.apache.org by ce...@apache.org on 2019/12/31 11:03:55 UTC
svn commit: r1872137 - in /poi/site: publish/ publish/devel/
src/documentation/content/xdocs/ src/documentation/content/xdocs/devel/
Author: centic
Date: Tue Dec 31 11:03:55 2019
New Revision: 1872137
URL: http://svn.apache.org/viewvc?rev=1872137&view=rev
Log:
Add case-study (bug 63549)
Update changelog
Adjust some development information
Modified:
poi/site/publish/casestudies.html
poi/site/publish/changes.html
poi/site/publish/devel/index.html
poi/site/src/documentation/content/xdocs/casestudies.xml
poi/site/src/documentation/content/xdocs/changes.xml
poi/site/src/documentation/content/xdocs/devel/index.xml
poi/site/src/documentation/content/xdocs/related-projects.xml
Modified: poi/site/publish/casestudies.html
URL: http://svn.apache.org/viewvc/poi/site/publish/casestudies.html?rev=1872137&r1=1872136&r2=1872137&view=diff
==============================================================================
--- poi/site/publish/casestudies.html (original)
+++ poi/site/publish/casestudies.html Tue Dec 31 11:03:55 2019
@@ -202,6 +202,39 @@ document.write("Last Published: " + docu
<a name="Case+Studies"></a>
<h2 class="boxed">Case Studies</h2>
<div class="section">
+<a name="WriteExcel+Utilities"></a>
+<h3 class="boxed">WriteExcel Utilities</h3>
+<p>
+ This WriteExcel distribution package found at <a href="https://stevepritchard.ca/home/WriteExcel/overview.htm">WriteExcel Utilities</a> contains source,
+ documentation, examples, build tools and precompiled classes that wrap the Apache POI Excel interface.
+ </p>
+<p>
+ WriteExcel creates a Workbook file using a simple interface that uses formatted strings as the primary way
+ of passing information to the support methods which interpret the strings and issue the necessary POI method calls.
+ Access to the <span class="codefrag">Workbook</span> object allows the POI methods to be called directly for cases not handled by the interface.
+ </p>
+<p>
+ An existing Workbook file can be used as a template source so that sheets can be copied and then left intact, modified and/or supplemented.
+ </p>
+<p>
+ The creation of Workbooks containing charts is supported by using an existing Workbook file as a template that contains one or more charts
+ and using WriteExcel to modify the data that the chart refers to.
+ </p>
+<p>
+ The ReadExcelFile component of the package can be used to selectively iterate across existing Workbooks (or Workbooks under construction) and create
+ Java objects with the selected data which can then be forwarded for further processing.
+ <br>
+<br>
+ WriteExcel was used to produce the monthly reporting files for a church accounting system among other things.
+ <br>
+<br>
+ Steve Pritchard<br>
+ Rexcel Systems Inc.<br>
+ July, 2019<br>
+
+<a href="https://stevepritchard.ca">Steve Pritchard Utilities</a>
+
+</p>
<a name="Processing+biometric+scanner+logs+-+Glassbeam"></a>
<h3 class="boxed">Processing biometric scanner logs - Glassbeam</h3>
<p>
Modified: poi/site/publish/changes.html
URL: http://svn.apache.org/viewvc/poi/site/publish/changes.html?rev=1872137&r1=1872136&r2=1872137&view=diff
==============================================================================
--- poi/site/publish/changes.html (original)
+++ poi/site/publish/changes.html Tue Dec 31 11:03:55 2019
@@ -227,6 +227,26 @@ document.write("Last Published: " + docu
<tbody>
<tr>
+<td style="text-align: center;"><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63700">63700</a></td><td>POI_Overall</td><td>Make D* functions work with numeric result column</td>
+</tr>
+
+<tr>
+<td style="text-align: center;"><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63960">63960</a></td><td>POI_Overall</td><td>Write pre-evaluated string-values in formula cells with the correct type</td>
+</tr>
+
+<tr>
+<td style="text-align: center;"><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63984">63984</a></td><td>POI_Overall</td><td>Function AND / OR should treat missing parameters as FALSE</td>
+</tr>
+
+<tr>
+<td style="text-align: center;"><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63749">63749</a></td><td>POI_Overall</td><td>Make getFirstRowNum() and getFirstCellNum() return -1 consistently with empty data</td>
+</tr>
+
+<tr>
+<td style="text-align: center;"><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63569">63569</a></td><td>POI_Overall</td><td>Make IOUtils.setByteArrayMaxOverride() work correctly</td>
+</tr>
+
+<tr>
<td style="text-align: center;"><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63918">63918</a></td><td>SL_Common XSLF</td><td>Fix texture fill - scale stretched images correctly</td>
</tr>
@@ -249,6 +269,18 @@ document.write("Last Published: " + docu
<tr>
<td style="text-align: center;"><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63927">63927</a></td><td>POI_Overall</td><td>Inconsistent mapping of Norwegian locales for date formats</td>
</tr>
+
+<tr>
+<td style="text-align: center;"><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://github.com/apache/poi/pull/164">github-164</a></td><td>XSSF</td><td>Fix Bug in XSSFTable.setCellReferences when table is single cell</td>
+</tr>
+
+<tr>
+<td style="text-align: center;"><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64004">64004</a></td><td>POI_Overall</td><td>Replace Cloneable / clone() with copy constructor</td>
+</tr>
+
+<tr>
+<td style="text-align: center;"><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64036">64036</a></td><td>POI_Overall</td><td>Replace reflection calls in factories for Java 9+</td>
+</tr>
</tbody>
</table>
@@ -296,6 +328,26 @@ document.write("Last Published: " + docu
<tbody>
<tr>
+<td style="text-align: center;"><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63779">63779</a></td><td>SS_Common</td><td>Add support for the new Java date/time API added in Java 8</td>
+</tr>
+
+<tr>
+<td style="text-align: center;"><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=59322">59322</a></td><td>HWPF</td><td>Avoid NullPointerException when reading Word Document with tables and a cell with a null descriptor</td>
+</tr>
+
+<tr>
+<td style="text-align: center;"><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61490">61490</a></td><td>HWPF</td><td>Read cells of tables correctly in cases where the last cell is not 'fake'</td>
+</tr>
+
+<tr>
+<td style="text-align: center;"><img class="icon" alt="fix" src="images/fix.png"></td><td></td><td>HWPF</td><td>Do not use WeakReference for parents in Ranges to avoid spurious failures in tests</td>
+</tr>
+
+<tr>
+<td style="text-align: center;"><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63657">63657</a></td><td>XSSF</td><td>Fix regression with memory usage in XSSFRow.onDocumentWrite and some other temporary memory leaks</td>
+</tr>
+
+<tr>
<td style="text-align: center;"><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63842">63842</a></td><td>SS_Common</td><td>FractionFormat casts whole part of the value into 'int'</td>
</tr>
Modified: poi/site/publish/devel/index.html
URL: http://svn.apache.org/viewvc/poi/site/publish/devel/index.html?rev=1872137&r1=1872136&r2=1872137&view=diff
==============================================================================
--- poi/site/publish/devel/index.html (original)
+++ poi/site/publish/devel/index.html Tue Dec 31 11:03:55 2019
@@ -205,13 +205,17 @@ document.write("Last Published: " + docu
version 1.8 - 1.9.x for Java 1.6 and higher. Newer versions (1.10.x) require Java 8 or higher.
</p>
<p>
- Specifically the build has been tested to work with Ant version
- 1.9.9 and 1.10.1.
+ The current source code has been tested to work with Ant version 1.9.x and 1.10.x.
</p>
<p>
- Remember to set the ANT_HOME environment variable and add
+ Remember to set the ANT_HOME environment variable to where Ant was installed/extracted and add
ANT_HOME/bin to your shell's PATH.
</p>
+<p>
+ If you are unsure about the correct value for ANT_HOME, search your file system for "ant.jar".
+ This file will be in the directory %ANT_HOME%/lib." For example, if the path to ant.jar is
+ "C:/Programs/Ant/lib/ant.jar", then set ANT_HOME to "C:/Progams/Ant".
+ </p>
</div>
<a name="Install+Apache+Forrest"></a>
@@ -306,11 +310,15 @@ document.write("Last Published: " + docu
used to quickly get set up in the Eclipse IDE.
</p>
<p>
- In order to get started, first build Apache POI using Ant as described above
- to get all required 3rd party libraries downloaded.
+ First make sure that Java is set up properly and that you can execute the 'javac' executable in your shell.
+ </p>
+<p>
+ Next, open Eclipse and create either a local SVN repository, or a copy of the Git repository,
+ and import the project into Eclipse.
</p>
<p>
- Then import the project in Eclipse via File->Import->Existing Projects into Workspace.
+ Right-click on "build.xml", and select "Run As / Ant Build...". The "Edit Configuration"
+ dialog should appear. In the "Targets" tab, select the "Compile" target and click on "Run".
</p>
<p>
Note: when executing junit tests from within Eclipse, you might need to set the system
Modified: poi/site/src/documentation/content/xdocs/casestudies.xml
URL: http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/casestudies.xml?rev=1872137&r1=1872136&r2=1872137&view=diff
==============================================================================
--- poi/site/src/documentation/content/xdocs/casestudies.xml (original)
+++ poi/site/src/documentation/content/xdocs/casestudies.xml Tue Dec 31 11:03:55 2019
@@ -56,6 +56,36 @@
<section>
<title>Case Studies</title>
+ <section><title>WriteExcel Utilities</title>
+ <p>
+ This WriteExcel distribution package found at <a href="https://stevepritchard.ca/home/WriteExcel/overview.htm">WriteExcel Utilities</a> contains source,
+ documentation, examples, build tools and precompiled classes that wrap the Apache POI Excel interface.
+ </p>
+ <p>
+ WriteExcel creates a Workbook file using a simple interface that uses formatted strings as the primary way
+ of passing information to the support methods which interpret the strings and issue the necessary POI method calls.
+ Access to the <code>Workbook</code> object allows the POI methods to be called directly for cases not handled by the interface.
+ </p>
+ <p>
+ An existing Workbook file can be used as a template source so that sheets can be copied and then left intact, modified and/or supplemented.
+ </p>
+ <p>
+ The creation of Workbooks containing charts is supported by using an existing Workbook file as a template that contains one or more charts
+ and using WriteExcel to modify the data that the chart refers to.
+ </p>
+ <p>
+ The ReadExcelFile component of the package can be used to selectively iterate across existing Workbooks (or Workbooks under construction) and create
+ Java objects with the selected data which can then be forwarded for further processing.
+ <br/><br/>
+ WriteExcel was used to produce the monthly reporting files for a church accounting system among other things.
+ <br/><br/>
+ Steve Pritchard<br/>
+ Rexcel Systems Inc.<br/>
+ July, 2019<br/>
+ <a href="https://stevepritchard.ca">Steve Pritchard Utilities</a>
+ </p>
+ </section>
+
<section><title>Processing biometric scanner logs - Glassbeam</title>
<p>
As a small startup there is no attendance management system in place. So they have a manual register where
@@ -245,62 +275,62 @@ format,
<section>
<title>iDATA Development Ltd (IDD)</title>
<p>
- <a href="http://www.iexlsoftware.com/">IDD</a> have developed the iEXL product to
- generate Excel spreadsheets directly on the Iseries/AS400 IBM I on Power platform.
+ <a href="http://www.iexlsoftware.com/">IDD</a> have developed the iEXL product to
+ generate Excel spreadsheets directly on the Iseries/AS400 IBM I on Power platform.
</p>
<p>
Professional spreadsheets created via a menu system. Some basic programming is required for more complex options.
- When programming is required it can be carried out using RPG, SQL, QUERY, JAVA, COBOL etc.
+ When programming is required it can be carried out using RPG, SQL, QUERY, JAVA, COBOL etc.
In other words your existing staffs knowledge
</p>
<p>
- Design spreadsheets with:
+ Design spreadsheets with:
</p>
<ul>
- <li>Fonts down to cell level</li>
- <li>Colours (Background and text) down to cell level</li>
- <li>Shading down to cell level</li>
- <li>Cell patterns down to cell level</li>
- <li>Cell initialization</li>
- <li>Freeze Panes</li>
- <li>Passwords</li>
- <li>Images/Pictures both static and dynamic</li>
- <li>Headings</li>
- <li>Page breaks</li>
- <li>Sheet breaks</li>
- <li>Text insertion and much more</li>
+ <li>Fonts down to cell level</li>
+ <li>Colours (Background and text) down to cell level</li>
+ <li>Shading down to cell level</li>
+ <li>Cell patterns down to cell level</li>
+ <li>Cell initialization</li>
+ <li>Freeze Panes</li>
+ <li>Passwords</li>
+ <li>Images/Pictures both static and dynamic</li>
+ <li>Headings</li>
+ <li>Page breaks</li>
+ <li>Sheet breaks</li>
+ <li>Text insertion and much more</li>
<li>Functions/Formula</li>
<li>Merge cells</li>
<li>Row Height</li>
<li>Cell text alignment</li>
<li>Text Rotation </li>
<li>50 Database files per workbook.</li>
- <li>E-mail the spreadsheet</li>
+ <li>E-mail the spreadsheet</li>
</ul>
<p>
- The product name is 'iEXL' and has been live on both European and North American systems for over four years.
- It is being used in preference to more established commercial products which our clients have already purchased.
- This is due to cost and ease of use.
- </p>
+ The product name is 'iEXL' and has been live on both European and North American systems for over four years.
+ It is being used in preference to more established commercial products which our clients have already purchased.
+ This is due to cost and ease of use.
+ </p>
<p>
- All spreadsheets can be archived if required so that historical spreadsheets can be retrieved.
+ All spreadsheets can be archived if required so that historical spreadsheets can be retrieved.
</p>
<p>
- The system has benefits for all departments within an organisation.
- Examples of this are accounts department for things such as aged trial balance,
- distribution department for ASNâs, warehousing for stock figures, IS for security reporting etc.
+ The system has benefits for all departments within an organisation.
+ Examples of this are accounts department for things such as aged trial balance,
+ distribution department for ASNâs, warehousing for stock figures, IS for security reporting etc.
</p>
<p>
- Clients have at this point (June 2012) created over 300 spreadsheets which in turn have generated over
- 500,000 E-mails. iEXL has a menu driven email system.
+ Clients have at this point (June 2012) created over 300 spreadsheets which in turn have generated over
+ 500,000 E-mails. iEXL has a menu driven email system.
</p>
<p>
- Due to the Apache-POI project IDD have been able to create the IEXL product.
+ Due to the Apache-POI project IDD have been able to create the IEXL product.
This is a well priced product which allows companies of all sizes access to a product that opens up their reporting capabilities
</p>
<p>
- Within the <a href="http://www.iexlsoftware.com/">iEXLSOFTWARE.COM</a> website you will find a full user manual,
- installation instructions, a call log (Ticket) system and a downloadable 45 day trial version.
+ Within the <a href="http://www.iexlsoftware.com/">iEXLSOFTWARE.COM</a> website you will find a full user manual,
+ installation instructions, a call log (Ticket) system and a downloadable 45 day trial version.
</p>
<p>
<em>Author: Mark.D.Golden</em>
@@ -309,19 +339,19 @@ format,
<section>
<title>Ugly Duckling</title>
<p>
- <a href="http://uglyduckling.nl/">Ugly Duckling</a> focus on Software, Management and Finance.
- We have recently been using Apache POI to create tools for the mortgage group of
- <a href="https://www.abnamro.nl/en/personal/index.html">ABN AMRO</a> in the Netherlands.
+ <a href="http://uglyduckling.nl/">Ugly Duckling</a> focus on Software, Management and Finance.
+ We have recently been using Apache POI to create tools for the mortgage group of
+ <a href="https://www.abnamro.nl/en/personal/index.html">ABN AMRO</a> in the Netherlands.
During this project we created a number of what we call 'Robots' using the HSSF API.
</p>
<p>
- These <a href="http://uglyduckling.nl/work/robots/">robots</a> run as services on the network and
- help automate the processing of large amounts of data. Our Robots can be used to spot problems that
+ These <a href="http://uglyduckling.nl/work/robots/">robots</a> run as services on the network and
+ help automate the processing of large amounts of data. Our Robots can be used to spot problems that
a human might not, and also to automate repetitive tasks.
</p>
<p>
- We found Apache POI to be extremely useful. We took the base API, wrapped it in a builder pattern and
- thus created a DSL with a fluid interface. Throughout the project we enjoyed very much working with
+ We found Apache POI to be extremely useful. We took the base API, wrapped it in a builder pattern and
+ thus created a DSL with a fluid interface. Throughout the project we enjoyed very much working with
Apache POI and found it to be very reliable.
</p>
</section>
@@ -331,39 +361,39 @@ format,
<p>Deutsche Bahn uses POI's HWPF component to process complex specification documents stored in the legacy Microsoft Word file format.</p>
<p>
- In a joint effort with other international partners, <a href="http://fahrweg.dbnetze.com/fahrweg-en/start/company_aboutus/">Deutsche Bahn Netz AG</a>,
- the owner of the German rail infrastructure, developed a novel software toolchain to facilitate the creation of an interoperable on-board component
- for a pan-European train protection system. One part of this toolchain is a domain-specific specification processor which reads the relevant
- requirements documents using Apache POI, enhances them and ultimately stores their contents as <a href="http://www.omg.org/spec/ReqIF/">ReqIF</a>.
- Contrary to DOC, this XML-based file format allows for proper traceability and versioning in a multi-tenant environment. Thus, it lends itself much
- better to the management and interchange of large sets of system requirements. The resulting ReqIF files are then consumed by the various tools in
+ In a joint effort with other international partners, <a href="http://fahrweg.dbnetze.com/fahrweg-en/start/company_aboutus/">Deutsche Bahn Netz AG</a>,
+ the owner of the German rail infrastructure, developed a novel software toolchain to facilitate the creation of an interoperable on-board component
+ for a pan-European train protection system. One part of this toolchain is a domain-specific specification processor which reads the relevant
+ requirements documents using Apache POI, enhances them and ultimately stores their contents as <a href="http://www.omg.org/spec/ReqIF/">ReqIF</a>.
+ Contrary to DOC, this XML-based file format allows for proper traceability and versioning in a multi-tenant environment. Thus, it lends itself much
+ better to the management and interchange of large sets of system requirements. The resulting ReqIF files are then consumed by the various tools in
the later stages of the software development process.
</p>
<p>
- Currently available, off-the-shelf software for requirement import performed very poorly on the original specification documents due to their
- structural complexity and heterogeneous formatting. POI not only helped to create a superior solution thanks to its rich API. Because of its
- open-source nature it also plays a key role in ensuring the maintainability of the resulting system which is expected to stay in operation for
+ Currently available, off-the-shelf software for requirement import performed very poorly on the original specification documents due to their
+ structural complexity and heterogeneous formatting. POI not only helped to create a superior solution thanks to its rich API. Because of its
+ open-source nature it also plays a key role in ensuring the maintainability of the resulting system which is expected to stay in operation for
many decades to come.
</p>
<p>
- POI has seen various enhancements for this challenging application. Most notably, these include the addition of extensive list numbering support,
- a feature which is now part of Apache TIKA. Numerous smaller improvements, such as support for table cell background shadings, interpretation of
- certain kinds of OfficeDrawings, and proper conversion of special characters, also helped to derive meaning from the input files. See
+ POI has seen various enhancements for this challenging application. Most notably, these include the addition of extensive list numbering support,
+ a feature which is now part of Apache TIKA. Numerous smaller improvements, such as support for table cell background shadings, interpretation of
+ certain kinds of OfficeDrawings, and proper conversion of special characters, also helped to derive meaning from the input files. See
<a href="http://nbn-resolving.de/urn:nbn:de:bsz:14-qucosa-182866">here</a> for details.
</p>
<p>
- This work was funded by the German Federal Ministry of Education and Research (Grant No. 01IS12021) in the context of the ITEA2 project
+ This work was funded by the German Federal Ministry of Education and Research (Grant No. 01IS12021) in the context of the ITEA2 project
<a href="http://openetcs.org/">openETCS</a>.
</p>
- </section>
-
+ </section>
+
</section>
</body>
<footer>
<legal>
Copyright (c) @year@ The Apache Software Foundation All rights reserved.
<br />
- Apache POI, POI, Apache, the Apache feather logo, and the Apache
+ Apache POI, POI, Apache, the Apache feather logo, and the Apache
POI project logo are trademarks of The Apache Software Foundation.
</legal>
</footer>
Modified: poi/site/src/documentation/content/xdocs/changes.xml
URL: http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/changes.xml?rev=1872137&r1=1872136&r2=1872137&view=diff
==============================================================================
--- poi/site/src/documentation/content/xdocs/changes.xml (original)
+++ poi/site/src/documentation/content/xdocs/changes.xml Tue Dec 31 11:03:55 2019
@@ -88,6 +88,11 @@
<release version="4.1.2" date="2020-01-??">
<actions>
+ <action dev="PD" type="fix" fixes-bug="63700" context="POI_Overall">Make D* functions work with numeric result column</action>
+ <action dev="PD" type="fix" fixes-bug="63960" context="POI_Overall">Write pre-evaluated string-values in formula cells with the correct type</action>
+ <action dev="PD" type="fix" fixes-bug="63984" context="POI_Overall">Function AND / OR should treat missing parameters as FALSE</action>
+ <action dev="PD" type="fix" fixes-bug="63749" context="POI_Overall">Make getFirstRowNum() and getFirstCellNum() return -1 consistently with empty data</action>
+ <action dev="PD" type="fix" fixes-bug="63569" context="POI_Overall">Make IOUtils.setByteArrayMaxOverride() work correctly</action>
<action dev="PD" type="fix" fixes-bug="63918" context="SL_Common XSLF">Fix texture fill - scale stretched images correctly</action>
<action dev="PD" type="add" context="XSLF">Add, insert and remove columns on XSLFTable</action>
<action dev="PD" type="fix" fixes-bug="63889" context="XDDF">Produce valid PPTX file with several chart series</action>
@@ -97,7 +102,7 @@
<action dev="PD" type="fix" fixes-bug="github-164" context="XSSF">Fix Bug in XSSFTable.setCellReferences when table is single cell</action>
<action dev="PD" type="fix" fixes-bug="64004" context="POI_Overall">Replace Cloneable / clone() with copy constructor</action>
<action dev="PD" type="fix" fixes-bug="64036" context="POI_Overall">Replace reflection calls in factories for Java 9+</action>
-cd </actions>
+ </actions>
</release>
<release version="4.1.1" date="2019-10-20">
@@ -111,6 +116,11 @@ cd </actions>
<summary-item>CVE-2019-12415 - XML External Entity (XXE) Processing in Apache POI</summary-item>
</summary>
<actions>
+ <action dev="PD" type="add" fixes-bug="63779" context="SS_Common">Add support for the new Java date/time API added in Java 8</action>
+ <action dev="PD" type="fix" fixes-bug="59322" context="HWPF">Avoid NullPointerException when reading Word Document with tables and a cell with a null descriptor</action>
+ <action dev="PD" type="fix" fixes-bug="61490" context="HWPF">Read cells of tables correctly in cases where the last cell is not 'fake'</action>
+ <action dev="PD" type="fix" context="HWPF">Do not use WeakReference for parents in Ranges to avoid spurious failures in tests</action>
+ <action dev="PD" type="fix" fixes-bug="63657" context="XSSF">Fix regression with memory usage in XSSFRow.onDocumentWrite and some other temporary memory leaks</action>
<action dev="PD" type="fix" fixes-bug="63842" context="SS_Common">FractionFormat casts whole part of the value into 'int'</action>
<action dev="PD" type="fix" fixes-bug="63818" context="HSLF">Allow multiple charsets for same font typeface</action>
<action dev="PD" type="fix" fixes-bug="63768" context="XSSF">XSSFExportToXml adjust settings on SchemaFactory</action>
Modified: poi/site/src/documentation/content/xdocs/devel/index.xml
URL: http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/devel/index.xml?rev=1872137&r1=1872136&r2=1872137&view=diff
==============================================================================
--- poi/site/src/documentation/content/xdocs/devel/index.xml (original)
+++ poi/site/src/documentation/content/xdocs/devel/index.xml Tue Dec 31 11:03:55 2019
@@ -49,13 +49,17 @@
version 1.8 - 1.9.x for Java 1.6 and higher. Newer versions (1.10.x) require Java 8 or higher.
</p>
<p>
- Specifically the build has been tested to work with Ant version
- 1.9.9 and 1.10.1.
+ The current source code has been tested to work with Ant version 1.9.x and 1.10.x.
</p>
<p>
- Remember to set the ANT_HOME environment variable and add
+ Remember to set the ANT_HOME environment variable to where Ant was installed/extracted and add
ANT_HOME/bin to your shell's PATH.
</p>
+ <p>
+ If you are unsure about the correct value for ANT_HOME, search your file system for "ant.jar".
+ This file will be in the directory %ANT_HOME%/lib." For example, if the path to ant.jar is
+ "C:/Programs/Ant/lib/ant.jar", then set ANT_HOME to "C:/Progams/Ant".
+ </p>
</section>
<section>
<title>Install Apache Forrest</title>
@@ -119,11 +123,15 @@
used to quickly get set up in the Eclipse IDE.
</p>
<p>
- In order to get started, first build Apache POI using Ant as described above
- to get all required 3rd party libraries downloaded.
+ First make sure that Java is set up properly and that you can execute the 'javac' executable in your shell.
+ </p>
+ <p>
+ Next, open Eclipse and create either a local SVN repository, or a copy of the Git repository,
+ and import the project into Eclipse.
</p>
<p>
- Then import the project in Eclipse via File->Import->Existing Projects into Workspace.
+ Right-click on "build.xml", and select "Run As / Ant Build...". The "Edit Configuration"
+ dialog should appear. In the "Targets" tab, select the "Compile" target and click on "Run".
</p>
<p>
Note: when executing junit tests from within Eclipse, you might need to set the system
Modified: poi/site/src/documentation/content/xdocs/related-projects.xml
URL: http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/related-projects.xml?rev=1872137&r1=1872136&r2=1872137&view=diff
==============================================================================
--- poi/site/src/documentation/content/xdocs/related-projects.xml (original)
+++ poi/site/src/documentation/content/xdocs/related-projects.xml Tue Dec 31 11:03:55 2019
@@ -54,7 +54,7 @@
<a href="https://incubator.apache.org/odftoolkit/">Apache ODF Toolkit (incubating)</a> is a set of Java modules that allow programmatic creation, scanning and manipulation of OpenDocument Format (ISO/IEC 26300 == ODF) documents.
</p>
</section>
-
+
<section><title>Apache Corinthia (retired)</title>
<p>
<a href="https://corinthia.incubator.apache.org/">Apache Corinthia (incubating)</a> is a toolkit/application written in C++ for converting between and editing common office file formats, with an initial focus on word processing.
@@ -70,23 +70,23 @@
</section>
<section><title>poi-mail-merge</title>
<p>
- <a href="https://github.com/centic9/poi-mail-merge">poi-mail-merge</a> is a small tool to automate mail-merges, i.e. replacing strings in a template Microsoft Word file multiple times with data from a list of replacements
- provided as Excel/CSV data. Available under the BSD 2-Clause License.
+ <a href="https://github.com/centic9/poi-mail-merge">poi-mail-merge</a> is a small tool to automate mail-merges, i.e. replacing strings in a template Microsoft Word file multiple times with data from a list of replacements
+ provided as Excel/CSV data. Available under the BSD 2-Clause License.
</p>
</section>
<section><title>poi-visio</title>
<p>Merged into POI as of version 3.14</p>
<p>
- <a href="https://github.com/BBN-D/poi-visio">poi-visio</a> is a Java library that loads Visio OOXML (vsdx) files and creates an in-memory data structure that allows full access to the contents of the document.
- There is built-in support for easily traversing the content of the document in a structured way, and can render pages to simplified PNG files, or other backends supported by Java AWT.
+ <a href="https://github.com/BBN-D/poi-visio">poi-visio</a> is a Java library that loads Visio OOXML (vsdx) files and creates an in-memory data structure that allows full access to the contents of the document.
+ There is built-in support for easily traversing the content of the document in a structured way, and can render pages to simplified PNG files, or other backends supported by Java AWT.
Currently the library only operates in read-only mode, but its design does not exclude being able to modify existing documents or creating new documents.
Available under the Apache License, Version 2.0.
</p>
</section>
<section><title>poi-visio-graph</title>
<p>
- <a href="https://github.com/BBN-D/poi-visio-graph">poi-visio-graph</a> is a Java library that loads Visio OOXML (vsdx) files using the poi-visio library and creates an in-memory graph structure from the objects present on the page.
- It utilizes user-specified connection points and also performs analysis to infer logical visual connection points between the objects on each page.
+ <a href="https://github.com/BBN-D/poi-visio-graph">poi-visio-graph</a> is a Java library that loads Visio OOXML (vsdx) files using the poi-visio library and creates an in-memory graph structure from the objects present on the page.
+ It utilizes user-specified connection points and also performs analysis to infer logical visual connection points between the objects on each page.
One possible use of this library is to create a network diagram from a Visio document.
Available under the Apache License, Version 2.0.
</p>
@@ -104,7 +104,7 @@
</section>
<section><title>Excel module for Apache Isis</title>
<p>
- <a href="https://github.com/isisaddons/isis-module-excel">Excel module for Apache Isis</a> is an add on for Apache Isis and provides a domain service so that a collection of (view model)
+ <a href="https://github.com/isisaddons/isis-module-excel">Excel module for Apache Isis</a> is an add on for Apache Isis and provides a domain service so that a collection of (view model)
object scan be exported to an Excel spreadsheet, or recreated by importing from Excel.
Available under the Apache License, Version 2.0.
</p>
@@ -170,7 +170,7 @@
<legal>
Copyright (c) @year@ The Apache Software Foundation All rights reserved.
<br />
- Apache POI, POI, Apache, the Apache feather logo, and the Apache
+ Apache POI, POI, Apache, the Apache feather logo, and the Apache
POI project logo are trademarks of The Apache Software Foundation.
</legal>
</footer>
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org