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/07/25 18:47:12 UTC

svn commit: r1613470 [3/7] - in /poi/site/publish/apidocs: ./ org/apache/poi/hssf/model/ org/apache/poi/hssf/record/ org/apache/poi/hssf/usermodel/ org/apache/poi/ss/formula/ org/apache/poi/ss/formula/class-use/ org/apache/poi/ss/formula/eval/ org/apac...

Modified: poi/site/publish/apidocs/org/apache/poi/hssf/model/InternalWorkbook.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/hssf/model/InternalWorkbook.html?rev=1613470&r1=1613469&r2=1613470&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/hssf/model/InternalWorkbook.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/hssf/model/InternalWorkbook.html Fri Jul 25 16:47:10 2014
@@ -177,60 +177,66 @@ extends java.lang.Object</pre>
 <tr class="altColor">
 <td class="colFirst"><code>short</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#checkExternSheet(int)">checkExternSheet</a></strong>(int&nbsp;sheetNumber)</code>
-<div class="block">returns the extern sheet number for specific sheet number ,
-  if this sheet doesn't exist in extern sheet , add it</div>
+<div class="block">Returns the extern sheet number for specific sheet number.</div>
 </td>
 </tr>
 <tr class="rowColor">
+<td class="colFirst"><code>short</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#checkExternSheet(int, int)">checkExternSheet</a></strong>(int&nbsp;firstSheetNumber,
+                int&nbsp;lastSheetNumber)</code>
+<div class="block">Returns the extern sheet number for specific range of sheets.</div>
+</td>
+</tr>
+<tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#cloneDrawings(org.apache.poi.hssf.model.InternalSheet)">cloneDrawings</a></strong>(<a href="../../../../../org/apache/poi/hssf/model/InternalSheet.html" title="class in org.apache.poi.hssf.model">InternalSheet</a>&nbsp;sheet)</code>
 <div class="block">Check if the cloned sheet has drawings.</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/hssf/record/NameRecord.html" title="class in org.apache.poi.hssf.record">NameRecord</a></code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#cloneFilter(int, int)">cloneFilter</a></strong>(int&nbsp;filterDbNameIndex,
            int&nbsp;newSheetIndex)</code>&nbsp;</td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/hssf/record/NameRecord.html" title="class in org.apache.poi.hssf.record">NameRecord</a></code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#createBuiltInName(byte, int)">createBuiltInName</a></strong>(byte&nbsp;builtInName,
                  int&nbsp;sheetNumber)</code>
 <div class="block">Generates a NameRecord to represent a built-in region</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/hssf/record/ExtendedFormatRecord.html" title="class in org.apache.poi.hssf.record">ExtendedFormatRecord</a></code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#createCellXF()">createCellXF</a></strong>()</code>
 <div class="block">creates a new Cell-type Extended Format Record and adds it to the end of
   ExtendedFormatRecords collection</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#createDrawingGroup()">createDrawingGroup</a></strong>()</code>
 <div class="block">Creates a primary drawing group record.</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>int</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#createFormat(java.lang.String)">createFormat</a></strong>(java.lang.String&nbsp;formatString)</code>
 <div class="block">Creates a FormatRecord, inserts it, and returns the index code.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/hssf/record/NameRecord.html" title="class in org.apache.poi.hssf.record">NameRecord</a></code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#createName()">createName</a></strong>()</code>
 <div class="block">creates new name</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/hssf/record/FontRecord.html" title="class in org.apache.poi.hssf.record">FontRecord</a></code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#createNewFont()">createNewFont</a></strong>()</code>
 <div class="block">creates a new font record and adds it to the "font table".</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/hssf/record/StyleRecord.html" title="class in org.apache.poi.hssf.record">StyleRecord</a></code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#createStyleRecord(int)">createStyleRecord</a></strong>(int&nbsp;xfIndex)</code>
 <div class="block">Creates a new StyleRecord, for the given Extended
@@ -238,58 +244,62 @@ extends java.lang.Object</pre>
   records collection</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>static <a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html" title="class in org.apache.poi.hssf.model">InternalWorkbook</a></code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#createWorkbook()">createWorkbook</a></strong>()</code>
 <div class="block">Creates an empty workbook object with three blank sheets and all the empty
  fields.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>static <a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html" title="class in org.apache.poi.hssf.model">InternalWorkbook</a></code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#createWorkbook(java.util.List)">createWorkbook</a></strong>(java.util.List&lt;<a href="../../../../../org/apache/poi/hssf/record/Record.html" title="class in org.apache.poi.hssf.record">Record</a>&gt;&nbsp;recs)</code>
 <div class="block">read support  for low level
  API.</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>boolean</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#doesContainsSheetName(java.lang.String, int)">doesContainsSheetName</a></strong>(java.lang.String&nbsp;name,
                      int&nbsp;excludeSheetIdx)</code>
 <div class="block">Determines whether a workbook contains the provided sheet name.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/hssf/model/DrawingManager2.html" title="class in org.apache.poi.hssf.model">DrawingManager2</a></code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#findDrawingGroup()">findDrawingGroup</a></strong>()</code>
 <div class="block">Finds the primary drawing group, if one already exists</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/hssf/record/Record.html" title="class in org.apache.poi.hssf.record">Record</a></code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#findFirstRecordBySid(short)">findFirstRecordBySid</a></strong>(short&nbsp;sid)</code>
 <div class="block">Returns the first occurance of a record matching a particular sid.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>int</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#findFirstRecordLocBySid(short)">findFirstRecordLocBySid</a></strong>(short&nbsp;sid)</code>
 <div class="block">Returns the index of a record matching a particular sid.</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/hssf/record/Record.html" title="class in org.apache.poi.hssf.record">Record</a></code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#findNextRecordBySid(short, int)">findNextRecordBySid</a></strong>(short&nbsp;sid,
                    int&nbsp;pos)</code>
 <div class="block">Returns the next occurance of a record matching a particular sid.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>java.lang.String</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#findSheetNameFromExternSheet(int)">findSheetNameFromExternSheet</a></strong>(int&nbsp;externSheetIndex)</code>
-<div class="block">finds the sheet name by his extern sheet index</div>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#findSheetFirstNameFromExternSheet(int)">findSheetFirstNameFromExternSheet</a></strong>(int&nbsp;externSheetIndex)</code>
+<div class="block">Finds the first sheet name by his extern sheet index</div>
 </td>
 </tr>
+<tr class="rowColor">
+<td class="colFirst"><code>java.lang.String</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#findSheetLastNameFromExternSheet(int)">findSheetLastNameFromExternSheet</a></strong>(int&nbsp;externSheetIndex)</code>&nbsp;</td>
+</tr>
 <tr class="altColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/hssf/record/BackupRecord.html" title="class in org.apache.poi.hssf.record">BackupRecord</a></code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getBackupRecord()">getBackupRecord</a></strong>()</code>
@@ -332,9 +342,21 @@ extends java.lang.Object</pre>
                      java.lang.String&nbsp;sheetName)</code>&nbsp;</td>
 </tr>
 <tr class="altColor">
+<td class="colFirst"><code>int</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getExternalSheetIndex(java.lang.String, java.lang.String, java.lang.String)">getExternalSheetIndex</a></strong>(java.lang.String&nbsp;workbookName,
+                     java.lang.String&nbsp;firstSheetName,
+                     java.lang.String&nbsp;lastSheetName)</code>&nbsp;</td>
+</tr>
+<tr class="rowColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/hssf/record/FileSharingRecord.html" title="class in org.apache.poi.hssf.record">FileSharingRecord</a></code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getFileSharing()">getFileSharing</a></strong>()</code>&nbsp;</td>
 </tr>
+<tr class="altColor">
+<td class="colFirst"><code>int</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getFirstSheetIndexFromExternSheetIndex(int)">getFirstSheetIndexFromExternSheetIndex</a></strong>(int&nbsp;externSheetNumber)</code>
+<div class="block">Finds the (first) sheet index for a particular external sheet number.</div>
+</td>
+</tr>
 <tr class="rowColor">
 <td class="colFirst"><code>int</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getFontIndex(org.apache.poi.hssf.record.FontRecord)">getFontIndex</a></strong>(<a href="../../../../../org/apache/poi/hssf/record/FontRecord.html" title="class in org.apache.poi.hssf.record">FontRecord</a>&nbsp;font)</code>
@@ -365,78 +387,79 @@ extends java.lang.Object</pre>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getHyperlinks()">getHyperlinks</a></strong>()</code>&nbsp;</td>
 </tr>
 <tr class="altColor">
