You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@poi.apache.org by ni...@apache.org on 2014/08/14 16:20:14 UTC
svn commit: r1617954 - in /poi/site: publish/spreadsheet/examples.html
src/documentation/content/xdocs/spreadsheet/examples.xml
Author: nick
Date: Thu Aug 14 14:20:14 2014
New Revision: 1617954
URL: http://svn.apache.org/r1617954
Log:
List the remaining examples
Modified:
poi/site/publish/spreadsheet/examples.html
poi/site/src/documentation/content/xdocs/spreadsheet/examples.xml
Modified: poi/site/publish/spreadsheet/examples.html
URL: http://svn.apache.org/viewvc/poi/site/publish/spreadsheet/examples.html?rev=1617954&r1=1617953&r2=1617954&view=diff
==============================================================================
--- poi/site/publish/spreadsheet/examples.html (original)
+++ poi/site/publish/spreadsheet/examples.html Thu Aug 14 14:20:14 2014
@@ -246,15 +246,35 @@ if (VERSION > 3) {
</li>
<li>
-<a href="#to-html">To HTML</a>
+<a href="#common-formulas">Formula Examples</a>
</li>
<li>
-<a href="#to-csv">To CSV</a>
+<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>
-<em>TODO - List remaining examples</em>
+<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>
@@ -376,39 +396,27 @@ if (VERSION > 3) {
-<a name="to-html"></a>
- <a name="ToHtml"></a>
-<div class="h4">
-<h4>ToHtml</h4>
-</div>
-
-<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>
-
-
-
-<a name="to-csv"></a>
- <a name="ToCSV"></a>
-<div class="h4">
-<h4>ToCSV</h4>
-</div>
-
-<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>
-
-
-
<a name="common-formulas"></a>
<a name="Formula+Examples"></a>
<div class="h4">
<h4>Formula Examples</h4>
</div>
-<p>
-<em>TODO</em>
-</p>
+<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 <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 <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 <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>
@@ -471,6 +479,30 @@ if (VERSION > 3) {
your system, and to also test if slow performance is due to Apache
POI itself or to your own code.</p>
+
+
+<a name="to-html"></a>
+ <a name="ToHtml"></a>
+<div class="h4">
+<h4>ToHtml</h4>
+</div>
+
+<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>
+
+
+
+<a name="to-csv"></a>
+ <a name="ToCSV"></a>
+<div class="h4">
+<h4>ToCSV</h4>
+</div>
+
+<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>
+
Modified: poi/site/src/documentation/content/xdocs/spreadsheet/examples.xml
URL: http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/spreadsheet/examples.xml?rev=1617954&r1=1617953&r2=1617954&view=diff
==============================================================================
--- poi/site/src/documentation/content/xdocs/spreadsheet/examples.xml (original)
+++ poi/site/src/documentation/content/xdocs/spreadsheet/examples.xml Thu Aug 14 14:20:14 2014
@@ -56,9 +56,14 @@
<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><em>TODO - List remaining examples</em></li>
</ul></li>
<li><link href="#hssf-only">HSSF-Only</link></li>
<li><link href="#xssf-only">XSSF-Only</link></li>
@@ -125,23 +130,20 @@
</ul>
</section>
- <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>
- 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>
- example demonstrates <em>one</em> way to convert an Excel spreadsheet into a CSV file.
- </p>
- </section>
-
<anchor id="common-formulas" />
<section><title>Formula Examples</title>
- <p><em>TODO</em></p>
+ <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>
+ 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>
+ 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>
+ 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>
+ 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" />
@@ -179,6 +181,20 @@
your system, and to also test if slow performance is due to Apache
POI itself or to your own code.</p>
</section>
+
+ <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>
+ 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>
+ example demonstrates <em>one</em> way to convert an Excel spreadsheet into a CSV file.
+ </p>
+ </section>
</section>
<anchor id="hssf-only" />
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org