poi-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From n...@apache.org
Subject svn commit: r1669366 - in /poi/site: publish/changes.html publish/changes.rss publish/faq.html publish/howtobuild.html src/documentation/content/xdocs/faq.xml
Date Thu, 26 Mar 2015 16:36:57 GMT
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


Mime
View raw message