+<td class="colFirst"><code>int</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getLastSheetIndexFromExternSheetIndex(int)">getLastSheetIndexFromExternSheetIndex</a></strong>(int&nbsp;externSheetNumber)</code>
+<div class="block">Finds the last sheet index for a particular external sheet number,
+  which may be the same as the first (except for multi-sheet references)</div>
+</td>
+</tr>
+<tr class="rowColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/hssf/record/NameCommentRecord.html" title="class in org.apache.poi.hssf.record">NameCommentRecord</a></code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getNameCommentRecord(org.apache.poi.hssf.record.NameRecord)">getNameCommentRecord</a></strong>(<a href="../../../../../org/apache/poi/hssf/record/NameRecord.html" title="class in org.apache.poi.hssf.record">NameRecord</a>&nbsp;nameRecord)</code>
 <div class="block">gets the name comment record</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/hssf/record/NameRecord.html" title="class in org.apache.poi.hssf.record">NameRecord</a></code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getNameRecord(int)">getNameRecord</a></strong>(int&nbsp;index)</code>
 <div class="block">gets the name record</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/formula/ptg/NameXPtg.html" title="class in org.apache.poi.ss.formula.ptg">NameXPtg</a></code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getNameXPtg(java.lang.String, int, org.apache.poi.ss.formula.udf.UDFFinder)">getNameXPtg</a></strong>(java.lang.String&nbsp;name,
            int&nbsp;sheetRefIndex,
            <a href="../../../../../org/apache/poi/ss/formula/udf/UDFFinder.html" title="interface in org.apache.poi.ss.formula.udf">UDFFinder</a>&nbsp;udf)</code>&nbsp;</td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/formula/ptg/NameXPtg.html" title="class in org.apache.poi.ss.formula.ptg">NameXPtg</a></code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getNameXPtg(java.lang.String, org.apache.poi.ss.formula.udf.UDFFinder)">getNameXPtg</a></strong>(java.lang.String&nbsp;name,
            <a href="../../../../../org/apache/poi/ss/formula/udf/UDFFinder.html" title="interface in org.apache.poi.ss.formula.udf">UDFFinder</a>&nbsp;udf)</code>&nbsp;</td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>int</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getNumberOfFontRecords()">getNumberOfFontRecords</a></strong>()</code>
 <div class="block">gets the number of font records</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>int</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getNumExFormats()">getNumExFormats</a></strong>()</code>
 <div class="block">get the number of ExtendedFormat records contained in this workbook.</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>int</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getNumNames()">getNumNames</a></strong>()</code>
 <div class="block">gets the total number of names</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>int</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getNumRecords()">getNumRecords</a></strong>()</code>&nbsp;</td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>int</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getNumSheets()">getNumSheets</a></strong>()</code>
 <div class="block">returns the number of boundsheet objects contained in this workbook.</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/hssf/record/RecalcIdRecord.html" title="class in org.apache.poi.hssf.record">RecalcIdRecord</a></code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getRecalcId()">getRecalcId</a></strong>()</code>
 <div class="block">Get or create RecalcIdRecord</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>java.util.List&lt;<a href="../../../../../org/apache/poi/hssf/record/Record.html" title="class in org.apache.poi.hssf.record">Record</a>&gt;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getRecords()">getRecords</a></strong>()</code>&nbsp;</td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>int</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getSheetIndex(java.lang.String)">getSheetIndex</a></strong>(java.lang.String&nbsp;name)</code>
 <div class="block">get the sheet's index</div>
 </td>
 </tr>
-<tr class="altColor">
-<td class="colFirst"><code>int</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getSheetIndexFromExternSheetIndex(int)">getSheetIndexFromExternSheetIndex</a></strong>(int&nbsp;externSheetNumber)</code>
-<div class="block">Finds the sheet index for a particular external sheet number.</div>
-</td>
-</tr>
 <tr class="rowColor">
 <td class="colFirst"><code>java.lang.String</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html#getSheetName(int)">getSheetName</a></strong>(int&nbsp;sheetIndex)</code>
@@ -1118,16 +1141,25 @@ extends java.lang.Object</pre>
 <pre>public&nbsp;int&nbsp;getSize()</pre>
 </li>
 </ul>
-<a name="findSheetNameFromExternSheet(int)">
+<a name="findSheetFirstNameFromExternSheet(int)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
-<h4>findSheetNameFromExternSheet</h4>
-<pre>public&nbsp;java.lang.String&nbsp;findSheetNameFromExternSheet(int&nbsp;externSheetIndex)</pre>
-<div class="block">finds the sheet name by his extern sheet index</div>
+<h4>findSheetFirstNameFromExternSheet</h4>
+<pre>public&nbsp;java.lang.String&nbsp;findSheetFirstNameFromExternSheet(int&nbsp;externSheetIndex)</pre>
+<div class="block">Finds the first sheet name by his extern sheet index</div>
 <dl><dt><span class="strong">Parameters:</span></dt><dd><code>externSheetIndex</code> - extern sheet index</dd>
-<dt><span class="strong">Returns:</span></dt><dd>sheet name.</dd></dl>
+<dt><span class="strong">Returns:</span></dt><dd>first sheet name.</dd></dl>
+</li>
+</ul>
+<a name="findSheetLastNameFromExternSheet(int)">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>findSheetLastNameFromExternSheet</h4>
+<pre>public&nbsp;java.lang.String&nbsp;findSheetLastNameFromExternSheet(int&nbsp;externSheetIndex)</pre>
 </li>
 </ul>
 <a name="getExternalSheet(int)">
@@ -1149,14 +1181,27 @@ extends java.lang.Object</pre>
                                               int&nbsp;externNameIndex)</pre>
 </li>
 </ul>
-<a name="getSheetIndexFromExternSheetIndex(int)">
+<a name="getFirstSheetIndexFromExternSheetIndex(int)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
-<h4>getSheetIndexFromExternSheetIndex</h4>
-<pre>public&nbsp;int&nbsp;getSheetIndexFromExternSheetIndex(int&nbsp;externSheetNumber)</pre>
-<div class="block">Finds the sheet index for a particular external sheet number.</div>
+<h4>getFirstSheetIndexFromExternSheetIndex</h4>
+<pre>public&nbsp;int&nbsp;getFirstSheetIndexFromExternSheetIndex(int&nbsp;externSheetNumber)</pre>
+<div class="block">Finds the (first) sheet index for a particular external sheet number.</div>
+<dl><dt><span class="strong">Parameters:</span></dt><dd><code>externSheetNumber</code> - The external sheet number to convert</dd>
+<dt><span class="strong">Returns:</span></dt><dd>The index to the sheet found.</dd></dl>
+</li>
+</ul>
+<a name="getLastSheetIndexFromExternSheetIndex(int)">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>getLastSheetIndexFromExternSheetIndex</h4>
+<pre>public&nbsp;int&nbsp;getLastSheetIndexFromExternSheetIndex(int&nbsp;externSheetNumber)</pre>
+<div class="block">Finds the last sheet index for a particular external sheet number,
+  which may be the same as the first (except for multi-sheet references)</div>
 <dl><dt><span class="strong">Parameters:</span></dt><dd><code>externSheetNumber</code> - The external sheet number to convert</dd>
 <dt><span class="strong">Returns:</span></dt><dd>The index to the sheet found.</dd></dl>
 </li>
@@ -1168,9 +1213,23 @@ extends java.lang.Object</pre>
 <li class="blockList">
 <h4>checkExternSheet</h4>
 <pre>public&nbsp;short&nbsp;checkExternSheet(int&nbsp;sheetNumber)</pre>
-<div class="block">returns the extern sheet number for specific sheet number ,
-  if this sheet doesn't exist in extern sheet , add it</div>
-<dl><dt><span class="strong">Parameters:</span></dt><dd><code>sheetNumber</code> - sheet number</dd>
+<div class="block">Returns the extern sheet number for specific sheet number.
+ If this sheet doesn't exist in extern sheet, add it</div>
+<dl><dt><span class="strong">Parameters:</span></dt><dd><code>sheetNumber</code> - local sheet number</dd>
+<dt><span class="strong">Returns:</span></dt><dd>index to extern sheet</dd></dl>
+</li>
+</ul>
+<a name="checkExternSheet(int, int)">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>checkExternSheet</h4>
+<pre>public&nbsp;short&nbsp;checkExternSheet(int&nbsp;firstSheetNumber,
+                     int&nbsp;lastSheetNumber)</pre>
+<div class="block">Returns the extern sheet number for specific range of sheets.
+ If this sheet range doesn't exist in extern sheet, add it</div>
+<dl><dt><span class="strong">Parameters:</span></dt><dd><code>firstSheetNumber</code> - first local sheet number</dd><dd><code>lastSheetNumber</code> - last local sheet number</dd>
 <dt><span class="strong">Returns:</span></dt><dd>index to extern sheet</dd></dl>
 </li>
 </ul>
@@ -1184,6 +1243,17 @@ extends java.lang.Object</pre>
                         java.lang.String&nbsp;sheetName)</pre>
 </li>
 </ul>
+<a name="getExternalSheetIndex(java.lang.String, java.lang.String, java.lang.String)">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>getExternalSheetIndex</h4>
+<pre>public&nbsp;int&nbsp;getExternalSheetIndex(java.lang.String&nbsp;workbookName,
+                        java.lang.String&nbsp;firstSheetName,
+                        java.lang.String&nbsp;lastSheetName)</pre>
+</li>
+</ul>
 <a name="getNumNames()">
 <!--   -->
 </a>

