Modified: poi/site/src/documentation/content/xdocs/components/poifs/embeded.xml URL: http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/components/poifs/embeded.xml?rev=1836243&r1=1836242&r2=1836243&view=diff ============================================================================== --- poi/site/src/documentation/content/xdocs/components/poifs/embeded.xml (original) +++ poi/site/src/documentation/content/xdocs/components/poifs/embeded.xml Wed Jul 18 23:24:53 2018 @@ -17,7 +17,7 @@ limitations under the License. ==================================================================== --> -<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V1.3//EN" "../dtd/document-v13.dtd"> +<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V2.0//EN" "document-v20.dtd"> <document> <header> <title>Apache POI - POIFS - Documents embedded in other documents</title> @@ -62,7 +62,7 @@ <p>PowerPoint does not normally store embedded files in the OLE2 layer. Instead, they are held within records of the main PowerPoint file. - <br/>See the <link href="./../slideshow/how-to-shapes.html#OLE">HSLF Tutorial</link> + <br/>See the <a href="./../slideshow/how-to-shapes.html#OLE">HSLF Tutorial</a> for how to retrieve embedded OLE objects from a presentation</p> </section> </section>
Modified: poi/site/src/documentation/content/xdocs/components/poifs/fileformat.xml URL: http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/components/poifs/fileformat.xml?rev=1836243&r1=1836242&r2=1836243&view=diff ============================================================================== --- poi/site/src/documentation/content/xdocs/components/poifs/fileformat.xml (original) +++ poi/site/src/documentation/content/xdocs/components/poifs/fileformat.xml Wed Jul 18 23:24:53 2018 @@ -17,7 +17,7 @@ limitations under the License. ==================================================================== --> -<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V1.3//EN" "../dtd/document-v13.dtd"> +<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V2.0//EN" "document-v20.dtd"> <document> <header> <title>POIFS File System Internals</title> @@ -57,13 +57,13 @@ <p>Note - this document is a good overview and explanation of the file format, but for the very nitty-gritty details, you should refer to - <link href="http://msdn.microsoft.com/en-us/library/dd942138%28v=prot.13%29.aspx";>[MS-CFB].pdf</link> + <a href="http://msdn.microsoft.com/en-us/library/dd942138%28v=prot.13%29.aspx";>[MS-CFB].pdf</a> in the (now public) Microsoft Documentation.</p> </section> <section><title>Document Conventions</title> <p>This document utilizes the numeric types as described by the Java Language Specification, which can be found at - <link href="http://java.sun.com";>http://java.sun.com</link>. In + <a href="http://java.sun.com";>http://java.sun.com</a>. In short:</p> <ul> <li>A <em>byte</em> is an 8 bit signed integer ranging from Modified: poi/site/src/documentation/content/xdocs/components/poifs/how-to.xml URL: http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/components/poifs/how-to.xml?rev=1836243&r1=1836242&r2=1836243&view=diff ============================================================================== --- poi/site/src/documentation/content/xdocs/components/poifs/how-to.xml (original) +++ poi/site/src/documentation/content/xdocs/components/poifs/how-to.xml Wed Jul 18 23:24:53 2018 @@ -17,7 +17,7 @@ limitations under the License. ==================================================================== --> -<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V1.3//EN" "../dtd/document-v13.dtd"> +<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V2.0//EN" "document-v20.dtd"> <document> <header> <title>How To Use the POIFS APIs</title> @@ -81,14 +81,14 @@ that employ a POIFS-compatible data structure to organize their content. The following use cases are covered:</p> <ul> - <li><link href="#reading">Reading a File System</link></li> - <li><link href="#reading_poifsfilesystem">Conventional Reading with - POIFSFileSystem</link></li> - <li><link href="#reading_npoifsfilesystem">NIO Reading using - NPOIFSFileSystem</link></li> - <li><link href="#reading_event">Event-Driven Reading</link></li> - <li><link href="#writing">Writing a File System</link></li> - <li><link href="#modifying">Modifying a File System</link></li> + <li><a href="#reading">Reading a File System</a></li> + <li><a href="#reading_poifsfilesystem">Conventional Reading with + POIFSFileSystem</a></li> + <li><a href="#reading_npoifsfilesystem">NIO Reading using + NPOIFSFileSystem</a></li> + <li><a href="#reading_event">Event-Driven Reading</a></li> + <li><a href="#writing">Writing a File System</a></li> + <li><a href="#modifying">Modifying a File System</a></li> </ul> </section> @@ -506,7 +506,7 @@ fs.close(); out.close(); </source> <p>For an example of an in-place change to one stream within a file, you - can see the example <link href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hpsf/examples/ModifyDocumentSummaryInformation.java";>org/apache/poi/hpsf/examples/ModifyDocumentSummaryInformation.java</link></p> + can see the example <a href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hpsf/examples/ModifyDocumentSummaryInformation.java";>org/apache/poi/hpsf/examples/ModifyDocumentSummaryInformation.java</a></p> </section> <section><title>Renaming a File</title> <p>Regardless of whether the file is a directory or a document, it can be renamed, with one exception - the root directory has a special name that is expected by the components of a major software vendor's office suite, and the POIFS API will not let that name be changed. Renaming is done by acquiring the file's corresponding <code>Entry</code> instance and calling its <code>renameTo</code> method, passing in the new name.</p> Modified: poi/site/src/documentation/content/xdocs/components/poifs/index.xml URL: http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/components/poifs/index.xml?rev=1836243&r1=1836242&r2=1836243&view=diff ============================================================================== --- poi/site/src/documentation/content/xdocs/components/poifs/index.xml (original) +++ poi/site/src/documentation/content/xdocs/components/poifs/index.xml Wed Jul 18 23:24:53 2018 @@ -17,7 +17,7 @@ limitations under the License. ==================================================================== --> -<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V1.3//EN" "../dtd/document-v13.dtd"> +<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V2.0//EN" "document-v20.dtd"> <document> <header> <title>Apache POI - POIFS - Java implementation of the OLE 2 Compound Document format</title> Modified: poi/site/src/documentation/content/xdocs/components/poifs/usecases.xml URL: http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/components/poifs/usecases.xml?rev=1836243&r1=1836242&r2=1836243&view=diff ============================================================================== --- poi/site/src/documentation/content/xdocs/components/poifs/usecases.xml (original) +++ poi/site/src/documentation/content/xdocs/components/poifs/usecases.xml Wed Jul 18 23:24:53 2018 @@ -17,7 +17,7 @@ limitations under the License. ==================================================================== --> -<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V1.3//EN" "../dtd/document-v13.dtd"> +<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V2.0//EN" "document-v20.dtd"> <document> <header> <title>POIFS Use Cases</title> Modified: poi/site/src/documentation/content/xdocs/components/slideshow/how-to-shapes.xml URL: http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/components/slideshow/how-to-shapes.xml?rev=1836243&r1=1836242&r2=1836243&view=diff ============================================================================== --- poi/site/src/documentation/content/xdocs/components/slideshow/how-to-shapes.xml (original) +++ poi/site/src/documentation/content/xdocs/components/slideshow/how-to-shapes.xml Wed Jul 18 23:24:53 2018 @@ -17,7 +17,7 @@ limitations under the License. ==================================================================== --> -<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V1.3//EN" "../dtd/document-v13.dtd"> +<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V2.0//EN" "document-v20.dtd"> <document> <header> @@ -30,23 +30,23 @@ <section><title>Busy Developers' Guide to HSLF drawing layer</title> <section><title>Index of Features</title> <ul> - <li><link href="#NewPresentation">How to create a new presentation and add new slides to it</link></li> - <li><link href="#PageSize">How to retrieve or change slide size</link></li> - <li><link href="#GetShapes">How to get shapes contained in a particular slide</link></li> - <li><link href="#Shapes">Drawing a shape on a slide</link></li> - <li><link href="#Pictures">How to work with pictures</link></li> - <li><link href="#SlideTitle">How to set slide title</link></li> - <li><link href="#Fill">How to work with slide/shape background</link></li> - <li><link href="#Bullets">How to create bulleted lists</link></li> - <li><link href="#Hyperlinks">Hyperlinks</link></li> - <li><link href="#Tables">Tables</link></li> - <li><link href="#RemoveShape">How to remove shapes</link></li> - <li><link href="#OLE">How to retrieve embedded OLE objects</link></li> - <li><link href="#Sound">How to retrieve embedded sounds</link></li> - <li><link href="#Freeform">How to create shapes of arbitrary geometry</link></li> - <li><link href="#Graphics2D">Shapes and Graphics2D</link></li> - <li><link href="#Render">How to convert slides into images</link></li> - <li><link href="#HeadersFooters">Headers / Footers</link></li> + <li><a href="#NewPresentation">How to create a new presentation and add new slides to it</a></li> + <li><a href="#PageSize">How to retrieve or change slide size</a></li> + <li><a href="#GetShapes">How to get shapes contained in a particular slide</a></li> + <li><a href="#Shapes">Drawing a shape on a slide</a></li> + <li><a href="#Pictures">How to work with pictures</a></li> + <li><a href="#SlideTitle">How to set slide title</a></li> + <li><a href="#Fill">How to work with slide/shape background</a></li> + <li><a href="#Bullets">How to create bulleted lists</a></li> + <li><a href="#Hyperlinks">Hyperlinks</a></li> + <li><a href="#Tables">Tables</a></li> + <li><a href="#RemoveShape">How to remove shapes</a></li> + <li><a href="#OLE">How to retrieve embedded OLE objects</a></li> + <li><a href="#Sound">How to retrieve embedded sounds</a></li> + <li><a href="#Freeform">How to create shapes of arbitrary geometry</a></li> + <li><a href="#Graphics2D">Shapes and Graphics2D</a></li> + <li><a href="#Render">How to convert slides into images</a></li> + <li><a href="#HeadersFooters">Headers / Footers</a></li> </ul> </section> <section><title>Features</title> Modified: poi/site/src/documentation/content/xdocs/components/slideshow/index.xml URL: http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/components/slideshow/index.xml?rev=1836243&r1=1836242&r2=1836243&view=diff ============================================================================== --- poi/site/src/documentation/content/xdocs/components/slideshow/index.xml (original) +++ poi/site/src/documentation/content/xdocs/components/slideshow/index.xml Wed Jul 18 23:24:53 2018 @@ -17,7 +17,7 @@ limitations under the License. ==================================================================== --> -<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V1.3//EN" "../dtd/document-v13.dtd"> +<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V2.0//EN" "document-v20.dtd"> <document> <header> @@ -43,15 +43,15 @@ </ul> <note> This code currently lives the - <link href="http://svn.apache.org/viewvc/poi/trunk/src/scratchpad/";>scratchpad area</link> + <a href="http://svn.apache.org/viewvc/poi/trunk/src/scratchpad/";>scratchpad area</a> of the POI SVN repository. To use this component, ensure you have the Scratchpad Jar on your classpath, or a dependency defined on the <em>poi-scratchpad</em> artifact - the main POI jar is not enough! See the - <link href="/overview.html#components">POI Components Map</link> + <a href="site:components">POI Components Map</a> for more details. </note> - <p>The <link href="./quick-guide.html">quick guide</link> documentation provides + <p>The <a href="./quick-guide.html">quick guide</a> documentation provides information on using this API. Comments and fixes gratefully accepted on the POI dev mailing lists.</p> </section> @@ -65,7 +65,7 @@ Please note that XSLF is still in early development and is a subject to incompatible changes in future. </p> <p> - A quick guide is available in the <link href="./xslf-cookbook.html">XSLF Cookbook</link> + A quick guide is available in the <a href="./xslf-cookbook.html">XSLF Cookbook</a> </p> </section> </body> Modified: poi/site/src/documentation/content/xdocs/components/slideshow/ppt-file-format.xml URL: http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/components/slideshow/ppt-file-format.xml?rev=1836243&r1=1836242&r2=1836243&view=diff ============================================================================== --- poi/site/src/documentation/content/xdocs/components/slideshow/ppt-file-format.xml (original) +++ poi/site/src/documentation/content/xdocs/components/slideshow/ppt-file-format.xml Wed Jul 18 23:24:53 2018 @@ -17,7 +17,7 @@ limitations under the License. ==================================================================== --> -<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V1.3//EN" "../dtd/document-v13.dtd"> +<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V2.0//EN" "document-v20.dtd"> <document> <header> Modified: poi/site/src/documentation/content/xdocs/components/slideshow/quick-guide.xml URL: http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/components/slideshow/quick-guide.xml?rev=1836243&r1=1836242&r2=1836243&view=diff ============================================================================== --- poi/site/src/documentation/content/xdocs/components/slideshow/quick-guide.xml (original) +++ poi/site/src/documentation/content/xdocs/components/slideshow/quick-guide.xml Wed Jul 18 23:24:53 2018 @@ -17,7 +17,7 @@ limitations under the License. ==================================================================== --> -<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V1.3//EN" "../dtd/document-v13.dtd"> +<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V2.0//EN" "document-v20.dtd"> <document> <header> Modified: poi/site/src/documentation/content/xdocs/components/slideshow/xslf-cookbook.xml URL: http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/components/slideshow/xslf-cookbook.xml?rev=1836243&r1=1836242&r2=1836243&view=diff ============================================================================== --- poi/site/src/documentation/content/xdocs/components/slideshow/xslf-cookbook.xml (original) +++ poi/site/src/documentation/content/xdocs/components/slideshow/xslf-cookbook.xml Wed Jul 18 23:24:53 2018 @@ -17,7 +17,7 @@ limitations under the License. ==================================================================== --> -<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V1.3//EN" "../dtd/document-v13.dtd"> +<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V2.0//EN" "document-v20.dtd"> <document> <header> @@ -30,7 +30,7 @@ <section><title>XSLF Cookbook</title> <p> This page offers a short introduction into the XSLF API. More examples can be found in the - <link href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xslf/usermodel/";> XSLF Examples</link> + <a href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xslf/usermodel/";> XSLF Examples</a> in the POI SVN repository. </p> <note> @@ -38,19 +38,19 @@ </note> <section><title>Index of Features</title> <ul> - <li><link href="#NewPresentation">Create a new presentation</link></li> - <li><link href="#ReadPresentation">Read an existing presentation</link></li> - <li><link href="#SlideLayout">Create a slide with a predefined layout</link></li> - <li><link href="#DeleteSlide">Delete slide</link></li> - <li><link href="#MoveSlide">Re-order slides</link></li> - <li><link href="#SlideSize">Change slide size</link></li> - <li><link href="#GetShapes">Read shapes</link></li> - <li><link href="#AddImage">Add image</link></li> - <li><link href="#ReadImages">Read images contained in a presentation</link></li> - <li><link href="#Text">Format text</link></li> - <li><link href="#Hyperlinks">Hyperlinks</link></li> - <li><link href="#PPTX2PNG">Convert .pptx slides into images</link></li> - <li><link href="#Merge">Merge multiple presentations together</link></li> + <li><a href="#NewPresentation">Create a new presentation</a></li> + <li><a href="#ReadPresentation">Read an existing presentation</a></li> + <li><a href="#SlideLayout">Create a slide with a predefined layout</a></li> + <li><a href="#DeleteSlide">Delete slide</a></li> + <li><a href="#MoveSlide">Re-order slides</a></li> + <li><a href="#SlideSize">Change slide size</a></li> + <li><a href="#GetShapes">Read shapes</a></li> + <li><a href="#AddImage">Add image</a></li> + <li><a href="#ReadImages">Read images contained in a presentation</a></li> + <li><a href="#Text">Format text</a></li> + <li><a href="#Hyperlinks">Hyperlinks</a></li> + <li><a href="#PPTX2PNG">Convert .pptx slides into images</a></li> + <li><a href="#Merge">Merge multiple presentations together</a></li> </ul> </section> <section><title>Cookbook</title> @@ -273,7 +273,7 @@ Options: where graphics is a class implementing java.awt.Graphics2D. In PPTX2PNG the graphic canvas is derived from java.awt.image.BufferedImage, i.e. the destination is an image in memory, but in general case you can pass any compliant implementation of java.awt.Graphics2D. The - <link href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xslf/usermodel/PPTX2SVG.txt";>PPTX2SVG</link> + <a href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xslf/usermodel/PPTX2SVG.txt";>PPTX2SVG</a> example demonstrates how to use Apache Batik to convert .pptx slides into SVG format. </p> </section> Modified: poi/site/src/documentation/content/xdocs/components/spreadsheet/chart.xml URL: http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/components/spreadsheet/chart.xml?rev=1836243&r1=1836242&r2=1836243&view=diff ============================================================================== --- poi/site/src/documentation/content/xdocs/components/spreadsheet/chart.xml (original) +++ poi/site/src/documentation/content/xdocs/components/spreadsheet/chart.xml Wed Jul 18 23:24:53 2018 @@ -17,7 +17,7 @@ limitations under the License. ==================================================================== --> -<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V1.3//EN" "../dtd/document-v13.dtd"> +<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V2.0//EN" "document-v20.dtd"> <document> <header> Modified: poi/site/src/documentation/content/xdocs/components/spreadsheet/converting.xml URL: http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/components/spreadsheet/converting.xml?rev=1836243&r1=1836242&r2=1836243&view=diff ============================================================================== --- poi/site/src/documentation/content/xdocs/components/spreadsheet/converting.xml (original) +++ poi/site/src/documentation/content/xdocs/components/spreadsheet/converting.xml Wed Jul 18 23:24:53 2018 @@ -17,7 +17,7 @@ limitations under the License. ==================================================================== --> -<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V1.3//EN" "../dtd/document-v13.dtd"> +<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V2.0//EN" "document-v20.dtd"> <document> <header> Modified: poi/site/src/documentation/content/xdocs/components/spreadsheet/diagram1.xml URL: http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/components/spreadsheet/diagram1.xml?rev=1836243&r1=1836242&r2=1836243&view=diff ============================================================================== --- poi/site/src/documentation/content/xdocs/components/spreadsheet/diagram1.xml (original) +++ poi/site/src/documentation/content/xdocs/components/spreadsheet/diagram1.xml Wed Jul 18 23:24:53 2018 @@ -17,7 +17,7 @@ limitations under the License. ==================================================================== --> -<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V1.3//EN" "../dtd/document-v13.dtd"> +<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V2.0//EN" "document-v20.dtd"> <document> <header> Modified: poi/site/src/documentation/content/xdocs/components/spreadsheet/diagrams.xml URL: http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/components/spreadsheet/diagrams.xml?rev=1836243&r1=1836242&r2=1836243&view=diff ============================================================================== --- poi/site/src/documentation/content/xdocs/components/spreadsheet/diagrams.xml (original) +++ poi/site/src/documentation/content/xdocs/components/spreadsheet/diagrams.xml Wed Jul 18 23:24:53 2018 @@ -17,7 +17,7 @@ limitations under the License. ==================================================================== --> -<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V1.3//EN" "../dtd/document-v13.dtd"> +<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V2.0//EN" "document-v20.dtd"> <document> <header> @@ -37,7 +37,7 @@ </p> <ul> <li> - <link href="diagram1.html">HSSF usermodel class diagram</link> - + <a href="diagram1.html">HSSF usermodel class diagram</a> - by Matthew Young (myoung at westernasset dot com) </li> </ul> Modified: poi/site/src/documentation/content/xdocs/components/spreadsheet/eval-devguide.xml URL: http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/components/spreadsheet/eval-devguide.xml?rev=1836243&r1=1836242&r2=1836243&view=diff ============================================================================== --- poi/site/src/documentation/content/xdocs/components/spreadsheet/eval-devguide.xml (original) +++ poi/site/src/documentation/content/xdocs/components/spreadsheet/eval-devguide.xml Wed Jul 18 23:24:53 2018 @@ -17,7 +17,7 @@ limitations under the License. ==================================================================== --> -<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V1.3//EN" "../dtd/document-v13.dtd"> +<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V2.0//EN" "document-v20.dtd"> <document> <header> @@ -48,8 +48,8 @@ form the context in which the formula is evaluated) is first parsed into RPN tokens using the FormulaParser class . (If you don't know what RPN tokens are, now is a good time to - read <link href="http://www-stone.ch.cam.ac.uk/documentation/rrf/rpn.html";> - this</link>.) + read <a href="http://www-stone.ch.cam.ac.uk/documentation/rrf/rpn.html";> + this</a>.) </p> <section><title> The big picture</title> <p>RPN tokens are mapped to Eval classes. (Class hierarchy for the Evals @@ -87,7 +87,7 @@ <section><title>What functions are supported?</title> <p> As of September 2017, POI supports about 176 built-in functions, - see <link href="#appendixA">Appendix A</link> for the full list. + see <a href="#appendixA">Appendix A</a> for the full list. You can programmatically list supported / unsupported functions using the following helper methods: </p> <source> Modified: poi/site/src/documentation/content/xdocs/components/spreadsheet/eval.xml URL: http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/components/spreadsheet/eval.xml?rev=1836243&r1=1836242&r2=1836243&view=diff ============================================================================== --- poi/site/src/documentation/content/xdocs/components/spreadsheet/eval.xml (original) +++ poi/site/src/documentation/content/xdocs/components/spreadsheet/eval.xml Wed Jul 18 23:24:53 2018 @@ -17,7 +17,7 @@ limitations under the License. ==================================================================== --> -<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V1.3//EN" "../dtd/document-v13.dtd"> +<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V2.0//EN" "document-v20.dtd"> <document> <header> @@ -47,7 +47,7 @@ Excel, until you go to the cell and hit enter or F9, you will either see the old value or '#VALUE!' for the cell. (Sometimes Excel will notice itself, and trigger a recalculation on load, but unless you know you are - using volatile functions it's generally best to trigger a <link href="#recalculation">Recalulation</link> + using volatile functions it's generally best to trigger a <a href="#recalculation">Recalulation</a> through POI) </p> </section> @@ -57,12 +57,12 @@ <p>The code currently provides implementations for all the arithmatic operators. It also provides implementations for approx. 140 built in functions in Excel. The framework however makes it easy to add - implementation of new functions. See the <link href="eval-devguide.html"> Formula - evaluation development guide</link> and <link href="../apidocs/org/apache/poi/hssf/record/formula/functions/package-summary.html">javadocs</link> + implementation of new functions. See the <a href="eval-devguide.html"> Formula + evaluation development guide</a> and <a href="../../apidocs/org/apache/poi/hssf/record/formula/functions/package-summary.html">javadocs</a> for details. </p> <p> Both HSSFWorkbook and XSSFWorkbook are supported, so you can evaluate formulas on both .xls and .xlsx files.</p> - <p> User-defined functions are <link href="user-defined-functions.html">supported</link>, + <p> User-defined functions are <a href="user-defined-functions.html">supported</a>, but must be rewritten in Java and registered with the macro-enabled workbook in order to be evaluated. </p> </section> @@ -298,7 +298,7 @@ for (Sheet sheet : wb) { </source> <p>If you don't have access to these other workbooks, then you should call - <link href="../apidocs/org/apache/poi/ss/usermodel/FormulaEvaluator.html#setIgnoreMissingWorkbooks(boolean)">setIgnoreMissingWorkbooks(true)</link> + <a href="../../apidocs/org/apache/poi/ss/usermodel/FormulaEvaluator.html#setIgnoreMissingWorkbooks(boolean)">setIgnoreMissingWorkbooks(true)</a> to tell the Formula Evaluator to skip evaluating any external references it can't look up.</p> <p>In order for POI to be able to evaluate external references, it @@ -306,7 +306,7 @@ for (Sheet sheet : wb) { have the same names on your system as in the workbook, you need to give POI a map of external references to open workbooks, through the - <link href="../apidocs/org/apache/poi/ss/usermodel/FormulaEvaluator.html#setupReferencedWorkbooks(java.util.Map)">setupReferencedWorkbooks(java.util.Map<java.lang.String,FormulaEvaluator> workbooks)</link> + <a href="../../apidocs/org/apache/poi/ss/usermodel/FormulaEvaluator.html#setupReferencedWorkbooks(java.util.Map)">setupReferencedWorkbooks(java.util.Map<java.lang.String,FormulaEvaluator> workbooks)</a> method. You should normally do something like:</p> <source> // Create a FormulaEvaluator to use Modified: poi/site/src/documentation/content/xdocs/components/spreadsheet/examples.xml URL: http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/components/spreadsheet/examples.xml?rev=1836243&r1=1836242&r2=1836243&view=diff ============================================================================== --- poi/site/src/documentation/content/xdocs/components/spreadsheet/examples.xml (original) +++ poi/site/src/documentation/content/xdocs/components/spreadsheet/examples.xml Wed Jul 18 23:24:53 2018 @@ -17,7 +17,7 @@ limitations under the License. ==================================================================== --> -<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V1.3//EN" "../dtd/document-v13.dtd"> +<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V2.0//EN" "document-v20.dtd"> <document> <header> @@ -39,10 +39,10 @@ or BusinessPlan -xlsx </source> - <p>All sample source is available in <link href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/";>SVN</link></p> + <p>All sample source is available in <a href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/";>SVN</a></p> <p>In addition, there are a handful of - <link href="#hssf-only">HSSF only</link> and - <link href="#xssf-only">XSSF only</link> examples as well. + <a href="#hssf-only">HSSF only</a> and + <a href="#xssf-only">XSSF only</a> examples as well. </p> <section><title>Available Examples</title> @@ -50,71 +50,71 @@ The following examples are available: </p> <ul> - <li><link href="#ss-common">Common HSSF and XSSF</link><ul> - <li><link href="#business-plan">Business Plan</link></li> - <li><link href="#calendar">Calendar</link></li> - <li><link href="#loan-calculator">Loan Calculator</link></li> - <li><link href="#timesheet">Timesheet</link></li> - <li><link href="#conditional-formats">Conditional Formats</link></li> - <li><link href="#common-formulas">Formula Examples</link></li> - <li><link href="#add-dimensioned-image">Add Dimensioned Image</link></li> - <li><link href="#aligned-cells">Aligned Cells</link></li> - <li><link href="#cell-style-details">Cell Style Details</link></li> - <li><link href="#linked-dropdown">Linked Dropdown Lists</link></li> - <li><link href="#performance-test">Common SS Performance Test</link></li> - <li><link href="#to-html">To HTML</link></li> - <li><link href="#to-csv">To CSV</link></li> + <li><a href="#ss-common">Common HSSF and XSSF</a><ul> + <li><a href="#business-plan">Business Plan</a></li> + <li><a href="#calendar">Calendar</a></li> + <li><a href="#loan-calculator">Loan Calculator</a></li> + <li><a href="#timesheet">Timesheet</a></li> + <li><a href="#conditional-formats">Conditional Formats</a></li> + <li><a href="#common-formulas">Formula Examples</a></li> + <li><a href="#add-dimensioned-image">Add Dimensioned Image</a></li> + <li><a href="#aligned-cells">Aligned Cells</a></li> + <li><a href="#cell-style-details">Cell Style Details</a></li> + <li><a href="#linked-dropdown">Linked Dropdown Lists</a></li> + <li><a href="#performance-test">Common SS Performance Test</a></li> + <li><a href="#to-html">To HTML</a></li> + <li><a href="#to-csv">To CSV</a></li> </ul></li> - <li><link href="#hssf-only">HSSF-Only</link></li> - <li><link href="#xssf-only">XSSF-Only</link></li> + <li><a href="#hssf-only">HSSF-Only</a></li> + <li><a href="#xssf-only">XSSF-Only</a></li> </ul> </section> <anchor id="ss-common" /> <anchor id="business-plan" /> <section><title>Business Plan</title> - <p> The <link href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/BusinessPlan.java";>BusinessPlan</link> + <p> The <a href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/BusinessPlan.java";>BusinessPlan</a> application creates a sample business plan with three phases, weekly iterations and time highlighting. Demonstrates advanced cell formatting (number and date formats, alignments, fills, borders) and various settings for organizing data in a sheet (freezed panes, grouped rows). </p> <p> - <img src="../resources/images/businessplan.jpg" alt="business plan demo"/> + <img src="images/businessplan.jpg" alt="business plan demo"/> </p> </section> <anchor id="calendar" /> <section><title>Calendar</title> - <p> The <link href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/CalendarDemo.java";>Calendar</link> + <p> The <a href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/CalendarDemo.java";>Calendar</a> demo creates a multi sheet calendar. Each month is on a separate sheet. </p> <p> - <img src="../resources/images/calendar.jpg" alt="calendar demo"/> + <img src="images/calendar.jpg" alt="calendar demo"/> </p> </section> <anchor id="loan-calculator" /> <section><title>Loan Calculator</title> - <p> The <link href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/LoanCalculator.java";>LoanCalculator</link> + <p> The <a href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/LoanCalculator.java";>LoanCalculator</a> demo creates a simple loan calculator. Demonstrates advance usage of cell formulas and named ranges. </p> <p> - <img src="../resources/images/loancalc.jpg" alt="loan calculator demo"/> + <img src="images/loancalc.jpg" alt="loan calculator demo"/> </p> </section> <anchor id="timesheet" /> <section><title>Timesheet</title> - <p> The <link href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/TimesheetDemo.java";>Timesheet</link> + <p> The <a href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/TimesheetDemo.java";>Timesheet</a> demo creates a weekly timesheet with automatic calculation of total hours. Demonstrates advance usage of cell formulas. </p> <p> - <img src="../resources/images/timesheet.jpg" alt="timesheet demo"/> + <img src="images/timesheet.jpg" alt="timesheet demo"/> </p> </section> <anchor id="conditional-formats" /> <section><title>Conditional Formats</title> - <p> The <link href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/ConditionalFormats.java";>ConditionalFormats</link> + <p> The <a href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/ConditionalFormats.java";>ConditionalFormats</a> demo is a collection of short examples showing what you can do with Excel conditional formatting in POI: </p> <ul> @@ -132,23 +132,23 @@ <anchor id="common-formulas" /> <section><title>Formula Examples</title> - <p>The <link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/formula/CalculateMortgage.java";>CalculateMortgage</link> + <p>The <a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/formula/CalculateMortgage.java";>CalculateMortgage</a> example demonstrates a simple user-defined function to calculate principal and interest.</p> - <p>The <link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/formula/CheckFunctionsSupported.java";>CheckFunctionsSupported</link> + <p>The <a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/formula/CheckFunctionsSupported.java";>CheckFunctionsSupported</a> example shows how to test what functions and formulas aren't supported from a given file.</p> - <p>The <link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/formula/SettingExternalFunction.java";>SettingExternalFunction</link> + <p>The <a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/formula/SettingExternalFunction.java";>SettingExternalFunction</a> example demonstrates how to use externally provided (third-party) formula add-ins.</p> - <p>The <link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/formula/UserDefinedFunctionExample.java";>UserDefinedFunctionExample</link> + <p>The <a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/formula/UserDefinedFunctionExample.java";>UserDefinedFunctionExample</a> example demonstrates how to invoke a User Defined Function for a given Workbook instance using POI's UDFFinder implementation.</p> </section> <anchor id="add-dimensioned-image" /> <section><title>Add Dimensioned Image</title> - <p>The <link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/AddDimensionedImage.java";>AddDimensionedImage</link> + <p>The <a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/AddDimensionedImage.java";>AddDimensionedImage</a> example demonstrates how to add an image to a worksheet and set that images size to a specific number of millimetres irrespective of the width of the columns or height of the rows.</p> @@ -156,26 +156,26 @@ <anchor id="aligned-cells" /> <section><title>Aligned Cells</title> - <p>The <link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/AligningCells.java";>AligningCells</link> + <p>The <a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/AligningCells.java";>AligningCells</a> example demonstrates how various alignment options work.</p> </section> <anchor id="cell-style-details" /> <section><title>Cell Style Details</title> - <p>The <link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/CellStyleDetails.java";>CellStyleDetails</link> + <p>The <a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/CellStyleDetails.java";>CellStyleDetails</a> example demonstrates how to read excel styles for cells.</p> </section> <anchor id="linked-dropdown" /> <section><title>Linked Dropdown Lists</title> - <p>The <link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/LinkedDropDownLists.java";>LinkedDropDownLists</link> + <p>The <a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/LinkedDropDownLists.java";>LinkedDropDownLists</a> example demonstrates one technique that may be used to create linked or dependent drop down lists.</p> </section> <anchor id="performance-test" /> <section><title>Common SS Performance Test</title> - <p>The <link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/SSPerformanceTest.java";>SSPerformanceTest</link> + <p>The <a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/SSPerformanceTest.java";>SSPerformanceTest</a> example provides a way to create simple example files of varying sizes, and to calculate how long they take. Useful for benchmarking your system, and to also test if slow performance is due to Apache @@ -184,14 +184,14 @@ <anchor id="to-html" /> <section><title>ToHtml</title> - <p> The <link href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/html/ToHtml.java";>ToHtml</link> + <p> The <a href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/html/ToHtml.java";>ToHtml</a> example shows how to display a spreadsheet in HTML using the classes for spreadsheet display. </p> </section> <anchor id="to-csv" /> <section><title>ToCSV</title> - <p>The <link href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/ToCSV.java";>ToCSV</link> + <p>The <a href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/ToCSV.java";>ToCSV</a> example demonstrates <em>one</em> way to convert an Excel spreadsheet into a CSV file. </p> </section> @@ -200,90 +200,90 @@ <anchor id="hssf-only" /> <section><title>HSSF-only Examples</title> <p>All the HSSF-only examples can be found in - <link href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/examples/";>SVN</link></p> + <a href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/examples/";>SVN</a></p> <ul> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/CellComments.java";>CellComments</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/HyperlinkFormula.java";>HyperlinkFormula</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/EventExample.java";>EventExample</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/OfficeDrawingWithGraphics.java";>OfficeDrawingWithGraphics</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/CreateDateCells.java";>CreateDateCells</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/NewWorkbook.java";>NewWorkbook</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/EmeddedObjects.java";>EmeddedObjects</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/Hyperlinks.java";>Hyperlinks</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/OfficeDrawing.java";>OfficeDrawing</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/HSSFReadWrite.java";>HSSFReadWrite</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/NewSheet.java";>NewSheet</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/SplitAndFreezePanes.java";>SplitAndFreezePanes</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/InCellLists.java";>InCellLists</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/RepeatingRowsAndColumns.java";>RepeatingRowsAndColumns</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/MergedCells.java";>MergedCells</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/CellTypes.java";>CellTypes</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/ZoomSheet.java";>ZoomSheet</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/ReadWriteWorkbook.java";>ReadWriteWorkbook</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/CreateCells.java";>CreateCells</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/Alignment.java";>Alignment</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/FrillsAndFills.java";>FrillsAndFills</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/AddDimensionedImage.java";>AddDimensionedImage</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/Borders.java";>Borders</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/NewLinesInCells.java";>NewLinesInCells</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/WorkingWithFonts.java";>WorkingWithFonts</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/BigExample.java";>BigExample</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/Outlines.java";>Outlines</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/eventusermodel/examples/XLS2CSVmra.java";>XLS2CSVmra</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/SViewer.java";>SViewer</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/SVFractionalFormat.java";>SVFractionalFormat</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/SVTableCellEditor.java";>SVTableCellEditor</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/SVBorder.java";>SVBorder</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/brush/DoubleStroke.java";>DoubleStroke</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/brush/BasicBrush.java";>BasicBrush</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/brush/Brush.java";>Brush</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/brush/PendingPaintings.java";>PendingPaintings</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/SVTableCellRenderer.java";>SVTableCellRenderer</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/SViewerPanel.java";>SViewerPanel</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/SVTableUtils.java";>SVTableUtils</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/SVTableModel.java";>SVTableModel</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/SVSheetTable.java";>SVSheetTable</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/SVRowHeader.java";>SVRowHeader</link></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/CellComments.java";>CellComments</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/HyperlinkFormula.java";>HyperlinkFormula</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/EventExample.java";>EventExample</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/OfficeDrawingWithGraphics.java";>OfficeDrawingWithGraphics</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/CreateDateCells.java";>CreateDateCells</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/NewWorkbook.java";>NewWorkbook</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/EmeddedObjects.java";>EmeddedObjects</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/Hyperlinks.java";>Hyperlinks</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/OfficeDrawing.java";>OfficeDrawing</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/HSSFReadWrite.java";>HSSFReadWrite</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/NewSheet.java";>NewSheet</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/SplitAndFreezePanes.java";>SplitAndFreezePanes</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/InCellLists.java";>InCellLists</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/RepeatingRowsAndColumns.java";>RepeatingRowsAndColumns</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/MergedCells.java";>MergedCells</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/CellTypes.java";>CellTypes</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/ZoomSheet.java";>ZoomSheet</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/ReadWriteWorkbook.java";>ReadWriteWorkbook</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/CreateCells.java";>CreateCells</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/Alignment.java";>Alignment</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/FrillsAndFills.java";>FrillsAndFills</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/AddDimensionedImage.java";>AddDimensionedImage</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/Borders.java";>Borders</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/NewLinesInCells.java";>NewLinesInCells</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/WorkingWithFonts.java";>WorkingWithFonts</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/BigExample.java";>BigExample</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/Outlines.java";>Outlines</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/eventusermodel/examples/XLS2CSVmra.java";>XLS2CSVmra</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/SViewer.java";>SViewer</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/SVFractionalFormat.java";>SVFractionalFormat</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/SVTableCellEditor.java";>SVTableCellEditor</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/SVBorder.java";>SVBorder</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/brush/DoubleStroke.java";>DoubleStroke</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/brush/BasicBrush.java";>BasicBrush</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/brush/Brush.java";>Brush</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/brush/PendingPaintings.java";>PendingPaintings</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/SVTableCellRenderer.java";>SVTableCellRenderer</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/SViewerPanel.java";>SViewerPanel</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/SVTableUtils.java";>SVTableUtils</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/SVTableModel.java";>SVTableModel</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/SVSheetTable.java";>SVSheetTable</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/view/SVRowHeader.java";>SVRowHeader</a></li> </ul> </section> <anchor id="xssf-only" /> <section><title>XSSF-only Examples</title> <p>All the XSSF-only examples can be found in - <link href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/examples/";>SVN</link></p> + <a href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/examples/";>SVN</a></p> <ul> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/ScatterChart.java";>ScatterChart</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/CellComments.java";>CellComments</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/HeadersAndFooters.java";>HeadersAndFooters</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/CreateUserDefinedDataFormats.java";>CreateUserDefinedDataFormats</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/CreatePivotTable.java";>CreatePivotTable</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/FillsAndColors.java";>FillsAndColors</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/WorkingWithBorders.java";>WorkingWithBorders</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/BigGridDemo.java";>BigGridDemo</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/CreateTable.java";>CreateTable</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/CalendarDemo.java";>CalendarDemo</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/AligningCells.java";>AligningCells</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/SplitAndFreezePanes.java";>SplitAndFreezePanes</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/WorkingWithPageSetup.java";>WorkingWithPageSetup</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/WorkingWithPictures.java";>WorkingWithPictures</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/MergingCells.java";>MergingCells</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/CustomXMLMapping.java";>CustomXMLMapping</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/SelectedSheet.java";>SelectedSheet</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/EmbeddedObjects.java";>EmbeddedObjects</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/WorkbookProperties.java";>WorkbookProperties</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/NewLinesInCells.java";>NewLinesInCells</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/Outlining.java";>Outlining</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/CreateCell.java";>CreateCell</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/IterateCells.java";>IterateCells</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/LineChart.java";>LineChart</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/WorkingWithFonts.java";>WorkingWithFonts</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/HyperlinkExample.java";>HyperlinkExample</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/ShiftRows.java";>ShiftRows</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/WorkingWithRichText.java";>WorkingWithRichText</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/FitSheetToOnePage.java";>FitSheetToOnePage</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/streaming/examples/Outlining.java";>Outlining</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/XLSX2CSV.java";>XLSX2CSV</link></li> - <li><link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/examples/FromHowTo.java";>FromHowTo</link></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/ScatterChart.java";>ScatterChart</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/CellComments.java";>CellComments</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/HeadersAndFooters.java";>HeadersAndFooters</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/CreateUserDefinedDataFormats.java";>CreateUserDefinedDataFormats</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/CreatePivotTable.java";>CreatePivotTable</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/FillsAndColors.java";>FillsAndColors</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/WorkingWithBorders.java";>WorkingWithBorders</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/BigGridDemo.java";>BigGridDemo</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/CreateTable.java";>CreateTable</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/CalendarDemo.java";>CalendarDemo</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/AligningCells.java";>AligningCells</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/SplitAndFreezePanes.java";>SplitAndFreezePanes</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/WorkingWithPageSetup.java";>WorkingWithPageSetup</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/WorkingWithPictures.java";>WorkingWithPictures</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/MergingCells.java";>MergingCells</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/CustomXMLMapping.java";>CustomXMLMapping</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/SelectedSheet.java";>SelectedSheet</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/EmbeddedObjects.java";>EmbeddedObjects</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/WorkbookProperties.java";>WorkbookProperties</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/NewLinesInCells.java";>NewLinesInCells</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/Outlining.java";>Outlining</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/CreateCell.java";>CreateCell</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/IterateCells.java";>IterateCells</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/LineChart.java";>LineChart</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/WorkingWithFonts.java";>WorkingWithFonts</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/HyperlinkExample.java";>HyperlinkExample</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/ShiftRows.java";>ShiftRows</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/WorkingWithRichText.java";>WorkingWithRichText</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/FitSheetToOnePage.java";>FitSheetToOnePage</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/streaming/examples/Outlining.java";>Outlining</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/XLSX2CSV.java";>XLSX2CSV</a></li> + <li><a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/examples/FromHowTo.java";>FromHowTo</a></li> </ul> </section> </body> Modified: poi/site/src/documentation/content/xdocs/components/spreadsheet/excelant.xml URL: http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/components/spreadsheet/excelant.xml?rev=1836243&r1=1836242&r2=1836243&view=diff ============================================================================== --- poi/site/src/documentation/content/xdocs/components/spreadsheet/excelant.xml (original) +++ poi/site/src/documentation/content/xdocs/components/spreadsheet/excelant.xml Wed Jul 18 23:24:53 2018 @@ -17,7 +17,7 @@ limitations under the License. ==================================================================== --> -<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V1.3//EN" "../dtd/document-v13.dtd"> +<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V2.0//EN" "document-v20.dtd"> <document> <header> @@ -100,7 +100,7 @@ workbooks then you need to have the foll (/examples/src/org/apache/poi/ss/examples/excelant/simple-mortgage-calculation.xls). This sheet is shown below:</p> - <!--img src="../resources/images/simple-xls-with-function.jpg" alt="mortgage calculation spreadsheet"/--> + <!--img src="images/simple-xls-with-function.jpg" alt="mortgage calculation spreadsheet"/--> <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 @@ -277,7 +277,7 @@ Total time: 390 milliseconds </section> <section><title>Leveraging User Defined Functions</title> - <p>POI has an excellent feature (besides ExcelAnt) called <link href="user-defined-functions.html">User Defined Functions</link>, + <p>POI has an excellent feature (besides ExcelAnt) called <a href="user-defined-functions.html">User Defined Functions</a>, 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. Modified: poi/site/src/documentation/content/xdocs/components/spreadsheet/formula.xml URL: http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/components/spreadsheet/formula.xml?rev=1836243&r1=1836242&r2=1836243&view=diff ============================================================================== --- poi/site/src/documentation/content/xdocs/components/spreadsheet/formula.xml (original) +++ poi/site/src/documentation/content/xdocs/components/spreadsheet/formula.xml Wed Jul 18 23:24:53 2018 @@ -17,7 +17,7 @@ limitations under the License. ==================================================================== --> -<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V1.3//EN" "../dtd/document-v13.dtd"> +<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V2.0//EN" "document-v20.dtd"> <document> <header> @@ -79,19 +79,19 @@ <p>To get the list of formula functions that POI supports, you need to call some code!</p> <p>The methods you need are available on - <link href="../apidocs/org/apache/poi/ss/formula/eval/FunctionEval.html">org.apache.poi.ss.formula.eval.FunctionEval</link>. + <a href="../../apidocs/org/apache/poi/ss/formula/eval/FunctionEval.html">org.apache.poi.ss.formula.eval.FunctionEval</a>. To find which functions your copy of Apache POI supports, use - <link href="../apidocs/org/apache/poi/ss/formula/eval/FunctionEval.html#getSupportedFunctionNames()">getSupportedFunctionNames()</link> + <a href="../../apidocs/org/apache/poi/ss/formula/eval/FunctionEval.html#getSupportedFunctionNames()">getSupportedFunctionNames()</a> to get a list of the implemented function names. For the list of functions that POI knows the name of, but doesn't currently implement, use - <link href="../apidocs/org/apache/poi/ss/formula/eval/FunctionEval.html#getNotSupportedFunctionNames()">getNotSupportedFunctionNames()</link> + <a href="../../apidocs/org/apache/poi/ss/formula/eval/FunctionEval.html#getNotSupportedFunctionNames()">getNotSupportedFunctionNames()</a> </p> </section> <section><title>Internals</title> <p> Formulas in Excel are stored as sequences of tokens in Reverse Polish Notation order. The - <link href="http://sc.openoffice.org/excelfileformat.pdf";>open office XLS spec</link> is the best + <a href="http://sc.openoffice.org/excelfileformat.pdf";>open office XLS spec</a> is the best documentation you will find for the format. </p> @@ -113,7 +113,7 @@ occurrence of #VALUE! in a cell upon opening a POI generated workbook in excel. (Check that typing the formula into Excel directly gives a valid result.) </p> - <p>Check out the <link href="http://poi.apache.org/apidocs/";>javadocs </link> for details. + <p>Check out the <a href="../../apidocs/">javadocs </a> for details. </p> </section> </body> Modified: poi/site/src/documentation/content/xdocs/components/spreadsheet/hacking-hssf.xml URL: http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/components/spreadsheet/hacking-hssf.xml?rev=1836243&r1=1836242&r2=1836243&view=diff ============================================================================== --- poi/site/src/documentation/content/xdocs/components/spreadsheet/hacking-hssf.xml (original) +++ poi/site/src/documentation/content/xdocs/components/spreadsheet/hacking-hssf.xml Wed Jul 18 23:24:53 2018 @@ -17,7 +17,7 @@ limitations under the License. ==================================================================== --> -<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V1.3//EN" "../dtd/document-v13.dtd"> +<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V2.0//EN" "document-v20.dtd"> <document> <header> @@ -36,7 +36,7 @@ understanding the file format. </p> <p> - Also useful is the <link href="http://sc.openoffice.org/excelfileformat.pdf";>open office XLS spec</link>. We + Also useful is the <a href="http://sc.openoffice.org/excelfileformat.pdf";>open office XLS spec</a>. We are collaborating with the maintainer of the spec so if you think you can add something to their document just send through your changes. </p> @@ -79,11 +79,10 @@ may ask you to sign an agreement.</p> </section> <section><title>What Can I Work On?</title> - <p>Check our <link href="../todo.html">todo list</link> or simply look for missing functionality. Start small - and work your way up.</p> + <p>Ask in the dev mailing list for advice.</p> </section> <section><title>What Else Should I Know?</title> - <p>Make sure you <link href="../guidelines.html">read the contributing section</link> + <p>Make sure you <a href="site:guidelines">read the contributing section</a> as it contains more generation information about contributing to POI in general.</p> </section> </body> Modified: poi/site/src/documentation/content/xdocs/components/spreadsheet/how-to.xml URL: http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/components/spreadsheet/how-to.xml?rev=1836243&r1=1836242&r2=1836243&view=diff ============================================================================== --- poi/site/src/documentation/content/xdocs/components/spreadsheet/how-to.xml (original) +++ poi/site/src/documentation/content/xdocs/components/spreadsheet/how-to.xml Wed Jul 18 23:24:53 2018 @@ -17,7 +17,7 @@ limitations under the License. ==================================================================== --> -<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V1.3//EN" "../dtd/document-v13.dtd"> +<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V2.0//EN" "document-v20.dtd"> <document> <header> @@ -54,12 +54,12 @@ have different characteristics, so you should read up on all to select the best for you.</p> <ul> - <li><link href="#user_api">User API (HSSF and XSSF)</link></li> - <li><link href="#event_api">Event API (HSSF Only)</link></li> - <li><link href="#record_aware_event_api">Event API with extensions to be Record Aware (HSSF Only)</link></li> - <li><link href="#xssf_sax_api">XSSF and SAX (Event API)</link></li> - <li><link href="#sxssf">SXSSF (Streaming User API)</link></li> - <li><link href="#low_level_api">Low Level API</link></li> + <li><a href="#user_api">User API (HSSF and XSSF)</a></li> + <li><a href="#event_api">Event API (HSSF Only)</a></li> + <li><a href="#record_aware_event_api">Event API with extensions to be Record Aware (HSSF Only)</a></li> + <li><a href="#xssf_sax_api">XSSF and SAX (Event API)</a></li> + <li><a href="#sxssf">SXSSF (Streaming User API)</a></li> + <li><a href="#low_level_api">Low Level API</a></li> </ul> </section> </section> @@ -284,7 +284,7 @@ method (sheet.removeRow(hssfrow)) and cr would if creating a new xls. When you are done modifying cells just call workbook.write(outputstream) just as you did above.</p> <p>An example of this can be seen in -<link href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/HSSFReadWrite.java";>org.apache.poi.hssf.usermodel.examples.HSSFReadWrite</link>.</p> +<a href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/usermodel/examples/HSSFReadWrite.java";>org.apache.poi.hssf.usermodel.examples.HSSFReadWrite</a>.</p> </section> </section> @@ -304,7 +304,7 @@ call workbook.write(outputstream) just a have yet to be edited to simply not exist in the file. This means there may well be apparent "gaps" in the record stream, which you either need to work around, or use the - <link href="#record_aware_event_api">Record Aware</link> extension + <a href="#record_aware_event_api">Record Aware</a> extension to the Event API.</p> <p>To use this API you construct an instance of org.apache.poi.hssf.eventmodel.HSSFRequest. Register a class you @@ -431,7 +431,7 @@ public class EventExample <section><title>Record Aware Event API (HSSF Only)</title> <p> This is an extension to the normal -<link href="#event_api">Event API</link>. With this, your listener +<a href="#event_api">Event API</a>. With this, your listener will be called with extra, dummy records. These dummy records should alert you to records which aren't present in the file (eg cells that have yet to be edited), and allow you to handle these. @@ -469,13 +469,13 @@ some of the rows or cells. It can be fou <code>/src/examples/src/org/apache/poi/hssf/eventusermodel/examples/XLS2CSVmra.java</code>, and may be called on the command line, or from within your own code. The latest version is always available from -<link href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/eventusermodel/examples/";>subversion</link>. +<a href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/eventusermodel/examples/";>subversion</a>. </p> <p> <em>In POI versions before 3.0.3, this code lived in the scratchpad section. If you're using one of these older versions of POI, you will either need to include the scratchpad jar on your classpath, or build from a</em> - <link href="../subversion.html">subversion checkout</link>. + <a href="site:subversion">subversion checkout</a>. </p> </section> @@ -503,8 +503,8 @@ The latest version is always available f file, which you will then pass to SAX.</p> <p>This example shows how to get at a single known sheet, or at all sheets in the file. It is based on the example in - <link href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/examples/FromHowTo.java";>svn - src/examples/src/org/apache/poi/xssf/eventusermodel/examples/FromHowTo.java</link></p> + <a href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/examples/FromHowTo.java";>svn + src/examples/src/org/apache/poi/xssf/eventusermodel/examples/FromHowTo.java</a></p> <source><![CDATA[ import java.io.InputStream; import java.util.Iterator; @@ -629,9 +629,9 @@ public class ExampleEventUserModel { For a fuller example, including support for fetching number formatting information and applying it to numeric cells (eg to format dates or percentages), please see - <link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/XLSX2CSV.java";>the XLSX2CSV example in svn</link> + <a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/XLSX2CSV.java";>the XLSX2CSV example in svn</a> </p> - <p>An example is also <link href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/streaming/examples/HybridStreaming.java";>provided</link> + <p>An example is also <a href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/streaming/examples/HybridStreaming.java";>provided</a> showing how to combine the user API and the SAX API by doing a streaming parse of larger worksheets and a traditional user-model parse of the rest of a workbook.</p> </section> @@ -804,8 +804,8 @@ documentation for the POIFS libraries as <p>If you wish to generate an XLS file from some XML, it is possible to write your own XML processing code, then use the User API to write out the document.</p> -<p>The other option is to use <link href="http://cocoon.apache.org/";>Cocoon</link>. -In Cocoon, there is the <link href="http://cocoon.apache.org/2.1/userdocs/xls-serializer.html";>HSSF Serializer</link>, +<p>The other option is to use <a href="http://cocoon.apache.org/";>Cocoon</a>. +In Cocoon, there is the <a href="http://cocoon.apache.org/2.1/userdocs/xls-serializer.html";>HSSF Serializer</a>, which takes in XML (in the gnumeric format), and outputs an XLS file for you.</p> </section> <section><title>HSSF Class/Test Application</title> @@ -879,7 +879,7 @@ yet. When it does something, we'll docum <li>Performance: POI currently uses a lot of memory for large sheets.</li> <li>Charts: This is a hard problem, with very little documentation.</li> </ul> -<p><link href="../guidelines.html"> So jump in! </link> </p> +<p><a href="site:guidelines"> So jump in! </a> </p> </section> Modified: poi/site/src/documentation/content/xdocs/components/spreadsheet/index.xml URL: http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/components/spreadsheet/index.xml?rev=1836243&r1=1836242&r2=1836243&view=diff ============================================================================== --- poi/site/src/documentation/content/xdocs/components/spreadsheet/index.xml (original) +++ poi/site/src/documentation/content/xdocs/components/spreadsheet/index.xml Wed Jul 18 23:24:53 2018 @@ -17,11 +17,11 @@ limitations under the License. ==================================================================== --> -<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V1.3//EN" "../dtd/document-v13.dtd"> +<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V2.0//EN" "document-v20.dtd"> <document> <header> - <title>POI-HSSF and POI-XSSF - Java API To Access Microsoft Excel Format Files</title> + <title>POI-HSSF and POI-XSSF/SXSSF - Java API To Access Microsoft Excel Format Files</title> <subtitle>Overview</subtitle> <authors> <person name="Andrew C. Oliver" email="[email protected]"/> @@ -47,11 +47,11 @@ </ul> <p>For people converting from pure HSSF usermodel, who wish to use the joint SS Usermodel for HSSF and XSSF support, then - see the <link href="converting.html">ss usermodel converting - guide</link>. + see the <a href="converting.html">ss usermodel converting + guide</a>. </p> <p> - An alternate way of generating a spreadsheet is via the <link href="http://cocoon.apache.org";>Cocoon</link> serializer (yet you'll still be using HSSF indirectly). + An alternate way of generating a spreadsheet is via the <a href="http://cocoon.apache.org";>Cocoon</a> serializer (yet you'll still be using HSSF indirectly). With Cocoon you can serialize any XML datasource (which might be a ESQL page outputting in SQL for instance) by simply applying the stylesheet and designating the serializer. </p> @@ -105,13 +105,13 @@ limitations when compared to XSSF: <li>Formula evaluation is not supported</li> </ul> - <p> See more details at <link href="how-to.html#sxssf">SXSSF How-To</link></p> + <p> See more details at <a href="how-to.html#sxssf">SXSSF How-To</a></p> <p>The table below synopsizes the comparative features of POI's Spreadsheet API:</p> <p><em>Spreadsheet API Feature Summary</em></p> <p> - <img src="../resources/images/ss-features.png" alt="Spreadsheet API Feature Summary"/> + <img src="images/ss-features.png" alt="Spreadsheet API Feature Summary"/> </p> </section> --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
