You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@poi.apache.org by ki...@apache.org on 2020/12/13 15:56:07 UTC
svn commit: r1884384 - in /poi/site/publish: changes.html
components/index.html components/poi-jvm-languages.html
components/slideshow/ppt-wmf-emf-renderer.html
components/spreadsheet/excelant.html devel/index.html help/faq.html
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: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org