Modified: poi/site/publish/apidocs/org/apache/poi/hssf/record/ExternSheetRecord.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/hssf/record/ExternSheetRecord.html?rev=1613470&r1=1613469&r2=1613470&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/hssf/record/ExternSheetRecord.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/hssf/record/ExternSheetRecord.html Fri Jul 25 16:47:10 2014
@@ -223,36 +223,45 @@ extends <a href="../../../../../org/apac
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>int</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/record/ExternSheetRecord.html#getNumOfREFRecords()">getNumOfREFRecords</a></strong>()</code>
-<div class="block">returns the number of REF Records, which is in model</div>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/record/ExternSheetRecord.html#getLastSheetIndexFromRefIndex(int)">getLastSheetIndexFromRefIndex</a></strong>(int&nbsp;extRefIndex)</code>
+<div class="block">Returns the last sheet that the reference applies to, or
+  -1 if the referenced sheet can't be found, or -2 if the
+  reference is workbook scoped.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>int</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/record/ExternSheetRecord.html#getNumOfRefs()">getNumOfRefs</a></strong>()</code>&nbsp;</td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/record/ExternSheetRecord.html#getNumOfREFRecords()">getNumOfREFRecords</a></strong>()</code>
+<div class="block">returns the number of REF Records, which is in model</div>
+</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>int</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/record/ExternSheetRecord.html#getRefIxForSheet(int, int)">getRefIxForSheet</a></strong>(int&nbsp;externalBookIndex,
-                int&nbsp;sheetIndex)</code>&nbsp;</td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/record/ExternSheetRecord.html#getNumOfRefs()">getNumOfRefs</a></strong>()</code>&nbsp;</td>
 </tr>
 <tr class="rowColor">
+<td class="colFirst"><code>int</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/record/ExternSheetRecord.html#getRefIxForSheet(int, int, int)">getRefIxForSheet</a></strong>(int&nbsp;externalBookIndex,
+                int&nbsp;firstSheetIndex,
+                int&nbsp;lastSheetIndex)</code>&nbsp;</td>
+</tr>
+<tr class="altColor">
 <td class="colFirst"><code>short</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/record/ExternSheetRecord.html#getSid()">getSid</a></strong>()</code>
 <div class="block">return the non static version of the id for this record.</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/record/ExternSheetRecord.html#removeSheet(int)">removeSheet</a></strong>(int&nbsp;sheetIdx)</code>&nbsp;</td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>void</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/record/ExternSheetRecord.html#serialize(org.apache.poi.util.LittleEndianOutput)">serialize</a></strong>(<a href="../../../../../org/apache/poi/util/LittleEndianOutput.html" title="interface in org.apache.poi.util">LittleEndianOutput</a>&nbsp;out)</code>
 <div class="block">Write the data content of this BIFF record.</div>
 </td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>java.lang.String</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/record/ExternSheetRecord.html#toString()">toString</a></strong>()</code>
 <div class="block">get a string representation of the record (for biffview/debugging)</div>
@@ -486,6 +495,20 @@ public&nbsp;void&nbsp;adjustIndex(int&nb
   reference is workbook scoped.</div>
 </li>
 </ul>
+<a name="getLastSheetIndexFromRefIndex(int)">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>getLastSheetIndexFromRefIndex</h4>
+<pre>public&nbsp;int&nbsp;getLastSheetIndexFromRefIndex(int&nbsp;extRefIndex)</pre>
+<div class="block">Returns the last sheet that the reference applies to, or
+  -1 if the referenced sheet can't be found, or -2 if the
+  reference is workbook scoped.
+ For a single sheet reference, the first and last should be
+  the same.</div>
+</li>
+</ul>
 <a name="addRef(int, int, int)">
 <!--   -->
 </a>
@@ -523,14 +546,15 @@ public&nbsp;void&nbsp;adjustIndex(int&nb
 <dt><span class="strong">Returns:</span></dt><dd>index of newly added ref</dd></dl>
 </li>
 </ul>
-<a name="getRefIxForSheet(int, int)">
+<a name="getRefIxForSheet(int, int, int)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>getRefIxForSheet</h4>
 <pre>public&nbsp;int&nbsp;getRefIxForSheet(int&nbsp;externalBookIndex,
-                   int&nbsp;sheetIndex)</pre>
+                   int&nbsp;firstSheetIndex,
+                   int&nbsp;lastSheetIndex)</pre>
 </li>
 </ul>
 <a name="combine(org.apache.poi.hssf.record.ExternSheetRecord[])">

Modified: poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/HSSFEvaluationWorkbook.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/HSSFEvaluationWorkbook.html?rev=1613470&r1=1613469&r2=1613470&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/HSSFEvaluationWorkbook.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/HSSFEvaluationWorkbook.html Fri Jul 25 16:47:10 2014
@@ -119,7 +119,7 @@ implements <a href="../../../../../org/a
 <!--   -->
 </a>
 <h3>Nested classes/interfaces inherited from interface&nbsp;org.apache.poi.ss.formula.<a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.html" title="interface in org.apache.poi.ss.formula">EvaluationWorkbook</a></h3>
-<code><a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.ExternalName.html" title="class in org.apache.poi.ss.formula">EvaluationWorkbook.ExternalName</a>, <a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheet.html" title="class in org.apache.poi.ss.formula">EvaluationWorkbook.ExternalSheet</a></code></li>
+<code><a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.ExternalName.html" title="class in org.apache.poi.ss.formula">EvaluationWorkbook.ExternalName</a>, <a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheet.html" title="class in org.apache.poi.ss.formula">EvaluationWorkbook.ExternalSheet</a>, <a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheetRange.html" title="class in org.apache.poi.ss.formula">EvaluationWorkbook.ExternalSheetRange</a></code></li>
 </ul>
 </li>
 </ul>
@@ -183,7 +183,8 @@ implements <a href="../../../../../org/a
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheet.html" title="class in org.apache.poi.ss.formula">EvaluationWorkbook.ExternalSheet</a></code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFEvaluationWorkbook.html#getExternalSheet(java.lang.String, int)">getExternalSheet</a></strong>(java.lang.String&nbsp;sheetName,
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFEvaluationWorkbook.html#getExternalSheet(java.lang.String, java.lang.String, int)">getExternalSheet</a></strong>(java.lang.String&nbsp;firstSheetName,
+                java.lang.String&nbsp;lastSheetName,
                 int&nbsp;externalWorkbookNumber)</code>
 <div class="block">XSSF Only - fetch the external-style sheet details</div>
 </td>
@@ -230,35 +231,39 @@ implements <a href="../../../../../org/a
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFEvaluationWorkbook.html#getSheet(int)">getSheet</a></strong>(int&nbsp;sheetIndex)</code>&nbsp;</td>
 </tr>
 <tr class="altColor">
+<td class="colFirst"><code>java.lang.String</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFEvaluationWorkbook.html#getSheetFirstNameByExternSheet(int)">getSheetFirstNameByExternSheet</a></strong>(int&nbsp;externSheetIndex)</code>&nbsp;</td>
+</tr>
+<tr class="rowColor">
 <td class="colFirst"><code>int</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFEvaluationWorkbook.html#getSheetIndex(org.apache.poi.ss.formula.EvaluationSheet)">getSheetIndex</a></strong>(<a href="../../../../../org/apache/poi/ss/formula/EvaluationSheet.html" title="interface in org.apache.poi.ss.formula">EvaluationSheet</a>&nbsp;evalSheet)</code>&nbsp;</td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>int</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFEvaluationWorkbook.html#getSheetIndex(java.lang.String)">getSheetIndex</a></strong>(java.lang.String&nbsp;sheetName)</code>
 <div class="block">Finds a sheet index by case insensitive name.</div>
 </td>
 </tr>
+<tr class="rowColor">
+<td class="colFirst"><code>java.lang.String</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFEvaluationWorkbook.html#getSheetLastNameByExternSheet(int)">getSheetLastNameByExternSheet</a></strong>(int&nbsp;externSheetIndex)</code>&nbsp;</td>
+</tr>
 <tr class="altColor">
 <td class="colFirst"><code>java.lang.String</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFEvaluationWorkbook.html#getSheetName(int)">getSheetName</a></strong>(int&nbsp;sheetIndex)</code>&nbsp;</td>
 </tr>
 <tr class="rowColor">
-<td class="colFirst"><code>java.lang.String</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFEvaluationWorkbook.html#getSheetNameByExternSheet(int)">getSheetNameByExternSheet</a></strong>(int&nbsp;externSheetIndex)</code>&nbsp;</td>
-</tr>
-<tr class="altColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/SpreadsheetVersion.html" title="enum in org.apache.poi.ss">SpreadsheetVersion</a></code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFEvaluationWorkbook.html#getSpreadsheetVersion()">getSpreadsheetVersion</a></strong>()</code>
 <div class="block">Returns an enum holding spreadhseet properties specific to an Excel version (
  max column and row numbers, max arguments to a function, etc.)</div>
 </td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/formula/udf/UDFFinder.html" title="interface in org.apache.poi.ss.formula.udf">UDFFinder</a></code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFEvaluationWorkbook.html#getUDFFinder()">getUDFFinder</a></strong>()</code>&nbsp;</td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code>java.lang.String</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFEvaluationWorkbook.html#resolveNameXText(org.apache.poi.ss.formula.ptg.NameXPtg)">resolveNameXText</a></strong>(<a href="../../../../../org/apache/poi/ss/formula/ptg/NameXPtg.html" title="class in org.apache.poi.ss.formula.ptg">NameXPtg</a>&nbsp;n)</code>&nbsp;</td>
 </tr>
@@ -476,20 +481,21 @@ implements <a href="../../../../../org/a
 <dt><span class="strong">Returns:</span></dt><dd><code>null</code> if externSheetIndex refers to a sheet inside the current workbook</dd></dl>
 </li>
 </ul>
-<a name="getExternalSheet(java.lang.String, int)">
+<a name="getExternalSheet(java.lang.String, java.lang.String, int)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>getExternalSheet</h4>
-<pre>public&nbsp;<a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheet.html" title="class in org.apache.poi.ss.formula">EvaluationWorkbook.ExternalSheet</a>&nbsp;getExternalSheet(java.lang.String&nbsp;sheetName,
+<pre>public&nbsp;<a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheet.html" title="class in org.apache.poi.ss.formula">EvaluationWorkbook.ExternalSheet</a>&nbsp;getExternalSheet(java.lang.String&nbsp;firstSheetName,
+                                                java.lang.String&nbsp;lastSheetName,
                                                 int&nbsp;externalWorkbookNumber)</pre>
