Author: kiwiwings
Date: Sun Dec 13 15:56:07 2020
New Revision: 1884384
URL: http://svn.apache.org/viewvc?rev=1884384&view=rev
Log:
update website
Modified:
poi/site/publish/changes.html
poi/site/publish/components/index.html
poi/site/publish/components/poi-jvm-languages.html
poi/site/publish/components/slideshow/ppt-wmf-emf-renderer.html
poi/site/publish/components/spreadsheet/excelant.html
poi/site/publish/devel/index.html
poi/site/publish/help/faq.html
Modified: poi/site/publish/changes.html
URL:
http://svn.apache.org/viewvc/poi/site/publish/changes.html?rev=1884384&r1=1884383&r2=1884384&view=diff
==============================================================================
--- poi/site/publish/changes.html (original)
+++ poi/site/publish/changes.html Sun Dec 13 15:56:07 2020
@@ -235,7 +235,7 @@ document.write("Last Published: " + docu
<li>removed deprecated code</li>
-<li>ooxml-security is part of ooxml-schemas now and won't be provided
separately</li>
+<li>ooxml-security is part of poi-ooxml-full (known as ooxml-schemas) now and
won't be provided separately</li>
<li>new experimental DeferredSXSSFWorkbook which avoids temp files by lazily
generating rows (see DeferredGeneration in poi-examples)</li>
@@ -383,6 +383,30 @@ document.write("Last Published: " + docu
<tr class="action">
<td><img class="icon" alt="fix" src="images/fix.png"></td><td><a
href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64964";>64964</a></td><td>SS_Common</td><td>Converting
cell values to boolean should throw IllegalStateException instead of
RuntimeException when conversion is not possible</td>
</tr>
+
+<tr class="action">
+<td><img class="icon" alt="fix" src="images/fix.png"></td><td><a
href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64971";>64971</a></td><td>XSSF</td><td>XSSFFont
setCharset(FontCharset) should use latest class instead of deprecated one</td>
+</tr>
+
+<tr class="action">
+<td><img class="icon" alt="fix" src="images/fix.png"></td><td><a
href="https://bz.apache.org/bugzilla/show_bug.cgi?id=60397";>60397</a></td><td>XSSF</td><td>Improve
performance of cell merge</td>
+</tr>
+
+<tr class="action">
+<td><img class="icon" alt="fix" src="images/fix.png"></td><td><a
href="https://github.com/apache/poi/pull/206";>github-206</a></td><td>SXSSF</td><td>Improve
performance of SXSSF cell evaluation</td>
+</tr>
+
+<tr class="action">
+<td><img class="icon" alt="fix" src="images/fix.png"></td><td><a
href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64976";>64976</a></td><td>SS_Common</td><td>Change
some methods to return ints instead of shorts (Font and CellStyle)</td>
+</tr>
+
+<tr class="action">
+<td><img class="icon" alt="fix" src="images/fix.png"></td><td><a
href="https://bz.apache.org/bugzilla/show_bug.cgi?id=56205";>56205</a></td><td>OOXML</td><td>Upgrade
OOXML schema to 3rd edition (transitional)</td>
+</tr>
+
+<tr class="action">
+<td><img class="icon" alt="fix" src="images/fix.png"></td><td><a
href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64979";>64979</a></td><td>OOXML</td><td>Change
artifact names of poi-/ooxml-schemas</td>
+</tr>
</tbody>
</table>
@@ -394,7 +418,7 @@ document.write("Last Published: " + docu
4.1.2 (2020-02-17)
</h2>
<div class="section">
-<a name="Summary-N1025C"></a>
+<a name="Summary-N102BC"></a>
<h3 class="boxed">Summary</h3>
<ul>
@@ -409,7 +433,7 @@ document.write("Last Published: " + docu
<li>updated dependencies to Bouncycastle 1.64</li>
</ul>
-<a name="Changes-N10272"></a>
+<a name="Changes-N102D2"></a>
<h3 class="boxed">Changes</h3>
<table class="POITable">
<colgroup>
@@ -543,7 +567,7 @@ document.write("Last Published: " + docu
4.1.1 (2019-10-20)
</h2>
<div class="section">
-<a name="Summary-N1043D"></a>
+<a name="Summary-N1049D"></a>
<h3 class="boxed">Summary</h3>
<ul>
@@ -562,7 +586,7 @@ document.write("Last Published: " + docu
<li>CVE-2019-12415 - XML External Entity (XXE) Processing in Apache POI</li>
</ul>
-<a name="Changes-N10459"></a>
+<a name="Changes-N104B9"></a>
<h3 class="boxed">Changes</h3>
<table class="POITable">
<colgroup>
@@ -712,7 +736,7 @@ document.write("Last Published: " + docu
4.1.0 (2019-04-09)
</h2>
<div class="section">
-<a name="Summary-N10661"></a>
+<a name="Summary-N106C1"></a>
<h3 class="boxed">Summary</h3>
<ul>
@@ -737,7 +761,7 @@ document.write("Last Published: " + docu
<li>Upgrade to XMLSec 2.1.2</li>
</ul>
-<a name="Changes-N10686"></a>
+<a name="Changes-N106E6"></a>
<h3 class="boxed">Changes</h3>
<table class="POITable">
<colgroup>
@@ -911,7 +935,7 @@ document.write("Last Published: " + docu
4.0.1 (2018-12-03)
</h2>
<div class="section">
-<a name="Summary-N108F7"></a>
+<a name="Summary-N10957"></a>
<h3 class="boxed">Summary</h3>
<ul>
@@ -922,7 +946,7 @@ document.write("Last Published: " + docu
<li>Upgrade to XMLBeans 3.0.2</li>
</ul>
-<a name="Changes-N10907"></a>
+<a name="Changes-N10967"></a>
<h3 class="boxed">Changes</h3>
<table class="POITable">
<colgroup>
@@ -1080,7 +1104,7 @@ document.write("Last Published: " + docu
4.0.0 (2018-09-07)
</h2>
<div class="section">
-<a name="Summary-N10B38"></a>
+<a name="Summary-N10B98"></a>
<h3 class="boxed">Summary</h3>
<ul>
@@ -1089,7 +1113,7 @@ document.write("Last Published: " + docu
<li>New OOXML schema (1.4) necessary, because of incompatible XMLBeans loading
not anymore through POIXMLTypeLoader</li>
</ul>
-<a name="Changes-N10B45"></a>
+<a name="Changes-N10BA5"></a>
<h3 class="boxed">Changes</h3>
<table class="POITable">
<colgroup>
Modified: poi/site/publish/components/index.html
URL:
http://svn.apache.org/viewvc/poi/site/publish/components/index.html?rev=1884384&r1=1884383&r2=1884384&view=diff
==============================================================================
--- poi/site/publish/components/index.html (original)
+++ poi/site/publish/components/index.html Sun Dec 13 15:56:07 2020
@@ -527,9 +527,9 @@ document.write("Last Published: " + docu
<td colspan="1" rowspan="1"><a href="./oxml4j/index.html">OpenXML4J</a></td>
<td colspan="1" rowspan="1">OOXML</td>
- <td colspan="1" rowspan="1"><em>poi-ooxml</em> plus either
<em>poi-ooxml-schemas</em> or<br>
+ <td colspan="1" rowspan="1"><em>poi-ooxml</em> plus either
<em>poi-ooxml-lite</em> or<br>
-<em>ooxml-schemas</em> and <em>ooxml-security</em></td>
+<em>poi-ooxml-full</em></td>
<td colspan="1" rowspan="1">See notes below for differences between
these options</td>
</tr>
@@ -633,7 +633,7 @@ document.write("Last Published: " + docu
<td colspan="1" rowspan="1">poi-ooxml</td>
<td colspan="1" rowspan="1"><a
href="https://search.maven.org/#search|gav|1|g:org.apache.poi AND
a:poi">poi</a>,
- <a href="https://search.maven.org/#search|gav|1|g:org.apache.poi
AND a:poi-ooxml-schemas">poi-ooxml-schemas</a>,
+ <a href="https://search.maven.org/#search|gav|1|g:org.apache.poi
AND a:poi-ooxml-lite">poi-ooxml-lite</a>,
<a
href="https://search.maven.org/#artifactdetails|org.apache.commons|commons-compress|1.20|jar">commons-compress</a>,
<a
href="https://search.maven.org/#artifactdetails|com.zaxxer|SparseBitSet|1.2|jar">SparseBitSet</a>
<br>
@@ -653,9 +653,9 @@ document.write("Last Published: " + docu
<tr>
-<td colspan="1" rowspan="1">poi-ooxml-schemas</td>
- <td colspan="1" rowspan="1"><a
href="https://search.maven.org/#artifactdetails|org.apache.xmlbeans|xmlbeans|3.1.0|jar">xmlbeans</a></td>
- <td colspan="1"
rowspan="1">poi-ooxml-schemas-version-yyyymmdd.jar</td>
+<td colspan="1" rowspan="1">poi-ooxml-lite</td>
+ <td colspan="1" rowspan="1"><a
href="https://search.maven.org/#artifactdetails|org.apache.xmlbeans|xmlbeans|4.0.0|jar">xmlbeans</a></td>
+ <td colspan="1" rowspan="1">poi-ooxml-lite-version-yyyymmdd.jar</td>
</tr>
@@ -672,24 +672,16 @@ document.write("Last Published: " + docu
<tr>
-<td colspan="1" rowspan="1">ooxml-schemas</td>
- <td colspan="1" rowspan="1"><a
href="https://search.maven.org/#artifactdetails|org.apache.xmlbeans|xmlbeans|3.1.0|jar">xmlbeans</a></td>
- <td colspan="1" rowspan="1"><a
href="https://search.maven.org/#artifactdetails|org.apache.poi|ooxml-schemas|1.4|jar">ooxml-schemas-1.4.jar</a></td>
-
-</tr>
-
-<tr>
-
-<td colspan="1" rowspan="1">ooxml-security</td>
- <td colspan="1" rowspan="1"><a
href="https://search.maven.org/#artifactdetails|org.apache.xmlbeans|xmlbeans|3.1.0|jar">xmlbeans</a>
+<td colspan="1" rowspan="1">poi-ooxml-full (known as ooxml-schemas)</td>
+ <td colspan="1" rowspan="1"><a
href="https://search.maven.org/#artifactdetails|org.apache.xmlbeans|xmlbeans|4.0.0|jar">xmlbeans</a>
<br>
- For signing:
- <a
href="https://search.maven.org/#artifactdetails|org.bouncycastle|bcpkix-jdk15on|1.65|jar">bcpkix-jdk15on</a>,
- <a
href="https://search.maven.org/#artifactdetails|org.bouncycastle|bcprov-jdk15on|1.65|jar">bcprov-jdk15on</a>,
- <a
href="https://search.maven.org/#artifactdetails|org.apache.santuario|xmlsec|2.1.5|bundle">xmlsec</a>,
- <a
href="https://search.maven.org/#artifactdetails|org.slf4j|slf4j-api|1.7.30|jar">slf4j-api</a>
+ For signing:
+ <a
href="https://search.maven.org/#artifactdetails|org.bouncycastle|bcpkix-jdk15on|1.67|jar">bcpkix-jdk15on</a>,
+ <a
href="https://search.maven.org/#artifactdetails|org.bouncycastle|bcprov-jdk15on|1.67|jar">bcprov-jdk15on</a>,
+ <a
href="https://search.maven.org/#artifactdetails|org.apache.santuario|xmlsec|2.2.0|bundle">xmlsec</a>,
+ <a
href="https://search.maven.org/#artifactdetails|org.slf4j|slf4j-api|1.7.30|jar">slf4j-api</a>
</td>
- <td colspan="1" rowspan="1"><a
href="https://search.maven.org/#artifactdetails|org.apache.poi|ooxml-security|1.1|jar">ooxml-security-1.1.jar</a></td>
+ <td colspan="1" rowspan="1">poi-ooxml-full-version-yyyymmdd.jar</td>
</tr>
@@ -703,9 +695,9 @@ document.write("Last Published: " + docu
</div>
</div>
<p>
- poi-ooxml requires poi-ooxml-schemas. This is a substantially smaller
- version of the ooxml-schemas jar (ooxml-schemas-1.4.jar for POI 4.0.0
- or later, ooxml-schemas-1.3.jar for POI 3.14 or to POI 3.17,
+ poi-ooxml requires poi-ooxml-lite. This is a substantially smaller
+ version of the poi-ooxml-full jar (ooxml-schemas-1.4.jar for POI 4.0.0,
+ ooxml-schemas-1.3.jar for POI 3.14 or to POI 3.17,
ooxml-schemas-1.1.jar for POI 3.7 up to POI 3.13, ooxml-schemas-1.0.jar
for POI 3.5 and 3.6).
The larger ooxml-schemas jar is <a
href="../help/index.html#faq-N10025">normally</a>
Modified: poi/site/publish/components/poi-jvm-languages.html
URL:
http://svn.apache.org/viewvc/poi/site/publish/components/poi-jvm-languages.html?rev=1884384&r1=1884383&r2=1884384&view=diff
==============================================================================
--- poi/site/publish/components/poi-jvm-languages.html (original)
+++ poi/site/publish/components/poi-jvm-languages.html Sun Dec 13 15:56:07 2020
@@ -482,7 +482,7 @@ document.write("Last Published: " + docu
<span class="lineno"></span><span class="codebody"> // include
poi-{version}-{yyyymmdd}.jar, poi-ooxml-{version}-{yyyymmdd}.jar,</span>
</div>
<div class="codeline">
-<span class="lineno"></span><span class="codebody"> // and
poi-ooxml-schemas-{version}-{yyyymmdd}.jar on Java classpath</span>
+<span class="lineno"></span><span class="codebody"> // and
poi-ooxml-lite-{version}-{yyyymmdd}.jar on Java classpath</span>
</div>
<div class="codeline">
<span class="lineno"></span><span class="codebody"></span>
@@ -631,13 +631,13 @@ document.write("Last Published: " + docu
<span class="lineno"></span><span class="codebody"> import sys</span>
</div>
<div class="codeline">
-<span class="lineno"></span><span class="codebody"> for jar in ('poi',
'poi-ooxml', 'poi-ooxml-schemas'):</span>
+<span class="lineno"></span><span class="codebody"> for jar in ('poi',
'poi-ooxml', 'poi-ooxml-lite'):</span>
</div>
<div class="codeline">
-<span class="lineno"></span><span class="codebody">
sys.path.append('/path/to/%s-3.14-20160307.jar')</span>
+<span class="lineno"></span><span class="codebody">
sys.path.append('/path/to/%s-5.0.0-SNAPSHOT.jar')</span>
</div>
<div class="codeline">
-<span class="lineno"></span><span class="codebody"> </span>
+<span class="lineno"></span><span class="codebody"></span>
</div>
<div class="codeline">
<span class="lineno"></span><span class="codebody"> from java.io import
File, FileOutputStream</span>
@@ -743,11 +743,11 @@ document.write("Last Published: " + docu
</div>
</div>
<p>There are several websites that have examples of using Apache POI in Jython
projects:
- <a href="https://wiki.python.org/jython/PoiExample";>python.org</a>,
+ <a href="https://wiki.python.org/jython/PoiExample";>python.org</a>,
<a
href="http://www.jython.org/jythonbook/en/1.0/appendixB.html#working-with-spreadsheets";>jython.org</a>,
and many others.
</p>
</div>
-
+
<a name="Scala+example"></a>
<h2 class="boxed">Scala example</h2>
@@ -768,13 +768,13 @@ document.write("Last Published: " + docu
<span class="lineno"></span><span class="codebody"> libraryDependencies ++=
Seq(</span>
</div>
<div class="codeline">
-<span class="lineno"></span><span class="codebody"> "org.apache.poi" %
"poi" % "3.15-beta2",</span>
+<span class="lineno"></span><span class="codebody"> "org.apache.poi" %
"poi" % "5.0.0-SNAPSHOT",</span>
</div>
<div class="codeline">
-<span class="lineno"></span><span class="codebody"> "org.apache.poi" %
"poi-ooxml" % "3.15-beta2",</span>
+<span class="lineno"></span><span class="codebody"> "org.apache.poi" %
"poi-ooxml" % "5.0.0-SNAPSHOT",</span>
</div>
<div class="codeline">
-<span class="lineno"></span><span class="codebody"> "org.apache.poi" %
"poi-ooxml-schemas" "3.15-beta2"</span>
+<span class="lineno"></span><span class="codebody"> "org.apache.poi" %
"poi-ooxml-lite" "5.0.0-SNAPSHOT"</span>
</div>
<div class="codeline">
<span class="lineno"></span><span class="codebody"> )</span>
@@ -1101,7 +1101,7 @@ document.write("Last Published: " + docu
<span class="lineno"></span><span class="codebody"> Sheet ns2 =
workbook.createSheet("Generated 2")</span>
</div>
<div class="codeline">
-<span class="lineno"></span><span class="codebody"> exportHeader(ns2,
headerStyle, "This is a demo sheet", </span>
+<span class="lineno"></span><span class="codebody"> exportHeader(ns2,
headerStyle, "This is a demo sheet",</span>
</div>
<div class="codeline">
<span class="lineno"></span><span class="codebody">
["ID","Title","Date","Author","Num"] as String[])</span>
Modified: poi/site/publish/components/slideshow/ppt-wmf-emf-renderer.html
URL:
http://svn.apache.org/viewvc/poi/site/publish/components/slideshow/ppt-wmf-emf-renderer.html?rev=1884384&r1=1884383&r2=1884384&view=diff
==============================================================================
--- poi/site/publish/components/slideshow/ppt-wmf-emf-renderer.html (original)
+++ poi/site/publish/components/slideshow/ppt-wmf-emf-renderer.html Sun Dec 13
15:56:07 2020
@@ -374,6 +374,21 @@ document.write("Last Published: " + docu
<span class="lineno"></span><span class="codebody"></span>
</div>
<div class="codeline">
+<span class="lineno"></span><span class="codebody"> -fontdir <dir>
(PDF only) font directories separated by ";" - use $HOME for current users home
dir</span>
+</div>
+<div class="codeline">
+<span class="lineno"></span><span class="codebody">
defaults to the usual plattform directories</span>
+</div>
+<div class="codeline">
+<span class="lineno"></span><span class="codebody"> -fontTtf <regex>
(PDF only) regex to match the .ttf filenames</span>
+</div>
+<div class="codeline">
+<span class="lineno"></span><span class="codebody"> -fontMap <map>
";"-separated list of font mappings <typeface from>:<typeface
to></span>
+</div>
+<div class="codeline">
+<span class="lineno"></span><span class="codebody"></span>
+</div>
+<div class="codeline">
<span class="lineno"></span><span class="codebody"></span>
</div>
</div>
Modified: poi/site/publish/components/spreadsheet/excelant.html
URL:
http://svn.apache.org/viewvc/poi/site/publish/components/spreadsheet/excelant.html?rev=1884384&r1=1884383&r2=1884384&view=diff
==============================================================================
--- poi/site/publish/components/spreadsheet/excelant.html (original)
+++ poi/site/publish/components/spreadsheet/excelant.html Sun Dec 13 15:56:07
2020
@@ -314,12 +314,12 @@ workbooks then you need to have the foll
<p> If you evaluate .xlsx workbooks then you need to add these: </p>
<ul>
-<li>poi-ooxml-schemas-$version-YYYYDDMM.jar</li>
+<li>poi-ooxml-lite-$version-YYYYDDMM.jar</li>
<li>xmlbeans.jar</li>
</ul>
-<p>For example, if you have these jars in a lib/ dir in your project, your
build.xml
+<p>For example, if you have these jars in a lib/ dir in your project, your
build.xml
might look like this:</p>
<div class="code">
<div class="codeline">
@@ -344,7 +344,7 @@ workbooks then you need to have the foll
<span class="lineno"></span><span class="codebody"> <pathelement
location="${lib.dir}/poi-ooxml-3.8-beta1-20101230.jar" /></span>
</div>
<div class="codeline">
-<span class="lineno"></span><span class="codebody">/path> </span>
+<span class="lineno"></span><span class="codebody">/path></span>
</div>
</div>
<p>Next, you'll need to define the Ant tasks. There are several ways to use
ExcelAnt:</p>
@@ -412,13 +412,13 @@ workbooks then you need to have the foll
<p>The simplest example of using Excel is the ability to validate that POI is
giving you back
the value you expect it to. Does this mean that POI is inaccurate?
Hardly. There are cases
where POI is unable to evaluate cells for a variety of reasons. If you
need to write code
- to integrate a worksheet into an app, you may want to know that it's
going to work before
+ to integrate a worksheet into an app, you may want to know that it's
going to work before
you actually try to write that code. ExcelAnt helps with that.</p>
-<p>Consider the mortgage-calculation.xls file found in the Examples
+<p>Consider the mortgage-calculation.xls file found in the Examples
(/examples/src/org/apache/poi/examples/ss/excelant/simple-mortgage-calculation.xls).
This sheet
is shown below:</p>
<p>This sheet calculates the principal and interest payment for a mortgage
based
- on the amount of the loan, term and rate. To write a simple ExcelAnt test
you
+ on the amount of the loan, term and rate. To write a simple ExcelAnt test
you
need to tell ExcelAnt about the file like this:</p>
<div class="code">
<div class="codeline">
@@ -428,7 +428,7 @@ workbooks then you need to have the foll
<span class="lineno"></span><span class="codebody">property name="xls.file"
value="" /></span>
</div>
<div class="codeline">
-<span class="lineno"></span><span class="codebody"> </span>
+<span class="lineno"></span><span class="codebody"></span>
</div>
<div class="codeline">
<span class="lineno"></span><span class="codebody">target
name="simpleTest"></span>
@@ -449,7 +449,7 @@ workbooks then you need to have the foll
<span class="lineno"></span><span class="codebody"> </excelant></span>
</div>
<div class="codeline">
-<span class="lineno"></span><span class="codebody">/target> </span>
+<span class="lineno"></span><span class="codebody">/target></span>
</div>
</div>
<p>This code sets up ExcelAnt to access the file defined in the ant property
@@ -480,7 +480,7 @@ workbooks then you need to have the foll
<span class="lineno"></span><span class="codebody">BUILD SUCCESSFUL</span>
</div>
<div class="codeline">
-<span class="lineno"></span><span class="codebody">Total time: 391
milliseconds </span>
+<span class="lineno"></span><span class="codebody">Total time: 391
milliseconds</span>
</div>
</div>
<a name="Setting+Values+into+a+Cell"></a>
@@ -521,7 +521,7 @@ workbooks then you need to have the foll
<span class="lineno"></span><span class="codebody">setDouble
cell="'MortgageCalculator'!$B$3" value ="30"/></span>
</div>
<div class="codeline">
-<span class="lineno"></span><span class="codebody">evaluate showDelta="true"
cell="'MortgageCalculator'!$B$4" expectedValue="2285.576149" precision="1.0e-4"
/> </span>
+<span class="lineno"></span><span class="codebody">evaluate showDelta="true"
cell="'MortgageCalculator'!$B$4" expectedValue="2285.576149" precision="1.0e-4"
/></span>
</div>
</div>
<p>Don't forget that we're verifying the behavior so you need to put all this
@@ -532,32 +532,32 @@ workbooks then you need to have the foll
<span class="lineno"></span><span class="codebody"></span>
</div>
<div class="codeline">
-<span class="lineno"></span><span class="codebody">file:
C:\opt\eclipse\workspaces\excelant\excelant.examples\build.xml</span>
+<span class="lineno"></span><span class="codebody">Buildfile:
C:\opt\eclipse\workspaces\excelant\excelant.examples\build.xml</span>
</div>
<div class="codeline">
-<span class="lineno"></span><span class="codebody">eTest:</span>
+<span class="lineno"></span><span class="codebody">simpleTest:</span>
</div>
<div class="codeline">
-<span class="lineno"></span><span class="codebody">elant] ExcelAnt version
0.4.0 Copyright 2011</span>
+<span class="lineno"></span><span class="codebody"> [excelant] ExcelAnt
version 0.4.0 Copyright 2011</span>
</div>
<div class="codeline">
-<span class="lineno"></span><span class="codebody">elant] Using input file:
resources/excelant.xls</span>
+<span class="lineno"></span><span class="codebody"> [excelant] Using input
file: resources/excelant.xls</span>
</div>
<div class="codeline">
-<span class="lineno"></span><span class="codebody">elant] 1/1 tests
passed.</span>
+<span class="lineno"></span><span class="codebody"> [excelant] 1/1 tests
passed.</span>
</div>
<div class="codeline">
-<span class="lineno"></span><span class="codebody"> SUCCESSFUL</span>
+<span class="lineno"></span><span class="codebody">BUILD SUCCESSFUL</span>
</div>
<div class="codeline">
-<span class="lineno"></span><span class="codebody"> time: 406 milliseconds
</span>
+<span class="lineno"></span><span class="codebody">Total time: 406
milliseconds</span>
</div>
</div>
<a name="Getting+More+Details"></a>
<h3 class="boxed">Getting More Details</h3>
<p>This is great, it's working! However, suppose you want to see a little more
detail. The
ExcelAnt tasks leverage the Ant logging so you can add the -verbose and
-debug flags to
- the Ant command line to get more detail. Try adding -verbose. Here is
what
+ the Ant command line to get more detail. Try adding -verbose. Here is
what
you should see:</p>
<div class="code">
<div class="codeline">
@@ -585,14 +585,14 @@ workbooks then you need to have the foll
<span class="lineno"></span><span class="codebody">BUILD SUCCESSFUL</span>
</div>
<div class="codeline">
-<span class="lineno"></span><span class="codebody">Total time: 406
milliseconds </span>
+<span class="lineno"></span><span class="codebody">Total time: 406
milliseconds</span>
</div>
</div>
<p>We see a little more detail. Notice that we see that there is a setting
for global precision.
- Up until now we've been setting the precision on each evaluate that we
call. This
+ Up until now we've been setting the precision on each evaluate that we
call. This
is obviously useful but it gets cumbersome. It would be better if there
were a way
- that we could specify a global precision - and there is. There is a
<precision>
- tag that you can specify as a child of the <excelant> tag. Let's
go back to
+ that we could specify a global precision - and there is. There is a
<precision>
+ tag that you can specify as a child of the <excelant> tag. Let's
go back to
our original task we set up earlier and modify it:</p>
<div class="code">
<div class="codeline">
@@ -602,7 +602,7 @@ workbooks then you need to have the foll
<span class="lineno"></span><span class="codebody">property name="xls.file"
value="" /></span>
</div>
<div class="codeline">
-<span class="lineno"></span><span class="codebody"> </span>
+<span class="lineno"></span><span class="codebody"></span>
</div>
<div class="codeline">
<span class="lineno"></span><span class="codebody">target
name="simpleTest"></span>
@@ -626,7 +626,7 @@ workbooks then you need to have the foll
<span class="lineno"></span><span class="codebody"> </excelant></span>
</div>
<div class="codeline">
-<span class="lineno"></span><span class="codebody">/target> </span>
+<span class="lineno"></span><span class="codebody">/target></span>
</div>
</div>
<p>In this example we have set the global precision to 1.0e-3. This means that
@@ -639,33 +639,33 @@ workbooks then you need to have the foll
<span class="lineno"></span><span class="codebody"></span>
</div>
<div class="codeline">
-<span class="lineno"></span><span class="codebody">eTest:</span>
+<span class="lineno"></span><span class="codebody">simpleTest:</span>
</div>
<div class="codeline">
-<span class="lineno"></span><span class="codebody">lant] ExcelAnt version
0.4.0 Copyright 2011</span>
+<span class="lineno"></span><span class="codebody">[excelant] ExcelAnt version
0.4.0 Copyright 2011</span>
</div>
<div class="codeline">
-<span class="lineno"></span><span class="codebody">lant] Using input file:
resources/excelant.xls</span>
+<span class="lineno"></span><span class="codebody">[excelant] Using input
file: resources/excelant.xls</span>
</div>
<div class="codeline">
-<span class="lineno"></span><span class="codebody">lant] setting precision for
the test checkValue</span>
+<span class="lineno"></span><span class="codebody">[excelant] setting
precision for the test checkValue</span>
</div>
<div class="codeline">
-<span class="lineno"></span><span class="codebody">test] setting
globalPrecision to 0.0010 in the evaluator</span>
+<span class="lineno"></span><span class="codebody"> [test] setting
globalPrecision to 0.0010 in the evaluator</span>
</div>
<div class="codeline">
-<span class="lineno"></span><span class="codebody">uate] test precision = 0.0
global precision = 0.0010</span>
+<span class="lineno"></span><span class="codebody">[evaluate] test precision =
0.0 global precision = 0.0010</span>
</div>
<div class="codeline">
-<span class="lineno"></span><span class="codebody">uate] Using global
precision of 0.0010</span>
+<span class="lineno"></span><span class="codebody">[evaluate] Using global
precision of 0.0010</span>
</div>
<div class="codeline">
-<span class="lineno"></span><span class="codebody">lant] 1/1 tests
passed.</span>
+<span class="lineno"></span><span class="codebody">[excelant] 1/1 tests
passed.</span>
</div>
</div>
<p>As the output clearly shows, the test itself has no precision but there is
the global precision. Additionally, it tells us we're going to use that
- more stringent global value. Now suppose that for this test we want
+ more stringent global value. Now suppose that for this test we want
to use a more stringent precision, say 1.0e-4. We can do that by adding
the precision attribute back to the <evaluate> task:</p>
<div class="code">
@@ -734,7 +734,7 @@ workbooks then you need to have the foll
<span class="lineno"></span><span class="codebody">BUILD SUCCESSFUL</span>
</div>
<div class="codeline">
-<span class="lineno"></span><span class="codebody">Total time: 390
milliseconds </span>
+<span class="lineno"></span><span class="codebody">Total time: 390
milliseconds</span>
</div>
</div>
<a name="Leveraging+User+Defined+Functions"></a>
@@ -743,11 +743,11 @@ workbooks then you need to have the foll
that allows you to write Java code that will be used in place of custom VB
code or macros is a spreadsheet. If you have read the documentation and
written
your own FreeRefFunction implmentations, ExcelAnt can make use of this
code.
- For each <excelant> task you define you can nest a <udf> tag
+ For each <excelant> task you define you can nest a <udf> tag
which allows you to specify the function alias and the class name.</p>
<p>Consider the previous example of the mortgage calculator. What if, instead
of being a formula in a cell, it was a function defined in a VB macro?
As luck
- would have it, we already have an example of this in the examples from
the
+ would have it, we already have an example of this in the examples from the
User Defined Functions example, so let's use that. In the example
spreadsheet
there is a tab for MortgageCalculatorFunction, which will use. If you
look in
cell B4, you see that rather than a messy cell based formula, there is
only the function
Modified: poi/site/publish/devel/index.html
URL:
http://svn.apache.org/viewvc/poi/site/publish/devel/index.html?rev=1884384&r1=1884383&r2=1884384&view=diff
==============================================================================
--- poi/site/publish/devel/index.html (original)
+++ poi/site/publish/devel/index.html Sun Dec 13 15:56:07 2020
@@ -236,10 +236,10 @@ document.write("Last Published: " + docu
to build the documentation.
</p>
<p>
- Specifically the build has been tested to work with Forrest
0.90.
+ Specifically, the build has been tested to work with Forrest
0.90.
</p>
<p>
- Remember to set the FORREST_HOME environment variable.
+ Remember to set the FORREST_HOME environment variable.
</p>
</div>
@@ -315,8 +315,8 @@ document.write("Last Published: " + docu
<h2 class="boxed">Working with Eclipse</h2>
<div class="section">
<p>
- Apache POI includes a pre-defined Eclipse project file which
can be
- used to quickly get set up in the Eclipse IDE.
+ Apache POI includes a pre-defined Eclipse project file which
can be
+ used to quickly get set up in the Eclipse IDE.
</p>
<p>
First make sure that Java is set up properly and that you can
execute the 'javac' executable in your shell.
@@ -330,9 +330,9 @@ document.write("Last Published: " + docu
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
- property "POI.testdata.path" to the actual location of the
'test-data' directory to make
- the test framework find the required test-files. A simple value
of 'test-data' usually works.
+ Note: when executing junit tests from within Eclipse, you
might need to set the system
+ property "POI.testdata.path" to the actual location of the
'test-data' directory to make
+ the test framework find the required test-files. A simple
value of 'test-data' usually works.
</p>
</div>
@@ -340,16 +340,8 @@ document.write("Last Published: " + docu
<h2 class="boxed">Working with IntelliJ Idea</h2>
<div class="section">
<p>
- We currently do not offer project files for IntelliJ and
unfortunately it
- cannot import the project from the Ant build files.
- </p>
-<p>
- In order to get started, first build Apache POI using Ant as
described above
- to get all required 3rd party libraries downloaded.
- </p>
-<p>
- Then import the main folder into a new project and then define
all the source folders under src
- accordingly. Also add all libraries from the lib, compile-lib
and ooxml-lib folders.
+ Import the Gradle project into your IDE. Execute a build to
get all the dependencies and generated code
+ in place.
</p>
<p>
Note: when executing junit tests from within IntelliJ, you
might need to set the system
Modified: poi/site/publish/help/faq.html
URL:
http://svn.apache.org/viewvc/poi/site/publish/help/faq.html?rev=1884384&r1=1884383&r2=1884384&view=diff
==============================================================================
--- poi/site/publish/help/faq.html (original)
+++ poi/site/publish/help/faq.html Sun Dec 13 15:56:07 2020
@@ -178,7 +178,7 @@ System.out.println("POI Scratchpad came
</div>
<a name="faq-N10025"></a>
<h2 class="boxed">3.
- I'm using the poi-ooxml-schemas jar, but my code is failing with
"java.lang.NoClassDefFoundError: org/openxmlformats/schemas/*something*"
+ I'm using the poi-ooxml-lite (known as poi-ooxml-schemas) jar, but my
code is failing with "java.lang.NoClassDefFoundError:
org/openxmlformats/schemas/*something*"
</h2>
<div class="section">
<p>To use the new OOXML file formats, POI requires a jar containing
@@ -188,21 +188,21 @@ System.out.println("POI Scratchpad came
<em>org.openxmlformats.schemas</em> namespace.</p>
<p>There are two jar files available, as described in
<a href="../components/">the components overview section</a>.
- The <em>full jar of all of the schemas is ooxml-schemas-1.4.jar
+ The <em>full jar of all of the schemas is poi-ooxml-full-XXX.jar (known
as ooxml-schemas)
(lower versions for older releases, see table below)</em>,
- and it is currently around 16mb. The <em>smaller poi-ooxml-schemas
+ and it is currently around 16mb. The <em>smaller poi-ooxml-lite (known
as poi-ooxml-schemas)
jar</em> is only about 6mb. This latter jar file only contains the
typically used parts though.</p>
-<p>Many users choose to use the smaller poi-ooxml-schemas jar to save
- space. However, the poi-ooxml-schemas jar only contains the XSDs and
+<p>Many users choose to use the smaller poi-ooxml-lite jar to save
+ space. However, the poi-ooxml-lite jar only contains the XSDs and
classes that are typically used, as identified by the unit tests.
Every so often, you may try to use part of the file format which
- isn't included in the minimal poi-ooxml-schemas jar. In this case,
- you should switch to the full ooxml-schemas-1.4.jar. Longer term,
+ isn't included in the minimal poi-ooxml-lite jar. In this case,
+ you should switch to the full poi-ooxml-full jar. Longer term,
you may also wish to submit a new unit test which uses the extra
- parts of the XSDs, so that a future poi-ooxml-schemas jar will
+ parts of the XSDs, so that a future poi-ooxml-lite jar will
include them.</p>
-<p>There are a number of ways to get the full ooxml-schemas-1.4.jar.
+<p>There are a number of ways to get the full poi-ooxml-full jar.
If you are a maven user, see the
<a href="../components/">the components overview section</a>
for the artifact details to have maven download it for you.
@@ -214,7 +214,7 @@ System.out.println("POI Scratchpad came
look at this). Finally, you can download the jar by hand from the
<a href="http://mirrors.ibiblio.org/apache/poi/";>POI
Maven Repository</a>.</p>
-<p>Note that historically, different versions of ooxml-schemas were
+<p>Note that historically, different versions of poi-ooxml-full /
ooxml-schemas were
used</p>
<table class="POITable autosize">
@@ -261,10 +261,18 @@ System.out.println("POI Scratchpad came
<tr>
<td colspan="1" rowspan="1">ooxml-schemas-1.4.jar</td>
- <td colspan="1" rowspan="1">POI 4.0.0 and newer</td>
+ <td colspan="1" rowspan="1">POI 4.*.*</td>
<td colspan="1" rowspan="1">Provide schema for
AlternateContent, can be used with previous versions of POI as well</td>
</tr>
+
+<tr>
+
+<td colspan="1" rowspan="1">poi-ooxml-full jar</td>
+ <td colspan="1" rowspan="1">POI 5.0.0 and newer</td>
+ <td colspan="1" rowspan="1">Upgrade to ECMA-376 3rd edition -
which is not downward compatible</td>
+
+</tr>
</table>
</div>
@@ -534,16 +542,15 @@ case HSSFCell.CELL_TYPE_NUMERIC:
isn't common any more).</p>
<p>All of the <em>org.openxmlformats.schemas.spreadsheetml.x2006</em> CT...
classes are auto-generated by XMLBeans. The resulting generated Java
goes
- in the <em>ooxml-schemas-src</em> jar, and the compiled version into
the
- <em>ooxml-schemas</em> jar.</p>
-<p>The full <em>ooxml-schemas</em> jar is distributed with Apache POI,
- along with the cut-down <em>poi-ooxml-schemas</em> jar containing just
- the common parts. The source jar isn't normally distributed with POI.
- It is, however, available from Maven Central - ask your favourite
Maven
- mirror for the <em>ooxml-schemas-src</em> jar. Alternately, if you
download
+ in the <em>poi-ooxml-full-*-sources</em> jar, and the compiled
version into the
+ <em>poi-ooxml-full</em> jar.</p>
+<p>The full <em>poi-ooxml-full</em> jar is distributed with Apache POI,
+ along with the cut-down <em>poi-ooxml-lite</em> jar containing just
+ the common parts. Use the sources off <em>poi-ooxml-full</em> for the
lite version,
+ which is available from Maven Central - ask your favourite Maven
+ mirror for the <em>poi-ooxml-full-*-sources</em> jar. Alternately, if
you download
the POI source distribution (or checkout from SVN) and build, Ant will
- automatically download the specification XML Schema, and compile it
for
- you to generate the source and binary ooxml-schemas jars.</p>
+ automatically compile it for you to generate the source and binary
poi-ooxml-full jars.</p>
</div>
<a name="faq-N101BA"></a>
<h2 class="boxed">16.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
