Modified: poi/site/publish/components/spreadsheet/diagram1.html
URL: 
http://svn.apache.org/viewvc/poi/site/publish/components/spreadsheet/diagram1.html?rev=1836244&r1=1836243&r2=1836244&view=diff
==============================================================================
--- poi/site/publish/components/spreadsheet/diagram1.html (original)
+++ poi/site/publish/components/spreadsheet/diagram1.html Wed Jul 18 23:27:21 
2018
@@ -1,247 +1,442 @@
-<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" 
"http://www.w3.org/TR/html4/loose.dtd";>
+<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" 
"http://www.w3.org/TR/html4/loose.dtd";>
 <html>
 <head>
 <META http-equiv="Content-Type" content="text/html; charset=UTF-8">
-<!--*** This is a generated file.  Do not edit.  ***-->
-<link rel="stylesheet" href="../skin/tigris.css" type="text/css">
-<link rel="stylesheet" href="../skin/mysite.css" type="text/css">
-<link rel="stylesheet" href="../skin/site.css" type="text/css">
-<link media="print" rel="stylesheet" href="../skin/print.css" type="text/css">
+<meta content="Apache Forrest" name="Generator">
+<meta name="Forrest-version" content="0.9">
+<meta name="Forrest-skin-name" content="pelt">
 <title>HSSF</title>
+<link type="text/css" href="../../skin/basic.css" rel="stylesheet">
+<link media="screen" type="text/css" href="../../skin/screen.css" 
rel="stylesheet">
+<link media="print" type="text/css" href="../../skin/print.css" 
rel="stylesheet">
+<link type="text/css" href="../../skin/profile.css" rel="stylesheet">
+<script src="../../skin/getBlank.js" language="javascript" 
type="text/javascript"></script><script src="../../skin/getMenu.js" 
language="javascript" type="text/javascript"></script><script 
src="../../skin/fontsize.js" language="javascript" 
type="text/javascript"></script>
+<link rel="shortcut icon" href="../../images/favicon.ico">
 </head>