-<div class="block"><strong>Description copied from interface:&nbsp;<code><a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.html#getExternalSheet(java.lang.String, int)">EvaluationWorkbook</a></code></strong></div>
+<div class="block"><strong>Description copied from interface:&nbsp;<code><a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.html#getExternalSheet(java.lang.String, java.lang.String, int)">EvaluationWorkbook</a></code></strong></div>
 <div class="block">XSSF Only - fetch the external-style sheet details
  <p>Return will have no workbook set if it's actually in our own workbook</p></div>
 <dl>
 <dt><strong>Specified by:</strong></dt>
-<dd><code><a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.html#getExternalSheet(java.lang.String, int)">getExternalSheet</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.html" title="interface in org.apache.poi.ss.formula">EvaluationWorkbook</a></code></dd>
+<dd><code><a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.html#getExternalSheet(java.lang.String, java.lang.String, int)">getExternalSheet</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.html" title="interface in org.apache.poi.ss.formula">EvaluationWorkbook</a></code></dd>
 </dl>
 </li>
 </ul>
@@ -541,17 +547,30 @@ implements <a href="../../../../../org/a
 </dl>
 </li>
 </ul>
-<a name="getSheetNameByExternSheet(int)">
+<a name="getSheetFirstNameByExternSheet(int)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
-<h4>getSheetNameByExternSheet</h4>
-<pre>public&nbsp;java.lang.String&nbsp;getSheetNameByExternSheet(int&nbsp;externSheetIndex)</pre>
+<h4>getSheetFirstNameByExternSheet</h4>
+<pre>public&nbsp;java.lang.String&nbsp;getSheetFirstNameByExternSheet(int&nbsp;externSheetIndex)</pre>
 <dl>
 <dt><strong>Specified by:</strong></dt>
-<dd><code><a href="../../../../../org/apache/poi/ss/formula/FormulaRenderingWorkbook.html#getSheetNameByExternSheet(int)">getSheetNameByExternSheet</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/formula/FormulaRenderingWorkbook.html" title="interface in org.apache.poi.ss.formula">FormulaRenderingWorkbook</a></code></dd>
-</dl>
+<dd><code><a href="../../../../../org/apache/poi/ss/formula/FormulaRenderingWorkbook.html#getSheetFirstNameByExternSheet(int)">getSheetFirstNameByExternSheet</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/formula/FormulaRenderingWorkbook.html" title="interface in org.apache.poi.ss.formula">FormulaRenderingWorkbook</a></code></dd>
+<dt><span class="strong">Returns:</span></dt><dd>the name of the (first) sheet referred to by the given external sheet index</dd></dl>
+</li>
+</ul>
+<a name="getSheetLastNameByExternSheet(int)">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>getSheetLastNameByExternSheet</h4>
+<pre>public&nbsp;java.lang.String&nbsp;getSheetLastNameByExternSheet(int&nbsp;externSheetIndex)</pre>
+<dl>
+<dt><strong>Specified by:</strong></dt>
+<dd><code><a href="../../../../../org/apache/poi/ss/formula/FormulaRenderingWorkbook.html#getSheetLastNameByExternSheet(int)">getSheetLastNameByExternSheet</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/formula/FormulaRenderingWorkbook.html" title="interface in org.apache.poi.ss.formula">FormulaRenderingWorkbook</a></code></dd>
+<dt><span class="strong">Returns:</span></dt><dd>the name of the (last) sheet referred to by the given external sheet index</dd></dl>
 </li>
 </ul>
 <a name="getNameText(org.apache.poi.ss.formula.ptg.NamePtg)">

Modified: poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/HSSFWorkbook.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/HSSFWorkbook.html?rev=1613470&r1=1613469&r2=1613470&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/HSSFWorkbook.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/hssf/usermodel/HSSFWorkbook.html Fri Jul 25 16:47:10 2014
@@ -536,7 +536,12 @@ implements <a href="../../../../../org/a
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>int</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#getSheetIndexFromExternSheetIndex(int)">getSheetIndexFromExternSheetIndex</a></strong>(int&nbsp;externSheetNumber)</code>&nbsp;</td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#getSheetIndexFromExternSheetIndex(int)">getSheetIndexFromExternSheetIndex</a></strong>(int&nbsp;externSheetNumber)</code>
+<div class="block"><strong>Deprecated.</strong>&nbsp;
+<div class="block"><i>for POI internal use only (formula parsing).  This method is likely to
+ be removed in future versions of POI.</i></div>
+</div>
+</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>java.lang.String</code></td>
@@ -1472,7 +1477,10 @@ public&nbsp;java.lang.String&nbsp;resolv
 <ul class="blockList">
 <li class="blockList">
 <h4>getSheetIndexFromExternSheetIndex</h4>
-<pre>public&nbsp;int&nbsp;getSheetIndexFromExternSheetIndex(int&nbsp;externSheetNumber)</pre>
+<pre>@Deprecated
+public&nbsp;int&nbsp;getSheetIndexFromExternSheetIndex(int&nbsp;externSheetNumber)</pre>
+<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>for POI internal use only (formula parsing).  This method is likely to
+ be removed in future versions of POI.</i></div>
 </li>
 </ul>
 <a name="getSheetAt(int)">

Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheet.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheet.html?rev=1613470&r1=1613469&r2=1613470&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheet.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheet.html Fri Jul 25 16:47:10 2014
@@ -35,7 +35,7 @@
 <div class="subNav">
 <ul class="navList">
 <li><a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.ExternalName.html" title="class in org.apache.poi.ss.formula"><span class="strong">Prev Class</span></a></li>
-<li><a href="../../../../../org/apache/poi/ss/formula/ExternSheetReferenceToken.html" title="interface in org.apache.poi.ss.formula"><span class="strong">Next Class</span></a></li>
+<li><a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheetRange.html" title="class in org.apache.poi.ss.formula"><span class="strong">Next Class</span></a></li>
 </ul>
 <ul class="navList">
 <li><a href="../../../../../index.html?org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheet.html" target="_top">Frames</a></li>
@@ -93,6 +93,10 @@
 <ul class="blockList">
 <li class="blockList">
 <dl>
+<dt>Direct Known Subclasses:</dt>
+<dd><a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheetRange.html" title="class in org.apache.poi.ss.formula">EvaluationWorkbook.ExternalSheetRange</a></dd>
+</dl>
+<dl>
 <dt>Enclosing interface:</dt>
 <dd><a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.html" title="interface in org.apache.poi.ss.formula">EvaluationWorkbook</a></dd>
 </dl>
@@ -229,7 +233,7 @@ extends java.lang.Object</pre>
 <div class="subNav">
 <ul class="navList">
 <li><a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.ExternalName.html" title="class in org.apache.poi.ss.formula"><span class="strong">Prev Class</span></a></li>
-<li><a href="../../../../../org/apache/poi/ss/formula/ExternSheetReferenceToken.html" title="interface in org.apache.poi.ss.formula"><span class="strong">Next Class</span></a></li>
+<li><a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheetRange.html" title="class in org.apache.poi.ss.formula"><span class="strong">Next Class</span></a></li>
 </ul>
 <ul class="navList">
 <li><a href="../../../../../index.html?org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheet.html" target="_top">Frames</a></li>

