You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@poi.apache.org by ni...@apache.org on 2015/03/26 17:36:57 UTC
svn commit: r1669366 - in /poi/site: publish/changes.html
publish/changes.rss publish/faq.html publish/howtobuild.html
src/documentation/content/xdocs/faq.xml
Author: nick
Date: Thu Mar 26 16:36:57 2015
New Revision: 1669366
URL: http://svn.apache.org/r1669366
Log:
Add OOXML and Scratchpad finding snippets to the "which jar" FAQ
Modified:
poi/site/publish/changes.html
poi/site/publish/changes.rss
poi/site/publish/faq.html
poi/site/publish/howtobuild.html
poi/site/src/documentation/content/xdocs/faq.xml
Modified: poi/site/publish/changes.html
URL: http://svn.apache.org/viewvc/poi/site/publish/changes.html?rev=1669366&r1=1669365&r2=1669366&view=diff
==============================================================================
--- poi/site/publish/changes.html (original)
+++ poi/site/publish/changes.html Thu Mar 26 16:36:57 2015
@@ -257,6 +257,12 @@ if (VERSION > 3) {
<ul>
<li>
+<img class="icon" alt="fix" src="images/fix.jpg"> <a href="http://issues.apache.org/bugzilla/show_bug.cgi?id=55386">55386</a> - Fix handling of bold formatting in example application 'ToHtml'</li>
+
+<li>
+<img class="icon" alt="fix" src="images/fix.jpg"> <a href="http://issues.apache.org/bugzilla/show_bug.cgi?id=47304">47304</a> - Use fixed encoding when extracting text in WordDocument</li>
+
+<li>
<img class="icon" alt="fix" src="images/fix.jpg"> <a href="http://issues.apache.org/bugzilla/show_bug.cgi?id=56017">56017</a> - Fix shifting comments with shifted rows</li>
<li>
Modified: poi/site/publish/changes.rss
URL: http://svn.apache.org/viewvc/poi/site/publish/changes.rss?rev=1669366&r1=1669365&r2=1669366&view=diff
==============================================================================
--- poi/site/publish/changes.rss (original)
+++ poi/site/publish/changes.rss Thu Mar 26 16:36:57 2015
@@ -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>POI Changes</title><link>http://poi.apache.org/changes.html</link><description>POI Changes</description><language>en-us</language><item><title> fix(bug 56017)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 56017) - Fix shifting comments with shifted rows</description></item><item><title> fix(bug 56295)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 56295) - Fix cloning of styles across workbooks and handling of default value of attribute applyFill</description></item><item><title> fix(bug 56380)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 56380) - Remove limitation of 1024 comments per Workbook</description></item><item><title> fix(bug 56467)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 56467) - Fix cloning of sheets with pictures</description></item><it
em><title> add</title><link>http://poi.apache.org/changes.html</link><description> add by POI Developers - More helpful ExtractorFactory exception if given a Visio VSDX ooxml file</description></item><item><title> fix(bug 56799)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 56799) - Include CTTblGrid in the smaller poi-ooxml-schemas jar</description></item><item><title> fix(bug 57165)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 57165) - Avoid PartAlreadyExistsException when removing/cloning sheets</description></item><item><title> fix(bug 56893)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 56893) - Additional check for supported string-length to avoid creating broken XLS files later one</description></item><item><title> fix</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers - When saving an OPCPac
kage with no Core Properties (eg from Jasper Reports), ensure they are always added even if not yet used</description></item><item><title> fix</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers - github-18 - Handle documents with a picture-only header</description></item><item><title> fix(bug 57622)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 57622) - Change from XMLEventFactory.newFactory to XMLEventFactory.newInstance, for IBM JDK Compatibility</description></item></channel></rss>
\ No newline at end of file
+<rss version="0.91"><channel><title>POI Changes</title><link>http://poi.apache.org/changes.html</link><description>POI Changes</description><language>en-us</language><item><title> fix(bug 55386)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 55386) - Fix handling of bold formatting in example application 'ToHtml'</description></item><item><title> fix(bug 47304)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 47304) - Use fixed encoding when extracting text in WordDocument</description></item><item><title> fix(bug 56017)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 56017) - Fix shifting comments with shifted rows</description></item><item><title> fix(bug 56295)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 56295) - Fix cloning of styles across workbooks and handling of default value of attribu
te applyFill</description></item><item><title> fix(bug 56380)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 56380) - Remove limitation of 1024 comments per Workbook</description></item><item><title> fix(bug 56467)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 56467) - Fix cloning of sheets with pictures</description></item><item><title> add</title><link>http://poi.apache.org/changes.html</link><description> add by POI Developers - More helpful ExtractorFactory exception if given a Visio VSDX ooxml file</description></item><item><title> fix(bug 56799)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 56799) - Include CTTblGrid in the smaller poi-ooxml-schemas jar</description></item><item><title> fix(bug 57165)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 57165) - Avoid PartAlreadyExistsExcepti
on when removing/cloning sheets</description></item><item><title> fix(bug 56893)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 56893) - Additional check for supported string-length to avoid creating broken XLS files later one</description></item><item><title> fix</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers - When saving an OPCPackage with no Core Properties (eg from Jasper Reports), ensure they are always added even if not yet used</description></item><item><title> fix</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers - github-18 - Handle documents with a picture-only header</description></item><item><title> fix(bug 57622)</title><link>http://poi.apache.org/changes.html</link><description> fix by POI Developers (bug 57622) - Change from XMLEventFactory.newFactory to XMLEventFactory.newInstance, for IBM JDK Compatibility</description></item></channel>
</rss>
\ No newline at end of file
Modified: poi/site/publish/faq.html
URL: http://svn.apache.org/viewvc/poi/site/publish/faq.html?rev=1669366&r1=1669365&r2=1669366&view=diff
==============================================================================
--- poi/site/publish/faq.html (original)
+++ poi/site/publish/faq.html Thu Mar 26 16:36:57 2015
@@ -255,93 +255,93 @@ if (VERSION > 3) {
</a>
</li>
<li>
-<a name="faq-N10019-menu"></a><a href="#faq-N10019">
+<a name="faq-N10020-menu"></a><a href="#faq-N10020">
My code uses the scratchpad, compiles fine but fails to run with a "MethodNotFoundException"
</a>
</li>
<li>
-<a name="faq-N10025-menu"></a><a href="#faq-N10025">
+<a name="faq-N1002C-menu"></a><a href="#faq-N1002C">
I'm using the poi-ooxml-schemas jar, but my code is failing with "java.lang.NoClassDefFoundError: org/openxmlformats/schemas/*something*"
</a>
</li>
<li>
-<a name="faq-N1005A-menu"></a><a href="#faq-N1005A">
+<a name="faq-N10061-menu"></a><a href="#faq-N10061">
Why is reading a simple sheet taking so long?
</a>
</li>
<li>
-<a name="faq-N10066-menu"></a><a href="#faq-N10066">
+<a name="faq-N1006D-menu"></a><a href="#faq-N1006D">
What is the HSSF "eventmodel"?
</a>
</li>
<li>
-<a name="faq-N10072-menu"></a><a href="#faq-N10072">
+<a name="faq-N10079-menu"></a><a href="#faq-N10079">
Why can't read the document I created using Star Office 5.1?
</a>
</li>
<li>
-<a name="faq-N1007E-menu"></a><a href="#faq-N1007E">
+<a name="faq-N10085-menu"></a><a href="#faq-N10085">
Why am I getting an exception each time I attempt to read my spreadsheet?
</a>
</li>
<li>
-<a name="faq-N1008D-menu"></a><a href="#faq-N1008D">
+<a name="faq-N10094-menu"></a><a href="#faq-N10094">
How do you tell if a spreadsheet cell contains a date?
</a>
</li>
<li>
-<a name="faq-N1009D-menu"></a><a href="#faq-N1009D">
+<a name="faq-N100A4-menu"></a><a href="#faq-N100A4">
I'm trying to stream an XLS file from a servlet and I'm having some trouble. What's the problem?
</a>
</li>
<li>
-<a name="faq-N100C7-menu"></a><a href="#faq-N100C7">
+<a name="faq-N100CE-menu"></a><a href="#faq-N100CE">
I want to set a cell format (Data format of a cell) of a excel sheet as ###,###,###.#### or ###,###,###.0000. Is it possible using POI ?
</a>
</li>
<li>
-<a name="faq-N100D7-menu"></a><a href="#faq-N100D7">
+<a name="faq-N100DE-menu"></a><a href="#faq-N100DE">
I want to set a cell format (Data format of a cell) of a excel sheet as text. Is it possible using POI ?
</a>
</li>
<li>
-<a name="faq-N100E3-menu"></a><a href="#faq-N100E3">
+<a name="faq-N100EA-menu"></a><a href="#faq-N100EA">
How do I add a border around a merged cell?
</a>
</li>
<li>
-<a name="faq-N100EF-menu"></a><a href="#faq-N100EF">
+<a name="faq-N100F6-menu"></a><a href="#faq-N100F6">
I am using styles when creating a workbook in POI, but Excel refuses to open the file, complaining about "Too Many Styles".
</a>
</li>
<li>
-<a name="faq-N10109-menu"></a><a href="#faq-N10109">
+<a name="faq-N10110-menu"></a><a href="#faq-N10110">
I think POI is using too much memory! What can I do?
</a>
</li>
<li>
-<a name="faq-N1012A-menu"></a><a href="#faq-N1012A">
+<a name="faq-N10131-menu"></a><a href="#faq-N10131">
I can't seem to find the source for the OOXML CT.. classes, where do they
come from?
</a>
</li>
<li>
-<a name="faq-N10152-menu"></a><a href="#faq-N10152">
+<a name="faq-N10159-menu"></a><a href="#faq-N10159">
An OLE2 ("binary") file is giving me problems, but I can't share it. How can I investigate the problem on my own?
</a>
</li>
<li>
-<a name="faq-N1016C-menu"></a><a href="#faq-N1016C">
+<a name="faq-N10173-menu"></a><a href="#faq-N10173">
An OOXML ("xml") file is giving me problems, but I can't share it. How can I investigate the problem on my own?
</a>
</li>
<li>
-<a name="faq-N1017E-menu"></a><a href="#faq-N1017E">
+<a name="faq-N10185-menu"></a><a href="#faq-N10185">
Why do I get a java.lang.NoClassDefFoundError: javax/xml/stream/XMLEventFactory.newFactory()
</a>
</li>
<li>
-<a name="faq-N1019C-menu"></a><a href="#faq-N1019C">
+<a name="faq-N101A3-menu"></a><a href="#faq-N101A3">
Can I mix POI jars from different versions?
</a>
</li>
@@ -372,10 +372,25 @@ ClassLoader classloader =
URL res = classloader.getResource(
"org/apache/poi/poifs/filesystem/POIFSFileSystem.class");
String path = res.getPath();
-System.out.println("Core POI came from " + path);
+System.out.println("POI Core came from " + path);
+ </pre>
+
+<p>To find out which jar file the POI OOXML and Scratchpad classes
+ are coming from, try these few lines of java:</p>
+
+<pre class="code">
+ClassLoader classloader = org.apache.poi.POIXMLDocument.class.getClassLoader();
+URL res = classloader.getResource("org/apache/poi/POIXMLDocument.class");
+String path = res.getPath();
+System.out.println("POI OOXML came from " + path);
+
+classloader = org.apache.poi.hslf.HSLFSlideShow.class.getClassLoader();
+res = classloader.getResource("org/apache/poi/hslf/HSLFSlideShow.class");
+path = res.getPath();
+System.out.println("POI Scratchpad came from " + path);
</pre>
-<a name="faq-N10019"></a>
+<a name="faq-N10020"></a>
<div class="h4">
<h4>2.
My code uses the scratchpad, compiles fine but fails to run with a "MethodNotFoundException"
@@ -385,7 +400,7 @@ System.out.println("Core POI came from "
<p>You almost certainly have an older version earlier on your
classpath. See the prior answer.</p>
-<a name="faq-N10025"></a>
+<a name="faq-N1002C"></a>
<div class="h4">
<h4>3.
I'm using the poi-ooxml-schemas jar, but my code is failing with "java.lang.NoClassDefFoundError: org/openxmlformats/schemas/*something*"
@@ -435,7 +450,7 @@ System.out.println("Core POI came from "
POI 3.7 won't work with ooxml-schemas-1.0.jar (it needs the newer
one).</p>
-<a name="faq-N1005A"></a>
+<a name="faq-N10061"></a>
<div class="h4">
<h4>4.
Why is reading a simple sheet taking so long?
@@ -449,7 +464,7 @@ System.out.println("Core POI came from "
errors are thrown as exceptions, which means you probably don't need
logging.</p>
-<a name="faq-N10066"></a>
+<a name="faq-N1006D"></a>
<div class="h4">
<h4>5.
What is the HSSF "eventmodel"?
@@ -461,7 +476,7 @@ System.out.println("Core POI came from "
tenfold. It is based on the AWT event model in combination with SAX. If you need read-only
access, this is the best way to do it.</p>
-<a name="faq-N10072"></a>
+<a name="faq-N10079"></a>
<div class="h4">
<h4>6.
Why can't read the document I created using Star Office 5.1?
@@ -471,7 +486,7 @@ System.out.println("Core POI came from "
<p>Star Office 5.1 writes some records using the older BIFF standard. This causes some problems
with POI which supports only BIFF8.</p>
-<a name="faq-N1007E"></a>
+<a name="faq-N10085"></a>
<div class="h4">
<h4>7.
Why am I getting an exception each time I attempt to read my spreadsheet?
@@ -483,7 +498,7 @@ System.out.println("Core POI came from "
<a href="http://issues.apache.org/bugzilla/buglist.cgi?product=POI">Bugzilla.</a>
</p>
-<a name="faq-N1008D"></a>
+<a name="faq-N10094"></a>
<div class="h4">
<h4>8.
How do you tell if a spreadsheet cell contains a date?
@@ -510,7 +525,7 @@ System.out.println("Core POI came from "
}
</pre>
-<a name="faq-N1009D"></a>
+<a name="faq-N100A4"></a>
<div class="h4">
<h4>9.
I'm trying to stream an XLS file from a servlet and I'm having some trouble. What's the problem?
@@ -562,7 +577,7 @@ System.out.println("Core POI came from "
</p>
-<a name="faq-N100C7"></a>
+<a name="faq-N100CE"></a>
<div class="h4">
<h4>10.
I want to set a cell format (Data format of a cell) of a excel sheet as ###,###,###.#### or ###,###,###.0000. Is it possible using POI ?
@@ -573,7 +588,7 @@ System.out.println("Core POI came from "
Yes. You first need to get a DataFormat object from the workbook and call getFormat with the desired format. Some examples are <a href="spreadsheet/quick-guide.html#DataFormats">here</a>.
</p>
-<a name="faq-N100D7"></a>
+<a name="faq-N100DE"></a>
<div class="h4">
<h4>11.
I want to set a cell format (Data format of a cell) of a excel sheet as text. Is it possible using POI ?
@@ -584,7 +599,7 @@ System.out.println("Core POI came from "
Yes. This is a built-in format for excel that you can get from DataFormat object using the format string "@". Also, the string "text" will alias this format.
</p>
-<a name="faq-N100E3"></a>
+<a name="faq-N100EA"></a>
<div class="h4">
<h4>12.
How do I add a border around a merged cell?
@@ -594,7 +609,7 @@ System.out.println("Core POI came from "
<p>Add blank cells around where the cells normally would have been and set the borders individually for each cell.
We will probably enhance HSSF in the future to make this process easier.</p>
-<a name="faq-N100EF"></a>
+<a name="faq-N100F6"></a>
<div class="h4">
<h4>13.
I am using styles when creating a workbook in POI, but Excel refuses to open the file, complaining about "Too Many Styles".
@@ -680,7 +695,7 @@ System.out.println("Core POI came from "
fileOut.close();
</pre>
-<a name="faq-N10109"></a>
+<a name="faq-N10110"></a>
<div class="h4">
<h4>14.
I think POI is using too much memory! What can I do?
@@ -719,7 +734,7 @@ System.out.println("Core POI came from "
files). If these tests are fast, then any performance problems are in your
code!</p>
-<a name="faq-N1012A"></a>
+<a name="faq-N10131"></a>
<div class="h4">
<h4>15.
I can't seem to find the source for the OOXML CT.. classes, where do they
@@ -750,7 +765,7 @@ System.out.println("Core POI came from "
automatically download the specification XML Schema, and compile it for
you to generate the source and binary ooxml-schemas jars.</p>
-<a name="faq-N10152"></a>
+<a name="faq-N10159"></a>
<div class="h4">
<h4>16.
An OLE2 ("binary") file is giving me problems, but I can't share it. How can I investigate the problem on my own?
@@ -775,7 +790,7 @@ System.out.println("Core POI came from "
allow you to check that things are being read as you expect, and
narrow in on problem records and structures.</p>
-<a name="faq-N1016C"></a>
+<a name="faq-N10173"></a>
<div class="h4">
<h4>17.
An OOXML ("xml") file is giving me problems, but I can't share it. How can I investigate the problem on my own?
@@ -797,7 +812,7 @@ System.out.println("Core POI came from "
unable to then include the snippet of XML for the problem area, and
reference the OOXML standard for what it should contain.</p>
-<a name="faq-N1017E"></a>
+<a name="faq-N10185"></a>
<div class="h4">
<h4>18.
Why do I get a java.lang.NoClassDefFoundError: javax/xml/stream/XMLEventFactory.newFactory()
@@ -831,7 +846,7 @@ System.out.println("Core POI came from "
</ul>
-<a name="faq-N1019C"></a>
+<a name="faq-N101A3"></a>
<div class="h4">
<h4>19.
Can I mix POI jars from different versions?
Modified: poi/site/publish/howtobuild.html
URL: http://svn.apache.org/viewvc/poi/site/publish/howtobuild.html?rev=1669366&r1=1669365&r2=1669366&view=diff
==============================================================================
--- poi/site/publish/howtobuild.html (original)
+++ poi/site/publish/howtobuild.html Thu Mar 26 16:36:57 2015
@@ -409,7 +409,8 @@ if (VERSION > 3) {
<p>
Note: when executing junit tests from within Eclipse, you might need to set the system
- property "POI.testdata.path" to make the test framework find the required test-files.
+ 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>
Modified: poi/site/src/documentation/content/xdocs/faq.xml
URL: http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/faq.xml?rev=1669366&r1=1669365&r2=1669366&view=diff
==============================================================================
--- poi/site/src/documentation/content/xdocs/faq.xml (original)
+++ poi/site/src/documentation/content/xdocs/faq.xml Thu Mar 26 16:36:57 2015
@@ -38,7 +38,20 @@ ClassLoader classloader =
URL res = classloader.getResource(
"org/apache/poi/poifs/filesystem/POIFSFileSystem.class");
String path = res.getPath();
-System.out.println("Core POI came from " + path);
+System.out.println("POI Core came from " + path);
+ </source>
+ <p>To find out which jar file the POI OOXML and Scratchpad classes
+ are coming from, try these few lines of java:</p>
+ <source>
+ClassLoader classloader = org.apache.poi.POIXMLDocument.class.getClassLoader();
+URL res = classloader.getResource("org/apache/poi/POIXMLDocument.class");
+String path = res.getPath();
+System.out.println("POI OOXML came from " + path);
+
+classloader = org.apache.poi.hslf.HSLFSlideShow.class.getClassLoader();
+res = classloader.getResource("org/apache/poi/hslf/HSLFSlideShow.class");
+path = res.getPath();
+System.out.println("POI Scratchpad came from " + path);
</source>
</answer>
</faq>
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org