Author: centic
Date: Mon Mar 28 20:47:01 2016
New Revision: 1736926
URL: http://svn.apache.org/viewvc?rev=1736926&view=rev
Log:
Docs: Add quick-guide for PivotTables, changelog, link to FrostedSheets and
point to the sources of openxml4j
Modified:
poi/site/publish/changes.html
poi/site/publish/changes.rss
poi/site/publish/oxml4j/index.html
poi/site/publish/related-projects.html
poi/site/publish/spreadsheet/quick-guide.html
poi/site/src/documentation/content/xdocs/oxml4j/index.xml
poi/site/src/documentation/content/xdocs/related-projects.xml
poi/site/src/documentation/content/xdocs/spreadsheet/quick-guide.xml
poi/site/src/documentation/content/xdocs/status.xml
Modified: poi/site/publish/changes.html
URL:
http://svn.apache.org/viewvc/poi/site/publish/changes.html?rev=1736926&r1=1736925&r2=1736926&view=diff
==============================================================================
--- poi/site/publish/changes.html (original)
+++ poi/site/publish/changes.html Mon Mar 28 20:47:01 2016
@@ -265,6 +265,9 @@ if (VERSION > 3) {
<ul>
<li>
+<img class="icon" alt="fix" src="images/fix.jpg"> <a
href="https://bz.apache.org/bugzilla/show_bug.cgi?id=59199";>59199</a> -
Gracefully handle null-values in Cell.setValue() for Date and Calendar similar
to String.</li>
+
+<li>
<img class="icon" alt="fix" src="images/fix.jpg"> <a
href="https://bz.apache.org/bugzilla/show_bug.cgi?id=59224";>59224</a> - XSSF:
fix XSSFColor.hasTint which incorrectly used the alpha channel, add
XSSFColor.hasAlpha</li>
<li>
@@ -286,7 +289,7 @@ if (VERSION > 3) {
<img class="icon" alt="fix" src="images/fix.jpg"> <a
href="https://bz.apache.org/bugzilla/show_bug.cgi?id=55791";>55791</a> - Avoid
using an existing file-name when creating a new slide, it could still be left
over from previous partial removal</li>
<li>
-<img class="icon" alt="fix" src="images/fix.jpg"> <a
href="https://bz.apache.org/bugzilla/show_bug.cgi?id=55668";>55668</a> - Try to
avoid NullPointerException by seting the cell to BLANK instead, when changing
cell-type and a formula leads to null-string</li>
+<img class="icon" alt="fix" src="images/fix.jpg"> <a
href="https://bz.apache.org/bugzilla/show_bug.cgi?id=55668";>55668</a> - Try to
avoid NullPointerException by setting the cell to BLANK instead, when changing
cell-type and a formula leads to null-string</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg"> <a
href="https://bz.apache.org/bugzilla/show_bug.cgi?id=59135";>59135</a> -
Password gets truncated when using passwords longer than 15 characters for the
function protectSheet()</li>
Modified: poi/site/publish/changes.rss
URL:
http://svn.apache.org/viewvc/poi/site/publish/changes.rss?rev=1736926&r1=1736925&r2=1736926&view=diff
==============================================================================
--- poi/site/publish/changes.rss (original)
+++ poi/site/publish/changes.rss Mon Mar 28 20:47:01 2016
@@ -1,3 +1,3 @@
<?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>http://poi.apache.org/changes.html</link><description>Apache
POI Changes</description><language>en-us</language><item><title> fix(bug
59224)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug 59224) - XSSF: fix XSSFColor.hasTint which incorrectly
used the alpha channel, add
XSSFColor.hasAlpha</description></item><item><title> fix(bug
59222)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug 59222) - XSSF: fix NPE raised by
XSSFSheet.getCellComments()</description></item><item><title> fix(bug
59212)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug 59212) - Common SS: copy non-validating
XSSFSheet.addMergedRegionUnsafe from bug 58885 to Sheet
interface</description></item><item><title> fix(bug
59208)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Develope
rs (bug 59208) - XWPF: bold xml value of "1" treated as
false</description></item><item><title>
add</title><link>http://poi.apache.org/changes.html</link><description> add by
POI Developers - HSLF: Add support for system
colors</description></item><item><title> fix(bug
56930)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug 56930) - Add Workbook.getNames() to allow to query for
names that appear multiple times</description></item><item><title> fix(bug
55791)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug 55791) - Avoid using an existing file-name when creating
a new slide, it could still be left over from previous partial
removal</description></item><item><title> fix(bug
55668)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug 55668) - Try to avoid NullPointerException by seting the
cell to BLANK instead, when changing cell-type and a formula lea
ds to null-string</description></item><item><title> fix(bug
59135)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug 59135) - Password gets truncated when using passwords
longer than 15 characters for the function
protectSheet()</description></item><item><title> add(bug
56549)</title><link>http://poi.apache.org/changes.html</link><description> add
by POI Developers (bug 56549) - Correctly calculate char index ranges for HWPF
in the TextPieceTable</description></item><item><title> add(bug
57495)</title><link>http://poi.apache.org/changes.html</link><description> add
by POI Developers (bug 57495) - Fix problem with tables in documents at pos
0</description></item><item><title>
fix</title><link>http://poi.apache.org/changes.html</link><description> fix by
POI Developers - Fix a number of edge-cases where file-handles would be
leaked</description></item><item><title> fix(bug
59170)</title><link>http://poi.apache.org/changes.html</link><descri
ption> fix by POI Developers (bug 59170) - Remove deprecated classes (POI
3.15) -
*Workbook.setRepeatingRowsAndColumns()</description></item><item><title>
fix(bug
59170)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug 59170) - Remove deprecated classes (POI 3.15) -
org.apache.poi.hssf/ss.util.Region</description></item><item><title> add(bug
57031)</title><link>http://poi.apache.org/changes.html</link><description> add
by POI Developers (bug 57031) - Out of Memory when extracting text from
attached files</description></item><item><title>
fix</title><link>http://poi.apache.org/changes.html</link><description> fix by
POI Developers - More helpful exception when POIFSFileSystem is given a raw XML
file</description></item><item><title>
fix</title><link>http://poi.apache.org/changes.html</link><description> fix by
POI Developers - More helpful exceptions when OPCPackage is given OLE2 or ODF
or raw XML files</description></item></channel></rss
>
\ No newline at end of file
+<rss version="0.91"><channel><title>Apache POI
Changes</title><link>http://poi.apache.org/changes.html</link><description>Apache
POI Changes</description><language>en-us</language><item><title> fix(bug
59199)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug 59199) - Gracefully handle null-values in
Cell.setValue() for Date and Calendar similar to
String.</description></item><item><title> fix(bug
59224)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug 59224) - XSSF: fix XSSFColor.hasTint which incorrectly
used the alpha channel, add
XSSFColor.hasAlpha</description></item><item><title> fix(bug
59222)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug 59222) - XSSF: fix NPE raised by
XSSFSheet.getCellComments()</description></item><item><title> fix(bug
59212)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug
59212) - Common SS: copy non-validating XSSFSheet.addMergedRegionUnsafe from
bug 58885 to Sheet interface</description></item><item><title> fix(bug
59208)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug 59208) - XWPF: bold xml value of "1" treated as
false</description></item><item><title>
add</title><link>http://poi.apache.org/changes.html</link><description> add by
POI Developers - HSLF: Add support for system
colors</description></item><item><title> fix(bug
56930)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug 56930) - Add Workbook.getNames() to allow to query for
names that appear multiple times</description></item><item><title> fix(bug
55791)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug 55791) - Avoid using an existing file-name when creating
a new slide, it could still be left over from previous partial
removal</description></item><i
tem><title> fix(bug
55668)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug 55668) - Try to avoid NullPointerException by setting
the cell to BLANK instead, when changing cell-type and a formula leads to
null-string</description></item><item><title> fix(bug
59135)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug 59135) - Password gets truncated when using passwords
longer than 15 characters for the function
protectSheet()</description></item><item><title> add(bug
56549)</title><link>http://poi.apache.org/changes.html</link><description> add
by POI Developers (bug 56549) - Correctly calculate char index ranges for HWPF
in the TextPieceTable</description></item><item><title> add(bug
57495)</title><link>http://poi.apache.org/changes.html</link><description> add
by POI Developers (bug 57495) - Fix problem with tables in documents at pos
0</description></item><item><title> fix</title><link>http://
poi.apache.org/changes.html</link><description> fix by POI Developers - Fix a
number of edge-cases where file-handles would be
leaked</description></item><item><title> fix(bug
59170)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug 59170) - Remove deprecated classes (POI 3.15) -
*Workbook.setRepeatingRowsAndColumns()</description></item><item><title>
fix(bug
59170)</title><link>http://poi.apache.org/changes.html</link><description> fix
by POI Developers (bug 59170) - Remove deprecated classes (POI 3.15) -
org.apache.poi.hssf/ss.util.Region</description></item><item><title> add(bug
57031)</title><link>http://poi.apache.org/changes.html</link><description> add
by POI Developers (bug 57031) - Out of Memory when extracting text from
attached files</description></item><item><title>
fix</title><link>http://poi.apache.org/changes.html</link><description> fix by
POI Developers - More helpful exception when POIFSFileSystem is given a raw XML
file
</description></item><item><title>
fix</title><link>http://poi.apache.org/changes.html</link><description> fix by
POI Developers - More helpful exceptions when OPCPackage is given OLE2 or ODF
or raw XML files</description></item></channel></rss>
\ No newline at end of file
Modified: poi/site/publish/oxml4j/index.html
URL:
http://svn.apache.org/viewvc/poi/site/publish/oxml4j/index.html?rev=1736926&r1=1736925&r2=1736926&view=diff
==============================================================================
--- poi/site/publish/oxml4j/index.html (original)
+++ poi/site/publish/oxml4j/index.html Mon Mar 28 20:47:01 2016
@@ -135,10 +135,11 @@ if (VERSION > 3) {
</div>
-<p>OpenXML4J was originally developed by
+<p>OpenXML4J was originally developed by
<a
href="http://web.archive.org/web/20090611063015/http://www.openxml4j.org/";>openxml4j.org</a>,
- and was contributed to Apache POI in 2008. Thanks to the
- support and guidance of Julien Chable</p>
+ and was contributed to Apache POI in 2008. The original code is
available at
+ <a
href="https://sourceforge.net/projects/openxml4j/";>https://sourceforge.net/projects/openxml4j/</a>.
+ Thanks to the support and guidance of Julien Chable</p>
Modified: poi/site/publish/related-projects.html
URL:
http://svn.apache.org/viewvc/poi/site/publish/related-projects.html?rev=1736926&r1=1736925&r2=1736926&view=diff
==============================================================================
--- poi/site/publish/related-projects.html (original)
+++ poi/site/publish/related-projects.html Mon Mar 28 20:47:01 2016
@@ -432,6 +432,19 @@ if (VERSION > 3) {
XDocReport code is license under MIT license but the
samples are licensed under LGPL license.
</p>
+
+<a name="Frosted+Sheets"></a>
+<div class="h4">
+<h4>Frosted Sheets</h4>
+</div>
+
+<p>
+
+<a href="https://bitbucket.org/erosa/frostedsheets/overview";>Frosted
Sheets</a> is a Groovy library which provides decorators for Apache POI
spreadsheets, making it easier to work with spreadsheets
+ in Groovy.
+ Frosted Sheets is license under the Apache License,
Version 2.0.
+ </p>
+
Modified: poi/site/publish/spreadsheet/quick-guide.html
URL:
http://svn.apache.org/viewvc/poi/site/publish/spreadsheet/quick-guide.html?rev=1736926&r1=1736925&r2=1736926&view=diff
==============================================================================
--- poi/site/publish/spreadsheet/quick-guide.html (original)
+++ poi/site/publish/spreadsheet/quick-guide.html Mon Mar 28 20:47:01 2016
@@ -369,6 +369,10 @@ if (VERSION > 3) {
<li>
<a href="#CellProperties">Setting Cell Properties</a>
</li>
+
+<li>
+<a href="#PivotTable">Create a Pivot Table</a>
+</li>
</ul>
@@ -3009,7 +3013,37 @@ the data to populate another drop down l
cell's existing style properties. If a property already exists, it is
replaced with the new property. If a property does not
exist, it is added. This method will not remove CellStyle properties.
</p>
+
+
+<a name="PivotTable"></a>
+ <a name="Creating+a+Pivot+Table"></a>
+<div class="h3">
+<h3>Creating a Pivot Table</h3>
+</div>
+<p>
+ Pivot Tables are a powerful feature of spreadsheet files. You can
create a pivot table with the following piece of code.
+ </p>
+
+<pre class="code">
+ XSSFWorkbook wb = new XSSFWorkbook();
+ XSSFSheet sheet = wb.createSheet();
+
+ //Create some data to build the pivot table on
+ setCellData(sheet);
+
+ XSSFPivotTable pivotTable = sheet.createPivotTable(new
AreaReference("A1:D4"), new CellReference("H5"));
+ //Configure the pivot table
+ //Use first column as row label
+ pivotTable.addRowLabel(0);
+ //Sum up the second column
+ pivotTable.addColumnLabel(DataConsolidateFunction.SUM, 1);
+ //Set the third column as filter
+ pivotTable.addColumnLabel(DataConsolidateFunction.AVERAGE, 2);
+ //Add filter on forth column
+ pivotTable.addReportFilter(3);
+ </pre>
+
</div>
Modified: poi/site/src/documentation/content/xdocs/oxml4j/index.xml
URL:
http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/oxml4j/index.xml?rev=1736926&r1=1736925&r2=1736926&view=diff
==============================================================================
--- poi/site/src/documentation/content/xdocs/oxml4j/index.xml (original)
+++ poi/site/src/documentation/content/xdocs/oxml4j/index.xml Mon Mar 28
20:47:01 2016
@@ -35,10 +35,11 @@
</section>
<section>
<title>History</title>
- <p>OpenXML4J was originally developed by
+ <p>OpenXML4J was originally developed by
<link
href="http://web.archive.org/web/20090611063015/http://www.openxml4j.org/";>openxml4j.org</link>,
- and was contributed to Apache POI in 2008. Thanks to the
- support and guidance of Julien Chable</p>
+ and was contributed to Apache POI in 2008. The original code is
available at
+ <link
href="https://sourceforge.net/projects/openxml4j/";>https://sourceforge.net/projects/openxml4j/</link>.
+ Thanks to the support and guidance of Julien Chable</p>
</section>
</body>
</document>
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=1736926&r1=1736925&r2=1736926&view=diff
==============================================================================
--- poi/site/src/documentation/content/xdocs/related-projects.xml (original)
+++ poi/site/src/documentation/content/xdocs/related-projects.xml Mon Mar 28
20:47:01 2016
@@ -116,6 +116,13 @@
XDocReport code is license under MIT license but the
samples are licensed under LGPL license.
</p>
</section>
+ <section><title>Frosted Sheets</title>
+ <p>
+ <link
href="https://bitbucket.org/erosa/frostedsheets/overview";>Frosted Sheets</link>
is a Groovy library which provides decorators for Apache POI spreadsheets,
making it easier to work with spreadsheets
+ in Groovy.
+ Frosted Sheets is license under the Apache License,
Version 2.0.
+ </p>
+ </section>
</section>
</body>
<footer>
Modified: poi/site/src/documentation/content/xdocs/spreadsheet/quick-guide.xml
URL:
http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/spreadsheet/quick-guide.xml?rev=1736926&r1=1736925&r2=1736926&view=diff
==============================================================================
--- poi/site/src/documentation/content/xdocs/spreadsheet/quick-guide.xml
(original)
+++ poi/site/src/documentation/content/xdocs/spreadsheet/quick-guide.xml Mon
Mar 28 20:47:01 2016
@@ -75,6 +75,7 @@
<li><link href="#ConditionalFormatting">Conditional
Formatting</link></li>
<li><link href="#Hiding">Hiding and Un-Hiding
Rows</link></li>
<li><link href="#CellProperties">Setting Cell
Properties</link></li>
+ <li><link href="#PivotTable">Create a Pivot
Table</link></li>
</ul>
</section>
<section><title>Features</title>
@@ -2202,6 +2203,30 @@ the data to populate another drop down l
cell's existing style properties. If a property already exists, it is
replaced with the new property. If a property does not
exist, it is added. This method will not remove CellStyle properties.
</p>
- </section>
+ </section>
+ <anchor id="PivotTable"/>
+ <section><title>Creating a Pivot Table</title>
+ <p>
+ Pivot Tables are a powerful feature of spreadsheet files. You can
create a pivot table with the following piece of code.
+ </p>
+ <source>
+ XSSFWorkbook wb = new XSSFWorkbook();
+ XSSFSheet sheet = wb.createSheet();
+
+ //Create some data to build the pivot table on
+ setCellData(sheet);
+
+ XSSFPivotTable pivotTable = sheet.createPivotTable(new
AreaReference("A1:D4"), new CellReference("H5"));
+ //Configure the pivot table
+ //Use first column as row label
+ pivotTable.addRowLabel(0);
+ //Sum up the second column
+ pivotTable.addColumnLabel(DataConsolidateFunction.SUM, 1);
+ //Set the third column as filter
+ pivotTable.addColumnLabel(DataConsolidateFunction.AVERAGE, 2);
+ //Add filter on forth column
+ pivotTable.addReportFilter(3);
+ </source>
+ </section>
</body>
</document>
Modified: poi/site/src/documentation/content/xdocs/status.xml
URL:
http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/status.xml?rev=1736926&r1=1736925&r2=1736926&view=diff
==============================================================================
--- poi/site/src/documentation/content/xdocs/status.xml (original)
+++ poi/site/src/documentation/content/xdocs/status.xml Mon Mar 28 20:47:01 2016
@@ -40,6 +40,7 @@
</devs>
<release version="3.15-beta1" date="2016-07-??">
+ <action dev="PD" type="fix" fixes-bug="59199">Gracefully handle
null-values in Cell.setValue() for Date and Calendar similar to String.</action>
<action dev="PD" type="fix" fixes-bug="59224">XSSF: fix
XSSFColor.hasTint which incorrectly used the alpha channel, add
XSSFColor.hasAlpha</action>
<action dev="PD" type="fix" fixes-bug="59222">XSSF: fix NPE raised by
XSSFSheet.getCellComments()</action>
<action dev="PD" type="fix" fixes-bug="59212">Common SS: copy
non-validating XSSFSheet.addMergedRegionUnsafe from bug 58885 to Sheet
interface</action>
@@ -47,7 +48,7 @@
<action dev="PD" type="add">HSLF: Add support for system
colors</action>
<action dev="PD" type="fix" fixes-bug="56930">Add Workbook.getNames()
to allow to query for names that appear multiple times</action>
<action dev="PD" type="fix" fixes-bug="55791">Avoid using an existing
file-name when creating a new slide, it could still be left over from previous
partial removal</action>
- <action dev="PD" type="fix" fixes-bug="55668">Try to avoid
NullPointerException by seting the cell to BLANK instead, when changing
cell-type and a formula leads to null-string</action>
+ <action dev="PD" type="fix" fixes-bug="55668">Try to avoid
NullPointerException by setting the cell to BLANK instead, when changing
cell-type and a formula leads to null-string</action>
<action dev="PD" type="fix" fixes-bug="59135">Password gets truncated
when using passwords longer than 15 characters for the function
protectSheet()</action>
<action dev="PD" type="add" fixes-bug="56549">Correctly calculate char
index ranges for HWPF in the TextPieceTable</action>
<action dev="PD" type="add" fixes-bug="57495">Fix problem with tables
in documents at pos 0</action>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