Added: poi/site/publish/apidocs/org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheetRange.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheetRange.html?rev=1613470&view=auto
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheetRange.html (added)
+++ poi/site/publish/apidocs/org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheetRange.html Fri Jul 25 16:47:10 2014
@@ -0,0 +1,291 @@
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
+<!-- NewPage -->
+<html lang="en">
+<head>
+<title>EvaluationWorkbook.ExternalSheetRange (POI API Documentation)</title>
+<link rel="stylesheet" type="text/css" href="../../../../../stylesheet.css" title="Style">
+</head>
+<body>
+<script type="text/javascript"><!--
+    if (location.href.indexOf('is-external=true') == -1) {
+        parent.document.title="EvaluationWorkbook.ExternalSheetRange (POI API Documentation)";
+    }
+//-->
+</script>
+<noscript>
+<div>JavaScript is disabled on your browser.</div>
+</noscript>
+<!-- ========= START OF TOP NAVBAR ======= -->
+<div class="topNav"><a name="navbar_top">
+<!--   -->
+</a><a href="#skip-navbar_top" title="Skip navigation links"></a><a name="navbar_top_firstrow">
+<!--   -->
+</a>
+<ul class="navList" title="Navigation">
+<li><a href="../../../../../overview-summary.html">Overview</a></li>
+<li><a href="package-summary.html">Package</a></li>
+<li class="navBarCell1Rev">Class</li>
+<li><a href="class-use/EvaluationWorkbook.ExternalSheetRange.html">Use</a></li>
+<li><a href="package-tree.html">Tree</a></li>
+<li><a href="../../../../../deprecated-list.html">Deprecated</a></li>
+<li><a href="../../../../../index-all.html">Index</a></li>
+<li><a href="../../../../../help-doc.html">Help</a></li>
+</ul>
+</div>
+<div class="subNav">
+<ul class="navList">
+<li><a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheet.html" title="class in org.apache.poi.ss.formula"><span class="strong">Prev Class</span></a></li>
+<li><a href="../../../../../org/apache/poi/ss/formula/ExternSheetReferenceToken.html" title="interface in org.apache.poi.ss.formula"><span class="strong">Next Class</span></a></li>
+</ul>
+<ul class="navList">
+<li><a href="../../../../../index.html?org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheetRange.html" target="_top">Frames</a></li>
+<li><a href="EvaluationWorkbook.ExternalSheetRange.html" target="_top">No Frames</a></li>
+</ul>
+<ul class="navList" id="allclasses_navbar_top">
+<li><a href="../../../../../allclasses-noframe.html">All Classes</a></li>
+</ul>
+<div>
+<script type="text/javascript"><!--
+  allClassesLink = document.getElementById("allclasses_navbar_top");
+  if(window==top) {
+    allClassesLink.style.display = "block";
+  }
+  else {
+    allClassesLink.style.display = "none";
+  }
+  //-->
+</script>
+</div>
+<div>
+<ul class="subNavList">
+<li>Summary:&nbsp;</li>
+<li>Nested&nbsp;|&nbsp;</li>
+<li>Field&nbsp;|&nbsp;</li>
+<li><a href="#constructor_summary">Constr</a>&nbsp;|&nbsp;</li>
+<li><a href="#method_summary">Method</a></li>
+</ul>
+<ul class="subNavList">
+<li>Detail:&nbsp;</li>
+<li>Field&nbsp;|&nbsp;</li>
+<li><a href="#constructor_detail">Constr</a>&nbsp;|&nbsp;</li>
+<li><a href="#method_detail">Method</a></li>
+</ul>
+</div>
+<a name="skip-navbar_top">
+<!--   -->
+</a></div>
+<!-- ========= END OF TOP NAVBAR ========= -->
+<!-- ======== START OF CLASS DATA ======== -->
+<div class="header">
+<div class="subTitle">org.apache.poi.ss.formula</div>
+<h2 title="Class EvaluationWorkbook.ExternalSheetRange" class="title">Class EvaluationWorkbook.ExternalSheetRange</h2>
+</div>
+<div class="contentContainer">
+<ul class="inheritance">
+<li>java.lang.Object</li>
+<li>
+<ul class="inheritance">
+<li><a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheet.html" title="class in org.apache.poi.ss.formula">org.apache.poi.ss.formula.EvaluationWorkbook.ExternalSheet</a></li>
+<li>
+<ul class="inheritance">
+<li>org.apache.poi.ss.formula.EvaluationWorkbook.ExternalSheetRange</li>
+</ul>
+</li>
+</ul>
+</li>
+</ul>
+<div class="description">
+<ul class="blockList">
+<li class="blockList">
+<dl>
+<dt>Enclosing interface:</dt>
+<dd><a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.html" title="interface in org.apache.poi.ss.formula">EvaluationWorkbook</a></dd>
+</dl>
+<hr>
+<br>
+<pre>public static class <span class="strong">EvaluationWorkbook.ExternalSheetRange</span>
+extends <a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheet.html" title="class in org.apache.poi.ss.formula">EvaluationWorkbook.ExternalSheet</a></pre>
+</li>
+</ul>
+</div>
+<div class="summary">
+<ul class="blockList">
+<li class="blockList">
+<!-- ======== CONSTRUCTOR SUMMARY ======== -->
+<ul class="blockList">
+<li class="blockList"><a name="constructor_summary">
+<!--   -->
+</a>
+<h3>Constructor Summary</h3>
+<table class="overviewSummary" border="0" cellpadding="3" cellspacing="0" summary="Constructor Summary table, listing constructors, and an explanation">
+<caption><span>Constructors</span><span class="tabEnd">&nbsp;</span></caption>
+<tr>
+<th class="colOne" scope="col">Constructor and Description</th>
+</tr>
+<tr class="altColor">
+<td class="colOne"><code><strong><a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheetRange.html#EvaluationWorkbook.ExternalSheetRange(java.lang.String, java.lang.String, java.lang.String)">EvaluationWorkbook.ExternalSheetRange</a></strong>(java.lang.String&nbsp;workbookName,
+                                     java.lang.String&nbsp;firstSheetName,
+                                     java.lang.String&nbsp;lastSheetName)</code>&nbsp;</td>
+</tr>
+</table>
+</li>
+</ul>
+<!-- ========== METHOD SUMMARY =========== -->
+<ul class="blockList">
+<li class="blockList"><a name="method_summary">
+<!--   -->
+</a>
+<h3>Method Summary</h3>
+<table class="overviewSummary" border="0" cellpadding="3" cellspacing="0" summary="Method Summary table, listing methods, and an explanation">
+<caption><span>Methods</span><span class="tabEnd">&nbsp;</span></caption>
+<tr>
+<th class="colFirst" scope="col">Modifier and Type</th>
+<th class="colLast" scope="col">Method and Description</th>
+</tr>
+<tr class="altColor">
+<td class="colFirst"><code>java.lang.String</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheetRange.html#getFirstSheetName()">getFirstSheetName</a></strong>()</code>&nbsp;</td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><code>java.lang.String</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheetRange.html#getLastSheetName()">getLastSheetName</a></strong>()</code>&nbsp;</td>
+</tr>
+</table>
+<ul class="blockList">
+<li class="blockList"><a name="methods_inherited_from_class_org.apache.poi.ss.formula.EvaluationWorkbook.ExternalSheet">
+<!--   -->
+</a>
+<h3>Methods inherited from class&nbsp;org.apache.poi.ss.formula.<a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheet.html" title="class in org.apache.poi.ss.formula">EvaluationWorkbook.ExternalSheet</a></h3>
+<code><a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheet.html#getSheetName()">getSheetName</a>, <a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheet.html#getWorkbookName()">getWorkbookName</a></code></li>
+</ul>
+<ul class="blockList">
+<li class="blockList"><a name="methods_inherited_from_class_java.lang.Object">
+<!--   -->
+</a>
+<h3>Methods inherited from class&nbsp;java.lang.Object</h3>
+<code>clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait</code></li>
+</ul>
+</li>
+</ul>
+</li>
+</ul>
+</div>
+<div class="details">
+<ul class="blockList">
+<li class="blockList">
+<!-- ========= CONSTRUCTOR DETAIL ======== -->
+<ul class="blockList">
+<li class="blockList"><a name="constructor_detail">
+<!--   -->
+</a>
+<h3>Constructor Detail</h3>
+<a name="EvaluationWorkbook.ExternalSheetRange(java.lang.String, java.lang.String, java.lang.String)">
+<!--   -->
+</a>
+<ul class="blockListLast">
+<li class="blockList">
+<h4>EvaluationWorkbook.ExternalSheetRange</h4>
+<pre>public&nbsp;EvaluationWorkbook.ExternalSheetRange(java.lang.String&nbsp;workbookName,
+                                     java.lang.String&nbsp;firstSheetName,
+                                     java.lang.String&nbsp;lastSheetName)</pre>
+</li>
+</ul>
+</li>
+</ul>
+<!-- ============ METHOD DETAIL ========== -->
+<ul class="blockList">
+<li class="blockList"><a name="method_detail">
+<!--   -->
+</a>
+<h3>Method Detail</h3>
+<a name="getFirstSheetName()">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>getFirstSheetName</h4>
+<pre>public&nbsp;java.lang.String&nbsp;getFirstSheetName()</pre>
+</li>
+</ul>
+<a name="getLastSheetName()">
+<!--   -->
+</a>
+<ul class="blockListLast">
+<li class="blockList">
+<h4>getLastSheetName</h4>
+<pre>public&nbsp;java.lang.String&nbsp;getLastSheetName()</pre>
+</li>
+</ul>
+</li>
+</ul>
+</li>
+</ul>
+</div>
+</div>
+<!-- ========= END OF CLASS DATA ========= -->
+<!-- ======= START OF BOTTOM NAVBAR ====== -->
+<div class="bottomNav"><a name="navbar_bottom">
+<!--   -->
+</a><a href="#skip-navbar_bottom" title="Skip navigation links"></a><a name="navbar_bottom_firstrow">
+<!--   -->
+</a>
+<ul class="navList" title="Navigation">
+<li><a href="../../../../../overview-summary.html">Overview</a></li>
+<li><a href="package-summary.html">Package</a></li>
+<li class="navBarCell1Rev">Class</li>
+<li><a href="class-use/EvaluationWorkbook.ExternalSheetRange.html">Use</a></li>
+<li><a href="package-tree.html">Tree</a></li>
+<li><a href="../../../../../deprecated-list.html">Deprecated</a></li>
+<li><a href="../../../../../index-all.html">Index</a></li>
+<li><a href="../../../../../help-doc.html">Help</a></li>
+</ul>
+</div>
+<div class="subNav">
+<ul class="navList">
+<li><a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheet.html" title="class in org.apache.poi.ss.formula"><span class="strong">Prev Class</span></a></li>
+<li><a href="../../../../../org/apache/poi/ss/formula/ExternSheetReferenceToken.html" title="interface in org.apache.poi.ss.formula"><span class="strong">Next Class</span></a></li>
+</ul>
+<ul class="navList">
+<li><a href="../../../../../index.html?org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheetRange.html" target="_top">Frames</a></li>
+<li><a href="EvaluationWorkbook.ExternalSheetRange.html" target="_top">No Frames</a></li>
+</ul>
+<ul class="navList" id="allclasses_navbar_bottom">
+<li><a href="../../../../../allclasses-noframe.html">All Classes</a></li>
+</ul>
+<div>
+<script type="text/javascript"><!--
+  allClassesLink = document.getElementById("allclasses_navbar_bottom");
+  if(window==top) {
+    allClassesLink.style.display = "block";
+  }
+  else {
+    allClassesLink.style.display = "none";
+  }
+  //-->
+</script>
+</div>
+<div>
+<ul class="subNavList">
+<li>Summary:&nbsp;</li>
+<li>Nested&nbsp;|&nbsp;</li>
+<li>Field&nbsp;|&nbsp;</li>
+<li><a href="#constructor_summary">Constr</a>&nbsp;|&nbsp;</li>
+<li><a href="#method_summary">Method</a></li>
+</ul>
+<ul class="subNavList">
+<li>Detail:&nbsp;</li>
+<li>Field&nbsp;|&nbsp;</li>
+<li><a href="#constructor_detail">Constr</a>&nbsp;|&nbsp;</li>
+<li><a href="#method_detail">Method</a></li>
+</ul>
+</div>
+<a name="skip-navbar_bottom">
+<!--   -->
+</a></div>
+<!-- ======== END OF BOTTOM NAVBAR ======= -->
+<p class="legalCopy"><small>
+                <i>Copyright 2014 The Apache Software Foundation or
+        its licensors, as applicable.</i>
+            </small></p>
+</body>
+</html>

Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/EvaluationWorkbook.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/EvaluationWorkbook.html?rev=1613470&r1=1613469&r2=1613470&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/formula/EvaluationWorkbook.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/formula/EvaluationWorkbook.html Fri Jul 25 16:47:10 2014
@@ -122,6 +122,10 @@
 <td class="colFirst"><code>static class&nbsp;</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheet.html" title="class in org.apache.poi.ss.formula">EvaluationWorkbook.ExternalSheet</a></strong></code>&nbsp;</td>
 </tr>
