poi-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From n...@apache.org
Subject svn commit: r1669369 - in /poi/site: publish/faq.html src/documentation/content/xdocs/faq.xml
Date Thu, 26 Mar 2015 16:45:12 GMT
Author: nick
Date: Thu Mar 26 16:45:12 2015
New Revision: 1669369

URL: http://svn.apache.org/r1669369
Log:
Re-jig the change, so that FAQ numbers are not altered

Modified:
    poi/site/publish/faq.html
    poi/site/src/documentation/content/xdocs/faq.xml

Modified: poi/site/publish/faq.html
URL: http://svn.apache.org/viewvc/poi/site/publish/faq.html?rev=1669369&r1=1669368&r2=1669369&view=diff
==============================================================================
--- poi/site/publish/faq.html (original)
+++ poi/site/publish/faq.html Thu Mar 26 16:45:12 2015
@@ -255,93 +255,93 @@ if (VERSION > 3) {
     </a>
 </li>
 <li>
-<a name="faq-N10020-menu"></a><a href="#faq-N10020">
+<a name="faq-N10019-menu"></a><a href="#faq-N10019">
       My code uses the scratchpad, compiles fine but fails to run with a "MethodNotFoundException"
     </a>
 </li>
 <li>
-<a name="faq-N1002C-menu"></a><a href="#faq-N1002C">
+<a name="faq-N10025-menu"></a><a href="#faq-N10025">
       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-N10061-menu"></a><a href="#faq-N10061">
+<a name="faq-N1005A-menu"></a><a href="#faq-N1005A">
       Why is reading a simple sheet taking so long?
     </a>
 </li>
 <li>
-<a name="faq-N1006D-menu"></a><a href="#faq-N1006D">
+<a name="faq-N10066-menu"></a><a href="#faq-N10066">
       What is the HSSF "eventmodel"?
     </a>
 </li>
 <li>
-<a name="faq-N10079-menu"></a><a href="#faq-N10079">
+<a name="faq-N10072-menu"></a><a href="#faq-N10072">
       Why can't read the document I created using Star Office 5.1?
     </a>
 </li>
 <li>
-<a name="faq-N10085-menu"></a><a href="#faq-N10085">
+<a name="faq-N1007E-menu"></a><a href="#faq-N1007E">
       Why am I getting an exception each time I attempt to read my spreadsheet?
     </a>
 </li>
 <li>
-<a name="faq-N10094-menu"></a><a href="#faq-N10094">
+<a name="faq-N1008D-menu"></a><a href="#faq-N1008D">
       How do you tell if a spreadsheet cell contains a date?
     </a>
 </li>
 <li>
-<a name="faq-N100A4-menu"></a><a href="#faq-N100A4">
+<a name="faq-N1009D-menu"></a><a href="#faq-N1009D">
       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-N100CE-menu"></a><a href="#faq-N100CE">
+<a name="faq-N100C7-menu"></a><a href="#faq-N100C7">
       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-N100DE-menu"></a><a href="#faq-N100DE">
+<a name="faq-N100D7-menu"></a><a href="#faq-N100D7">
       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-N100EA-menu"></a><a href="#faq-N100EA">
+<a name="faq-N100E3-menu"></a><a href="#faq-N100E3">
       How do I add a border around a merged cell?
     </a>
 </li>
 <li>
-<a name="faq-N100F6-menu"></a><a href="#faq-N100F6">
+<a name="faq-N100EF-menu"></a><a href="#faq-N100EF">
       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-N10110-menu"></a><a href="#faq-N10110">
+<a name="faq-N10109-menu"></a><a href="#faq-N10109">
       I think POI is using too much memory! What can I do?
     </a>
 </li>
 <li>
-<a name="faq-N10131-menu"></a><a href="#faq-N10131">
+<a name="faq-N1012A-menu"></a><a href="#faq-N1012A">
       I can't seem to find the source for the OOXML CT.. classes, where do they
       come from?
     </a>
 </li>
 <li>
-<a name="faq-N10159-menu"></a><a href="#faq-N10159">
+<a name="faq-N10152-menu"></a><a href="#faq-N10152">
       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-N10173-menu"></a><a href="#faq-N10173">
+<a name="faq-N1016C-menu"></a><a href="#faq-N1016C">
       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-N10185-menu"></a><a href="#faq-N10185">
+<a name="faq-N1017E-menu"></a><a href="#faq-N1017E">
       Why do I get a java.lang.NoClassDefFoundError: javax/xml/stream/XMLEventFactory.newFactory()
     </a>
 </li>
 <li>
-<a name="faq-N101A3-menu"></a><a href="#faq-N101A3">
+<a name="faq-N1019C-menu"></a><a href="#faq-N1019C">
       Can I mix POI jars from different versions?
     </a>
 </li>
@@ -357,14 +357,16 @@ if (VERSION > 3) {
     </h4>
 </div>
       
-<p>You almost certainly have an older version of POI 
+<p>You almost certainly have an older version of Apache POI 
 	on your classpath. Quite a few runtimes and other packages 
-	will ship an older version of POI, so this is an easy problem
-	to hit without your realising.</p>
-      
-<p>The best way to identify the offending earlier jar file is
-	with a few lines of java. These will load one of the core POI
-	classes, and report where it came from.</p>
+	will ship older version of Apache POI, so this is an easy problem
+	to hit without your realising. Some will ship just one old jar,
+   some may ship a full set of old POI jars.</p>
+      
+<p>The best way to identify the offending earlier jar files is
+	with a few lines of java. These will load a Core POI class, an
+   OOXML class and a Scratchpad class, and report where they all came
+   from.</p>
       
 <pre class="code">
 ClassLoader classloader =
@@ -373,15 +375,10 @@ URL res = classloader.getResource(
              "org/apache/poi/poifs/filesystem/POIFSFileSystem.class");
 String path = res.getPath();
 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();
+
+classloader = org.apache.poi.POIXMLDocument.class.getClassLoader();
+res = classloader.getResource("org/apache/poi/POIXMLDocument.class");
+path = res.getPath();
 System.out.println("POI OOXML came from " + path);
 
 classloader = org.apache.poi.hslf.HSLFSlideShow.class.getClassLoader();
@@ -390,7 +387,7 @@ path = res.getPath();
 System.out.println("POI Scratchpad came from " + path);
       </pre>
     
-<a name="faq-N10020"></a>
+<a name="faq-N10019"></a>
 <div class="h4">
 <h4>2. 
       My code uses the scratchpad, compiles fine but fails to run with a "MethodNotFoundException"
@@ -400,7 +397,7 @@ System.out.println("POI Scratchpad came
 <p>You almost certainly have an older version earlier on your
 	classpath. See the prior answer.</p>
     
-<a name="faq-N1002C"></a>
+<a name="faq-N10025"></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*"
@@ -450,7 +447,7 @@ System.out.println("POI Scratchpad came
        POI 3.7 won't work with ooxml-schemas-1.0.jar (it needs the newer
        one).</p>
     
-<a name="faq-N10061"></a>
+<a name="faq-N1005A"></a>
 <div class="h4">
 <h4>4. 
       Why is reading a simple sheet taking so long?
@@ -464,7 +461,7 @@ System.out.println("POI Scratchpad came
         errors are thrown as exceptions, which means you probably don't need
         logging.</p>
     
-<a name="faq-N1006D"></a>
+<a name="faq-N10066"></a>
 <div class="h4">
 <h4>5. 
       What is the HSSF "eventmodel"?
@@ -476,7 +473,7 @@ System.out.println("POI Scratchpad came
         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-N10079"></a>
+<a name="faq-N10072"></a>
 <div class="h4">
 <h4>6. 
       Why can't read the document I created using Star Office 5.1?
@@ -486,7 +483,7 @@ System.out.println("POI Scratchpad came
 <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-N10085"></a>
+<a name="faq-N1007E"></a>
 <div class="h4">
 <h4>7. 
       Why am I getting an exception each time I attempt to read my spreadsheet?
@@ -498,7 +495,7 @@ System.out.println("POI Scratchpad came
 	<a href="http://issues.apache.org/bugzilla/buglist.cgi?product=POI">Bugzilla.</a>
 </p>
     
-<a name="faq-N10094"></a>
+<a name="faq-N1008D"></a>
 <div class="h4">
 <h4>8. 
       How do you tell if a spreadsheet cell contains a date?
@@ -525,7 +522,7 @@ System.out.println("POI Scratchpad came
          }
       </pre>
     
-<a name="faq-N100A4"></a>
+<a name="faq-N1009D"></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?
@@ -577,7 +574,7 @@ System.out.println("POI Scratchpad came
       </p>
       
     
-<a name="faq-N100CE"></a>
+<a name="faq-N100C7"></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 ?
@@ -588,7 +585,7 @@ System.out.println("POI Scratchpad came
 	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-N100DE"></a>
+<a name="faq-N100D7"></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 ?
@@ -599,7 +596,7 @@ System.out.println("POI Scratchpad came
 	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-N100EA"></a>
+<a name="faq-N100E3"></a>
 <div class="h4">
 <h4>12. 
       How do I add a border around a merged cell?
@@ -609,7 +606,7 @@ System.out.println("POI Scratchpad came
 <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-N100F6"></a>
+<a name="faq-N100EF"></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".
@@ -695,7 +692,7 @@ System.out.println("POI Scratchpad came
  fileOut.close();
       </pre>
     
-<a name="faq-N10110"></a>
+<a name="faq-N10109"></a>
 <div class="h4">
 <h4>14. 
       I think POI is using too much memory! What can I do?
@@ -734,7 +731,7 @@ System.out.println("POI Scratchpad came
      files). If these tests are fast, then any performance problems are in your
      code!</p>
     
-<a name="faq-N10131"></a>
+<a name="faq-N1012A"></a>
 <div class="h4">
 <h4>15. 
       I can't seem to find the source for the OOXML CT.. classes, where do they
@@ -765,7 +762,7 @@ System.out.println("POI Scratchpad came
          automatically download the specification XML Schema, and compile it for 
          you to generate the source and binary ooxml-schemas jars.</p>
     
-<a name="faq-N10159"></a>
+<a name="faq-N10152"></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?
@@ -790,7 +787,7 @@ System.out.println("POI Scratchpad came
         allow you to check that things are being read as you expect, and 
         narrow in on problem records and structures.</p>
     
-<a name="faq-N10173"></a>
+<a name="faq-N1016C"></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?
@@ -812,7 +809,7 @@ System.out.println("POI Scratchpad came
          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-N10185"></a>
+<a name="faq-N1017E"></a>
 <div class="h4">
 <h4>18. 
       Why do I get a java.lang.NoClassDefFoundError: javax/xml/stream/XMLEventFactory.newFactory()
@@ -846,7 +843,7 @@ System.out.println("POI Scratchpad came
 	  
 </ul>
     
-<a name="faq-N101A3"></a>
+<a name="faq-N1019C"></a>
 <div class="h4">
 <h4>19. 
       Can I mix POI jars from different versions?

Modified: poi/site/src/documentation/content/xdocs/faq.xml
URL: http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/faq.xml?rev=1669369&r1=1669368&r2=1669369&view=diff
==============================================================================
--- poi/site/src/documentation/content/xdocs/faq.xml (original)
+++ poi/site/src/documentation/content/xdocs/faq.xml Thu Mar 26 16:45:12 2015
@@ -25,13 +25,15 @@
       My code uses some new feature, compiles fine but fails when live with a "MethodNotFoundException"
or "IncompatibleClassChangeError"
     </question>
     <answer>
-      <p>You almost certainly have an older version of POI 
+      <p>You almost certainly have an older version of Apache POI 
 	on your classpath. Quite a few runtimes and other packages 
-	will ship an older version of POI, so this is an easy problem
-	to hit without your realising.</p>
-      <p>The best way to identify the offending earlier jar file is
-	with a few lines of java. These will load one of the core POI
-	classes, and report where it came from.</p>
+	will ship older version of Apache POI, so this is an easy problem
+	to hit without your realising. Some will ship just one old jar,
+   some may ship a full set of old POI jars.</p>
+      <p>The best way to identify the offending earlier jar files is
+	with a few lines of java. These will load a Core POI class, an
+   OOXML class and a Scratchpad class, and report where they all came
+   from.</p>
       <source>
 ClassLoader classloader =
    org.apache.poi.poifs.filesystem.POIFSFileSystem.class.getClassLoader();
@@ -39,13 +41,10 @@ URL res = classloader.getResource(
              "org/apache/poi/poifs/filesystem/POIFSFileSystem.class");
 String path = res.getPath();
 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();
+
+classloader = org.apache.poi.POIXMLDocument.class.getClassLoader();
+res = classloader.getResource("org/apache/poi/POIXMLDocument.class");
+path = res.getPath();
 System.out.println("POI OOXML came from " + path);
 
 classloader = org.apache.poi.hslf.HSLFSlideShow.class.getClassLoader();



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org


Mime
View raw message