Added: poi/site/publish/apidocs/org/apache/poi/ss/usermodel/ConditionType.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/usermodel/ConditionType.html?rev=1690972&view=auto ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/usermodel/ConditionType.html (added) +++ poi/site/publish/apidocs/org/apache/poi/ss/usermodel/ConditionType.html Tue Jul 14 15:11:48 2015 @@ -0,0 +1,409 @@ +<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd";> +<!-- NewPage --> +<html lang="en"> +<head> +<title>ConditionType (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="ConditionType (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/ConditionType.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/usermodel/ConditionalFormattingRule.html" title="interface in org.apache.poi.ss.usermodel"><span class="strong">Prev Class</span></a></li> +<li><a href="../../../../../org/apache/poi/ss/usermodel/CreationHelper.html" title="interface in org.apache.poi.ss.usermodel"><span class="strong">Next Class</span></a></li> +</ul> +<ul class="navList"> +<li><a href="../../../../../index.html?org/apache/poi/ss/usermodel/ConditionType.html" target="_top">Frames</a></li> +<li><a href="ConditionType.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: </li> +<li>Nested | </li> +<li><a href="#field_summary">Field</a> | </li> +<li>Constr | </li> +<li><a href="#method_summary">Method</a></li> +</ul> +<ul class="subNavList"> +<li>Detail: </li> +<li><a href="#field_detail">Field</a> | </li> +<li>Constr | </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.usermodel</div> +<h2 title="Class ConditionType" class="title">Class ConditionType</h2> +</div> +<div class="contentContainer"> +<ul class="inheritance"> +<li>java.lang.Object</li> +<li> +<ul class="inheritance"> +<li>org.apache.poi.ss.usermodel.ConditionType</li> +</ul> +</li> +</ul> +<div class="description"> +<ul class="blockList"> +<li class="blockList"> +<hr> +<br> +<pre>public class <span class="strong">ConditionType</span> +extends java.lang.Object</pre> +<div class="block">Represents a type of a conditional formatting rule</div> +</li> +</ul> +</div> +<div class="summary"> +<ul class="blockList"> +<li class="blockList"> +<!-- =========== FIELD SUMMARY =========== --> +<ul class="blockList"> +<li class="blockList"><a name="field_summary"> +<!-- --> +</a> +<h3>Field Summary</h3> +<table class="overviewSummary" border="0" cellpadding="3" cellspacing="0" summary="Field Summary table, listing fields, and an explanation"> +<caption><span>Fields</span><span class="tabEnd"> </span></caption> +<tr> +<th class="colFirst" scope="col">Modifier and Type</th> +<th class="colLast" scope="col">Field and Description</th> +</tr> +<tr class="altColor"> +<td class="colFirst"><code>static <a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">ConditionType</a></code></td> +<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html#CELL_VALUE_IS">CELL_VALUE_IS</a></strong></code> +<div class="block">This conditional formatting rule compares a cell value + to a formula calculated result, using an operator</div> +</td> +</tr> +<tr class="rowColor"> +<td class="colFirst"><code>static <a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">ConditionType</a></code></td> +<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html#COLOR_SCALE">COLOR_SCALE</a></strong></code> +<div class="block">This conditional formatting rule contains a color scale, + with the cell background set according to a gradient.</div> +</td> +</tr> +<tr class="altColor"> +<td class="colFirst"><code>static <a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">ConditionType</a></code></td> +<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html#DATA_BAR">DATA_BAR</a></strong></code> +<div class="block">This conditional formatting rule sets a data bar, with the + cell populated with bars based on their values</div> +</td> +</tr> +<tr class="rowColor"> +<td class="colFirst"><code>static <a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">ConditionType</a></code></td> +<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html#FILTER">FILTER</a></strong></code> +<div class="block">This conditional formatting rule that files the values</div> +</td> +</tr> +<tr class="altColor"> +<td class="colFirst"><code>static <a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">ConditionType</a></code></td> +<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html#FORMULA">FORMULA</a></strong></code> +<div class="block">This conditional formatting rule contains a formula to evaluate.</div> +</td> +</tr> +<tr class="rowColor"> +<td class="colFirst"><code>static <a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">ConditionType</a></code></td> +<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html#ICON_SET">ICON_SET</a></strong></code> +<div class="block">This conditional formatting rule sets a data bar, with the + cell populated with bars based on their values</div> +</td> +</tr> +<tr class="altColor"> +<td class="colFirst"><code>byte</code></td> +<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html#id">id</a></strong></code> </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/usermodel/ConditionType.html#type">type</a></strong></code> </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"> </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>static <a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">ConditionType</a></code></td> +<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html#forId(byte)">forId</a></strong>(byte id)</code> </td> +</tr> +<tr class="rowColor"> +<td class="colFirst"><code>static <a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">ConditionType</a></code></td> +<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html#forId(int)">forId</a></strong>(int id)</code> </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/usermodel/ConditionType.html#toString()">toString</a></strong>()</code> </td> +</tr> +</table> +<ul class="blockList"> +<li class="blockList"><a name="methods_inherited_from_class_java.lang.Object"> +<!-- --> +</a> +<h3>Methods inherited from class java.lang.Object</h3> +<code>clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait</code></li> +</ul> +</li> +</ul> +</li> +</ul> +</div> +<div class="details"> +<ul class="blockList"> +<li class="blockList"> +<!-- ============ FIELD DETAIL =========== --> +<ul class="blockList"> +<li class="blockList"><a name="field_detail"> +<!-- --> +</a> +<h3>Field Detail</h3> +<a name="CELL_VALUE_IS"> +<!-- --> +</a> +<ul class="blockList"> +<li class="blockList"> +<h4>CELL_VALUE_IS</h4> +<pre>public static final <a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">ConditionType</a> CELL_VALUE_IS</pre> +<div class="block">This conditional formatting rule compares a cell value + to a formula calculated result, using an operator</div> +</li> +</ul> +<a name="FORMULA"> +<!-- --> +</a> +<ul class="blockList"> +<li class="blockList"> +<h4>FORMULA</h4> +<pre>public static final <a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">ConditionType</a> FORMULA</pre> +<div class="block">This conditional formatting rule contains a formula to evaluate. + When the formula result is true, the cell is highlighted.</div> +</li> +</ul> +<a name="COLOR_SCALE"> +<!-- --> +</a> +<ul class="blockList"> +<li class="blockList"> +<h4>COLOR_SCALE</h4> +<pre>public static final <a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">ConditionType</a> COLOR_SCALE</pre> +<div class="block">This conditional formatting rule contains a color scale, + with the cell background set according to a gradient.</div> +</li> +</ul> +<a name="DATA_BAR"> +<!-- --> +</a> +<ul class="blockList"> +<li class="blockList"> +<h4>DATA_BAR</h4> +<pre>public static final <a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">ConditionType</a> DATA_BAR</pre> +<div class="block">This conditional formatting rule sets a data bar, with the + cell populated with bars based on their values</div> +</li> +</ul> +<a name="FILTER"> +<!-- --> +</a> +<ul class="blockList"> +<li class="blockList"> +<h4>FILTER</h4> +<pre>public static final <a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">ConditionType</a> FILTER</pre> +<div class="block">This conditional formatting rule that files the values</div> +</li> +</ul> +<a name="ICON_SET"> +<!-- --> +</a> +<ul class="blockList"> +<li class="blockList"> +<h4>ICON_SET</h4> +<pre>public static final <a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">ConditionType</a> ICON_SET</pre> +<div class="block">This conditional formatting rule sets a data bar, with the + cell populated with bars based on their values</div> +</li> +</ul> +<a name="id"> +<!-- --> +</a> +<ul class="blockList"> +<li class="blockList"> +<h4>id</h4> +<pre>public final byte id</pre> +</li> +</ul> +<a name="type"> +<!-- --> +</a> +<ul class="blockListLast"> +<li class="blockList"> +<h4>type</h4> +<pre>public final java.lang.String type</pre> +</li> +</ul> +</li> +</ul> +<!-- ============ METHOD DETAIL ========== --> +<ul class="blockList"> +<li class="blockList"><a name="method_detail"> +<!-- --> +</a> +<h3>Method Detail</h3> +<a name="toString()"> +<!-- --> +</a> +<ul class="blockList"> +<li class="blockList"> +<h4>toString</h4> +<pre>public java.lang.String toString()</pre> +<dl> +<dt><strong>Overrides:</strong></dt> +<dd><code>toString</code> in class <code>java.lang.Object</code></dd> +</dl> +</li> +</ul> +<a name="forId(byte)"> +<!-- --> +</a> +<ul class="blockList"> +<li class="blockList"> +<h4>forId</h4> +<pre>public static <a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">ConditionType</a> forId(byte id)</pre> +</li> +</ul> +<a name="forId(int)"> +<!-- --> +</a> +<ul class="blockListLast"> +<li class="blockList"> +<h4>forId</h4> +<pre>public static <a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">ConditionType</a> forId(int id)</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/ConditionType.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/usermodel/ConditionalFormattingRule.html" title="interface in org.apache.poi.ss.usermodel"><span class="strong">Prev Class</span></a></li> +<li><a href="../../../../../org/apache/poi/ss/usermodel/CreationHelper.html" title="interface in org.apache.poi.ss.usermodel"><span class="strong">Next Class</span></a></li> +</ul> +<ul class="navList"> +<li><a href="../../../../../index.html?org/apache/poi/ss/usermodel/ConditionType.html" target="_top">Frames</a></li> +<li><a href="ConditionType.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: </li> +<li>Nested | </li> +<li><a href="#field_summary">Field</a> | </li> +<li>Constr | </li> +<li><a href="#method_summary">Method</a></li> +</ul> +<ul class="subNavList"> +<li>Detail: </li> +<li><a href="#field_detail">Field</a> | </li> +<li>Constr | </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 2015 The Apache Software Foundation or + its licensors, as applicable.</i> + </small></p> +</body> +</html>
Modified: poi/site/publish/apidocs/org/apache/poi/ss/usermodel/ConditionalFormatting.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/usermodel/ConditionalFormatting.html?rev=1690972&r1=1690971&r2=1690972&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/usermodel/ConditionalFormatting.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/usermodel/ConditionalFormatting.html Tue Jul 14 15:11:48 2015 @@ -141,8 +141,6 @@ // Apply Conditional Formatting rule defined above to the regions sheet.addConditionalFormatting(regions, rule); </PRE></div> -<dl><dt><span class="strong">Author:</span></dt> - <dd>Dmitriy Kumshayev, Yegor Kozlov</dd></dl> </li> </ul> </div> @@ -220,9 +218,10 @@ <pre>void setRule(int idx, <a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormattingRule.html" title="interface in org.apache.poi.ss.usermodel">ConditionalFormattingRule</a> cfRule)</pre> <div class="block">Replaces an existing Conditional Formatting rule at position idx. - Excel allows to create up to 3 Conditional Formatting rules. + Excel pre-2007 allows to create up to 3 Conditional Formatting rules, + 2007 and later allow unlimited numbers. This method can be useful to modify existing Conditional Formatting rules.</div> -<dl><dt><span class="strong">Parameters:</span></dt><dd><code>idx</code> - position of the rule. Should be between 0 and 2.</dd><dd><code>cfRule</code> - - Conditional Formatting rule</dd></dl> +<dl><dt><span class="strong">Parameters:</span></dt><dd><code>idx</code> - position of the rule. Should be between 0 and 2 for Excel before 2007, otherwise 0+.</dd><dd><code>cfRule</code> - - Conditional Formatting rule</dd></dl> </li> </ul> <a name="addRule(org.apache.poi.ss.usermodel.ConditionalFormattingRule)"> @@ -233,7 +232,7 @@ <h4>addRule</h4> <pre>void addRule(<a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormattingRule.html" title="interface in org.apache.poi.ss.usermodel">ConditionalFormattingRule</a> cfRule)</pre> <div class="block">Add a Conditional Formatting rule. - Excel allows to create up to 3 Conditional Formatting rules.</div> + Excel pre-2007 allows to create up to 3 Conditional Formatting rules.</div> <dl><dt><span class="strong">Parameters:</span></dt><dd><code>cfRule</code> - - Conditional Formatting rule</dd></dl> </li> </ul> Modified: poi/site/publish/apidocs/org/apache/poi/ss/usermodel/ConditionalFormattingRule.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/usermodel/ConditionalFormattingRule.html?rev=1690972&r1=1690971&r2=1690972&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/usermodel/ConditionalFormattingRule.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/usermodel/ConditionalFormattingRule.html Tue Jul 14 15:11:48 2015 @@ -35,7 +35,7 @@ <div class="subNav"> <ul class="navList"> <li><a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormatting.html" title="interface in org.apache.poi.ss.usermodel"><span class="strong">Prev Class</span></a></li> -<li><a href="../../../../../org/apache/poi/ss/usermodel/CreationHelper.html" title="interface in org.apache.poi.ss.usermodel"><span class="strong">Next Class</span></a></li> +<li><a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel"><span class="strong">Next Class</span></a></li> </ul> <ul class="navList"> <li><a href="../../../../../index.html?org/apache/poi/ss/usermodel/ConditionalFormattingRule.html" target="_top">Frames</a></li> @@ -92,8 +92,6 @@ <br> <pre>public interface <span class="strong">ConditionalFormattingRule</span></pre> <div class="block">Represents a description of a conditional formatting rule</div> -<dl><dt><span class="strong">Author:</span></dt> - <dd>Dmitriy Kumshayev, Yegor Kozlov</dd></dl> </li> </ul> </div> @@ -115,14 +113,17 @@ <tr class="altColor"> <td class="colFirst"><code>static byte</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormattingRule.html#CONDITION_TYPE_CELL_VALUE_IS">CONDITION_TYPE_CELL_VALUE_IS</a></strong></code> -<div class="block">This conditional formatting rule compares a cell value - to a formula calculated result, using an operator</div> +<div class="block"><strong>Deprecated.</strong> +<div class="block"><i>Use <a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html#CELL_VALUE_IS"><code>ConditionType.CELL_VALUE_IS</code></a></i></div> +</div> </td> </tr> <tr class="rowColor"> <td class="colFirst"><code>static byte</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormattingRule.html#CONDITION_TYPE_FORMULA">CONDITION_TYPE_FORMULA</a></strong></code> -<div class="block">This conditional formatting rule contains a formula to evaluate.</div> +<div class="block"><strong>Deprecated.</strong> +<div class="block"><i>Use <a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html#FORMULA"><code>ConditionType.FORMULA</code></a></i></div> +</div> </td> </tr> </table> @@ -175,20 +176,28 @@ <tr class="rowColor"> <td class="colFirst"><code>byte</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormattingRule.html#getConditionType()">getConditionType</a></strong>()</code> -<div class="block">Type of conditional formatting rule.</div> +<div class="block"><strong>Deprecated.</strong> +<div class="block"><i>Use <a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormattingRule.html#getConditionTypeType()"><code>getConditionTypeType()</code></a></i></div> +</div> </td> </tr> <tr class="altColor"> +<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">ConditionType</a></code></td> +<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormattingRule.html#getConditionTypeType()">getConditionTypeType</a></strong>()</code> +<div class="block">Type of conditional formatting rule.</div> +</td> +</tr> +<tr class="rowColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/FontFormatting.html" title="interface in org.apache.poi.ss.usermodel">FontFormatting</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormattingRule.html#getFontFormatting()">getFontFormatting</a></strong>()</code> </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/usermodel/ConditionalFormattingRule.html#getFormula1()">getFormula1</a></strong>()</code> <div class="block">The formula used to evaluate the first operand for the conditional formatting rule.</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/ss/usermodel/ConditionalFormattingRule.html#getFormula2()">getFormula2</a></strong>()</code> <div class="block">The formula used to evaluate the second operand of the comparison when @@ -196,7 +205,7 @@ is either <a href="../../../../../org/apache/poi/ss/usermodel/ComparisonOperator.html#BETWEEN"><code>ComparisonOperator.BETWEEN</code></a> or <a href="../../../../../org/apache/poi/ss/usermodel/ComparisonOperator.html#NOT_BETWEEN"><code>ComparisonOperator.NOT_BETWEEN</code></a></div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/PatternFormatting.html" title="interface in org.apache.poi.ss.usermodel">PatternFormatting</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormattingRule.html#getPatternFormatting()">getPatternFormatting</a></strong>()</code> </td> </tr> @@ -222,9 +231,9 @@ <li class="blockList"> <h4>CONDITION_TYPE_CELL_VALUE_IS</h4> <pre>static final byte CONDITION_TYPE_CELL_VALUE_IS</pre> +<div class="block"><span class="strong">Deprecated.</span> <i>Use <a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html#CELL_VALUE_IS"><code>ConditionType.CELL_VALUE_IS</code></a></i></div> <div class="block">This conditional formatting rule compares a cell value to a formula calculated result, using an operator</div> -<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.ConditionalFormattingRule.CONDITION_TYPE_CELL_VALUE_IS">Constant Field Values</a></dd></dl> </li> </ul> <a name="CONDITION_TYPE_FORMULA"> @@ -234,9 +243,9 @@ <li class="blockList"> <h4>CONDITION_TYPE_FORMULA</h4> <pre>static final byte CONDITION_TYPE_FORMULA</pre> +<div class="block"><span class="strong">Deprecated.</span> <i>Use <a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html#FORMULA"><code>ConditionType.FORMULA</code></a></i></div> <div class="block">This conditional formatting rule contains a formula to evaluate. When the formula result is true, the cell is highlighted.</div> -<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.ConditionalFormattingRule.CONDITION_TYPE_FORMULA">Constant Field Values</a></dd></dl> </li> </ul> </li> @@ -320,13 +329,25 @@ <li class="blockList"> <h4>getConditionType</h4> <pre>byte getConditionType()</pre> +<div class="block"><span class="strong">Deprecated.</span> <i>Use <a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormattingRule.html#getConditionTypeType()"><code>getConditionTypeType()</code></a></i></div> <div class="block">Type of conditional formatting rule. <p> - MUST be either <a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormattingRule.html#CONDITION_TYPE_CELL_VALUE_IS"><code>CONDITION_TYPE_CELL_VALUE_IS</code></a> or <a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormattingRule.html#CONDITION_TYPE_FORMULA"><code>CONDITION_TYPE_FORMULA</code></a> + MUST be one of the IDs of a <a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel"><code>ConditionType</code></a> </p></div> <dl><dt><span class="strong">Returns:</span></dt><dd>the type of condition</dd></dl> </li> </ul> +<a name="getConditionTypeType()"> +<!-- --> +</a> +<ul class="blockList"> +<li class="blockList"> +<h4>getConditionTypeType</h4> +<pre><a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">ConditionType</a> getConditionTypeType()</pre> +<div class="block">Type of conditional formatting rule.</div> +<dl><dt><span class="strong">Returns:</span></dt><dd>the type of condition</dd></dl> +</li> +</ul> <a name="getComparisonOperation()"> <!-- --> </a> @@ -402,7 +423,7 @@ <div class="subNav"> <ul class="navList"> <li><a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormatting.html" title="interface in org.apache.poi.ss.usermodel"><span class="strong">Prev Class</span></a></li> -<li><a href="../../../../../org/apache/poi/ss/usermodel/CreationHelper.html" title="interface in org.apache.poi.ss.usermodel"><span class="strong">Next Class</span></a></li> +<li><a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel"><span class="strong">Next Class</span></a></li> </ul> <ul class="navList"> <li><a href="../../../../../index.html?org/apache/poi/ss/usermodel/ConditionalFormattingRule.html" target="_top">Frames</a></li> Modified: poi/site/publish/apidocs/org/apache/poi/ss/usermodel/CreationHelper.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/usermodel/CreationHelper.html?rev=1690972&r1=1690971&r2=1690972&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/usermodel/CreationHelper.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/usermodel/CreationHelper.html Tue Jul 14 15:11:48 2015 @@ -34,7 +34,7 @@ </div> <div class="subNav"> <ul class="navList"> -<li><a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormattingRule.html" title="interface in org.apache.poi.ss.usermodel"><span class="strong">Prev Class</span></a></li> +<li><a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel"><span class="strong">Prev Class</span></a></li> <li><a href="../../../../../org/apache/poi/ss/usermodel/DataConsolidateFunction.html" title="enum in org.apache.poi.ss.usermodel"><span class="strong">Next Class</span></a></li> </ul> <ul class="navList"> @@ -239,7 +239,7 @@ </div> <div class="subNav"> <ul class="navList"> -<li><a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormattingRule.html" title="interface in org.apache.poi.ss.usermodel"><span class="strong">Prev Class</span></a></li> +<li><a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel"><span class="strong">Prev Class</span></a></li> <li><a href="../../../../../org/apache/poi/ss/usermodel/DataConsolidateFunction.html" title="enum in org.apache.poi.ss.usermodel"><span class="strong">Next Class</span></a></li> </ul> <ul class="navList"> Modified: poi/site/publish/apidocs/org/apache/poi/ss/usermodel/Sheet.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/usermodel/Sheet.html?rev=1690972&r1=1690971&r2=1690972&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/usermodel/Sheet.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/usermodel/Sheet.html Tue Jul 14 15:11:48 2015 @@ -385,430 +385,436 @@ extends java.lang.Iterable<<a href=". </td> </tr> <tr class="altColor"> +<td class="colFirst"><code>java.util.List<<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>></code></td> +<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getMergedRegions()">getMergedRegions</a></strong>()</code> +<div class="block">Returns the list of merged regions.</div> +</td> +</tr> +<tr class="rowColor"> <td class="colFirst"><code>int</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getNumMergedRegions()">getNumMergedRegions</a></strong>()</code> <div class="block">Returns the number of merged regions</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/hssf/util/PaneInformation.html" title="class in org.apache.poi.hssf.util">PaneInformation</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getPaneInformation()">getPaneInformation</a></strong>()</code> <div class="block">Returns the information regarding the currently configured pane (split or freeze)</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/ss/usermodel/Sheet.html#getPhysicalNumberOfRows()">getPhysicalNumberOfRows</a></strong>()</code> <div class="block">Returns the number of physically defined rows (NOT the number of rows in the sheet)</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/PrintSetup.html" title="interface in org.apache.poi.ss.usermodel">PrintSetup</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getPrintSetup()">getPrintSetup</a></strong>()</code> <div class="block">Gets the print setup object.</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/ss/usermodel/Sheet.html#getProtect()">getProtect</a></strong>()</code> <div class="block">Answer whether protection is enabled or disabled</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getRepeatingColumns()">getRepeatingColumns</a></strong>()</code> <div class="block">Gets the repeating columns used when printing the sheet, as found in File->PageSetup->Sheet.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getRepeatingRows()">getRepeatingRows</a></strong>()</code> <div class="block">Gets the repeating rows used when printing the sheet, as found in File->PageSetup->Sheet.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/Row.html" title="interface in org.apache.poi.ss.usermodel">Row</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getRow(int)">getRow</a></strong>(int rownum)</code> <div class="block">Returns the logical row (not physical) 0-based.</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/ss/usermodel/Sheet.html#getRowBreaks()">getRowBreaks</a></strong>()</code> <div class="block">Retrieves all the horizontal page breaks</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getRowSumsBelow()">getRowSumsBelow</a></strong>()</code> <div class="block">Flag indicating whether summary rows appear below detail in an outline, when applying an outline.</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/ss/usermodel/Sheet.html#getRowSumsRight()">getRowSumsRight</a></strong>()</code> <div class="block">Flag indicating whether summary columns appear to the right of detail in an outline, when applying an outline.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getScenarioProtect()">getScenarioProtect</a></strong>()</code> <div class="block">Answer whether scenario protection is enabled or disabled</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/SheetConditionalFormatting.html" title="interface in org.apache.poi.ss.usermodel">SheetConditionalFormatting</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getSheetConditionalFormatting()">getSheetConditionalFormatting</a></strong>()</code> <div class="block">The 'Conditional Formatting' facet for this <tt>Sheet</tt></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/ss/usermodel/Sheet.html#getSheetName()">getSheetName</a></strong>()</code> <div class="block">Returns the name of this sheet</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code>short</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getTopRow()">getTopRow</a></strong>()</code> <div class="block">The top row in the visible view when the sheet is first viewed after opening it in a viewer</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getVerticallyCenter()">getVerticallyCenter</a></strong>()</code> <div class="block">Determine whether printed output for this sheet will be vertically centered.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html" title="interface in org.apache.poi.ss.usermodel">Workbook</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getWorkbook()">getWorkbook</a></strong>()</code> <div class="block">Return the parent workbook</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/ss/usermodel/Sheet.html#groupColumn(int,%20int)">groupColumn</a></strong>(int fromColumn, int toColumn)</code> <div class="block">Create an outline for the provided column range.</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/ss/usermodel/Sheet.html#groupRow(int,%20int)">groupRow</a></strong>(int fromRow, int toRow)</code> <div class="block">Tie a range of rows together so that they can be collapsed or expanded</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isColumnBroken(int)">isColumnBroken</a></strong>(int column)</code> <div class="block">Determines if there is a page break at the indicated column</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/ss/usermodel/Sheet.html#isColumnHidden(int)">isColumnHidden</a></strong>(int columnIndex)</code> <div class="block">Get the hidden state for a given column</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isDisplayFormulas()">isDisplayFormulas</a></strong>()</code> <div class="block">Returns if formulas are displayed</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/ss/usermodel/Sheet.html#isDisplayGridlines()">isDisplayGridlines</a></strong>()</code> <div class="block">Returns if gridlines are displayed</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isDisplayRowColHeadings()">isDisplayRowColHeadings</a></strong>()</code> <div class="block">Returns if RowColHeadings are displayed.</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/ss/usermodel/Sheet.html#isDisplayZeros()">isDisplayZeros</a></strong>()</code> <div class="block">Gets the flag indicating whether the window should show 0 (zero) in cells containing zero value.</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isPrintGridlines()">isPrintGridlines</a></strong>()</code> <div class="block">Gets the flag indicating whether this sheet displays the lines between rows and columns to make editing and reading easier.</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/ss/usermodel/Sheet.html#isRightToLeft()">isRightToLeft</a></strong>()</code> <div class="block">Whether the text is displayed in right-to-left mode in the window</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>boolean</code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isRowBroken(int)">isRowBroken</a></strong>(int row)</code> <div class="block">Determines if there is a page break at the indicated row</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/ss/usermodel/Sheet.html#isSelected()">isSelected</a></strong>()</code> <div class="block">Note - this is not the same as whether the sheet is focused (isActive)</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/ss/usermodel/Sheet.html#protectSheet(java.lang.String)">protectSheet</a></strong>(java.lang.String password)</code> <div class="block">Sets the protection enabled as well as the password</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/CellRange.html" title="interface in org.apache.poi.ss.usermodel">CellRange</a><? extends <a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a>></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#removeArrayFormula(org.apache.poi.ss.usermodel.Cell)">removeArrayFormula</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a> cell)</code> <div class="block">Remove a Array Formula from this sheet.</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/ss/usermodel/Sheet.html#removeColumnBreak(int)">removeColumnBreak</a></strong>(int column)</code> <div class="block">Removes a page break at the indicated column</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/ss/usermodel/Sheet.html#removeMergedRegion(int)">removeMergedRegion</a></strong>(int index)</code> <div class="block">Removes a merged region of cells (hence letting them free)</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/ss/usermodel/Sheet.html#removeRow(org.apache.poi.ss.usermodel.Row)">removeRow</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/Row.html" title="interface in org.apache.poi.ss.usermodel">Row</a> row)</code> <div class="block">Remove a row from this sheet.</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/ss/usermodel/Sheet.html#removeRowBreak(int)">removeRowBreak</a></strong>(int row)</code> <div class="block">Removes the page break at the indicated row</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><code>java.util.Iterator<<a href="../../../../../org/apache/poi/ss/usermodel/Row.html" title="interface in org.apache.poi.ss.usermodel">Row</a>></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#rowIterator()">rowIterator</a></strong>()</code> <div class="block">Returns an iterator of the physical rows</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/CellRange.html" title="interface in org.apache.poi.ss.usermodel">CellRange</a><? extends <a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a>></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setArrayFormula(java.lang.String,%20org.apache.poi.ss.util.CellRangeAddress)">setArrayFormula</a></strong>(java.lang.String formula, <a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> range)</code> <div class="block">Sets array formula to specified region for result.</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/ss/usermodel/Sheet.html#setAutobreaks(boolean)">setAutobreaks</a></strong>(boolean value)</code> <div class="block">Flag indicating whether the sheet displays Automatic Page Breaks.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/AutoFilter.html" title="interface in org.apache.poi.ss.usermodel">AutoFilter</a></code></td> <td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setAutoFilter(org.apache.poi.ss.util.CellRangeAddress)">setAutoFilter</a></strong>(<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> range)</code> <div class="block">Enable filtering for a range of cells</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/ss/usermodel/Sheet.html#setColumnBreak(int)">setColumnBreak</a></strong>(int column)</code> <div class="block">Sets a page break at the indicated column.</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/ss/usermodel/Sheet.html#setColumnGroupCollapsed(int,%20boolean)">setColumnGroupCollapsed</a></strong>(int columnNumber, boolean collapsed)</code> <div class="block">Expands or collapses a column group.</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/ss/usermodel/Sheet.html#setColumnHidden(int,%20boolean)">setColumnHidden</a></strong>(int columnIndex, boolean hidden)</code> <div class="block">Get the visibility state for a given column</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/ss/usermodel/Sheet.html#setColumnWidth(int,%20int)">setColumnWidth</a></strong>(int columnIndex, int width)</code> <div class="block">Set the width (in units of 1/256th of a character width)</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/ss/usermodel/Sheet.html#setDefaultColumnStyle(int,%20org.apache.poi.ss.usermodel.CellStyle)">setDefaultColumnStyle</a></strong>(int column, <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a> style)</code> <div class="block">Sets the default column style for a given column.</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/ss/usermodel/Sheet.html#setDefaultColumnWidth(int)">setDefaultColumnWidth</a></strong>(int width)</code> <div class="block">Set the default column width for the sheet (if the columns do not define their own width) in characters</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/ss/usermodel/Sheet.html#setDefaultRowHeight(short)">setDefaultRowHeight</a></strong>(short height)</code> <div class="block">Set the default row height for the sheet (if the rows do not define their own height) in twips (1/20 of a point)</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/ss/usermodel/Sheet.html#setDefaultRowHeightInPoints(float)">setDefaultRowHeightInPoints</a></strong>(float height)</code> <div class="block">Set the default row height for the sheet (if the rows do not define their own height) in points</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/ss/usermodel/Sheet.html#setDisplayFormulas(boolean)">setDisplayFormulas</a></strong>(boolean show)</code> <div class="block">Sets whether the formulas are shown in a viewer</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/ss/usermodel/Sheet.html#setDisplayGridlines(boolean)">setDisplayGridlines</a></strong>(boolean show)</code> <div class="block">Sets whether the gridlines are shown in a viewer</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/ss/usermodel/Sheet.html#setDisplayGuts(boolean)">setDisplayGuts</a></strong>(boolean value)</code> <div class="block">Set whether to display the guts or not</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/ss/usermodel/Sheet.html#setDisplayRowColHeadings(boolean)">setDisplayRowColHeadings</a></strong>(boolean show)</code> <div class="block">Sets whether the RowColHeadings are shown in a viewer</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/ss/usermodel/Sheet.html#setDisplayZeros(boolean)">setDisplayZeros</a></strong>(boolean value)</code> <div class="block">Set whether the window should show 0 (zero) in cells containing zero value.</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/ss/usermodel/Sheet.html#setFitToPage(boolean)">setFitToPage</a></strong>(boolean value)</code> <div class="block">Flag indicating whether the Fit to Page print option is enabled.</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/ss/usermodel/Sheet.html#setForceFormulaRecalculation(boolean)">setForceFormulaRecalculation</a></strong>(boolean value)</code> <div class="block">Control if Excel should be asked to recalculate all formulas on this sheet when the workbook is opened.</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/ss/usermodel/Sheet.html#setHorizontallyCenter(boolean)">setHorizontallyCenter</a></strong>(boolean value)</code> <div class="block">Determines whether the output is horizontally centered on the page.</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/ss/usermodel/Sheet.html#setMargin(short,%20double)">setMargin</a></strong>(short margin, double size)</code> <div class="block">Sets the size of the margin in inches.</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/ss/usermodel/Sheet.html#setPrintGridlines(boolean)">setPrintGridlines</a></strong>(boolean show)</code> <div class="block">Sets the flag indicating whether this sheet should display the lines between rows and columns to make editing and reading easier.</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/ss/usermodel/Sheet.html#setRepeatingColumns(org.apache.poi.ss.util.CellRangeAddress)">setRepeatingColumns</a></strong>(<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> columnRangeRef)</code> <div class="block">Sets the repeating columns used when printing the sheet, as found in File->PageSetup->Sheet.</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/ss/usermodel/Sheet.html#setRepeatingRows(org.apache.poi.ss.util.CellRangeAddress)">setRepeatingRows</a></strong>(<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a> rowRangeRef)</code> <div class="block">Sets the repeating rows used when printing the sheet, as found in File->PageSetup->Sheet.</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/ss/usermodel/Sheet.html#setRightToLeft(boolean)">setRightToLeft</a></strong>(boolean value)</code> <div class="block">Sets whether the worksheet is displayed from right to left instead of from left to right.</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/ss/usermodel/Sheet.html#setRowBreak(int)">setRowBreak</a></strong>(int row)</code> <div class="block">Sets a page break at the indicated row Breaks occur above the specified row and left of the specified column inclusive.</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/ss/usermodel/Sheet.html#setRowGroupCollapsed(int,%20boolean)">setRowGroupCollapsed</a></strong>(int row, boolean collapse)</code> <div class="block">Set view state of a groupped range of rows</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/ss/usermodel/Sheet.html#setRowSumsBelow(boolean)">setRowSumsBelow</a></strong>(boolean value)</code> <div class="block">Flag indicating whether summary rows appear below detail in an outline, when applying an outline.</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/ss/usermodel/Sheet.html#setRowSumsRight(boolean)">setRowSumsRight</a></strong>(boolean value)</code> <div class="block">Flag indicating whether summary columns appear to the right of detail in an outline, when applying an outline.</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/ss/usermodel/Sheet.html#setSelected(boolean)">setSelected</a></strong>(boolean value)</code> <div class="block">Sets a flag indicating whether this sheet is selected.</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/ss/usermodel/Sheet.html#setVerticallyCenter(boolean)">setVerticallyCenter</a></strong>(boolean value)</code> <div class="block">Determines whether the output is vertically centered on the page.</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/ss/usermodel/Sheet.html#setZoom(int,%20int)">setZoom</a></strong>(int numerator, int denominator)</code> <div class="block">Sets the zoom magnication for the sheet.</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/ss/usermodel/Sheet.html#shiftRows(int,%20int,%20int)">shiftRows</a></strong>(int startRow, int endRow, @@ -816,7 +822,7 @@ extends java.lang.Iterable<<a href=". <div class="block">Shifts rows between startRow and endRow n number of rows.</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/ss/usermodel/Sheet.html#shiftRows(int,%20int,%20int,%20boolean,%20boolean)">shiftRows</a></strong>(int startRow, int endRow, @@ -826,7 +832,7 @@ extends java.lang.Iterable<<a href=". <div class="block">Shifts rows between startRow and endRow n number of rows.</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/ss/usermodel/Sheet.html#showInPane(int,%20int)">showInPane</a></strong>(int toprow, int leftcol)</code> @@ -834,7 +840,7 @@ extends java.lang.Iterable<<a href=". file is first opened in a viewer.</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/ss/usermodel/Sheet.html#showInPane(short,%20short)">showInPane</a></strong>(short toprow, short leftcol)</code> @@ -843,14 +849,14 @@ extends java.lang.Iterable<<a href=". </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/ss/usermodel/Sheet.html#ungroupColumn(int,%20int)">ungroupColumn</a></strong>(int fromColumn, int toColumn)</code> <div class="block">Ungroup a range of columns that were previously groupped</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/ss/usermodel/Sheet.html#ungroupRow(int,%20int)">ungroupRow</a></strong>(int fromRow, int toRow)</code> @@ -1360,6 +1366,17 @@ extends java.lang.Iterable<<a href=". <dl><dt><span class="strong">Returns:</span></dt><dd>the merged region at the specified index</dd></dl> </li> </ul> +<a name="getMergedRegions()"> +<!-- --> +</a> +<ul class="blockList"> +<li class="blockList"> +<h4>getMergedRegions</h4> +<pre>java.util.List<<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>> getMergedRegions()</pre> +<div class="block">Returns the list of merged regions.</div> +<dl><dt><span class="strong">Returns:</span></dt><dd>the list of merged regions</dd></dl> +</li> +</ul> <a name="rowIterator()"> <!-- --> </a> Modified: poi/site/publish/apidocs/org/apache/poi/ss/usermodel/SheetConditionalFormatting.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/usermodel/SheetConditionalFormatting.html?rev=1690972&r1=1690971&r2=1690972&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/usermodel/SheetConditionalFormatting.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/usermodel/SheetConditionalFormatting.html Tue Jul 14 15:11:48 2015 @@ -93,9 +93,7 @@ <pre>public interface <span class="strong">SheetConditionalFormatting</span></pre> <div class="block">The 'Conditional Formatting' facet of <tt>Sheet</tt></div> <dl><dt><span class="strong">Since:</span></dt> - <dd>3.8</dd> -<dt><span class="strong">Author:</span></dt> - <dd>Dmitriy Kumshayev, Yegor Kozlov</dd></dl> + <dd>3.8</dd></dl> </li> </ul> </div> @@ -232,7 +230,7 @@ <pre>int addConditionalFormatting(<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>[] regions, <a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormattingRule.html" title="interface in org.apache.poi.ss.usermodel">ConditionalFormattingRule</a>[] cfRules)</pre> <div class="block">Add a new Conditional Formatting set to the sheet.</div> -<dl><dt><span class="strong">Parameters:</span></dt><dd><code>regions</code> - - list of rectangular regions to apply conditional formatting rules</dd><dd><code>cfRules</code> - - set of up to three conditional formatting rules</dd> +<dl><dt><span class="strong">Parameters:</span></dt><dd><code>regions</code> - - list of rectangular regions to apply conditional formatting rules</dd><dd><code>cfRules</code> - - set of up to conditional formatting rules (max 3 for Excel pre-2007)</dd> <dt><span class="strong">Returns:</span></dt><dd>index of the newly created Conditional Formatting object</dd></dl> </li> </ul> @@ -270,7 +268,7 @@ <p> The created conditional formatting rule compares a cell value to a formula calculated result, using the specified operator. - The type of the created condition is <a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormattingRule.html#CONDITION_TYPE_CELL_VALUE_IS"><code>ConditionalFormattingRule.CONDITION_TYPE_CELL_VALUE_IS</code></a> + The type of the created condition is <code>ConditionalFormattingRule#CONDITION_CELL_VALUE_IS</code> </p></div> <dl><dt><span class="strong">Parameters:</span></dt><dd><code>comparisonOperation</code> - - MUST be a constant value from <tt><a href="../../../../../org/apache/poi/ss/usermodel/ComparisonOperator.html" title="class in org.apache.poi.ss.usermodel"><code>ComparisonOperator</code></a></tt>: <p> @@ -299,7 +297,7 @@ <div class="block">Create a conditional formatting rule that compares a cell value to a formula calculated result, using an operator * <p> - The type of the created condition is <a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormattingRule.html#CONDITION_TYPE_CELL_VALUE_IS"><code>ConditionalFormattingRule.CONDITION_TYPE_CELL_VALUE_IS</code></a> + The type of the created condition is <code>ConditionalFormattingRule#CONDITION_CELL_VALUE_IS</code> </p></div> <dl><dt><span class="strong">Parameters:</span></dt><dd><code>comparisonOperation</code> - MUST be a constant value from <tt><a href="../../../../../org/apache/poi/ss/usermodel/ComparisonOperator.html" title="class in org.apache.poi.ss.usermodel"><code>ComparisonOperator</code></a></tt> except BETWEEN and NOT_BETWEEN</dd><dd><code>formula</code> - the formula to determine if the conditional formatting is applied</dd></dl> @@ -316,7 +314,7 @@ When the formula result is true, the cell is highlighted. <p> - The type of the created format condition is <a href="../../../../../org/apache/poi/ss/usermodel/ConditionalFormattingRule.html#CONDITION_TYPE_FORMULA"><code>ConditionalFormattingRule.CONDITION_TYPE_FORMULA</code></a> + The type of the created format condition is <code>ConditionalFormattingRule#CONDITION_FORMULA</code> </p></div> <dl><dt><span class="strong">Parameters:</span></dt><dd><code>formula</code> - the formula to evaluate. MUST be a Boolean function.</dd></dl> </li> Added: poi/site/publish/apidocs/org/apache/poi/ss/usermodel/class-use/ConditionType.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/usermodel/class-use/ConditionType.html?rev=1690972&view=auto ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/usermodel/class-use/ConditionType.html (added) +++ poi/site/publish/apidocs/org/apache/poi/ss/usermodel/class-use/ConditionType.html Tue Jul 14 15:11:48 2015 @@ -0,0 +1,264 @@ +<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd";> +<!-- NewPage --> +<html lang="en"> +<head> +<title>Uses of Class org.apache.poi.ss.usermodel.ConditionType (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="Uses of Class org.apache.poi.ss.usermodel.ConditionType (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><a href="../../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">Class</a></li> +<li class="navBarCell1Rev">Use</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>Prev</li> +<li>Next</li> +</ul> +<ul class="navList"> +<li><a href="../../../../../../index.html?org/apache/poi/ss/usermodel/class-use/ConditionType.html" target="_top">Frames</a></li> +<li><a href="ConditionType.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> +<a name="skip-navbar_top"> +<!-- --> +</a></div> +<!-- ========= END OF TOP NAVBAR ========= --> +<div class="header"> +<h2 title="Uses of Class org.apache.poi.ss.usermodel.ConditionType" class="title">Uses of Class<br>org.apache.poi.ss.usermodel.ConditionType</h2> +</div> +<div class="classUseContainer"> +<ul class="blockList"> +<li class="blockList"> +<table border="0" cellpadding="3" cellspacing="0" summary="Use table, listing packages, and an explanation"> +<caption><span>Packages that use <a href="../../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">ConditionType</a></span><span class="tabEnd"> </span></caption> +<tr> +<th class="colFirst" scope="col">Package</th> +<th class="colLast" scope="col">Description</th> +</tr> +<tbody> +<tr class="altColor"> +<td class="colFirst"><a href="#org.apache.poi.hssf.usermodel">org.apache.poi.hssf.usermodel</a></td> +<td class="colLast"> +<div class="block">usermodel package maps HSSF low level strutures to familiar workbook/sheet model</div> +</td> +</tr> +<tr class="rowColor"> +<td class="colFirst"><a href="#org.apache.poi.ss.usermodel">org.apache.poi.ss.usermodel</a></td> +<td class="colLast"> </td> +</tr> +<tr class="altColor"> +<td class="colFirst"><a href="#org.apache.poi.xssf.usermodel">org.apache.poi.xssf.usermodel</a></td> +<td class="colLast"> </td> +</tr> +</tbody> +</table> +</li> +<li class="blockList"> +<ul class="blockList"> +<li class="blockList"><a name="org.apache.poi.hssf.usermodel"> +<!-- --> +</a> +<h3>Uses of <a href="../../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">ConditionType</a> in <a href="../../../../../../org/apache/poi/hssf/usermodel/package-summary.html">org.apache.poi.hssf.usermodel</a></h3> +<table border="0" cellpadding="3" cellspacing="0" summary="Use table, listing methods, and an explanation"> +<caption><span>Methods in <a href="../../../../../../org/apache/poi/hssf/usermodel/package-summary.html">org.apache.poi.hssf.usermodel</a> that return <a href="../../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">ConditionType</a></span><span class="tabEnd"> </span></caption> +<tr> +<th class="colFirst" scope="col">Modifier and Type</th> +<th class="colLast" scope="col">Method and Description</th> +</tr> +<tbody> +<tr class="altColor"> +<td class="colFirst"><code><a href="../../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">ConditionType</a></code></td> +<td class="colLast"><span class="strong">HSSFConditionalFormattingRule.</span><code><strong><a href="../../../../../../org/apache/poi/hssf/usermodel/HSSFConditionalFormattingRule.html#getConditionTypeType()">getConditionTypeType</a></strong>()</code> </td> +</tr> +</tbody> +</table> +</li> +<li class="blockList"><a name="org.apache.poi.ss.usermodel"> +<!-- --> +</a> +<h3>Uses of <a href="../../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">ConditionType</a> in <a href="../../../../../../org/apache/poi/ss/usermodel/package-summary.html">org.apache.poi.ss.usermodel</a></h3> +<table border="0" cellpadding="3" cellspacing="0" summary="Use table, listing fields, and an explanation"> +<caption><span>Fields in <a href="../../../../../../org/apache/poi/ss/usermodel/package-summary.html">org.apache.poi.ss.usermodel</a> declared as <a href="../../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">ConditionType</a></span><span class="tabEnd"> </span></caption> +<tr> +<th class="colFirst" scope="col">Modifier and Type</th> +<th class="colLast" scope="col">Field and Description</th> +</tr> +<tbody> +<tr class="altColor"> +<td class="colFirst"><code>static <a href="../../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">ConditionType</a></code></td> +<td class="colLast"><span class="strong">ConditionType.</span><code><strong><a href="../../../../../../org/apache/poi/ss/usermodel/ConditionType.html#CELL_VALUE_IS">CELL_VALUE_IS</a></strong></code> +<div class="block">This conditional formatting rule compares a cell value + to a formula calculated result, using an operator</div> +</td> +</tr> +<tr class="rowColor"> +<td class="colFirst"><code>static <a href="../../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">ConditionType</a></code></td> +<td class="colLast"><span class="strong">ConditionType.</span><code><strong><a href="../../../../../../org/apache/poi/ss/usermodel/ConditionType.html#COLOR_SCALE">COLOR_SCALE</a></strong></code> +<div class="block">This conditional formatting rule contains a color scale, + with the cell background set according to a gradient.</div> +</td> +</tr> +<tr class="altColor"> +<td class="colFirst"><code>static <a href="../../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">ConditionType</a></code></td> +<td class="colLast"><span class="strong">ConditionType.</span><code><strong><a href="../../../../../../org/apache/poi/ss/usermodel/ConditionType.html#DATA_BAR">DATA_BAR</a></strong></code> +<div class="block">This conditional formatting rule sets a data bar, with the + cell populated with bars based on their values</div> +</td> +</tr> +<tr class="rowColor"> +<td class="colFirst"><code>static <a href="../../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">ConditionType</a></code></td> +<td class="colLast"><span class="strong">ConditionType.</span><code><strong><a href="../../../../../../org/apache/poi/ss/usermodel/ConditionType.html#FILTER">FILTER</a></strong></code> +<div class="block">This conditional formatting rule that files the values</div> +</td> +</tr> +<tr class="altColor"> +<td class="colFirst"><code>static <a href="../../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">ConditionType</a></code></td> +<td class="colLast"><span class="strong">ConditionType.</span><code><strong><a href="../../../../../../org/apache/poi/ss/usermodel/ConditionType.html#FORMULA">FORMULA</a></strong></code> +<div class="block">This conditional formatting rule contains a formula to evaluate.</div> +</td> +</tr> +<tr class="rowColor"> +<td class="colFirst"><code>static <a href="../../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">ConditionType</a></code></td> +<td class="colLast"><span class="strong">ConditionType.</span><code><strong><a href="../../../../../../org/apache/poi/ss/usermodel/ConditionType.html#ICON_SET">ICON_SET</a></strong></code> +<div class="block">This conditional formatting rule sets a data bar, with the + cell populated with bars based on their values</div> +</td> +</tr> +</tbody> +</table> +<table border="0" cellpadding="3" cellspacing="0" summary="Use table, listing methods, and an explanation"> +<caption><span>Methods in <a href="../../../../../../org/apache/poi/ss/usermodel/package-summary.html">org.apache.poi.ss.usermodel</a> that return <a href="../../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">ConditionType</a></span><span class="tabEnd"> </span></caption> +<tr> +<th class="colFirst" scope="col">Modifier and Type</th> +<th class="colLast" scope="col">Method and Description</th> +</tr> +<tbody> +<tr class="altColor"> +<td class="colFirst"><code>static <a href="../../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">ConditionType</a></code></td> +<td class="colLast"><span class="strong">ConditionType.</span><code><strong><a href="../../../../../../org/apache/poi/ss/usermodel/ConditionType.html#forId(byte)">forId</a></strong>(byte id)</code> </td> +</tr> +<tr class="rowColor"> +<td class="colFirst"><code>static <a href="../../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">ConditionType</a></code></td> +<td class="colLast"><span class="strong">ConditionType.</span><code><strong><a href="../../../../../../org/apache/poi/ss/usermodel/ConditionType.html#forId(int)">forId</a></strong>(int id)</code> </td> +</tr> +<tr class="altColor"> +<td class="colFirst"><code><a href="../../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">ConditionType</a></code></td> +<td class="colLast"><span class="strong">ConditionalFormattingRule.</span><code><strong><a href="../../../../../../org/apache/poi/ss/usermodel/ConditionalFormattingRule.html#getConditionTypeType()">getConditionTypeType</a></strong>()</code> +<div class="block">Type of conditional formatting rule.</div> +</td> +</tr> +</tbody> +</table> +</li> +<li class="blockList"><a name="org.apache.poi.xssf.usermodel"> +<!-- --> +</a> +<h3>Uses of <a href="../../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">ConditionType</a> in <a href="../../../../../../org/apache/poi/xssf/usermodel/package-summary.html">org.apache.poi.xssf.usermodel</a></h3> +<table border="0" cellpadding="3" cellspacing="0" summary="Use table, listing methods, and an explanation"> +<caption><span>Methods in <a href="../../../../../../org/apache/poi/xssf/usermodel/package-summary.html">org.apache.poi.xssf.usermodel</a> that return <a href="../../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">ConditionType</a></span><span class="tabEnd"> </span></caption> +<tr> +<th class="colFirst" scope="col">Modifier and Type</th> +<th class="colLast" scope="col">Method and Description</th> +</tr> +<tbody> +<tr class="altColor"> +<td class="colFirst"><code><a href="../../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">ConditionType</a></code></td> +<td class="colLast"><span class="strong">XSSFConditionalFormattingRule.</span><code><strong><a href="../../../../../../org/apache/poi/xssf/usermodel/XSSFConditionalFormattingRule.html#getConditionTypeType()">getConditionTypeType</a></strong>()</code> +<div class="block">Type of conditional formatting rule.</div> +</td> +</tr> +</tbody> +</table> +</li> +</ul> +</li> +</ul> +</div> +<!-- ======= 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><a href="../../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">Class</a></li> +<li class="navBarCell1Rev">Use</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>Prev</li> +<li>Next</li> +</ul> +<ul class="navList"> +<li><a href="../../../../../../index.html?org/apache/poi/ss/usermodel/class-use/ConditionType.html" target="_top">Frames</a></li> +<li><a href="ConditionType.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> +<a name="skip-navbar_bottom"> +<!-- --> +</a></div> +<!-- ======== END OF BOTTOM NAVBAR ======= --> +<p class="legalCopy"><small> + <i>Copyright 2015 The Apache Software Foundation or + its licensors, as applicable.</i> + </small></p> +</body> +</html> Modified: poi/site/publish/apidocs/org/apache/poi/ss/usermodel/class-use/ConditionalFormattingRule.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/usermodel/class-use/ConditionalFormattingRule.html?rev=1690972&r1=1690971&r2=1690972&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/usermodel/class-use/ConditionalFormattingRule.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/usermodel/class-use/ConditionalFormattingRule.html Tue Jul 14 15:11:48 2015 @@ -244,7 +244,9 @@ <tbody> <tr class="altColor"> <td class="colFirst"><code>class </code></td> -<td class="colLast"><code><strong><a href="../../../../../../org/apache/poi/xssf/usermodel/XSSFConditionalFormattingRule.html" title="class in org.apache.poi.xssf.usermodel">XSSFConditionalFormattingRule</a></strong></code> </td> +<td class="colLast"><code><strong><a href="../../../../../../org/apache/poi/xssf/usermodel/XSSFConditionalFormattingRule.html" title="class in org.apache.poi.xssf.usermodel">XSSFConditionalFormattingRule</a></strong></code> +<div class="block">XSSF suport for Conditional Formatting rules</div> +</td> </tr> </tbody> </table> Modified: poi/site/publish/apidocs/org/apache/poi/ss/usermodel/package-frame.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/usermodel/package-frame.html?rev=1690972&r1=1690971&r2=1690972&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/usermodel/package-frame.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/usermodel/package-frame.html Tue Jul 14 15:11:48 2015 @@ -51,6 +51,7 @@ <li><a href="BuiltinFormats.html" title="class in org.apache.poi.ss.usermodel" target="classFrame">BuiltinFormats</a></li> <li><a href="CellValue.html" title="class in org.apache.poi.ss.usermodel" target="classFrame">CellValue</a></li> <li><a href="ComparisonOperator.html" title="class in org.apache.poi.ss.usermodel" target="classFrame">ComparisonOperator</a></li> +<li><a href="ConditionType.html" title="class in org.apache.poi.ss.usermodel" target="classFrame">ConditionType</a></li> <li><a href="DataFormatter.html" title="class in org.apache.poi.ss.usermodel" target="classFrame">DataFormatter</a></li> <li><a href="DataValidation.ErrorStyle.html" title="class in org.apache.poi.ss.usermodel" target="classFrame">DataValidation.ErrorStyle</a></li> <li><a href="DataValidationConstraint.OperatorType.html" title="class in org.apache.poi.ss.usermodel" target="classFrame">DataValidationConstraint.OperatorType</a></li> Modified: poi/site/publish/apidocs/org/apache/poi/ss/usermodel/package-summary.html URL: http://svn.apache.org/viewvc/poi/site/publish/apidocs/org/apache/poi/ss/usermodel/package-summary.html?rev=1690972&r1=1690971&r2=1690972&view=diff ============================================================================== --- poi/site/publish/apidocs/org/apache/poi/ss/usermodel/package-summary.html (original) +++ poi/site/publish/apidocs/org/apache/poi/ss/usermodel/package-summary.html Tue Jul 14 15:11:48 2015 @@ -294,43 +294,49 @@ </td> </tr> <tr class="rowColor"> +<td class="colFirst"><a href="../../../../../org/apache/poi/ss/usermodel/ConditionType.html" title="class in org.apache.poi.ss.usermodel">ConditionType</a></td> +<td class="colLast"> +<div class="block">Represents a type of a conditional formatting rule</div> +</td> +</tr> +<tr class="altColor"> <td class="colFirst"><a href="../../../../../org/apache/poi/ss/usermodel/DataFormatter.html" title="class in org.apache.poi.ss.usermodel">DataFormatter</a></td> <td class="colLast"> <div class="block">DataFormatter contains methods for formatting the value stored in an Cell.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><a href="../../../../../org/apache/poi/ss/usermodel/DataValidation.ErrorStyle.html" title="class in org.apache.poi.ss.usermodel">DataValidation.ErrorStyle</a></td> <td class="colLast"> <div class="block">Error style constants for error box</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><a href="../../../../../org/apache/poi/ss/usermodel/DataValidationConstraint.OperatorType.html" title="class in org.apache.poi.ss.usermodel">DataValidationConstraint.OperatorType</a></td> <td class="colLast"> <div class="block">Condition operator enum</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><a href="../../../../../org/apache/poi/ss/usermodel/DataValidationConstraint.ValidationType.html" title="class in org.apache.poi.ss.usermodel">DataValidationConstraint.ValidationType</a></td> <td class="colLast"> <div class="block">ValidationType enum</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><a href="../../../../../org/apache/poi/ss/usermodel/DateUtil.html" title="class in org.apache.poi.ss.usermodel">DateUtil</a></td> <td class="colLast"> <div class="block">Contains methods for dealing with Excel dates.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><a href="../../../../../org/apache/poi/ss/usermodel/ErrorConstants.html" title="class in org.apache.poi.ss.usermodel">ErrorConstants</a></td> <td class="colLast">Deprecated <div class="block"><i>Use <a href="../../../../../org/apache/poi/ss/usermodel/FormulaError.html" title="enum in org.apache.poi.ss.usermodel"><code>FormulaError</code></a> instead where possible</i></div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><a href="../../../../../org/apache/poi/ss/usermodel/ExcelStyleDateFormatter.html" title="class in org.apache.poi.ss.usermodel">ExcelStyleDateFormatter</a></td> <td class="colLast"> <div class="block">A wrapper around a <code>SimpleDateFormat</code> instance, @@ -338,26 +344,26 @@ are not supported by <code>SimpleDateFormat</code>.</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><a href="../../../../../org/apache/poi/ss/usermodel/FractionFormat.html" title="class in org.apache.poi.ss.usermodel">FractionFormat</a></td> <td class="colLast"> <div class="block">Format class that handles Excel style fractions, such as "# #/#" and "#/###"</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><a href="../../../../../org/apache/poi/ss/usermodel/Row.MissingCellPolicy.html" title="class in org.apache.poi.ss.usermodel">Row.MissingCellPolicy</a></td> <td class="colLast"> <div class="block">Used to specify the different possible policies if for the case of null and blank cells</div> </td> </tr> -<tr class="altColor"> +<tr class="rowColor"> <td class="colFirst"><a href="../../../../../org/apache/poi/ss/usermodel/ShapeTypes.html" title="class in org.apache.poi.ss.usermodel">ShapeTypes</a></td> <td class="colLast"> <div class="block">All known types of automatic shapes in DrawingML</div> </td> </tr> -<tr class="rowColor"> +<tr class="altColor"> <td class="colFirst"><a href="../../../../../org/apache/poi/ss/usermodel/WorkbookFactory.html" title="class in org.apache.poi.ss.usermodel">WorkbookFactory</a></td> <td class="colLast"> <div class="block">Factory for creating the appropriate kind of Workbook --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