+<tr class="altColor">
+<td class="colFirst"><code>static class&nbsp;</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheetRange.html" title="class in org.apache.poi.ss.formula">EvaluationWorkbook.ExternalSheetRange</a></strong></code>&nbsp;</td>
+</tr>
 </table>
 </li>
 </ul>
@@ -167,7 +171,8 @@
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheet.html" title="class in org.apache.poi.ss.formula">EvaluationWorkbook.ExternalSheet</a></code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.html#getExternalSheet(java.lang.String, int)">getExternalSheet</a></strong>(java.lang.String&nbsp;sheetName,
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.html#getExternalSheet(java.lang.String, java.lang.String, int)">getExternalSheet</a></strong>(java.lang.String&nbsp;firstSheetName,
+                java.lang.String&nbsp;lastSheetName,
                 int&nbsp;externalWorkbookNumber)</code>
 <div class="block">XSSF Only - fetch the external-style sheet details</div>
 </td>
@@ -276,13 +281,14 @@
  <p>Return will have no workbook set if it's actually in our own workbook</p></div>
 </li>
 </ul>
-<a name="getExternalSheet(java.lang.String, int)">
+<a name="getExternalSheet(java.lang.String, java.lang.String, int)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>getExternalSheet</h4>
-<pre><a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheet.html" title="class in org.apache.poi.ss.formula">EvaluationWorkbook.ExternalSheet</a>&nbsp;getExternalSheet(java.lang.String&nbsp;sheetName,
+<pre><a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheet.html" title="class in org.apache.poi.ss.formula">EvaluationWorkbook.ExternalSheet</a>&nbsp;getExternalSheet(java.lang.String&nbsp;firstSheetName,
+                                                java.lang.String&nbsp;lastSheetName,
                                                 int&nbsp;externalWorkbookNumber)</pre>
 <div class="block">XSSF Only - fetch the external-style sheet details
  <p>Return will have no workbook set if it's actually in our own workbook</p></div>

Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/ExternSheetReferenceToken.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/ExternSheetReferenceToken.html?rev=1613470&r1=1613469&r2=1613470&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/formula/ExternSheetReferenceToken.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/formula/ExternSheetReferenceToken.html Fri Jul 25 16:47:10 2014
@@ -34,7 +34,7 @@
 </div>
 <div class="subNav">
 <ul class="navList">
-<li><a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheet.html" title="class in org.apache.poi.ss.formula"><span class="strong">Prev Class</span></a></li>
+<li><a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheetRange.html" title="class in org.apache.poi.ss.formula"><span class="strong">Prev Class</span></a></li>
 <li><a href="../../../../../org/apache/poi/ss/formula/Formula.html" title="class in org.apache.poi.ss.formula"><span class="strong">Next Class</span></a></li>
 </ul>
 <ul class="navList">
@@ -182,7 +182,7 @@
 </div>
 <div class="subNav">
 <ul class="navList">
-<li><a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheet.html" title="class in org.apache.poi.ss.formula"><span class="strong">Prev Class</span></a></li>
+<li><a href="../../../../../org/apache/poi/ss/formula/EvaluationWorkbook.ExternalSheetRange.html" title="class in org.apache.poi.ss.formula"><span class="strong">Prev Class</span></a></li>
 <li><a href="../../../../../org/apache/poi/ss/formula/Formula.html" title="class in org.apache.poi.ss.formula"><span class="strong">Next Class</span></a></li>
 </ul>
 <ul class="navList">

Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/FormulaRenderingWorkbook.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/FormulaRenderingWorkbook.html?rev=1613470&r1=1613469&r2=1613470&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/formula/FormulaRenderingWorkbook.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/formula/FormulaRenderingWorkbook.html Fri Jul 25 16:47:10 2014
@@ -124,10 +124,14 @@
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>java.lang.String</code></td>
-<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/formula/FormulaRenderingWorkbook.html#getSheetNameByExternSheet(int)">getSheetNameByExternSheet</a></strong>(int&nbsp;externSheetIndex)</code>&nbsp;</td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/formula/FormulaRenderingWorkbook.html#getSheetFirstNameByExternSheet(int)">getSheetFirstNameByExternSheet</a></strong>(int&nbsp;externSheetIndex)</code>&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>java.lang.String</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/formula/FormulaRenderingWorkbook.html#getSheetLastNameByExternSheet(int)">getSheetLastNameByExternSheet</a></strong>(int&nbsp;externSheetIndex)</code>&nbsp;</td>
+</tr>
+<tr class="altColor">
+<td class="colFirst"><code>java.lang.String</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/formula/FormulaRenderingWorkbook.html#resolveNameXText(org.apache.poi.ss.formula.ptg.NameXPtg)">resolveNameXText</a></strong>(<a href="../../../../../org/apache/poi/ss/formula/ptg/NameXPtg.html" title="class in org.apache.poi.ss.formula.ptg">NameXPtg</a>&nbsp;nameXPtg)</code>&nbsp;</td>
 </tr>
 </table>
