Author: fanningpj
Date: Thu Jul 30 11:36:47 2020
New Revision: 1880440
URL: http://svn.apache.org/viewvc?rev=1880440&view=rev
Log:
try to fix paths for examples
Modified:
poi/site/src/documentation/content/xdocs/components/spreadsheet/examples.xml
poi/site/src/documentation/content/xdocs/components/spreadsheet/excelant.xml
poi/site/src/documentation/content/xdocs/components/spreadsheet/quick-guide.xml
poi/site/src/documentation/content/xdocs/components/spreadsheet/user-defined-functions.xml
poi/site/src/documentation/content/xdocs/help/faq.xml
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=1880440&r1=1880439&r2=1880440&view=diff
==============================================================================
---
poi/site/src/documentation/content/xdocs/components/spreadsheet/examples.xml
(original)
+++
poi/site/src/documentation/content/xdocs/components/spreadsheet/examples.xml
Thu Jul 30 11:36:47 2020
@@ -39,7 +39,7 @@
or
BusinessPlan -xlsx
</source>
- <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>All sample source is available in <a
href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/examples/ss/";>SVN</a></p>
<p>In addition, there are a handful of
<a href="#hssf-only">HSSF only</a> and
<a href="#xssf-only">XSSF only</a> examples as well.
@@ -73,7 +73,7 @@
<anchor id="ss-common" />
<anchor id="business-plan" />
<section><title>Business Plan</title>
- <p> The <a
href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/BusinessPlan.java";>BusinessPlan</a>
+ <p> The <a
href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/examples/ss/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>
@@ -84,7 +84,7 @@
<anchor id="calendar" />
<section><title>Calendar</title>
- <p> The <a
href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/CalendarDemo.java";>Calendar</a>
+ <p> The <a
href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/examples/ss/CalendarDemo.java";>Calendar</a>
demo creates a multi sheet calendar. Each month is on a separate sheet.
</p>
<p>
@@ -94,7 +94,7 @@
<anchor id="loan-calculator" />
<section><title>Loan Calculator</title>
- <p> The <a
href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/LoanCalculator.java";>LoanCalculator</a>
+ <p> The <a
href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/examples/ss/LoanCalculator.java";>LoanCalculator</a>
demo creates a simple loan calculator. Demonstrates advance usage of
cell formulas and named ranges.
</p>
<p>
@@ -104,7 +104,7 @@
<anchor id="timesheet" />
<section><title>Timesheet</title>
- <p> The <a
href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/TimesheetDemo.java";>Timesheet</a>
+ <p> The <a
href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/examples/ss/TimesheetDemo.java";>Timesheet</a>
demo creates a weekly timesheet with automatic calculation of total
hours. Demonstrates advance usage of cell formulas.
</p>
<p>
@@ -114,7 +114,7 @@
<anchor id="conditional-formats" />
<section><title>Conditional Formats</title>
- <p> The <a
href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/ConditionalFormats.java";>ConditionalFormats</a>
+ <p> The <a
href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/examples/ss/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 <a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/formula/CalculateMortgage.java";>CalculateMortgage</a>
+ <p>The <a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/examples/ss/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>
+ <p>The <a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/examples/ss/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>
+ <p>The <a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/examples/ss/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>
+ <p>The <a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/examples/ss/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 <a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/AddDimensionedImage.java";>AddDimensionedImage</a>
+ <p>The <a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/examples/ss/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 <a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/AligningCells.java";>AligningCells</a>
+ <p>The <a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/examples/ss/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 <a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/CellStyleDetails.java";>CellStyleDetails</a>
+ <p>The <a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/examples/ss/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 <a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/LinkedDropDownLists.java";>LinkedDropDownLists</a>
+ <p>The <a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/examples/ss/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 <a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/SSPerformanceTest.java";>SSPerformanceTest</a>
+ <p>The <a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/examples/ss/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 <a
href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/html/ToHtml.java";>ToHtml</a>
+ <p> The <a
href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/examples/ss/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 <a
href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/ToCSV.java";>ToCSV</a>
+ <p>The <a
href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/examples/ss/ToCSV.java";>ToCSV</a>
example demonstrates <em>one</em> way to convert an Excel spreadsheet
into a CSV file.
</p>
</section>
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=1880440&r1=1880439&r2=1880440&view=diff
==============================================================================
---
poi/site/src/documentation/content/xdocs/components/spreadsheet/excelant.xml
(original)
+++
poi/site/src/documentation/content/xdocs/components/spreadsheet/excelant.xml
Thu Jul 30 11:36:47 2020
@@ -97,7 +97,7 @@ workbooks then you need to have the foll
you actually try to write that code. ExcelAnt helps with that.</p>
<p>Consider the mortgage-calculation.xls file found in the Examples
-
(/examples/src/org/apache/poi/ss/examples/excelant/simple-mortgage-calculation.xls).
This sheet
+
(/examples/src/org/apache/poi/examples/ss/excelant/simple-mortgage-calculation.xls).
This sheet
is shown below:</p>
<!--img src="images/simple-xls-with-function.jpg" alt="mortgage
calculation spreadsheet"/-->
Modified:
poi/site/src/documentation/content/xdocs/components/spreadsheet/quick-guide.xml
URL:
http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/components/spreadsheet/quick-guide.xml?rev=1880440&r1=1880439&r2=1880440&view=diff
==============================================================================
---
poi/site/src/documentation/content/xdocs/components/spreadsheet/quick-guide.xml
(original)
+++
poi/site/src/documentation/content/xdocs/components/spreadsheet/quick-guide.xml
Thu Jul 30 11:36:47 2020
@@ -2197,7 +2197,7 @@ the data to populate another drop down l
sheetCF.addConditionalFormatting(regions, cfRules);
</source>
<p> See more examples on Excel conditional formatting in
- <a
href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/ConditionalFormats.java";>ConditionalFormats.java</a>
+ <a
href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/examples/ss/ConditionalFormats.java";>ConditionalFormats.java</a>
</p>
</section>
Modified:
poi/site/src/documentation/content/xdocs/components/spreadsheet/user-defined-functions.xml
URL:
http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/components/spreadsheet/user-defined-functions.xml?rev=1880440&r1=1880439&r2=1880440&view=diff
==============================================================================
---
poi/site/src/documentation/content/xdocs/components/spreadsheet/user-defined-functions.xml
(original)
+++
poi/site/src/documentation/content/xdocs/components/spreadsheet/user-defined-functions.xml
Thu Jul 30 11:36:47 2020
@@ -406,7 +406,7 @@ cell: Sheet1!B4
returns value: org.apache.poi.ss.usermodel.CellValue [790.7936267415464]
]]></source>
<p>That is it! Now you can create Java code and register it,
allowing your POI based appliction to run spreadsheets that previously were
inaccessible.</p>
- <p>This example can be found in the <a
href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/formula";>src/examples/src/org/apache/poi/ss/examples/formula</a>
folder in the source.</p>
+ <p>This example can be found in the <a
href="http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/examples/ss/formula";>src/examples/src/org/apache/poi/examples/ss/formula</a>
folder in the source.</p>
</section>
</section>
</body>
Modified: poi/site/src/documentation/content/xdocs/help/faq.xml
URL:
http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/help/faq.xml?rev=1880440&r1=1880439&r2=1880440&view=diff
==============================================================================
--- poi/site/src/documentation/content/xdocs/help/faq.xml (original)
+++ poi/site/src/documentation/content/xdocs/help/faq.xml Thu Jul 30 11:36:47
2020
@@ -377,8 +377,8 @@ case HSSFCell.CELL_TYPE_NUMERIC:
<p>Apache POI ships with a few programs and a few example programs,
which can be used to do some basic performance checks. For testing
file generation, the class to use is in the examples package,
- <a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/SSPerformanceTest.java";>SSPerformanceTest</a>
- (<a
href="https://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/ss/examples/SSPerformanceTest.java";>viewvc</a>).
+ <a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/examples/ss/SSPerformanceTest.java";>SSPerformanceTest</a>
+ (<a
href="https://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/examples/ss/SSPerformanceTest.java";>viewvc</a>).
Run SSPerformanceTest with arguments of the writing type (HSSF, XSSF
or SXSSF), the number rows, the number of columns, and if the file
should be saved. If you can't run that with 50,000 rows and 50 columns
@@ -386,8 +386,8 @@ case HSSFCell.CELL_TYPE_NUMERIC:
(and ideally all 3 in less than that!), then the problem is with
your environment.</p>
<p>Next, use the example program
- <a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/ToCSV.java";>ToCSV</a>
- (<a
href="https://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/ss/examples/ToCSV.java";>viewvc</a>)
+ <a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/examples/ss/ToCSV.java";>ToCSV</a>
+ (<a
href="https://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/examples/ss/ToCSV.java";>viewvc</a>)
to try reading the file in with HSSF or XSSF. Related is
<a
href="https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/XLSX2CSV.java";>XLSX2CSV</a>
(<a
href="https://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/XLSX2CSV.java";>viewvc</a>),
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@poi.apache.org
For additional commands, e-mail: commits-h...@poi.apache.org
