<html> <head> <title>Interface XCellRangesQuery</title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <link rel="stylesheet" type="text/css" href="../../../../idl.css"> </head> <body> <div id="adc-idlref"> <a name="_top_"> </a><table class="navimain" border="0" cellpadding="3"> <tr> <td class="navimain"><a href="../module-ix.html" class="navimain">Overview</a></td> <td class="navimain"><a href="module-ix.html" class="navimain">Module</a></td> <td class="navimain"><a href="XCellRangesQuery-xref.html" class="navimain">Use</a></td> <td class="navimain"><a href="http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Querying_for_Cells_with_Specific_Properties" class="navimain">Devguide</a></td> <td class="navimain"><a href="../../../../index-files/index-1.html" class="navimain">Index</a></td> </tr> </table> <table class="navisub" border="0" cellpadding="0"> <tr> <td class="navisub"><a href="#MethodsSummary" class="navisub">Methods' Summary</a></td> <td class="navisub"><a href="#MethodsDetails" class="navisub">Methods' Details</a></td> <td class="navisub">Attributes' Summary</td> <td class="navisub">Attributes' Details</td> </tr> </table> <hr> <table border="0" width="100%" cellpadding="5" cellspacing="3" class="title-table" style="margin-bottom:6pt;"> <tr> <td><p class="namechain"><a href="../../../../module-ix.html" class="namechain">::</a> <a href="../../../module-ix.html" class="namechain">com</a> :: <a href="../../module-ix.html" class="namechain">sun</a> :: <a href="../module-ix.html" class="namechain">star</a> :: <a href="module-ix.html" class="namechain">sheet</a> :: </p> </td> </tr> <tr> <td class="title">interface XCellRangesQuery</td> </tr> <tr> <td/></tr> <tr> <td><dl> <dt><b>Description</b></dt> <dd>provides methods to query for cell ranges with specific contents. </dd> <dd><p>All methods return a collection of cell ranges.</p> </dd> <dt><b>See also</b></dt> <dd><a href="SheetRangesQuery.html">SheetRangesQuery</a>, <a href="SheetCellRanges.html">SheetCellRanges</a></dd> </dl> <a name="devmanual"> </a><dl> <dt><b>Developers Guide</b></dt> <dd><a href="http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Querying_for_Cells_with_Specific_Properties">Spreadsheets - Querying for Cells with Specific Properties</a></dd> </dl> </td> </tr> </table> <hr> <a name="MethodsSummary"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Methods' Summary</td> </tr> <tr> <td class="imsum_left"><a href="#queryVisibleCells">queryVisibleCells</a></td> <td class="imsum_right">queries all visible cells. </td> </tr> <tr> <td class="imsum_left"><a href="#queryEmptyCells">queryEmptyCells</a></td> <td class="imsum_right">queries all empty cells. </td> </tr> <tr> <td class="imsum_left"><a href="#queryContentCells">queryContentCells</a></td> <td class="imsum_right">queries all cells with the specified content type(s). </td> </tr> <tr> <td class="imsum_left"><a href="#queryFormulaCells">queryFormulaCells</a></td> <td class="imsum_right">queries all formula cells with the specified result type. </td> </tr> <tr> <td class="imsum_left"><a href="#queryColumnDifferences">queryColumnDifferences</a></td> <td class="imsum_right">queries all cells with different values in a specified row. </td> </tr> <tr> <td class="imsum_left"><a href="#queryRowDifferences">queryRowDifferences</a></td> <td class="imsum_right">queries all cells with different values in a specified column. </td> </tr> <tr> <td class="imsum_left"><a href="#queryIntersection">queryIntersection</a></td> <td class="imsum_right">intersects the current cell range(s) with the specified cell range. </td> </tr> </table> <a name="MethodsDetails"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle">Methods' Details</td> </tr> <tr> <td class="imdetail"><a name="queryVisibleCells" class="membertitle">queryVisibleCells</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-method" bgcolor="#ffffff" align="center"> <tr> <td><table class="table-in-method" border="0"> <tr> <td valign="top" colspan="3"><a href="XSheetCellRanges.html">XSheetCellRanges</a></td> </tr> <tr> <td valign="top"><b>queryVisibleCells</b>();</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>queries all visible cells. </dd> <dt><b>Returns</b></dt> <dd>the visible (not hidden) cells of the current cell range(s). </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="queryEmptyCells" class="membertitle">queryEmptyCells</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-method" bgcolor="#ffffff" align="center"> <tr> <td><table class="table-in-method" border="0"> <tr> <td valign="top" colspan="3"><a href="XSheetCellRanges.html">XSheetCellRanges</a></td> </tr> <tr> <td valign="top"><b>queryEmptyCells</b>();</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>queries all empty cells. </dd> <dt><b>Returns</b></dt> <dd>the empty cells of the current cell range(s). </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="queryContentCells" class="membertitle">queryContentCells</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-method" bgcolor="#ffffff" align="center"> <tr> <td><table class="table-in-method" border="0"> <tr> <td valign="top" colspan="3"><a href="XSheetCellRanges.html">XSheetCellRanges</a></td> </tr> <tr> <td valign="top"><b>queryContentCells</b>(</td> <td valign="top">[in] short</td> <td valign="bottom"> nContentFlags );</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>queries all cells with the specified content type(s). </dd> <dt><b>Parameter nContentFlags</b></dt> <dd>a combination of <a href="CellFlags.html">CellFlags</a> flags. <p>Attention: Despite the <a href="CellFlags.html">CellFlags</a> flags are <code>long</code> values, this method expects a <code>short</code> parameter. </dd> <dt><b>Returns</b></dt> <dd>all cells of the current cell range(s) with the specified content type(s). </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="queryFormulaCells" class="membertitle">queryFormulaCells</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-method" bgcolor="#ffffff" align="center"> <tr> <td><table class="table-in-method" border="0"> <tr> <td valign="top" colspan="3"><a href="XSheetCellRanges.html">XSheetCellRanges</a></td> </tr> <tr> <td valign="top"><b>queryFormulaCells</b>(</td> <td valign="top">[in] long</td> <td valign="bottom"> nResultFlags );</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>queries all formula cells with the specified result type. </dd> <dt><b>Parameter nResultFlags</b></dt> <dd>a combination of <a href="FormulaResult.html">FormulaResult</a> flags. </dd> <dt><b>Returns</b></dt> <dd>all formula cells of the current cell range(s) with the specified result type(s). </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="queryColumnDifferences" class="membertitle">queryColumnDifferences</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-method" bgcolor="#ffffff" align="center"> <tr> <td><table class="table-in-method" border="0"> <tr> <td valign="top" colspan="3"><a href="XSheetCellRanges.html">XSheetCellRanges</a></td> </tr> <tr> <td valign="top"><b>queryColumnDifferences</b>(</td> <td valign="top">[in] ::com::sun::star::<a href="../table/module-ix.html">table</a>::<a href="../table/CellAddress.html">CellAddress</a></td> <td valign="bottom"> aCompare );</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>queries all cells with different values in a specified row. </dd> <dd><p>This method takes each column of the current cell range(s) and compares all cells with the cell in the specified row. All cells which are different to this comparison cell will be returned.</p> </dd> <dt><b>Parameter aCompare</b></dt> <dd>contains a cell address with the row index used for comparison. Only this row index is of interest. </dd> <dt><b>Returns</b></dt> <dd>all cells of the current cell range(s) which are different to the comparison cell of each column. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="queryRowDifferences" class="membertitle">queryRowDifferences</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-method" bgcolor="#ffffff" align="center"> <tr> <td><table class="table-in-method" border="0"> <tr> <td valign="top" colspan="3"><a href="XSheetCellRanges.html">XSheetCellRanges</a></td> </tr> <tr> <td valign="top"><b>queryRowDifferences</b>(</td> <td valign="top">[in] ::com::sun::star::<a href="../table/module-ix.html">table</a>::<a href="../table/CellAddress.html">CellAddress</a></td> <td valign="bottom"> aCompare );</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>queries all cells with different values in a specified column. </dd> <dd><p>This method takes each row of the current cell range(s) and compares all cells with the cell in the specified column. All cells which are different to this comparison cell will be returned.</p> </dd> <dt><b>Parameter aCompare</b></dt> <dd>contains a cell address with the column index used for comparison. Only this column index is of interest. </dd> <dt><b>Returns</b></dt> <dd>all cells of the current cell range(s) which are different to the comparison cell of each row. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="queryIntersection" class="membertitle">queryIntersection</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-method" bgcolor="#ffffff" align="center"> <tr> <td><table class="table-in-method" border="0"> <tr> <td valign="top" colspan="3"><a href="XSheetCellRanges.html">XSheetCellRanges</a></td> </tr> <tr> <td valign="top"><b>queryIntersection</b>(</td> <td valign="top">[in] ::com::sun::star::<a href="../table/module-ix.html">table</a>::<a href="../table/CellRangeAddress.html">CellRangeAddress</a></td> <td valign="bottom"> aRange );</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>intersects the current cell range(s) with the specified cell range. </dd> <dt><b>Parameter aRange</b></dt> <dd>contains the cell range for intersection. </dd> <dt><b>Returns</b></dt> <dd>all cells of the current cell range(s) which are contained in the passed cell range. </dd> </dl> </td> </tr> </table> </td> </tr> </table> <a href="#_top_">Top of Page</a><hr size="3"><p class="copyright" align="center">Copyright © 2008 Sun Microsystems, Inc.</p> </div> <!-- id="adc-idlref" --> </body> </html>
distrib
>
Mandriva
>
2008.1
>
x86_64
>
media
>
main-testing
>
by-pkgid
>
2c50825dd66d0497b96a67f7fab2ee84
>
files
>
5826