@@ -155,13 +159,24 @@
 <dl><dt><span class="strong">Returns:</span></dt><dd><code>null</code> if externSheetIndex refers to a sheet inside the current workbook</dd></dl>
 </li>
 </ul>
-<a name="getSheetNameByExternSheet(int)">
+<a name="getSheetFirstNameByExternSheet(int)">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>getSheetFirstNameByExternSheet</h4>
+<pre>java.lang.String&nbsp;getSheetFirstNameByExternSheet(int&nbsp;externSheetIndex)</pre>
+<dl><dt><span class="strong">Returns:</span></dt><dd>the name of the (first) sheet referred to by the given external sheet index</dd></dl>
+</li>
+</ul>
+<a name="getSheetLastNameByExternSheet(int)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
-<h4>getSheetNameByExternSheet</h4>
-<pre>java.lang.String&nbsp;getSheetNameByExternSheet(int&nbsp;externSheetIndex)</pre>
+<h4>getSheetLastNameByExternSheet</h4>
+<pre>java.lang.String&nbsp;getSheetLastNameByExternSheet(int&nbsp;externSheetIndex)</pre>
+<dl><dt><span class="strong">Returns:</span></dt><dd>the name of the (last) sheet referred to by the given external sheet index</dd></dl>
 </li>
 </ul>
 <a name="resolveNameXText(org.apache.poi.ss.formula.ptg.NameXPtg)">

Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/OperationEvaluationContext.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/OperationEvaluationContext.html?rev=1613470&r1=1613469&r2=1613470&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/formula/OperationEvaluationContext.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/formula/OperationEvaluationContext.html Fri Jul 25 16:47:10 2014
@@ -214,7 +214,7 @@ extends java.lang.Object</pre>
           int&nbsp;columnIndex)</code>&nbsp;</td>
 </tr>
 <tr class="rowColor">
-<td class="colFirst"><code>org.apache.poi.ss.formula.SheetRefEvaluator</code></td>
+<td class="colFirst"><code>org.apache.poi.ss.formula.SheetRangeEvaluator</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/formula/OperationEvaluationContext.html#getRefEvaluatorForCurrentSheet()">getRefEvaluatorForCurrentSheet</a></strong>()</code>&nbsp;</td>
 </tr>
 <tr class="altColor">
@@ -319,7 +319,7 @@ extends java.lang.Object</pre>
 <ul class="blockList">
 <li class="blockList">
 <h4>getRefEvaluatorForCurrentSheet</h4>
-<pre>public&nbsp;org.apache.poi.ss.formula.SheetRefEvaluator&nbsp;getRefEvaluatorForCurrentSheet()</pre>
+<pre>public&nbsp;org.apache.poi.ss.formula.SheetRangeEvaluator&nbsp;getRefEvaluatorForCurrentSheet()</pre>
 </li>
 </ul>
 <a name="getDynamicReference(java.lang.String, java.lang.String, java.lang.String, java.lang.String, boolean)">

Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/SheetIdentifier.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/SheetIdentifier.html?rev=1613470&r1=1613469&r2=1613470&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/formula/SheetIdentifier.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/formula/SheetIdentifier.html Fri Jul 25 16:47:10 2014
@@ -92,6 +92,10 @@
 <div class="description">
 <ul class="blockList">
 <li class="blockList">
+<dl>
+<dt>Direct Known Subclasses:</dt>
+<dd><a href="../../../../../org/apache/poi/ss/formula/SheetRangeIdentifier.html" title="class in org.apache.poi.ss.formula">SheetRangeIdentifier</a></dd>
+</dl>
 <hr>
 <br>
 <pre>public class <span class="strong">SheetIdentifier</span>
@@ -160,14 +164,18 @@ extends java.lang.Object</pre>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/formula/SheetIdentifier.html#asFormulaString()">asFormulaString</a></strong>()</code>&nbsp;</td>
 </tr>
 <tr class="rowColor">
+<td class="colFirst"><code>protected void</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/formula/SheetIdentifier.html#asFormulaString(java.lang.StringBuffer)">asFormulaString</a></strong>(java.lang.StringBuffer&nbsp;sb)</code>&nbsp;</td>
+</tr>
+<tr class="altColor">
 <td class="colFirst"><code>java.lang.String</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/formula/SheetIdentifier.html#getBookName()">getBookName</a></strong>()</code>&nbsp;</td>
 </tr>
-<tr class="altColor">
+<tr class="rowColor">
 <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/formula/NameIdentifier.html" title="class in org.apache.poi.ss.formula">NameIdentifier</a></code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/formula/SheetIdentifier.html#getSheetIdentifier()">getSheetIdentifier</a></strong>()</code>&nbsp;</td>
 </tr>
-<tr class="rowColor">
+<tr class="altColor">
 <td class="colFirst"><code>java.lang.String</code></td>
 <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/formula/SheetIdentifier.html#toString()">toString</a></strong>()</code>&nbsp;</td>
 </tr>
@@ -255,6 +263,15 @@ extends java.lang.Object</pre>
 <pre>public&nbsp;<a href="../../../../../org/apache/poi/ss/formula/NameIdentifier.html" title="class in org.apache.poi.ss.formula">NameIdentifier</a>&nbsp;getSheetIdentifier()</pre>
 </li>
 </ul>
+<a name="asFormulaString(java.lang.StringBuffer)">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>asFormulaString</h4>
+<pre>protected&nbsp;void&nbsp;asFormulaString(java.lang.StringBuffer&nbsp;sb)</pre>
+</li>
+</ul>
 <a name="asFormulaString()">
 <!--   -->
 </a>

Modified: poi/site/publish/apidocs/org/apache/poi/ss/formula/SheetNameFormatter.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/SheetNameFormatter.html?rev=1613470&r1=1613469&r2=1613470&view=diff
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/formula/SheetNameFormatter.html (original)
+++ poi/site/publish/apidocs/org/apache/poi/ss/formula/SheetNameFormatter.html Fri Jul 25 16:47:10 2014
@@ -35,7 +35,7 @@
 <div class="subNav">
 <ul class="navList">
 <li><a href="../../../../../org/apache/poi/ss/formula/SheetIdentifier.html" title="class in org.apache.poi.ss.formula"><span class="strong">Prev Class</span></a></li>
-<li><a href="../../../../../org/apache/poi/ss/formula/TwoDEval.html" title="interface in org.apache.poi.ss.formula"><span class="strong">Next Class</span></a></li>
+<li><a href="../../../../../org/apache/poi/ss/formula/SheetRange.html" title="interface in org.apache.poi.ss.formula"><span class="strong">Next Class</span></a></li>
 </ul>
 <ul class="navList">
 <li><a href="../../../../../index.html?org/apache/poi/ss/formula/SheetNameFormatter.html" target="_top">Frames</a></li>
@@ -221,7 +221,7 @@ extends java.lang.Object</pre>
 <div class="subNav">
 <ul class="navList">
 <li><a href="../../../../../org/apache/poi/ss/formula/SheetIdentifier.html" title="class in org.apache.poi.ss.formula"><span class="strong">Prev Class</span></a></li>
-<li><a href="../../../../../org/apache/poi/ss/formula/TwoDEval.html" title="interface in org.apache.poi.ss.formula"><span class="strong">Next Class</span></a></li>
+<li><a href="../../../../../org/apache/poi/ss/formula/SheetRange.html" title="interface in org.apache.poi.ss.formula"><span class="strong">Next Class</span></a></li>
 </ul>
 <ul class="navList">
 <li><a href="../../../../../index.html?org/apache/poi/ss/formula/SheetNameFormatter.html" target="_top">Frames</a></li>