-<body bgcolor="white" class="composite">
-<!--================= start Banner ==================-->
-<div id="banner">
-<table width="100%" cellpadding="8" cellspacing="0" summary="banner" 
border="0">
-<tbody>
-<tr>
-<!--================= start Group Logo ==================-->
-<td width="50%" align="left">
-<div class="groupLogo">
-<a href="https://www.apache.org";><img border="0" class="logoImage" alt="The 
Apache Software Foundation" src="../resources/images/asf_logo.png"></a>
-</div>
-</td>
-<!--================= end Group Logo ==================-->
-<!--================= start Project Logo ==================--><td width="50%" 
align="right">
-<div align="right" class="projectLogo">
-<a href="https://donate.apache.org/";><img border="0" class="logoImage" 
alt="Support Apache" src="../resources/images/support-asf.png" width="120" 
height="120" title="Your donation helps The Apache Software Foundation ensure 
its community-driven software remains available to billions of users at 
absolutely no cost."></a><a href="https://poi.apache.org/";><img border="0" 
class="logoImage" alt="Apache POI" src="../resources/images/pb-poi.png" 
width="120" height="120" title="Apache POI - the Java API for Microsoft 
Documents"></a>
-</div>
-</td>
-<!--================= end Project Logo ==================-->
-</tr>
-</tbody>
-</table>
-</div>
-<!--================= end Banner ==================-->
-<!--================= start Main ==================-->
-<table width="100%" cellpadding="0" cellspacing="0" border="0" summary="nav" 
id="breadcrumbs">
-<tbody>
-<!--================= start Status ==================-->
-<tr class="status">
-<td>
-<!--================= start BreadCrumb ==================--><a 
href="https://www.apache.org/";>Apache</a> | <a 
href="https://poi.apache.org/";>POI</a><a href=""></a>
-<!--================= end BreadCrumb ==================--></td><td id="tabs">
-<!--================= start Tabs ==================-->
-<div class="tab">
-<span class="selectedTab"><a class="base-selected" 
href="../index.html">Home</a></span> | <script language="Javascript" 
type="text/javascript">
-function printit() {  
-if (window.print) {
-    window.print() ;  
-} else {
-    var WebBrowser = '<OBJECT ID="WebBrowser1" WIDTH="0" HEIGHT="0" 
CLASSID="CLSID:8856F961-340A-11D0-A96B-00C04FD705A2"></OBJECT>';
-document.body.insertAdjacentHTML('beforeEnd', WebBrowser);
-    WebBrowser1.ExecWB(6, 2);//Use a 1 vs. a 2 for a prompting dialog box    
WebBrowser1.outerHTML = "";  
-}
-}
-</script><script language="Javascript" type="text/javascript">
-var NS = (navigator.appName == "Netscape");
-var VERSION = parseInt(navigator.appVersion);
-if (VERSION > 3) {
-    document.write('  <a title="PRINT this page OUT" 
href="javascript:printit()">PRINT</a>');
-}
-</script>
-</div>
-<!--================= end Tabs ==================-->
-</td>
-</tr>
-</tbody>
-</table>
-<!--================= end Status ==================-->
-<table id="main" width="100%" cellpadding="8" cellspacing="0" summary="" 
border="0">
-<tbody>
-<tr valign="top">
-<!--================= start Menu ==================-->
-<td id="leftcol">
-<div id="navcolumn">
-<div class="menuBar">
-<div class="menu">
-<span class="menuLabel">Apache POI</span>
-        
-<div class="menuItem">
-<a href="../index.html">Top</a>
+<body onload="init()">
+<script type="text/javascript">ndeSetTextSize();</script>
+<div id="top">
+<!--+
+    |breadtrail
+    +-->
+<div class="breadtrail">
+<a href="https://www.apache.org";>Apache Software Foundation</a> &gt; <a 
href="https://poi.apache.org";>Apache POI</a><script 
src="../../skin/breadcrumbs.js" language="JavaScript" 
type="text/javascript"></script>
+</div>
+<!--+
+    |header
+    +-->
+<div class="header">
+<!--+
+    |start group logo
+    +-->
+<div class="grouplogo">
+<a href="https://www.apache.org";><img class="logoImage" alt="Apache Software 
Foundation" src="../../images/group-logo.png" title="The Apache Software 
Foundation is a cornerstone of the modern Open Source software ecosystem 
&ndash; supporting some of the most widely used and important software 
solutions powering today's Internet economy."></a>
+</div>
+<!--+
+    |end group logo
+    +-->
+<!--+
+    |start Project Logo
+    +-->
+<div class="projectlogo">
+<a href="https://poi.apache.org";><img class="logoImage" alt="Apache POI" 
src="../../images/project-logo.png" title="Apache POI is well-known in the Java 
field as a library for reading and writing Microsoft Office file formats, such 
as Excel, PowerPoint, Word, Visio, Publisher and Outlook. It supports both the 
older (OLE2) and new (OOXML - Office Open XML) formats."></a>
+</div>
+<!--+
+    |end Project Logo
+    +-->
+<!--+
+    |start Search
+    +-->
+<div class="searchbox">
+<form action="http://www.google.com/search"; method="get" class="roundtopsmall">
+<input value="poi.apache.org" name="sitesearch" type="hidden"><input 
onFocus="getBlank (this, 'Search the site with google');" size="25" name="q" 
id="query" type="text" value="Search the site with google">&nbsp; 
+                    <input name="Search" value="Search" type="submit">
+</form>
 </div>
-    
+<!--+
+    |end search
+    +-->
+<!--+
+    |start Tabs
+    +-->
+<ul id="tabs">
+<li>
+<a class="unselected" href="../../index.html">Home</a>
+</li>
+<li>
+<a class="unselected" href="../../help/index.html">Help</a>
+</li>
+<li>
+<a class="unselected" href="../../components/index.html">Component APIs</a>
+</li>
+<li>
+<a class="unselected" href="../../devel/index.html">Getting Involved</a>
+</li>
+</ul>
+<!--+
+    |end Tabs
+    +-->
+</div>
+</div>
+<div id="main">
+<div id="publishedStrip">
+<!--+
+    |start Subtabs
+    +-->
+<div id="level2tabs"></div>
+<!--+
+    |end Endtabs
+    +-->
+<script type="text/javascript"><!--
+document.write("Last Published: " + document.lastModified);
+//  --></script>
+</div>
+<!--+
+    |breadtrail
+    +-->
+<div class="breadtrail">
+
+             &nbsp;
+           </div>
+<!--+
+    |start Menu, mainarea
+    +-->
+<!--+
+    |start Menu
+    +-->
+<div id="menu">
+<div onclick="SwitchMenu('menu_1.1', '../../skin/')" id="menu_1.1Title" 
class="menutitle">Overview</div>
+<div id="menu_1.1" class="menuitemgroup">
+<div class="menuitem">
+<a href="../../index.html">Home</a>
 </div>
-<div class="menu">
-<span class="menuLabel">HSSF+XSSF</span>
-        
-<div class="menuItem">
-<a href="index.html">Overview</a>
+<div class="menuitem">
+<a href="../../download.html">Download</a>
 </div>
-        
-<div class="menuItem">
-<a href="quick-guide.html">Quick Guide</a>
+<div class="menuitem">
+<a href="../../changes.html">Changelog</a>
 </div>
-        
-<div class="menuItem">
-<a href="how-to.html">HOWTO</a>
+<div class="menuitem">
+<a href="../../apidocs/index.html">Javadocs</a>
 </div>
-        
-<div class="menuItem">
-<a href="converting.html">HSSF to SS Converting</a>
+<div class="menuitem">
+<a href="../../text-extraction.html">Text Extraction</a>
 </div>
-        
-<div class="menuItem">
-<a href="formula.html">Formula Support</a>
+<div class="menuitem">
+<a href="../../encryption.html">Encryption support</a>
 </div>
-        
-<div class="menuItem">
-<a href="eval.html">Formula Evaluation</a>
+<div class="menuitem">
+<a href="../../casestudies.html">Case Studies</a>
 </div>
-                   
-<div class="menuItem">
-<a href="eval-devguide.html">Eval Dev Guide</a>
+<div class="menuitem">
+<a href="../../related-projects.html">Related projects</a>
 </div>
-        
-<div class="menuItem">
-<a href="examples.html">Examples</a>
+<div class="menuitem">
+<a href="../../legal.html">Legal</a>
 </div>
-        
-<div class="menuItem">
-<a href="use-case.html">Use Case</a>
 </div>
-        
-<div class="menuItem">
-<a href="diagrams.html">Pictorial Docs</a>
+<div onclick="SwitchMenu('menu_1.2', '../../skin/')" id="menu_1.2Title" 
class="menutitle">Apache Wide</div>
+<div id="menu_1.2" class="menuitemgroup">
+<div class="menuitem">
+<a href="https://www.apache.org/";>Apache Software Foundation</a>
 </div>
-        
-<div class="menuItem">
-<a href="limitations.html">Limitations</a>
+<div class="menuitem">
+<a href="https://www.apache.org/licenses/";>License</a>
 </div>
-        
-<div class="menuItem">
-<a href="user-defined-functions.html">User Defined Functions</a>
+<div class="menuitem">
+<a href="https://www.apache.org/foundation/sponsorship.html";>Sponsorship</a>
 </div>
-        
-<div class="menuItem">
-<a href="excelant.html">ExcelAnt Tests</a>
+<div class="menuitem">
+<a href="https://www.apache.org/foundation/thanks.html";>Thanks</a>
 </div>
-    
+<div class="menuitem">
+<a href="https://www.apache.org/security/";>Security</a>
 </div>
-<div class="menu">
-<span class="menuLabel">Contributer's Guide</span>
-        
-<div class="menuItem">
-<a href="hacking-hssf.html">Hacking HSSF</a>
 </div>
-        
-<div class="menuItem">
-<a href="record-generator.html">Record Generator</a>
+<div onclick="SwitchMenu('menu_1.3', '../../skin/')" id="menu_1.3Title" 
class="menutitle">Component APIs</div>
+<div id="menu_1.3" class="menuitemgroup">
+<div class="menuitem">
+<a href="../../components/index.html">Overview</a>
 </div>
-        
-<div class="menuItem">
-<a href="chart.html">Charts</a>
+<div class="menuitem">
+<a href="../../apidocs/index.html">Javadocs</a>
 </div>
-    
+<div onclick="SwitchMenu('menu_1.3.3', '../../skin/')" id="menu_1.3.3Title" 
class="menutitle">Excel (HSSF/XSSF)</div>
+<div id="menu_1.3.3" class="menuitemgroup">
+<div class="menuitem">
+<a href="../../components/spreadsheet/index.html">Overview</a>
 </div>
-<center>
-<a href="https://www.apache.org/events/current-event.html";><img 
src="https://www.apache.org/events/current-event-125x125.png";></a>
-</center>
-</div>
-</div>
-<form target="_blank" action="https://www.google.com/search"; method="get">
-<table summary="search" border="0" cellspacing="0" cellpadding="0">
-<tr>
-<td><img height="1" width="1" alt="" src="../skin/images/spacer.gif" 
class="spacer"></td><td nowrap="nowrap">
-                          Search Apache POI<br>
-<input value="poi.apache.org" name="sitesearch" type="hidden"><input size="10" 
name="q" id="query" type="text"><img height="1" width="5" alt="" 
src="../skin/images/spacer.gif" class="spacer"><input name="Search" value="GO" 
type="submit"></td><td><img height="1" width="1" alt="" 
src="../skin/images/spacer.gif" class="spacer"></td>
-</tr>
-<tr>
-<td colspan="3"><img height="7" width="1" alt="" 
src="../skin/images/spacer.gif" class="spacer"></td>
-</tr>
-<tr>
-<td class="bottom-left-thick"></td><td bgcolor="#a5b6c6"><img height="1" 
width="1" alt="" src="../skin/images/spacer.gif" class="spacer"></td><td 
class="bottom-right-thick"></td>
-</tr>
-</table>
-</form>
-</td>
-<!--================= end Menu ==================-->
-<!--================= start Content ==================--><td>
-<div id="bodycol">
-<div class="app">
-<div align="center">
-<h1>HSSF</h1>
+<div class="menuitem">
+<a href="../../components/spreadsheet/quick-guide.html">Quick Guide</a>
 </div>
-<div class="h3">
-    
-
-    
+<div class="menuitem">
+<a href="../../components/spreadsheet/how-to.html">HOWTO</a>
+</div>
+<div class="menuitem">
+<a href="../../components/spreadsheet/converting.html">HSSF to SS 
Converting</a>
+</div>
+<div class="menuitem">
+<a href="../../components/spreadsheet/formula.html">Formula Support</a>
+</div>
+<div class="menuitem">
+<a href="../../components/spreadsheet/eval.html">Formula Evaluation</a>
+</div>
+<div class="menuitem">
+<a href="../../components/spreadsheet/eval-devguide.html">Eval Dev Guide</a>
+</div>
+<div class="menuitem">
+<a href="../../components/spreadsheet/examples.html">Examples</a>
+</div>
+<div class="menuitem">
+<a href="../../components/spreadsheet/use-case.html">Use Case</a>
+</div>
+<div class="menuitem">
+<a href="../../components/spreadsheet/diagrams.html">Pictorial Docs</a>
+</div>
+<div class="menuitem">
+<a href="../../components/spreadsheet/limitations.html">Limitations</a>
+</div>
+<div class="menuitem">
+<a href="../../components/spreadsheet/user-defined-functions.html">User 
Defined Functions</a>
+</div>
+<div class="menuitem">
+<a href="../../components/spreadsheet/excelant.html">ExcelAnt Tests</a>
+</div>
+<div class="menuitem">
+<a href="../../components/spreadsheet/hacking-hssf.html">Hacking HSSF</a>
+</div>
+<div class="menuitem">
+<a href="../../components/spreadsheet/record-generator.html">Record 
Generator</a>
+</div>
+<div class="menuitem">
+<a href="../../components/spreadsheet/chart.html">Charts</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.3.4', '../../skin/')" id="menu_1.3.4Title" 
class="menutitle">PowerPoint (HSLF/XSLF)</div>
+<div id="menu_1.3.4" class="menuitemgroup">
+<div class="menuitem">
+<a href="../../components/slideshow/index.html">Overview</a>
+</div>
+<div class="menuitem">
+<a href="../../components/slideshow/quick-guide.html">Quick Guide</a>
+</div>
+<div class="menuitem">
+<a href="../../components/slideshow/how-to-shapes.html">HSLF Cookbook</a>
+</div>
+<div class="menuitem">
+<a href="../../components/slideshow/xslf-cookbook.html">XSLF Cookbook</a>
+</div>
+<div class="menuitem">
+<a href="../../components/slideshow/ppt-file-format.html">PPT File Format</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.3.5', '../../skin/')" id="menu_1.3.5Title" 
class="menutitle">Word (HWPF/XWPF)</div>
+<div id="menu_1.3.5" class="menuitemgroup">
+<div class="menuitem">
+<a href="../../components/document/index.html">Overview</a>
+</div>
+<div class="menuitem">
+<a href="../../components/document/quick-guide.html">HWPF Quick Guide</a>
+</div>
+<div class="menuitem">
+<a href="../../components/document/quick-guide-xwpf.html">XWPF Quick Guide</a>
+</div>
+<div class="menuitem">
+<a href="../../components/document/docoverview.html">HWPF Format</a>
+</div>
+<div class="menuitem">
+<a href="../../components/document/projectplan.html">HWPF Project plan</a>
+</div>
+</div>
+<div class="menuitem">
+<a href="../../components/hsmf/index.html">Outlook (HSMF)</a>
+</div>
+<div class="menuitem">
+<a href="../../components/diagram/index.html">Visio (HDGF+XDGF)</a>
+</div>
+<div onclick="SwitchMenu('menu_1.3.8', '../../skin/')" id="menu_1.3.8Title" 
class="menutitle">Publisher (HPBF)</div>
+<div id="menu_1.3.8" class="menuitemgroup">
+<div class="menuitem">
+<a href="../../components/hpbf/index.html">Overview</a>
+</div>
+<div class="menuitem">
+<a href="../../components/hpbf/file-format.html">File Format</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.3.9', '../../skin/')" id="menu_1.3.9Title" 
class="menutitle">OLE2 Filesystem (POIFS)</div>
+<div id="menu_1.3.9" class="menuitemgroup">
+<div class="menuitem">
+<a href="../../components/poifs/index.html">Overview</a>
+</div>
+<div class="menuitem">
+<a href="../../components/poifs/how-to.html">How To</a>
+</div>
+<div class="menuitem">
+<a href="../../components/poifs/embeded.html">Embedded Documents</a>
+</div>
+<div class="menuitem">
+<a href="../../components/poifs/fileformat.html">File System Documentation</a>
+</div>
+<div class="menuitem">
+<a href="../../components/poifs/usecases.html">Use Cases</a>
+</div>
+<div class="menuitem">
+<a href="../../components/poifs/design.html">Design</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.3.10', '../../skin/')" id="menu_1.3.10Title" 
class="menutitle">OLE2 Document Props (HPSF)</div>
+<div id="menu_1.3.10" class="menuitemgroup">
+<div class="menuitem">
+<a href="../../components/hpsf/index.html">Overview</a>
+</div>
+<div class="menuitem">
+<a href="../../components/hpsf/how-to.html">How To</a>
+</div>
+<div class="menuitem">
+<a href="../../components/hpsf/thumbnails.html">Thumbnails</a>
+</div>
+<div class="menuitem">
+<a href="../../components/hpsf/internals.html">Internals</a>
+</div>
+<div class="menuitem">
+<a href="../../components/hpsf/todo.html">To Do</a>
+</div>
+</div>
+<div class="menuitem">
+<a href="../../components/hmef/index.html">TNEF (HMEF) for winmail.dat</a>
+</div>
+<div class="menuitem">
+<a href="../../components/oxml4j/index.html">OpenXML4J (OOXML)</a>
+</div>
+<div class="menuitem">
+<a href="../../components/logging.html">Logging framework</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.4', '../../skin/')" id="menu_1.4Title" 
class="menutitle">Help</div>
+<div id="menu_1.4" class="menuitemgroup">
+<div class="menuitem">
+<a href="../../help/index.html">Mailing Lists</a>
+</div>
+<div class="menuitem">
+<a href="../../help/faq.html">FAQ</a>
+</div>
+<div class="menuitem">
+<a href="https://bz.apache.org/bugzilla/buglist.cgi?product=POI";>Bug 
Database</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.5', '../../skin/')" id="menu_1.5Title" 
class="menutitle">Getting Involved</div>
+<div id="menu_1.5" class="menuitemgroup">
+<div class="menuitem">
+<a href="../../devel/index.html">How To Build</a>
+</div>
+<div class="menuitem">
+<a href="../../devel/subversion.html">Subversion Repository</a>
+</div>
+<div class="menuitem">
+<a href="../../devel/guidelines.html">Contribution Guidelines</a>
+</div>
+<div class="menuitem">
+<a href="../../devel/who.html">Who We Are</a>
+</div>
+<div onclick="SwitchMenu('menu_1.5.5', '../../skin/')" id="menu_1.5.5Title" 
class="menutitle">Planning Documents</div>
+<div id="menu_1.5.5" class="menuitemgroup">
+<div class="menuitem">
+<a href="../../devel/plan/index.html">Overview</a>
+</div>
+<div class="menuitem">
+<a href="../../devel/plan/vision10.html">1.0 Vision</a>
+</div>
+<div class="menuitem">
+<a href="../../devel/plan/vision20.html">2.0 Vision</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.5.6', '../../skin/')" id="menu_1.5.6Title" 
class="menutitle">References</div>
+<div id="menu_1.5.6" class="menuitemgroup">
+<div class="menuitem">
+<a href="../../devel/references/index.html">Overview</a>
+</div>
+<div class="menuitem">
+<a href="../../devel/references/logocontest.html">Logo Submissions</a>
+</div>
+<div class="menuitem">
+<a href="http://sc.openoffice.org/excelfileformat.pdf";>XLS spec [PDF]</a>
+</div>
+<div class="menuitem">
+<a href="http://xml.apache.org/cocoon/";>Apache Cocoon</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.5.7', '../../skin/')" id="menu_1.5.7Title" 
class="menutitle">Resolutions</div>
+<div id="menu_1.5.7" class="menuitemgroup">
+<div class="menuitem">
+<a href="../../devel/resolutions/index.html">Overview</a>
+</div>
+<div class="menuitem">
+<a href="../../devel/resolutions/res001.html">Minimal Coding Standards</a>
+</div>
+</div>
+<div class="menuitem">
+<a href="../../devel/historyandfuture.html">History</a>
+</div>
+</div>
+<div id="credit"></div>
+<div id="roundbottom">
+<img style="display: none" class="corner" height="15" width="15" alt="" 
src="../../skin/images/rc-b-l-15-1body-2menu-3menu.png"></div>
+<!--+
+  |alternative credits
+  +-->
+<div id="credit2">
+<a href="https://donate.apache.org/";><img border="0" title="Support Apache" 
alt="Support Apache - logo" src="../../images/support-asf.png" style="width: 
125px;height: 125px;"></a>
+</div>
+</div>
+<!--+
+    |end Menu
+    +-->
+<!--+
+    |start content
+    +-->
+<div id="content">
+<h1>HSSF</h1>
+<h3>Overview</h3>
+<div id="front-matter"></div>
         
 <a name="Usermodel+Class+Diagram+by+Matthew+Young"></a>
-<div class="h3">
-<h3>Usermodel Class Diagram by Matthew Young<a title="Permanent link" 
class="headerlink" href="#Usermodel+Class+Diagram+by+Matthew+Young">#</a>
-</h3>
-</div>
-            
-            
+<h2 class="boxed">Usermodel Class Diagram by Matthew Young</h2>
+<div class="section">
 <p>
             
 <img alt="Usermodel" src="images/usermodel.gif">
             </p>
-        
-    
-
-<div id="authors" align="right">by&nbsp;Andrew C. Oliver,&nbsp;Nicola Ken 
Barozzi</div>
-</div>
 </div>
+    
+<p align="right">
+<font size="-2">by&nbsp;Andrew C. Oliver,&nbsp;Nicola Ken Barozzi</font>
+</p>
+</div>
+<!--+
+    |end content
+    +-->
+<div class="clearboth">&nbsp;</div>
 </div>
-</td>
-<!--================= end Content ==================-->
-</tr>
-</tbody>
-</table>
-<!--================= end Main ==================-->
-<!--================= start Footer ==================-->
 <div id="footer">
-<table summary="footer" cellspacing="0" cellpadding="4" width="100%" 
border="0">
-<tbody>
-<tr>
-<!--================= start Copyright ==================-->
-<td colspan="2">
-<div align="center">
+<!--+
+    |start bottomstrip
+    +-->
+<div class="lastmodified">
+<script type="text/javascript"><!--
+document.write("Last Published: " + document.lastModified);
+//  --></script>
+</div>
 <div class="copyright">
-              Copyright &copy; 2002-2018&nbsp;The Apache Software Foundation. 
All rights reserved.<br>
-              Apache, Apache POI, and the Apache POI logo are registered 
trademarks or
-              trademarks of The Apache Software Foundation in the U.S. and/or 
other countries.
-            </div>
-</div>
-</td>
-<!--================= end Copyright ==================-->
-</tr>
-<tr>
-<td align="left">
-<!--================= start Host ==================-->
-<!--================= end Host ==================--></td><td align="right">
-<!--================= start Credits ==================-->
-<div align="right">
-<div class="credit"></div>
-</div>
-<!--================= end Credits ==================-->
-</td>
-</tr>
-</tbody>
-</table>
+        Copyright &copy;
+         2001-2018 <a href="https://www.apache.org/";>The Apache Software 
Foundation</a>
+</div>
+<div id="feedback">
+        Send feedback about the website to:
+    <a id="feedbackto" 
href="mailto:[email protected]?subject=Feedback%C2%A0components/spreadsheet/diagram1.html";>[email protected]</a>
+</div>
+<!--+
+    |end bottomstrip
+    +-->
 </div>
-<!--================= end Footer ==================-->
 </body>
 </html>

Modified: poi/site/publish/components/spreadsheet/diagrams.html
URL: 
http://svn.apache.org/viewvc/poi/site/publish/components/spreadsheet/diagrams.html?rev=1836244&r1=1836243&r2=1836244&view=diff
==============================================================================
--- poi/site/publish/components/spreadsheet/diagrams.html (original)
+++ poi/site/publish/components/spreadsheet/diagrams.html Wed Jul 18 23:27:21 
2018
@@ -1,203 +1,297 @@
-<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" 
"http://www.w3.org/TR/html4/loose.dtd";>
+<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" 
"http://www.w3.org/TR/html4/loose.dtd";>
 <html>
 <head>
 <META http-equiv="Content-Type" content="text/html; charset=UTF-8">
-<!--*** This is a generated file.  Do not edit.  ***-->
-<link rel="stylesheet" href="../skin/tigris.css" type="text/css">
-<link rel="stylesheet" href="../skin/mysite.css" type="text/css">
-<link rel="stylesheet" href="../skin/site.css" type="text/css">
-<link media="print" rel="stylesheet" href="../skin/print.css" type="text/css">
+<meta content="Apache Forrest" name="Generator">
+<meta name="Forrest-version" content="0.9">
+<meta name="Forrest-skin-name" content="pelt">
 <title>HSSF</title>
+<link type="text/css" href="../../skin/basic.css" rel="stylesheet">
+<link media="screen" type="text/css" href="../../skin/screen.css" 
rel="stylesheet">
+<link media="print" type="text/css" href="../../skin/print.css" 
rel="stylesheet">
+<link type="text/css" href="../../skin/profile.css" rel="stylesheet">
+<script src="../../skin/getBlank.js" language="javascript" 
type="text/javascript"></script><script src="../../skin/getMenu.js" 
language="javascript" type="text/javascript"></script><script 
src="../../skin/fontsize.js" language="javascript" 
type="text/javascript"></script>
+<link rel="shortcut icon" href="../../images/favicon.ico">
 </head>
-<body bgcolor="white" class="composite">
-<!--================= start Banner ==================-->
-<div id="banner">
-<table width="100%" cellpadding="8" cellspacing="0" summary="banner" 
border="0">
-<tbody>
-<tr>
-<!--================= start Group Logo ==================-->
-<td width="50%" align="left">
-<div class="groupLogo">
-<a href="https://www.apache.org";><img border="0" class="logoImage" alt="The 
Apache Software Foundation" src="../resources/images/asf_logo.png"></a>
-</div>
-</td>
-<!--================= end Group Logo ==================-->
-<!--================= start Project Logo ==================--><td width="50%" 
align="right">
-<div align="right" class="projectLogo">
-<a href="https://donate.apache.org/";><img border="0" class="logoImage" 
alt="Support Apache" src="../resources/images/support-asf.png" width="120" 
height="120" title="Your donation helps The Apache Software Foundation ensure 
its community-driven software remains available to billions of users at 
absolutely no cost."></a><a href="https://poi.apache.org/";><img border="0" 
class="logoImage" alt="Apache POI" src="../resources/images/pb-poi.png" 
width="120" height="120" title="Apache POI - the Java API for Microsoft 
Documents"></a>
-</div>
-</td>
-<!--================= end Project Logo ==================-->
-</tr>
-</tbody>
-</table>
-</div>
-<!--================= end Banner ==================-->
-<!--================= start Main ==================-->
-<table width="100%" cellpadding="0" cellspacing="0" border="0" summary="nav" 
id="breadcrumbs">
-<tbody>
-<!--================= start Status ==================-->
-<tr class="status">
-<td>
-<!--================= start BreadCrumb ==================--><a 
href="https://www.apache.org/";>Apache</a> | <a 
href="https://poi.apache.org/";>POI</a><a href=""></a>
-<!--================= end BreadCrumb ==================--></td><td id="tabs">
-<!--================= start Tabs ==================-->
-<div class="tab">
-<span class="selectedTab"><a class="base-selected" 
href="../index.html">Home</a></span> | <script language="Javascript" 
type="text/javascript">
-function printit() {  
-if (window.print) {
-    window.print() ;  
-} else {
-    var WebBrowser = '<OBJECT ID="WebBrowser1" WIDTH="0" HEIGHT="0" 
CLASSID="CLSID:8856F961-340A-11D0-A96B-00C04FD705A2"></OBJECT>';
-document.body.insertAdjacentHTML('beforeEnd', WebBrowser);
-    WebBrowser1.ExecWB(6, 2);//Use a 1 vs. a 2 for a prompting dialog box    
WebBrowser1.outerHTML = "";  
-}
-}
-</script><script language="Javascript" type="text/javascript">
-var NS = (navigator.appName == "Netscape");
-var VERSION = parseInt(navigator.appVersion);
-if (VERSION > 3) {
-    document.write('  <a title="PRINT this page OUT" 
href="javascript:printit()">PRINT</a>');
-}
-</script>
-</div>
-<!--================= end Tabs ==================-->
-</td>
-</tr>
-</tbody>
-</table>
-<!--================= end Status ==================-->
-<table id="main" width="100%" cellpadding="8" cellspacing="0" summary="" 
border="0">
-<tbody>
-<tr valign="top">
-<!--================= start Menu ==================-->
-<td id="leftcol">
-<div id="navcolumn">
-<div class="menuBar">
-<div class="menu">
-<span class="menuLabel">Apache POI</span>
-        
-<div class="menuItem">
-<a href="../index.html">Top</a>
+<body onload="init()">
+<script type="text/javascript">ndeSetTextSize();</script>
+<div id="top">
+<!--+
+    |breadtrail
+    +-->
+<div class="breadtrail">
+<a href="https://www.apache.org";>Apache Software Foundation</a> &gt; <a 
href="https://poi.apache.org";>Apache POI</a><script 
src="../../skin/breadcrumbs.js" language="JavaScript" 
type="text/javascript"></script>
+</div>
+<!--+
+    |header
+    +-->
+<div class="header">
+<!--+
+    |start group logo
+    +-->
+<div class="grouplogo">
+<a href="https://www.apache.org";><img class="logoImage" alt="Apache Software 
Foundation" src="../../images/group-logo.png" title="The Apache Software 
Foundation is a cornerstone of the modern Open Source software ecosystem 
&ndash; supporting some of the most widely used and important software 
solutions powering today's Internet economy."></a>
+</div>
+<!--+
+    |end group logo
+    +-->
+<!--+
+    |start Project Logo
+    +-->
+<div class="projectlogo">
+<a href="https://poi.apache.org";><img class="logoImage" alt="Apache POI" 
src="../../images/project-logo.png" title="Apache POI is well-known in the Java 
field as a library for reading and writing Microsoft Office file formats, such 
as Excel, PowerPoint, Word, Visio, Publisher and Outlook. It supports both the 
older (OLE2) and new (OOXML - Office Open XML) formats."></a>
+</div>
+<!--+
+    |end Project Logo
+    +-->
+<!--+
+    |start Search
+    +-->
+<div class="searchbox">
+<form action="http://www.google.com/search"; method="get" class="roundtopsmall">
+<input value="poi.apache.org" name="sitesearch" type="hidden"><input 
onFocus="getBlank (this, 'Search the site with google');" size="25" name="q" 
id="query" type="text" value="Search the site with google">&nbsp; 
+                    <input name="Search" value="Search" type="submit">
+</form>
 </div>
-    
+<!--+
+    |end search
+    +-->
+<!--+
+    |start Tabs
+    +-->
+<ul id="tabs">
+<li>
+<a class="unselected" href="../../index.html">Home</a>
+</li>
+<li>
+<a class="unselected" href="../../help/index.html">Help</a>
+</li>
+<li class="current">
+<a class="selected" href="../../components/index.html">Component APIs</a>
+</li>
+<li>
+<a class="unselected" href="../../devel/index.html">Getting Involved</a>
+</li>
+</ul>
+<!--+
+    |end Tabs
+    +-->
+</div>
+</div>
+<div id="main">
+<div id="publishedStrip">
+<!--+
+    |start Subtabs
+    +-->
+<div id="level2tabs"></div>
+<!--+
+    |end Endtabs
+    +-->
+<script type="text/javascript"><!--
+document.write("Last Published: " + document.lastModified);
+//  --></script>
+</div>
+<!--+
+    |breadtrail
+    +-->
+<div class="breadtrail">
+
+             &nbsp;
+           </div>
+<!--+
+    |start Menu, mainarea
+    +-->
+<!--+
+    |start Menu
+    +-->
+<div id="menu">
+<div onclick="SwitchMenu('menu_selected_1.1', '../../skin/')" 
id="menu_selected_1.1Title" class="menutitle" style="background-image: 
url('../../skin/images/chapter_open.gif');">Component APIs</div>
+<div id="menu_selected_1.1" class="selectedmenuitemgroup" style="display: 
block;">
+<div class="menuitem">
+<a href="../../components/index.html">Overview</a>
 </div>
-<div class="menu">
-<span class="menuLabel">HSSF+XSSF</span>
-        
-<div class="menuItem">
-<a href="index.html">Overview</a>
+<div class="menuitem">
+<a href="../../apidocs/index.html">Javadocs</a>
 </div>
-        
-<div class="menuItem">
-<a href="quick-guide.html">Quick Guide</a>
+<div onclick="SwitchMenu('menu_selected_1.1.3', '../../skin/')" 
id="menu_selected_1.1.3Title" class="menutitle" style="background-image: 
url('../../skin/images/chapter_open.gif');">Excel (HSSF/XSSF)</div>
+<div id="menu_selected_1.1.3" class="selectedmenuitemgroup" style="display: 
block;">
+<div class="menuitem">
+<a href="../../components/spreadsheet/index.html">Overview</a>
 </div>
-        
-<div class="menuItem">
-<a href="how-to.html">HOWTO</a>
+<div class="menuitem">
+<a href="../../components/spreadsheet/quick-guide.html">Quick Guide</a>
 </div>
-        
-<div class="menuItem">
-<a href="converting.html">HSSF to SS Converting</a>
+<div class="menuitem">
+<a href="../../components/spreadsheet/how-to.html">HOWTO</a>
 </div>
-        
-<div class="menuItem">
-<a href="formula.html">Formula Support</a>
+<div class="menuitem">
+<a href="../../components/spreadsheet/converting.html">HSSF to SS 
Converting</a>
 </div>
-        
-<div class="menuItem">
-<a href="eval.html">Formula Evaluation</a>
+<div class="menuitem">
+<a href="../../components/spreadsheet/formula.html">Formula Support</a>
 </div>
-                   
-<div class="menuItem">
-<a href="eval-devguide.html">Eval Dev Guide</a>
+<div class="menuitem">
+<a href="../../components/spreadsheet/eval.html">Formula Evaluation</a>
 </div>
-        
-<div class="menuItem">
-<a href="examples.html">Examples</a>
+<div class="menuitem">
+<a href="../../components/spreadsheet/eval-devguide.html">Eval Dev Guide</a>
 </div>
-        
-<div class="menuItem">
-<a href="use-case.html">Use Case</a>
+<div class="menuitem">
+<a href="../../components/spreadsheet/examples.html">Examples</a>
 </div>
-        
-<div class="menuItem">
-<span class="menuSelected">Pictorial Docs</span>
+<div class="menuitem">
+<a href="../../components/spreadsheet/use-case.html">Use Case</a>
 </div>
-        
-<div class="menuItem">
-<a href="limitations.html">Limitations</a>
+<div class="menupage">
+<div class="menupagetitle">Pictorial Docs</div>
 </div>
-        
-<div class="menuItem">
-<a href="user-defined-functions.html">User Defined Functions</a>
+<div class="menuitem">
+<a href="../../components/spreadsheet/limitations.html">Limitations</a>
 </div>
-        
-<div class="menuItem">
-<a href="excelant.html">ExcelAnt Tests</a>
+<div class="menuitem">
+<a href="../../components/spreadsheet/user-defined-functions.html">User 
Defined Functions</a>
 </div>
-    
+<div class="menuitem">
+<a href="../../components/spreadsheet/excelant.html">ExcelAnt Tests</a>
 </div>
-<div class="menu">
-<span class="menuLabel">Contributer's Guide</span>
-        
-<div class="menuItem">
-<a href="hacking-hssf.html">Hacking HSSF</a>
+<div class="menuitem">
+<a href="../../components/spreadsheet/hacking-hssf.html">Hacking HSSF</a>
 </div>
-        
-<div class="menuItem">
-<a href="record-generator.html">Record Generator</a>
+<div class="menuitem">
+<a href="../../components/spreadsheet/record-generator.html">Record 
Generator</a>
 </div>
-        
-<div class="menuItem">
-<a href="chart.html">Charts</a>
+<div class="menuitem">
+<a href="../../components/spreadsheet/chart.html">Charts</a>
 </div>
-    
 </div>
-<center>
-<a href="https://www.apache.org/events/current-event.html";><img 
src="https://www.apache.org/events/current-event-125x125.png";></a>
-</center>
-</div>
-</div>
-<form target="_blank" action="https://www.google.com/search"; method="get">
-<table summary="search" border="0" cellspacing="0" cellpadding="0">
-<tr>
-<td><img height="1" width="1" alt="" src="../skin/images/spacer.gif" 
class="spacer"></td><td nowrap="nowrap">
-                          Search Apache POI<br>
-<input value="poi.apache.org" name="sitesearch" type="hidden"><input size="10" 
name="q" id="query" type="text"><img height="1" width="5" alt="" 
src="../skin/images/spacer.gif" class="spacer"><input name="Search" value="GO" 
type="submit"></td><td><img height="1" width="1" alt="" 
src="../skin/images/spacer.gif" class="spacer"></td>
-</tr>
-<tr>
-<td colspan="3"><img height="7" width="1" alt="" 
src="../skin/images/spacer.gif" class="spacer"></td>
-</tr>
-<tr>
-<td class="bottom-left-thick"></td><td bgcolor="#a5b6c6"><img height="1" 
width="1" alt="" src="../skin/images/spacer.gif" class="spacer"></td><td 
class="bottom-right-thick"></td>
-</tr>
-</table>
-</form>
-</td>
-<!--================= end Menu ==================-->
-<!--================= start Content ==================--><td>
-<div id="bodycol">
-<div class="app">
-<div align="center">
-<h1>HSSF</h1>
+<div onclick="SwitchMenu('menu_1.1.4', '../../skin/')" id="menu_1.1.4Title" 
class="menutitle">PowerPoint (HSLF/XSLF)</div>
+<div id="menu_1.1.4" class="menuitemgroup">
+<div class="menuitem">
+<a href="../../components/slideshow/index.html">Overview</a>
 </div>
-<div class="h3">
- 
-
- 
+<div class="menuitem">
+<a href="../../components/slideshow/quick-guide.html">Quick Guide</a>
+</div>
+<div class="menuitem">
+<a href="../../components/slideshow/how-to-shapes.html">HSLF Cookbook</a>
+</div>
+<div class="menuitem">
+<a href="../../components/slideshow/xslf-cookbook.html">XSLF Cookbook</a>
+</div>
+<div class="menuitem">
+<a href="../../components/slideshow/ppt-file-format.html">PPT File Format</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.1.5', '../../skin/')" id="menu_1.1.5Title" 
class="menutitle">Word (HWPF/XWPF)</div>
+<div id="menu_1.1.5" class="menuitemgroup">
+<div class="menuitem">
+<a href="../../components/document/index.html">Overview</a>
+</div>
+<div class="menuitem">
+<a href="../../components/document/quick-guide.html">HWPF Quick Guide</a>
+</div>
+<div class="menuitem">
+<a href="../../components/document/quick-guide-xwpf.html">XWPF Quick Guide</a>
+</div>
+<div class="menuitem">
+<a href="../../components/document/docoverview.html">HWPF Format</a>
+</div>
+<div class="menuitem">
+<a href="../../components/document/projectplan.html">HWPF Project plan</a>
+</div>
+</div>
+<div class="menuitem">
+<a href="../../components/hsmf/index.html">Outlook (HSMF)</a>
+</div>
+<div class="menuitem">
+<a href="../../components/diagram/index.html">Visio (HDGF+XDGF)</a>
+</div>
+<div onclick="SwitchMenu('menu_1.1.8', '../../skin/')" id="menu_1.1.8Title" 
class="menutitle">Publisher (HPBF)</div>
+<div id="menu_1.1.8" class="menuitemgroup">
+<div class="menuitem">
+<a href="../../components/hpbf/index.html">Overview</a>
+</div>
+<div class="menuitem">
+<a href="../../components/hpbf/file-format.html">File Format</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.1.9', '../../skin/')" id="menu_1.1.9Title" 
class="menutitle">OLE2 Filesystem (POIFS)</div>
+<div id="menu_1.1.9" class="menuitemgroup">
+<div class="menuitem">
+<a href="../../components/poifs/index.html">Overview</a>
+</div>
+<div class="menuitem">
+<a href="../../components/poifs/how-to.html">How To</a>
+</div>
+<div class="menuitem">
+<a href="../../components/poifs/embeded.html">Embedded Documents</a>
+</div>
+<div class="menuitem">
+<a href="../../components/poifs/fileformat.html">File System Documentation</a>
+</div>
+<div class="menuitem">
+<a href="../../components/poifs/usecases.html">Use Cases</a>
+</div>
+<div class="menuitem">
+<a href="../../components/poifs/design.html">Design</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.1.10', '../../skin/')" id="menu_1.1.10Title" 
class="menutitle">OLE2 Document Props (HPSF)</div>
+<div id="menu_1.1.10" class="menuitemgroup">
+<div class="menuitem">
+<a href="../../components/hpsf/index.html">Overview</a>
+</div>
+<div class="menuitem">
+<a href="../../components/hpsf/how-to.html">How To</a>
+</div>
+<div class="menuitem">
+<a href="../../components/hpsf/thumbnails.html">Thumbnails</a>
+</div>
+<div class="menuitem">
+<a href="../../components/hpsf/internals.html">Internals</a>
+</div>
+<div class="menuitem">
+<a href="../../components/hpsf/todo.html">To Do</a>
+</div>
+</div>
+<div class="menuitem">
+<a href="../../components/hmef/index.html">TNEF (HMEF) for winmail.dat</a>
+</div>
+<div class="menuitem">
+<a href="../../components/oxml4j/index.html">OpenXML4J (OOXML)</a>
+</div>
+<div class="menuitem">
+<a href="../../components/logging.html">Logging framework</a>
+</div>
+</div>
+<div id="credit"></div>
+<div id="roundbottom">
+<img style="display: none" class="corner" height="15" width="15" alt="" 
src="../../skin/images/rc-b-l-15-1body-2menu-3menu.png"></div>
+<!--+
+  |alternative credits
+  +-->
+<div id="credit2">
+<a href="https://donate.apache.org/";><img border="0" title="Support Apache" 
alt="Support Apache - logo" src="../../images/support-asf.png" style="width: 
125px;height: 125px;"></a>
+</div>
+</div>
+<!--+
+    |end Menu
+    +-->
+<!--+
+    |start content
+    +-->
+<div id="content">
+<h1>HSSF</h1>
+<h3>Overview</h3>
+<div id="front-matter"></div>
  
 <a name="Overview"></a>
-<div class="h3">
-<h3>Overview<a title="Permanent link" class="headerlink" href="#Overview">#</a>
-</h3>
-</div>
-        
+<h2 class="boxed">Overview</h2>
+<div class="section">
 <p>
                 This section is intended for diagrams (UML/etc) that help
                 explain HSSF. 
         </p>
-        
 <ul>
                
 <li>
@@ -207,7 +301,6 @@ if (VERSION > 3) {
                </li>
         
 </ul>
-        
 <p>
                 Have more?  Add a new "bug" to the bug database with 
[DOCUMENTATION]
                 prefacing the description and a link to the file on an http 
server 
@@ -218,50 +311,37 @@ if (VERSION > 3) {
                 many good affordable UML tools yet!  And no they don't HAVE to 
be UML...
                 just useful.
         </p>
-  
- 
-
-<div id="authors" align="right">by&nbsp;Andrew C. Oliver,&nbsp;Nicola Ken 
Barozzi</div>
-</div>
 </div>
+ 
+<p align="right">
+<font size="-2">by&nbsp;Andrew C. Oliver,&nbsp;Nicola Ken Barozzi</font>
+</p>
+</div>
+<!--+
+    |end content
+    +-->
+<div class="clearboth">&nbsp;</div>
 </div>
-</td>
-<!--================= end Content ==================-->
-</tr>
-</tbody>
-</table>
-<!--================= end Main ==================-->
-<!--================= start Footer ==================-->
 <div id="footer">
-<table summary="footer" cellspacing="0" cellpadding="4" width="100%" 
border="0">
-<tbody>
-<tr>
-<!--================= start Copyright ==================-->
-<td colspan="2">
-<div align="center">
+<!--+
+    |start bottomstrip
+    +-->
+<div class="lastmodified">
+<script type="text/javascript"><!--
+document.write("Last Published: " + document.lastModified);
+//  --></script>
+</div>
 <div class="copyright">
-              Copyright &copy; 2002-2018&nbsp;The Apache Software Foundation. 
All rights reserved.<br>
-              Apache, Apache POI, and the Apache POI logo are registered 
trademarks or
-              trademarks of The Apache Software Foundation in the U.S. and/or 
other countries.
-            </div>
-</div>
-</td>
-<!--================= end Copyright ==================-->
-</tr>
-<tr>
-<td align="left">
-<!--================= start Host ==================-->
-<!--================= end Host ==================--></td><td align="right">
-<!--================= start Credits ==================-->
-<div align="right">
-<div class="credit"></div>
-</div>
-<!--================= end Credits ==================-->
-</td>
-</tr>
-</tbody>
-</table>
+        Copyright &copy;
+         2001-2018 <a href="https://www.apache.org/";>The Apache Software 
Foundation</a>
+</div>
+<div id="feedback">
+        Send feedback about the website to:
+    <a id="feedbackto" 
href="mailto:[email protected]?subject=Feedback%C2%A0components/spreadsheet/diagrams.html";>[email protected]</a>
+</div>
+<!--+
+    |end bottomstrip
+    +-->
 </div>
-<!--================= end Footer ==================-->
 </body>
 </html>

Modified: poi/site/publish/components/spreadsheet/eval-devguide.html
URL: 
http://svn.apache.org/viewvc/poi/site/publish/components/spreadsheet/eval-devguide.html?rev=1836244&r1=1836243&r2=1836244&view=diff
==============================================================================
--- poi/site/publish/components/spreadsheet/eval-devguide.html (original)
+++ poi/site/publish/components/spreadsheet/eval-devguide.html Wed Jul 18 
23:27:21 2018
@@ -1,220 +1,310 @@
-<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" 
"http://www.w3.org/TR/html4/loose.dtd";>
+<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" 
"http://www.w3.org/TR/html4/loose.dtd";>
 <html>
 <head>
 <META http-equiv="Content-Type" content="text/html; charset=UTF-8">
-<!--*** This is a generated file.  Do not edit.  ***-->
-<link rel="stylesheet" href="../skin/tigris.css" type="text/css">
-<link rel="stylesheet" href="../skin/mysite.css" type="text/css">
-<link rel="stylesheet" href="../skin/site.css" type="text/css">
-<link media="print" rel="stylesheet" href="../skin/print.css" type="text/css">
+<meta content="Apache Forrest" name="Generator">
+<meta name="Forrest-version" content="0.9">
+<meta name="Forrest-skin-name" content="pelt">
 <title>Developing Formula Evaluation</title>
+<link type="text/css" href="../../skin/basic.css" rel="stylesheet">
+<link media="screen" type="text/css" href="../../skin/screen.css" 
rel="stylesheet">
+<link media="print" type="text/css" href="../../skin/print.css" 
rel="stylesheet">
+<link type="text/css" href="../../skin/profile.css" rel="stylesheet">
+<script src="../../skin/getBlank.js" language="javascript" 
type="text/javascript"></script><script src="../../skin/getMenu.js" 
language="javascript" type="text/javascript"></script><script 
src="../../skin/fontsize.js" language="javascript" 
type="text/javascript"></script>
+<link rel="shortcut icon" href="../../images/favicon.ico">
 </head>
-<body bgcolor="white" class="composite">
-<!--================= start Banner ==================-->
-<div id="banner">
-<table width="100%" cellpadding="8" cellspacing="0" summary="banner" 
border="0">
-<tbody>
-<tr>
-<!--================= start Group Logo ==================-->
-<td width="50%" align="left">
-<div class="groupLogo">
-<a href="https://www.apache.org";><img border="0" class="logoImage" alt="The 
Apache Software Foundation" src="../resources/images/asf_logo.png"></a>
-</div>
-</td>
-<!--================= end Group Logo ==================-->
-<!--================= start Project Logo ==================--><td width="50%" 
align="right">
-<div align="right" class="projectLogo">
-<a href="https://donate.apache.org/";><img border="0" class="logoImage" 
alt="Support Apache" src="../resources/images/support-asf.png" width="120" 
height="120" title="Your donation helps The Apache Software Foundation ensure 
its community-driven software remains available to billions of users at 
absolutely no cost."></a><a href="https://poi.apache.org/";><img border="0" 
class="logoImage" alt="Apache POI" src="../resources/images/pb-poi.png" 
width="120" height="120" title="Apache POI - the Java API for Microsoft 
Documents"></a>
-</div>
-</td>
-<!--================= end Project Logo ==================-->
-</tr>
-</tbody>
-</table>
-</div>
-<!--================= end Banner ==================-->
-<!--================= start Main ==================-->
-<table width="100%" cellpadding="0" cellspacing="0" border="0" summary="nav" 
id="breadcrumbs">
-<tbody>
-<!--================= start Status ==================-->
-<tr class="status">
-<td>
-<!--================= start BreadCrumb ==================--><a 
href="https://www.apache.org/";>Apache</a> | <a 
href="https://poi.apache.org/";>POI</a><a href=""></a>
-<!--================= end BreadCrumb ==================--></td><td id="tabs">
-<!--================= start Tabs ==================-->
-<div class="tab">
-<span class="selectedTab"><a class="base-selected" 
href="../index.html">Home</a></span> | <script language="Javascript" 
type="text/javascript">
-function printit() {  
-if (window.print) {
-    window.print() ;  
-} else {
-    var WebBrowser = '<OBJECT ID="WebBrowser1" WIDTH="0" HEIGHT="0" 
CLASSID="CLSID:8856F961-340A-11D0-A96B-00C04FD705A2"></OBJECT>';
-document.body.insertAdjacentHTML('beforeEnd', WebBrowser);
-    WebBrowser1.ExecWB(6, 2);//Use a 1 vs. a 2 for a prompting dialog box    
WebBrowser1.outerHTML = "";  
-}
-}
-</script><script language="Javascript" type="text/javascript">
-var NS = (navigator.appName == "Netscape");
-var VERSION = parseInt(navigator.appVersion);
-if (VERSION > 3) {
-    document.write('  <a title="PRINT this page OUT" 
href="javascript:printit()">PRINT</a>');
-}
-</script>
-</div>
-<!--================= end Tabs ==================-->
-</td>
-</tr>
-</tbody>
-</table>
-<!--================= end Status ==================-->
-<table id="main" width="100%" cellpadding="8" cellspacing="0" summary="" 
border="0">
-<tbody>
-<tr valign="top">
-<!--================= start Menu ==================-->
-<td id="leftcol">
-<div id="navcolumn">
-<div class="menuBar">
-<div class="menu">
-<span class="menuLabel">Apache POI</span>
-        
-<div class="menuItem">
-<a href="../index.html">Top</a>
+<body onload="init()">
+<script type="text/javascript">ndeSetTextSize();</script>
+<div id="top">
+<!--+
+    |breadtrail
+    +-->
+<div class="breadtrail">
+<a href="https://www.apache.org";>Apache Software Foundation</a> &gt; <a 
href="https://poi.apache.org";>Apache POI</a><script 
src="../../skin/breadcrumbs.js" language="JavaScript" 
type="text/javascript"></script>
+</div>
+<!--+
+    |header
+    +-->
+<div class="header">
+<!--+
+    |start group logo
+    +-->
+<div class="grouplogo">
+<a href="https://www.apache.org";><img class="logoImage" alt="Apache Software 
Foundation" src="../../images/group-logo.png" title="The Apache Software 
Foundation is a cornerstone of the modern Open Source software ecosystem 
&ndash; supporting some of the most widely used and important software 
solutions powering today's Internet economy."></a>
+</div>
+<!--+
+    |end group logo
+    +-->
+<!--+
+    |start Project Logo
+    +-->
+<div class="projectlogo">
+<a href="https://poi.apache.org";><img class="logoImage" alt="Apache POI" 
src="../../images/project-logo.png" title="Apache POI is well-known in the Java 
field as a library for reading and writing Microsoft Office file formats, such 
as Excel, PowerPoint, Word, Visio, Publisher and Outlook. It supports both the 
older (OLE2) and new (OOXML - Office Open XML) formats."></a>
+</div>
+<!--+
+    |end Project Logo
+    +-->
+<!--+
+    |start Search
+    +-->
+<div class="searchbox">
+<form action="http://www.google.com/search"; method="get" class="roundtopsmall">
+<input value="poi.apache.org" name="sitesearch" type="hidden"><input 
onFocus="getBlank (this, 'Search the site with google');" size="25" name="q" 
id="query" type="text" value="Search the site with google">&nbsp; 
+                    <input name="Search" value="Search" type="submit">
+</form>
 </div>
-    
+<!--+
+    |end search
+    +-->
+<!--+
+    |start Tabs
+    +-->
+<ul id="tabs">
+<li>
+<a class="unselected" href="../../index.html">Home</a>
+</li>
+<li>
+<a class="unselected" href="../../help/index.html">Help</a>
+</li>
+<li class="current">
+<a class="selected" href="../../components/index.html">Component APIs</a>
+</li>
+<li>
+<a class="unselected" href="../../devel/index.html">Getting Involved</a>
+</li>
+</ul>
+<!--+
+    |end Tabs
+    +-->
 </div>
-<div class="menu">
-<span class="menuLabel">HSSF+XSSF</span>
-        
-<div class="menuItem">
-<a href="index.html">Overview</a>
 </div>
-        
-<div class="menuItem">
-<a href="quick-guide.html">Quick Guide</a>
+<div id="main">
+<div id="publishedStrip">
+<!--+
+    |start Subtabs
+    +-->
+<div id="level2tabs"></div>
+<!--+
+    |end Endtabs
+    +-->
+<script type="text/javascript"><!--
+document.write("Last Published: " + document.lastModified);
+//  --></script>
 </div>
-        
-<div class="menuItem">
-<a href="how-to.html">HOWTO</a>
+<!--+
+    |breadtrail
+    +-->
+<div class="breadtrail">
+
+             &nbsp;
+           </div>
+<!--+
+    |start Menu, mainarea
+    +-->
+<!--+
+    |start Menu
+    +-->
+<div id="menu">
+<div onclick="SwitchMenu('menu_selected_1.1', '../../skin/')" 
id="menu_selected_1.1Title" class="menutitle" style="background-image: 
url('../../skin/images/chapter_open.gif');">Component APIs</div>
+<div id="menu_selected_1.1" class="selectedmenuitemgroup" style="display: 
block;">
+<div class="menuitem">
+<a href="../../components/index.html">Overview</a>
 </div>
-        
-<div class="menuItem">
-<a href="converting.html">HSSF to SS Converting</a>
+<div class="menuitem">
+<a href="../../apidocs/index.html">Javadocs</a>
 </div>
-        
-<div class="menuItem">
-<a href="formula.html">Formula Support</a>
+<div onclick="SwitchMenu('menu_selected_1.1.3', '../../skin/')" 
id="menu_selected_1.1.3Title" class="menutitle" style="background-image: 
url('../../skin/images/chapter_open.gif');">Excel (HSSF/XSSF)</div>
+<div id="menu_selected_1.1.3" class="selectedmenuitemgroup" style="display: 
block;">
+<div class="menuitem">
+<a href="../../components/spreadsheet/index.html">Overview</a>
 </div>
-        
-<div class="menuItem">
-<a href="eval.html">Formula Evaluation</a>
+<div class="menuitem">
+<a href="../../components/spreadsheet/quick-guide.html">Quick Guide</a>
 </div>
-                   
-<div class="menuItem">
-<span class="menuSelected">Eval Dev Guide</span>
+<div class="menuitem">
+<a href="../../components/spreadsheet/how-to.html">HOWTO</a>
 </div>
-        
-<div class="menuItem">
-<a href="examples.html">Examples</a>
+<div class="menuitem">
+<a href="../../components/spreadsheet/converting.html">HSSF to SS 
Converting</a>
 </div>
-        
-<div class="menuItem">
-<a href="use-case.html">Use Case</a>
+<div class="menuitem">
+<a href="../../components/spreadsheet/formula.html">Formula Support</a>
 </div>
-        
-<div class="menuItem">
-<a href="diagrams.html">Pictorial Docs</a>
+<div class="menuitem">
+<a href="../../components/spreadsheet/eval.html">Formula Evaluation</a>
 </div>
-        
-<div class="menuItem">
-<a href="limitations.html">Limitations</a>
+<div class="menupage">
+<div class="menupagetitle">Eval Dev Guide</div>
 </div>
-        
-<div class="menuItem">
-<a href="user-defined-functions.html">User Defined Functions</a>
+<div class="menuitem">
+<a href="../../components/spreadsheet/examples.html">Examples</a>
 </div>
-        
-<div class="menuItem">
-<a href="excelant.html">ExcelAnt Tests</a>
+<div class="menuitem">
+<a href="../../components/spreadsheet/use-case.html">Use Case</a>
 </div>
-    
+<div class="menuitem">
+<a href="../../components/spreadsheet/diagrams.html">Pictorial Docs</a>
 </div>
-<div class="menu">
-<span class="menuLabel">Contributer's Guide</span>
-        
-<div class="menuItem">
-<a href="hacking-hssf.html">Hacking HSSF</a>
+<div class="menuitem">
+<a href="../../components/spreadsheet/limitations.html">Limitations</a>
 </div>
-        
-<div class="menuItem">
-<a href="record-generator.html">Record Generator</a>
+<div class="menuitem">
+<a href="../../components/spreadsheet/user-defined-functions.html">User 
Defined Functions</a>
 </div>
-        
-<div class="menuItem">
-<a href="chart.html">Charts</a>
+<div class="menuitem">
+<a href="../../components/spreadsheet/excelant.html">ExcelAnt Tests</a>
 </div>
-    
+<div class="menuitem">
+<a href="../../components/spreadsheet/hacking-hssf.html">Hacking HSSF</a>
+</div>
+<div class="menuitem">
+<a href="../../components/spreadsheet/record-generator.html">Record 
Generator</a>
+</div>
+<div class="menuitem">
+<a href="../../components/spreadsheet/chart.html">Charts</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.1.4', '../../skin/')" id="menu_1.1.4Title" 
class="menutitle">PowerPoint (HSLF/XSLF)</div>
+<div id="menu_1.1.4" class="menuitemgroup">
+<div class="menuitem">
+<a href="../../components/slideshow/index.html">Overview</a>
+</div>
+<div class="menuitem">
+<a href="../../components/slideshow/quick-guide.html">Quick Guide</a>
+</div>
+<div class="menuitem">
+<a href="../../components/slideshow/how-to-shapes.html">HSLF Cookbook</a>
+</div>
+<div class="menuitem">
+<a href="../../components/slideshow/xslf-cookbook.html">XSLF Cookbook</a>
+</div>
+<div class="menuitem">
+<a href="../../components/slideshow/ppt-file-format.html">PPT File Format</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.1.5', '../../skin/')" id="menu_1.1.5Title" 
class="menutitle">Word (HWPF/XWPF)</div>
+<div id="menu_1.1.5" class="menuitemgroup">
+<div class="menuitem">
+<a href="../../components/document/index.html">Overview</a>
+</div>
+<div class="menuitem">
+<a href="../../components/document/quick-guide.html">HWPF Quick Guide</a>
+</div>
+<div class="menuitem">
+<a href="../../components/document/quick-guide-xwpf.html">XWPF Quick Guide</a>
+</div>
+<div class="menuitem">
+<a href="../../components/document/docoverview.html">HWPF Format</a>
+</div>
+<div class="menuitem">
+<a href="../../components/document/projectplan.html">HWPF Project plan</a>
+</div>
+</div>
+<div class="menuitem">
+<a href="../../components/hsmf/index.html">Outlook (HSMF)</a>
+</div>
+<div class="menuitem">
+<a href="../../components/diagram/index.html">Visio (HDGF+XDGF)</a>
+</div>
+<div onclick="SwitchMenu('menu_1.1.8', '../../skin/')" id="menu_1.1.8Title" 
class="menutitle">Publisher (HPBF)</div>
+<div id="menu_1.1.8" class="menuitemgroup">
+<div class="menuitem">
+<a href="../../components/hpbf/index.html">Overview</a>
+</div>
+<div class="menuitem">
+<a href="../../components/hpbf/file-format.html">File Format</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.1.9', '../../skin/')" id="menu_1.1.9Title" 
class="menutitle">OLE2 Filesystem (POIFS)</div>
+<div id="menu_1.1.9" class="menuitemgroup">
+<div class="menuitem">
+<a href="../../components/poifs/index.html">Overview</a>
+</div>
+<div class="menuitem">
+<a href="../../components/poifs/how-to.html">How To</a>
+</div>
+<div class="menuitem">
+<a href="../../components/poifs/embeded.html">Embedded Documents</a>
+</div>
+<div class="menuitem">
+<a href="../../components/poifs/fileformat.html">File System Documentation</a>
+</div>
+<div class="menuitem">
+<a href="../../components/poifs/usecases.html">Use Cases</a>
+</div>
+<div class="menuitem">
+<a href="../../components/poifs/design.html">Design</a>
+</div>
+</div>
+<div onclick="SwitchMenu('menu_1.1.10', '../../skin/')" id="menu_1.1.10Title" 
class="menutitle">OLE2 Document Props (HPSF)</div>
+<div id="menu_1.1.10" class="menuitemgroup">
+<div class="menuitem">
+<a href="../../components/hpsf/index.html">Overview</a>
+</div>
+<div class="menuitem">
+<a href="../../components/hpsf/how-to.html">How To</a>
+</div>
+<div class="menuitem">
+<a href="../../components/hpsf/thumbnails.html">Thumbnails</a>
+</div>
+<div class="menuitem">
+<a href="../../components/hpsf/internals.html">Internals</a>
+</div>
+<div class="menuitem">
+<a href="../../components/hpsf/todo.html">To Do</a>
+</div>
+</div>
+<div class="menuitem">
+<a href="../../components/hmef/index.html">TNEF (HMEF) for winmail.dat</a>
+</div>
+<div class="menuitem">
+<a href="../../components/oxml4j/index.html">OpenXML4J (OOXML)</a>
+</div>
+<div class="menuitem">
+<a href="../../components/logging.html">Logging framework</a>
+</div>
+</div>
+<div id="credit"></div>
+<div id="roundbottom">
+<img style="display: none" class="corner" height="15" width="15" alt="" 
src="../../skin/images/rc-b-l-15-1body-2menu-3menu.png"></div>
+<!--+
+  |alternative credits
+  +-->
+<div id="credit2">
+<a href="https://donate.apache.org/";><img border="0" title="Support Apache" 
alt="Support Apache - logo" src="../../images/support-asf.png" style="width: 
125px;height: 125px;"></a>
 </div>
-<center>
-<a href="https://www.apache.org/events/current-event.html";><img 
src="https://www.apache.org/events/current-event-125x125.png";></a>
-</center>
-</div>
-</div>
-<form target="_blank" action="https://www.google.com/search"; method="get">
-<table summary="search" border="0" cellspacing="0" cellpadding="0">
-<tr>
-<td><img height="1" width="1" alt="" src="../skin/images/spacer.gif" 
class="spacer"></td><td nowrap="nowrap">
-                          Search Apache POI<br>
-<input value="poi.apache.org" name="sitesearch" type="hidden"><input size="10" 
name="q" id="query" type="text"><img height="1" width="5" alt="" 
src="../skin/images/spacer.gif" class="spacer"><input name="Search" value="GO" 
type="submit"></td><td><img height="1" width="1" alt="" 
src="../skin/images/spacer.gif" class="spacer"></td>
-</tr>
-<tr>
-<td colspan="3"><img height="7" width="1" alt="" 
src="../skin/images/spacer.gif" class="spacer"></td>
-</tr>
-<tr>
-<td class="bottom-left-thick"></td><td bgcolor="#a5b6c6"><img height="1" 
width="1" alt="" src="../skin/images/spacer.gif" class="spacer"></td><td 
class="bottom-right-thick"></td>
-</tr>
-</table>
-</form>
-</td>
-<!--================= end Menu ==================-->
-<!--================= start Content ==================--><td>
-<div id="bodycol">
-<div class="app">
-<div align="center">
-<h1>Developing Formula Evaluation</h1>
 </div>
-<div class="h3">
-    
-    
+<!--+
+    |end Menu
+    +-->
+<!--+
+    |start content
+    +-->
+<div id="content">
+<h1>Developing Formula Evaluation</h1>
+<div id="front-matter"></div>
        
 <a name="Introduction"></a>
-<div class="h3">
-<h3>Introduction<a title="Permanent link" class="headerlink" 
href="#Introduction">#</a>
-</h3>
-</div>
-               
+<h2 class="boxed">Introduction</h2>
+<div class="section">
 <p>This document is for developers wishing to contribute to the 
                        FormulaEvaluator API functionality.</p>
-        
 <p>When evaluating workbooks you may encounter a 
org.apache.poi.ss.formula.eval.NotImplementedException
             which indicates that a function is not (yet) supported by POI. Is 
there a workaround?
             Yes, the POI framework  makes it easy to add implementation of new 
functions. Prior to POI-3.8
             you had to checkout the source code from svn and make a custom 
build with your function implementation.
             Since POI-3.8 you can register new functions in run-time.
         </p>
-               
 <p>Currently, contribution is desired for implementing the standard MS
                        excel functions. Place holder classes for these have 
been created, 
                        contributors only need to insert implementation for the 
                        individual "evaluate()" methods that do the actual 
evaluation.</p>
-       
+</div>
 
        
-<a name="Overview+of+FormulaEvaluator+"></a>
-<div class="h3">
-<h3>Overview of FormulaEvaluator <a title="Permanent link" class="headerlink" 
href="#Overview+of+FormulaEvaluator+">#</a>
-</h3>
-</div>
-               
+<a name="Overview+of+FormulaEvaluator"></a>
+<h2 class="boxed">Overview of FormulaEvaluator </h2>
+<div class="section">
 <p>Briefly, a formula string (along with the sheet and workbook that 
                        form the context in which the formula is evaluated) is 
first parsed 
                        into RPN tokens using the FormulaParser class .
@@ -222,13 +312,8 @@ if (VERSION > 3) {
                        read <a 
href="http://www-stone.ch.cam.ac.uk/documentation/rrf/rpn.html";>
                        this</a>.)
                </p>
-               
-<a name="+The+big+picture"></a>
-<div class="h4">
-<h4> The big picture<a title="Permanent link" class="headerlink" 
href="#+The+big+picture">#</a>
-</h4>
-</div>
-                       
+<a name="The+big+picture"></a>
+<h3 class="boxed"> The big picture</h3>
 <p>RPN tokens are mapped to Eval classes. (Class hierarchy for the Evals 
                                is best understood if you view the class 
diagram in a class diagram 
                                viewer.) Depending on the type of RPN token 
(also called as Ptgs 
@@ -240,13 +325,11 @@ if (VERSION > 3) {
                                that many Evals are popped of the stack and 
passed in an array to 
                                the OperationEval instance's evaluate method 
which returns an Eval 
                                of subtype ValueEval.Thus an operation in the 
formula is evaluated. </p>
-                               
-<div class="frame note">
+<div class="note">
 <div class="label">Note</div>
 <div class="content"> An Eval is of subinterface ValueEval or OperationEval. 
                                Operands are always ValueEvals, Operations are 
always OperationEvals.</div>
-</div> 
-                               
+</div>
 <p>
 <span class="codefrag">OperationEval.evaluate(Eval[])</span> returns an Eval 
which is supposed 
                                to be of type ValueEval (actually since 
ValueEval is an interface, 
@@ -256,7 +339,6 @@ if (VERSION > 3) {
                                eventually there are no more RPN tokens at 
which point, if the formula 
                                string was correctly parsed, there should be 
just one Eval on the 
                                stack - which contains the result of evaluating 
the formula.</p>
-                       
 <p>Of course I glossed over the details of how AreaPtg and ReferencePtg
                                are handled a little differently, but the code 
should be self 
                                explanatory for that. Very briefly, the cells 
included in AreaPtg and 
@@ -264,24 +346,18 @@ if (VERSION > 3) {
                                ValueEval objects which are set into the 
AreaEval and RefEval (ok, 
                                since AreaEval and RefEval are interfaces, the 
implementations of 
                                AreaEval and RefEval - but you'll figure all 
that out from the code)</p>
-                       
 <p>OperationEvals for the standard operators have been implemented and 
tested.</p>
-               
-       
+</div>
 
         
 <a name="What+functions+are+supported%3F"></a>
-<div class="h3">
-<h3>What functions are supported?<a title="Permanent link" class="headerlink" 
href="#What+functions+are+supported%3F">#</a>
-</h3>
-</div>
-            
+<h2 class="boxed">What functions are supported?</h2>
+<div class="section">
 <p>
                 As of September 2017, POI supports about 176 built-in 
functions,
                 see <a href="#appendixA">Appendix A</a> for the full list.
                 You can programmatically list supported / unsupported 
functions using the following helper methods:
             </p>
-            
 <pre class="code">
     // list of functions that POI can evaluate
     Collection&lt;String&gt; supportedFuncs = 
WorkbookEvaluator.getSupportedFunctionNames();
@@ -290,15 +366,12 @@ if (VERSION > 3) {
     Collection&lt;String&gt; unsupportedFuncs = 
WorkbookEvaluator.getNotSupportedFunctionNames();
 
             </pre>
-        
+</div>
 
         
 <a name="Two+base+interfaces+to+start+your+implementation"></a>
-<div class="h3">
-<h3>Two base interfaces to start your implementation<a title="Permanent link" 
class="headerlink" 
href="#Two+base+interfaces+to+start+your+implementation">#</a>
-</h3>
-</div>
-            
+<h2 class="boxed">Two base interfaces to start your implementation</h2>
+<div class="section">
 <p>
                 All Excel formula function classes implement either
                 org.apache.poi.hssf.record.formula.functions.Function or
@@ -309,20 +382,16 @@ if (VERSION > 3) {
                 In the future these two interfaces are expected be unified 
into one, but for now you have to start your implementation from two slightly 
different roots.
 
             </p>
-        
+</div>
 
         
 <a name="Which+interface+to+start+from%3F"></a>
-<div class="h3">
-<h3>Which interface to start from?<a title="Permanent link" class="headerlink" 
href="#Which+interface+to+start+from%3F">#</a>
-</h3>
-</div>
-            
+<h2 class="boxed">Which interface to start from?</h2>
+<div class="section">
 <p>
                 You are about to implement a function XXX and don't know which 
interface to start from: Function or FreeRefFunction.
                 Use the following code to check whether your function is from 
the excel Analysis Toolpack:
             </p>
-            
 <pre class="code">
     if(AnalysisToolPack.isATPFunction(functionName)){
         // the function implements 
org.apache.poi.hssf.record.formula.functions.Function
@@ -330,27 +399,22 @@ if (VERSION > 3) {
         // the function implements 
org.apache.poi.hssf.record.formula.functions.FreeRefFunction
     }
             </pre>
-        
+</div>
 
 
         
 <a name="Walkthrough+of+an+%22evaluate%28%29%22+implementation."></a>
-<div class="h3">
-<h3>Walkthrough of an "evaluate()" implementation.<a title="Permanent link" 
class="headerlink" 
href="#Walkthrough+of+an+%22evaluate%28%29%22+implementation.">#</a>
-</h3>
-</div>
-            
+<h2 class="boxed">Walkthrough of an "evaluate()" implementation.</h2>
+<div class="section">
 <p>Here is the fun part: lets walk through the implementation of the excel 
function  <strong>SQRT()</strong>
             
 </p>
-            
 <p>
                 AnalysisToolPack.isATPFunction("SQRTPI") returns false so the 
base interface is Function.
 
                 There are sub-interfaces that make life easier when 
implementing numeric functions or functions
                 with fixed number of arguments, 1-arg, 2-arg and 3-arg 
function:
             </p>
-            
 <ul>
                 
 <li>org.apache.poi.hssf.record.formula.functions.NumericFunction</li>
@@ -364,12 +428,9 @@ if (VERSION > 3) {
 <li>org.apache.poi.hssf.record.formula.functions.Fixed4ArgFunction</li>
             
 </ul>
-            
 <p>
                 Since SQRTPI takes exactly one argument we start our 
implementation from 
org.apache.poi.hssf.record.formula.functions.Fixed1ArgFunction:
             </p>
-
-            
 <pre class="code">
     Function SQRTPI = new Fixed1ArgFunction() {
         public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, 
ValueEval arg0) {
@@ -399,30 +460,20 @@ if (VERSION > 3) {
         }
     }
             </pre>
-
-            
 <p>Now when the implementation is ready we need to register it in the formula 
evaluator:</p>
-            
 <pre class="code">
     WorkbookEvaluator.registerFunction("SQRTPI", SQRTPI);
             </pre>
-
-            
 <p>Voila! The formula evaluator now recognizes SQRTPI! </p>
-
-        
+</div>
 
         
 <a name="Floating-point+Arithmetic+in+Excel"></a>
-<div class="h3">
-<h3>Floating-point Arithmetic in Excel<a title="Permanent link" 
class="headerlink" href="#Floating-point+Arithmetic+in+Excel">#</a>
-</h3>
-</div>
-            
+<h2 class="boxed">Floating-point Arithmetic in Excel</h2>
+<div class="section">
 <p>Excel uses the IEEE Standard for Double Precision Floating Point numbers
                 except two cases where it does not adhere to IEEE 754:
             </p>
-            
 <ol>
                 
 <li>Positive/Negative Infinities: Infinities occur when you divide by 0.
@@ -436,19 +487,15 @@ if (VERSION > 3) {
                 </li>
             
 </ol>
-            
 <p>Be aware of these two cases when saving results of your scientific 
calculations in Excel:
                 &ldquo;where are my Infinities and NaNs? They are gone!&rdquo;
             </p>
-        
+</div>
 
        
 <a name="Testing+Framework"></a>
-<div class="h3">
-<h3>Testing Framework<a title="Permanent link" class="headerlink" 
href="#Testing+Framework">#</a>
-</h3>
-</div>
-       
+<h2 class="boxed">Testing Framework</h2>
+<div class="section">
 <p>Automated testing of the implemented Function is easy.
        The source code for this is in the file: 
o.a.p.h.record.formula.GenericFormulaTestCase.java
        This class has a reference to the test xls file (not /a/ test xls, 
/the/ test xls :)
@@ -462,20 +509,15 @@ if (VERSION > 3) {
        value (Again, hard to put in words, so if you will, please take time to 
quickly look
        at the code and the currently entered tests in the patch attachment 
"FormulaEvalTestData.xls" 
        file).
-       </p>    
-       
+       </p>
+</div>
 
         
-<a name="appendixA"></a>
+<a name="appendixA" id="appendixA"></a>
         <a name="Appendix+A"></a>
-<div class="h3">
-<h3>Appendix A<a title="Permanent link" class="headerlink" 
href="#Appendix+A">#</a>
-</h3>
-</div>
-           
-            
+<h2 class="boxed">Appendix A</h2>
+<div class="section">
 <p>Functions supported by POI (as of September 2017)</p>
-            
 <pre class="code">
     ABS
     ACOS
@@ -654,50 +696,37 @@ if (VERSION > 3) {
     YEAR
     YEARFRAC
             </pre>
-        
-       
-
-<div id="authors" align="right">by&nbsp;Amol Deshmukh,&nbsp;Yegor Kozlov</div>
 </div>
+       
+<p align="right">
+<font size="-2">by&nbsp;Amol Deshmukh,&nbsp;Yegor Kozlov</font>
+</p>
 </div>
+<!--+
+    |end content
+    +-->
+<div class="clearboth">&nbsp;</div>
 </div>
-</td>
-<!--================= end Content ==================-->
-</tr>
-</tbody>
-</table>
-<!--================= end Main ==================-->
-<!--================= start Footer ==================-->
 <div id="footer">
-<table summary="footer" cellspacing="0" cellpadding="4" width="100%" 
border="0">
-<tbody>
-<tr>
-<!--================= start Copyright ==================-->
-<td colspan="2">
-<div align="center">
+<!--+
+    |start bottomstrip
+    +-->
+<div class="lastmodified">
+<script type="text/javascript"><!--
+document.write("Last Published: " + document.lastModified);
+//  --></script>
+</div>
 <div class="copyright">
-              Copyright &copy; 2002-2018&nbsp;The Apache Software Foundation. 
All rights reserved.<br>
-              Apache, Apache POI, and the Apache POI logo are registered 
trademarks or
-              trademarks of The Apache Software Foundation in the U.S. and/or 
other countries.
-            </div>
-</div>
-</td>
-<!--================= end Copyright ==================-->
-</tr>
-<tr>
-<td align="left">
-<!--================= start Host ==================-->
-<!--================= end Host ==================--></td><td align="right">
-<!--================= start Credits ==================-->
-<div align="right">
-<div class="credit"></div>
-</div>
-<!--================= end Credits ==================-->
-</td>
-</tr>
-</tbody>
-</table>
+        Copyright &copy;
+         2001-2018 <a href="https://www.apache.org/";>The Apache Software 
Foundation</a>
+</div>
+<div id="feedback">
+        Send feedback about the website to:
+    <a id="feedbackto" 
href="mailto:[email protected]?subject=Feedback%C2%A0components/spreadsheet/eval-devguide.html";>[email protected]</a>
+</div>
+<!--+
+    |end bottomstrip
+    +-->
 </div>
-<!--================= end Footer ==================-->
 </body>
 </html>



---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to