Added: poi/site/publish/apidocs/org/apache/poi/ss/formula/SheetRange.html
URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/formula/SheetRange.html?rev=1613470&view=auto
==============================================================================
--- poi/site/publish/apidocs/org/apache/poi/ss/formula/SheetRange.html (added)
+++ poi/site/publish/apidocs/org/apache/poi/ss/formula/SheetRange.html Fri Jul 25 16:47:10 2014
@@ -0,0 +1,229 @@
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
+<!-- NewPage -->
+<html lang="en">
+<head>
+<title>SheetRange (POI API Documentation)</title>
+<link rel="stylesheet" type="text/css" href="../../../../../stylesheet.css" title="Style">
+</head>
+<body>
+<script type="text/javascript"><!--
+    if (location.href.indexOf('is-external=true') == -1) {
+        parent.document.title="SheetRange (POI API Documentation)";
+    }
+//-->
+</script>
+<noscript>
+<div>JavaScript is disabled on your browser.</div>
+</noscript>
+<!-- ========= START OF TOP NAVBAR ======= -->
+<div class="topNav"><a name="navbar_top">
+<!--   -->
+</a><a href="#skip-navbar_top" title="Skip navigation links"></a><a name="navbar_top_firstrow">
+<!--   -->
+</a>
+<ul class="navList" title="Navigation">
+<li><a href="../../../../../overview-summary.html">Overview</a></li>
+<li><a href="package-summary.html">Package</a></li>
+<li class="navBarCell1Rev">Class</li>
+<li><a href="class-use/SheetRange.html">Use</a></li>
+<li><a href="package-tree.html">Tree</a></li>
+<li><a href="../../../../../deprecated-list.html">Deprecated</a></li>
+<li><a href="../../../../../index-all.html">Index</a></li>
+<li><a href="../../../../../help-doc.html">Help</a></li>
+</ul>
+</div>
+<div class="subNav">
+<ul class="navList">
+<li><a href="../../../../../org/apache/poi/ss/formula/SheetNameFormatter.html" title="class in org.apache.poi.ss.formula"><span class="strong">Prev Class</span></a></li>
+<li><a href="../../../../../org/apache/poi/ss/formula/SheetRangeIdentifier.html" title="class in org.apache.poi.ss.formula"><span class="strong">Next Class</span></a></li>
+</ul>
+<ul class="navList">
+<li><a href="../../../../../index.html?org/apache/poi/ss/formula/SheetRange.html" target="_top">Frames</a></li>
+<li><a href="SheetRange.html" target="_top">No Frames</a></li>
+</ul>
+<ul class="navList" id="allclasses_navbar_top">
+<li><a href="../../../../../allclasses-noframe.html">All Classes</a></li>
+</ul>
+<div>
+<script type="text/javascript"><!--
+  allClassesLink = document.getElementById("allclasses_navbar_top");
+  if(window==top) {
+    allClassesLink.style.display = "block";
+  }
+  else {
+    allClassesLink.style.display = "none";
+  }
+  //-->
+</script>
+</div>
+<div>
+<ul class="subNavList">
+<li>Summary:&nbsp;</li>
+<li>Nested&nbsp;|&nbsp;</li>
+<li>Field&nbsp;|&nbsp;</li>
+<li>Constr&nbsp;|&nbsp;</li>
+<li><a href="#method_summary">Method</a></li>
+</ul>
+<ul class="subNavList">
+<li>Detail:&nbsp;</li>
+<li>Field&nbsp;|&nbsp;</li>
+<li>Constr&nbsp;|&nbsp;</li>
+<li><a href="#method_detail">Method</a></li>
+</ul>
+</div>
+<a name="skip-navbar_top">
+<!--   -->
+</a></div>
+<!-- ========= END OF TOP NAVBAR ========= -->
+<!-- ======== START OF CLASS DATA ======== -->
+<div class="header">
+<div class="subTitle">org.apache.poi.ss.formula</div>
+<h2 title="Interface SheetRange" class="title">Interface SheetRange</h2>
+</div>
+<div class="contentContainer">
+<div class="description">
+<ul class="blockList">
+<li class="blockList">
+<dl>
+<dt>All Known Subinterfaces:</dt>
+<dd><a href="../../../../../org/apache/poi/ss/formula/eval/AreaEval.html" title="interface in org.apache.poi.ss.formula.eval">AreaEval</a>, <a href="../../../../../org/apache/poi/ss/formula/eval/RefEval.html" title="interface in org.apache.poi.ss.formula.eval">RefEval</a>, <a href="../../../../../org/apache/poi/ss/formula/ThreeDEval.html" title="interface in org.apache.poi.ss.formula">ThreeDEval</a></dd>
+</dl>
+<dl>
+<dt>All Known Implementing Classes:</dt>
+<dd><a href="../../../../../org/apache/poi/ss/formula/eval/AreaEvalBase.html" title="class in org.apache.poi.ss.formula.eval">AreaEvalBase</a>, <a href="../../../../../org/apache/poi/ss/formula/eval/RefEvalBase.html" title="class in org.apache.poi.ss.formula.eval">RefEvalBase</a></dd>
+</dl>
+<hr>
+<br>
+<pre>public interface <span class="strong">SheetRange</span></pre>
+</li>
+</ul>
+</div>
+<div class="summary">
+<ul class="blockList">
+<li class="blockList">
+<!-- ========== METHOD SUMMARY =========== -->
+<ul class="blockList">
+<li class="blockList"><a name="method_summary">
+<!--   -->
+</a>
+<h3>Method Summary</h3>
+<table class="overviewSummary" border="0" cellpadding="3" cellspacing="0" summary="Method Summary table, listing methods, and an explanation">
+<caption><span>Methods</span><span class="tabEnd">&nbsp;</span></caption>
+<tr>
+<th class="colFirst" scope="col">Modifier and Type</th>
+<th class="colLast" scope="col">Method and Description</th>
+</tr>
+<tr class="altColor">
+<td class="colFirst"><code>int</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/formula/SheetRange.html#getFirstSheetIndex()">getFirstSheetIndex</a></strong>()</code>&nbsp;</td>
+</tr>
+<tr class="rowColor">
+<td class="colFirst"><code>int</code></td>
+<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/formula/SheetRange.html#getLastSheetIndex()">getLastSheetIndex</a></strong>()</code>&nbsp;</td>
+</tr>
+</table>
+</li>
+</ul>
+</li>
+</ul>
+</div>
+<div class="details">
+<ul class="blockList">
+<li class="blockList">
+<!-- ============ METHOD DETAIL ========== -->
+<ul class="blockList">
+<li class="blockList"><a name="method_detail">
+<!--   -->
+</a>
+<h3>Method Detail</h3>
+<a name="getFirstSheetIndex()">
+<!--   -->
+</a>
+<ul class="blockList">
+<li class="blockList">
+<h4>getFirstSheetIndex</h4>
+<pre>int&nbsp;getFirstSheetIndex()</pre>
+</li>
+</ul>
+<a name="getLastSheetIndex()">
+<!--   -->
+</a>
+<ul class="blockListLast">
+<li class="blockList">
+<h4>getLastSheetIndex</h4>
+<pre>int&nbsp;getLastSheetIndex()</pre>
+</li>
+</ul>
+</li>
+</ul>
+</li>
+</ul>
+</div>
+</div>
+<!-- ========= END OF CLASS DATA ========= -->
+<!-- ======= START OF BOTTOM NAVBAR ====== -->
+<div class="bottomNav"><a name="navbar_bottom">
+<!--   -->
+</a><a href="#skip-navbar_bottom" title="Skip navigation links"></a><a name="navbar_bottom_firstrow">
+<!--   -->
+</a>
+<ul class="navList" title="Navigation">
+<li><a href="../../../../../overview-summary.html">Overview</a></li>
+<li><a href="package-summary.html">Package</a></li>
+<li class="navBarCell1Rev">Class</li>
+<li><a href="class-use/SheetRange.html">Use</a></li>
+<li><a href="package-tree.html">Tree</a></li>
+<li><a href="../../../../../deprecated-list.html">Deprecated</a></li>
+<li><a href="../../../../../index-all.html">Index</a></li>
+<li><a href="../../../../../help-doc.html">Help</a></li>
+</ul>
+</div>
+<div class="subNav">
+<ul class="navList">
+<li><a href="../../../../../org/apache/poi/ss/formula/SheetNameFormatter.html" title="class in org.apache.poi.ss.formula"><span class="strong">Prev Class</span></a></li>
+<li><a href="../../../../../org/apache/poi/ss/formula/SheetRangeIdentifier.html" title="class in org.apache.poi.ss.formula"><span class="strong">Next Class</span></a></li>
+</ul>
+<ul class="navList">
+<li><a href="../../../../../index.html?org/apache/poi/ss/formula/SheetRange.html" target="_top">Frames</a></li>
+<li><a href="SheetRange.html" target="_top">No Frames</a></li>
+</ul>
+<ul class="navList" id="allclasses_navbar_bottom">
+<li><a href="../../../../../allclasses-noframe.html">All Classes</a></li>
+</ul>
+<div>
+<script type="text/javascript"><!--
+  allClassesLink = document.getElementById("allclasses_navbar_bottom");
+  if(window==top) {
+    allClassesLink.style.display = "block";
+  }
+  else {
+    allClassesLink.style.display = "none";
+  }
+  //-->
+</script>
+</div>
+<div>
+<ul class="subNavList">
+<li>Summary:&nbsp;</li>
+<li>Nested&nbsp;|&nbsp;</li>
+<li>Field&nbsp;|&nbsp;</li>
+<li>Constr&nbsp;|&nbsp;</li>
+<li><a href="#method_summary">Method</a></li>
+</ul>
+<ul class="subNavList">
+<li>Detail:&nbsp;</li>
+<li>Field&nbsp;|&nbsp;</li>
+<li>Constr&nbsp;|&nbsp;</li>
+<li><a href="#method_detail">Method</a></li>
+</ul>
+</div>
+<a name="skip-navbar_bottom">
+<!--   -->
+</a></div>
+<!-- ======== END OF BOTTOM NAVBAR ======= -->
+<p class="legalCopy"><small>
+                <i>Copyright 2014 The Apache Software Foundation or
+        its licensors, as applicable.</i>
+            </small></p>
+</body>
+</html>



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