<html> <head> <title>Service SheetCellRange</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="SheetCellRange-xref.html" class="navimain">Use</a></td> <td class="navimain"><a href="#devmanual" 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="#ServicesSummary" class="navisub">Services' Summary</a></td> <td class="navisub"><a href="#InterfacesSummary" class="navisub">Interfaces' Summary</a></td> <td class="navisub"><a href="#PropertiesSummary" class="navisub">Properties' Summary</a></td> <td class="navisub"><a href="#ServicesDetails" class="navisub">Services' Details</a></td> <td class="navisub"><a href="#InterfacesDetails" class="navisub">Interfaces' Details</a></td> <td class="navisub"><a href="#PropertiesDetails" class="navisub">Properties' Details</a></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">service SheetCellRange</td> </tr> <tr> <td><dl> <dt><b>Description</b></dt> <dd>represents a rectangular range of cells in a spreadsheet document. </dd> <dd><p>This service is an extension of the CellRange service for use in spreadsheet documents.</p> </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/Spreadsheet_Services_-_Overview">Spreadsheets - Spreadsheet Services - Overview</a></dd> <dd><a href="http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Cell_Ranges">Spreadsheets - Cell Ranges</a></dd> <dd><a href="http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Cell_and_Cell_Range_Access">Spreadsheets - Cell and Cell Range Access</a></dd> </dl> </td> </tr> </table> <hr> <a name="ServicesSummary"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Included Services - Summary</td> </tr> <tr> <td class="imsum_left">::com::sun::star::<a href="../table/module-ix.html">table</a>::<a href="../table/CellRange.html">CellRange</a></td> <td class="imsum_right"><p>provides basic handling of cell ranges and contributes common cell formatting properties. </p> </td> </tr> <tr> <td class="imsum_left">::com::sun::star::<a href="../style/module-ix.html">style</a>::<a href="../style/CharacterProperties.html">CharacterProperties</a></td> <td class="imsum_right"><p>contributes properties for character formatting of Western text. </p> </td> </tr> <tr> <td class="imsum_left">::com::sun::star::<a href="../style/module-ix.html">style</a>::<a href="../style/CharacterPropertiesAsian.html">CharacterPropertiesAsian</a></td> <td class="imsum_right"><p>contributes properties for character formatting of Asian text. </p> </td> </tr> <tr> <td class="imsum_left">::com::sun::star::<a href="../style/module-ix.html">style</a>::<a href="../style/CharacterPropertiesComplex.html">CharacterPropertiesComplex</a></td> <td class="imsum_right"><p>contributes properties for character formatting of Complex text. </p> </td> </tr> <tr> <td class="imsum_left">::com::sun::star::<a href="../style/module-ix.html">style</a>::<a href="../style/ParagraphProperties.html">ParagraphProperties</a></td> <td class="imsum_right"><p>contributes properties for paragraph formatting. </p> </td> </tr> <tr> <td class="imsum_left"><a href="SheetRangesQuery.html">SheetRangesQuery</a></td> <td class="imsum_right"><p>provides interfaces to find cells with specific properties. </p> </td> </tr> </table> <a name="InterfacesSummary"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Exported Interfaces - Summary</td> </tr> <tr> <td class="imsum_left">::com::sun::star::<a href="../util/module-ix.html">util</a>::<a href="../util/XReplaceable.html">XReplaceable</a></td> <td class="imsum_right"><p>provides "Find & Replace" functionality. (<a href="#XReplaceable">details</a>)</p> </td> </tr> <tr> <td class="imsum_left">::com::sun::star::<a href="../util/module-ix.html">util</a>::<a href="../util/XMergeable.html">XMergeable</a></td> <td class="imsum_right"><p>provides merging and unmerging the cells of this cell range. </p> </td> </tr> <tr> <td class="imsum_left">::com::sun::star::<a href="../util/module-ix.html">util</a>::<a href="../util/XIndent.html">XIndent</a></td> <td class="imsum_right"><p>provides modifying the cell indentation. </p> </td> </tr> <tr> <td class="imsum_left">::com::sun::star::<a href="../table/module-ix.html">table</a>::<a href="../table/XColumnRowRange.html">XColumnRowRange</a></td> <td class="imsum_right"><p>provides access to the collections of columns and rows. </p> </td> </tr> <tr> <td class="imsum_left">::com::sun::star::<a href="../table/module-ix.html">table</a>::<a href="../table/XAutoFormattable.html">XAutoFormattable</a></td> <td class="imsum_right"><p>provides applying an AutoFormat to the cell range. </p> </td> </tr> <tr> <td class="imsum_left"><a href="XSheetCellRange.html">XSheetCellRange</a></td> <td class="imsum_right"><p>provides access to the spreadsheet that contains this cell range. </p> </td> </tr> <tr> <td class="imsum_left"><a href="XCellRangeData.html">XCellRangeData</a></td> <td class="imsum_right"><p>provides simultaneous access to the contents of all cells. </p> </td> </tr> <tr> <td class="imsum_left"><a href="XCellRangeFormula.html">XCellRangeFormula</a></td> <td class="imsum_right"><p>provides simultaneous access to the formula contents of all cells. (<a href="#XCellRangeFormula">details</a>)</p> </td> </tr> <tr> <td class="imsum_left"><a href="XCellRangeAddressable.html">XCellRangeAddressable</a></td> <td class="imsum_right"><p>provides access to the cell range address of this range. </p> </td> </tr> <tr> <td class="imsum_left"><a href="XSheetOperation.html">XSheetOperation</a></td> <td class="imsum_right"><p>provides computation of a value based on the contents of all cells of this range and to clear specific cells. </p> </td> </tr> <tr> <td class="imsum_left"><a href="XCellSeries.html">XCellSeries</a></td> <td class="imsum_right"><p>provides filling out the cell range automatically with values based on a start value, step count and fill mode. </p> </td> </tr> <tr> <td class="imsum_left"><a href="XArrayFormulaRange.html">XArrayFormulaRange</a></td> <td class="imsum_right"><p>provides handling of array formulas. </p> </td> </tr> <tr> <td class="imsum_left"><a href="XMultipleOperation.html">XMultipleOperation</a></td> <td class="imsum_right"><p>provides access to the Multiple Operations feature. </p> </td> </tr> <tr> <td class="imsum_left">::com::sun::star::<a href="../util/module-ix.html">util</a>::<a href="../util/XSortable.html">XSortable</a></td> <td class="imsum_right"><p>provides sorting functionality. </p> </td> </tr> <tr> <td class="imsum_left">::com::sun::star::<a href="../util/module-ix.html">util</a>::<a href="../util/XImportable.html">XImportable</a></td> <td class="imsum_right"><p>provides functionality to import data from external data sources. (<a href="#XImportable">details</a>)</p> </td> </tr> <tr> <td class="imsum_left"><a href="XSubTotalCalculatable.html">XSubTotalCalculatable</a></td> <td class="imsum_right"><p>provides calculating SubTotal values in this range. </p> </td> </tr> <tr> <td class="imsum_left"><a href="XSheetFilterableEx.html">XSheetFilterableEx</a></td> <td class="imsum_right"><p>provides filtering the contents of this range. </p> </td> </tr> <tr> <td class="imsum_left"><a href="XCellFormatRangesSupplier.html">XCellFormatRangesSupplier</a></td> <td class="imsum_right"><p>provide access to a collection of equal-formatted cell ranges. </p> </td> </tr> <tr> <td class="imsum_left"><a href="XUniqueCellFormatRangesSupplier.html">XUniqueCellFormatRangesSupplier</a></td> <td class="imsum_right"><p>provide access to a collection of equal-formatted cell ranges. </p> </td> </tr> <tr> <td class="imsum_left">::com::sun::star::<a href="../chart/module-ix.html">chart</a>::<a href="../chart/XChartDataArray.html">XChartDataArray</a></td> <td class="imsum_right"><p>provides modifying the source data cells of a chart and makes it possible to learn about changes in the cell values. </p> </td> </tr> <tr> <td class="imsum_left">::com::sun::star::<a href="../beans/module-ix.html">beans</a>::<a href="../beans/XTolerantMultiPropertySet.html">XTolerantMultiPropertySet</a></td> <td class="imsum_right"/></tr> <tr> <td class="imsum_left">::com::sun::star::<a href="../util/module-ix.html">util</a>::<a href="../util/XModifyBroadcaster.html">XModifyBroadcaster</a></td> <td class="imsum_right"/></tr> </table> <a name="PropertiesSummary"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Properties' Summary</td> </tr> <tr> <td class="imsum_left">[ readonly ] ::com::sun::star::<a href="../awt/module-ix.html">awt</a>::<a href="../awt/Point.html">Point</a><br> <a href="#Position">Position</a></td> <td class="imsum_right">contains the position of the top left cell of this range in the sheet (in 1/100 mm). </td> </tr> <tr> <td class="imsum_left">[ readonly ] ::com::sun::star::<a href="../awt/module-ix.html">awt</a>::<a href="../awt/Size.html">Size</a><br> <a href="#Size">Size</a></td> <td class="imsum_right">contains the size of this range (in 1/100 mm). </td> </tr> <tr> <td class="imsum_left"><a href="XSheetConditionalEntries.html">XSheetConditionalEntries</a><br> <a href="#ConditionalFormat">ConditionalFormat</a></td> <td class="imsum_right">contains the conditional formatting settings for this cell. </td> </tr> <tr> <td class="imsum_left"><a href="XSheetConditionalEntries.html">XSheetConditionalEntries</a><br> <a href="#ConditionalFormatLocal">ConditionalFormatLocal</a></td> <td class="imsum_right"><b>[ OPTIONAL ]<br> </b>contains the conditional formatting settings for this cell, using localized formulas. </td> </tr> <tr> <td class="imsum_left">::com::sun::star::<a href="../beans/module-ix.html">beans</a>::<a href="../beans/XPropertySet.html">XPropertySet</a><br> <a href="#Validation">Validation</a></td> <td class="imsum_right">contains the data validation settings for this cell. </td> </tr> <tr> <td class="imsum_left">::com::sun::star::<a href="../beans/module-ix.html">beans</a>::<a href="../beans/XPropertySet.html">XPropertySet</a><br> <a href="#ValidationLocal">ValidationLocal</a></td> <td class="imsum_right"><b>[ OPTIONAL ]<br> </b>contains the data validation settings for this cell, using localized formulas. </td> </tr> <tr> <td class="imsum_left">[ readonly ] string<br> <a href="#AbsoluteName">AbsoluteName</a></td> <td class="imsum_right"><b>[ OPTIONAL ]<br> </b>Returns the absolute address of the range as string, e.g. "$Sheet1.$B$2:$D$5". </td> </tr> </table> <a name="ServicesDetails"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Included Services - Details</td> </tr> <tr/> <tr> <td class="imdetail"><a name="CellRange" class="membertitle">::com::sun::star::<a href="../table/module-ix.html">table</a>::<a href="../table/CellRange.html">CellRange</a></a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><dl> <dt><b>Description</b></dt> <dd>provides basic handling of cell ranges and contributes common cell formatting properties. </dd> </dl> </td> </tr> </table> </td> </tr> <tr/> <tr> <td class="imdetail"><a name="CharacterProperties" class="membertitle">::com::sun::star::<a href="../style/module-ix.html">style</a>::<a href="../style/CharacterProperties.html">CharacterProperties</a></a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><dl> <dt><b>Description</b></dt> <dd>contributes properties for character formatting of Western text. </dd> </dl> </td> </tr> </table> </td> </tr> <tr/> <tr> <td class="imdetail"><a name="CharacterPropertiesAsian" class="membertitle">::com::sun::star::<a href="../style/module-ix.html">style</a>::<a href="../style/CharacterPropertiesAsian.html">CharacterPropertiesAsian</a></a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><dl> <dt><b>Description</b></dt> <dd>contributes properties for character formatting of Asian text. </dd> </dl> </td> </tr> </table> </td> </tr> <tr/> <tr> <td class="imdetail"><a name="CharacterPropertiesComplex" class="membertitle">::com::sun::star::<a href="../style/module-ix.html">style</a>::<a href="../style/CharacterPropertiesComplex.html">CharacterPropertiesComplex</a></a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><dl> <dt><b>Description</b></dt> <dd>contributes properties for character formatting of Complex text. </dd> </dl> </td> </tr> </table> </td> </tr> <tr/> <tr> <td class="imdetail"><a name="ParagraphProperties" class="membertitle">::com::sun::star::<a href="../style/module-ix.html">style</a>::<a href="../style/ParagraphProperties.html">ParagraphProperties</a></a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><dl> <dt><b>Description</b></dt> <dd>contributes properties for paragraph formatting. </dd> </dl> </td> </tr> </table> </td> </tr> <tr/> <tr> <td class="imdetail"><a name="SheetRangesQuery" class="membertitle"><a href="SheetRangesQuery.html">SheetRangesQuery</a></a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><dl> <dt><b>Description</b></dt> <dd>provides interfaces to find cells with specific properties. </dd> </dl> </td> </tr> </table> </td> </tr> </table> <a name="InterfacesDetails"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Exported Interfaces - Details</td> </tr> <tr/> <tr> <td class="imdetail"><a name="XReplaceable" class="membertitle">::com::sun::star::<a href="../util/module-ix.html">util</a>::<a href="../util/XReplaceable.html">XReplaceable</a></a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><dl> <dt><b>Description</b></dt> <dd>provides "Find & Replace" functionality. </dd> <dd><p>The property ::com::sun::star::<a href="../util/module-ix.html">util</a>::<a href="../util/SearchDescriptor.html">SearchDescriptor</a>::<a href="../util/SearchDescriptor.html#SearchWords">SearchWords</a> has a different meaning in spreadsheets: If set to <b>true</b>, the spreadsheet searches for cells containing the search text only.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr/> <tr> <td class="imdetail"><a name="XMergeable" class="membertitle">::com::sun::star::<a href="../util/module-ix.html">util</a>::<a href="../util/XMergeable.html">XMergeable</a></a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><dl> <dt><b>Description</b></dt> <dd>provides merging and unmerging the cells of this cell range. </dd> </dl> </td> </tr> </table> </td> </tr> <tr/> <tr> <td class="imdetail"><a name="XIndent" class="membertitle">::com::sun::star::<a href="../util/module-ix.html">util</a>::<a href="../util/XIndent.html">XIndent</a></a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><dl> <dt><b>Description</b></dt> <dd>provides modifying the cell indentation. </dd> </dl> </td> </tr> </table> </td> </tr> <tr/> <tr> <td class="imdetail"><a name="XColumnRowRange" class="membertitle">::com::sun::star::<a href="../table/module-ix.html">table</a>::<a href="../table/XColumnRowRange.html">XColumnRowRange</a></a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><dl> <dt><b>Description</b></dt> <dd>provides access to the collections of columns and rows. </dd> </dl> </td> </tr> </table> </td> </tr> <tr/> <tr> <td class="imdetail"><a name="XAutoFormattable" class="membertitle">::com::sun::star::<a href="../table/module-ix.html">table</a>::<a href="../table/XAutoFormattable.html">XAutoFormattable</a></a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><dl> <dt><b>Description</b></dt> <dd>provides applying an AutoFormat to the cell range. </dd> </dl> </td> </tr> </table> </td> </tr> <tr/> <tr> <td class="imdetail"><a name="XSheetCellRange" class="membertitle"><a href="XSheetCellRange.html">XSheetCellRange</a></a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><dl> <dt><b>Description</b></dt> <dd>provides access to the spreadsheet that contains this cell range. </dd> </dl> </td> </tr> </table> </td> </tr> <tr/> <tr> <td class="imdetail"><a name="XCellRangeData" class="membertitle"><a href="XCellRangeData.html">XCellRangeData</a></a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><dl> <dt><b>Description</b></dt> <dd>provides simultaneous access to the contents of all cells. </dd> </dl> </td> </tr> </table> </td> </tr> <tr/> <tr> <td class="imdetail"><a name="XCellRangeFormula" class="membertitle"><a href="XCellRangeFormula.html">XCellRangeFormula</a></a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><dl> <dt><b>Usage Restrictions</b></dt> <dd><i>optional</i></dd> <dt><b>Description</b></dt> <dd>provides simultaneous access to the formula contents of all cells. </dd> <dt><b>Since </b></dt> <dd>OOo 1.1.2 </dd> </dl> </td> </tr> </table> </td> </tr> <tr/> <tr> <td class="imdetail"><a name="XCellRangeAddressable" class="membertitle"><a href="XCellRangeAddressable.html">XCellRangeAddressable</a></a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><dl> <dt><b>Description</b></dt> <dd>provides access to the cell range address of this range. </dd> </dl> </td> </tr> </table> </td> </tr> <tr/> <tr> <td class="imdetail"><a name="XSheetOperation" class="membertitle"><a href="XSheetOperation.html">XSheetOperation</a></a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><dl> <dt><b>Description</b></dt> <dd>provides computation of a value based on the contents of all cells of this range and to clear specific cells. </dd> </dl> </td> </tr> </table> </td> </tr> <tr/> <tr> <td class="imdetail"><a name="XCellSeries" class="membertitle"><a href="XCellSeries.html">XCellSeries</a></a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><dl> <dt><b>Description</b></dt> <dd>provides filling out the cell range automatically with values based on a start value, step count and fill mode. </dd> </dl> </td> </tr> </table> </td> </tr> <tr/> <tr> <td class="imdetail"><a name="XArrayFormulaRange" class="membertitle"><a href="XArrayFormulaRange.html">XArrayFormulaRange</a></a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><dl> <dt><b>Description</b></dt> <dd>provides handling of array formulas. </dd> </dl> </td> </tr> </table> </td> </tr> <tr/> <tr> <td class="imdetail"><a name="XMultipleOperation" class="membertitle"><a href="XMultipleOperation.html">XMultipleOperation</a></a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><dl> <dt><b>Description</b></dt> <dd>provides access to the Multiple Operations feature. </dd> </dl> </td> </tr> </table> </td> </tr> <tr/> <tr> <td class="imdetail"><a name="XSortable" class="membertitle">::com::sun::star::<a href="../util/module-ix.html">util</a>::<a href="../util/XSortable.html">XSortable</a></a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><dl> <dt><b>Description</b></dt> <dd>provides sorting functionality. </dd> </dl> </td> </tr> </table> </td> </tr> <tr/> <tr> <td class="imdetail"><a name="XImportable" class="membertitle">::com::sun::star::<a href="../util/module-ix.html">util</a>::<a href="../util/XImportable.html">XImportable</a></a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><dl> <dt><b>Description</b></dt> <dd>provides functionality to import data from external data sources. </dd> <dt><b>See also</b></dt> <dd><a href="DatabaseImportDescriptor.html">DatabaseImportDescriptor</a></dd> </dl> </td> </tr> </table> </td> </tr> <tr/> <tr> <td class="imdetail"><a name="XSubTotalCalculatable" class="membertitle"><a href="XSubTotalCalculatable.html">XSubTotalCalculatable</a></a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><dl> <dt><b>Description</b></dt> <dd>provides calculating SubTotal values in this range. </dd> </dl> </td> </tr> </table> </td> </tr> <tr/> <tr> <td class="imdetail"><a name="XSheetFilterableEx" class="membertitle"><a href="XSheetFilterableEx.html">XSheetFilterableEx</a></a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><dl> <dt><b>Description</b></dt> <dd>provides filtering the contents of this range. </dd> </dl> </td> </tr> </table> </td> </tr> <tr/> <tr> <td class="imdetail"><a name="XCellFormatRangesSupplier" class="membertitle"><a href="XCellFormatRangesSupplier.html">XCellFormatRangesSupplier</a></a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><dl> <dt><b>Description</b></dt> <dd>provide access to a collection of equal-formatted cell ranges. </dd> </dl> </td> </tr> </table> </td> </tr> <tr/> <tr> <td class="imdetail"><a name="XUniqueCellFormatRangesSupplier" class="membertitle"><a href="XUniqueCellFormatRangesSupplier.html">XUniqueCellFormatRangesSupplier</a></a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><dl> <dt><b>Description</b></dt> <dd>provide access to a collection of equal-formatted cell ranges. </dd> </dl> </td> </tr> </table> </td> </tr> <tr/> <tr> <td class="imdetail"><a name="XChartDataArray" class="membertitle">::com::sun::star::<a href="../chart/module-ix.html">chart</a>::<a href="../chart/XChartDataArray.html">XChartDataArray</a></a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><dl> <dt><b>Description</b></dt> <dd>provides modifying the source data cells of a chart and makes it possible to learn about changes in the cell values. </dd> </dl> </td> </tr> </table> </td> </tr> <tr/> <tr> <td class="imdetail"><a name="XTolerantMultiPropertySet" class="membertitle">::com::sun::star::<a href="../beans/module-ix.html">beans</a>::<a href="../beans/XTolerantMultiPropertySet.html">XTolerantMultiPropertySet</a></a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><dl> <dt><b>Usage Restrictions</b></dt> <dd><i>optional</i></dd> </dl> </td> </tr> </table> </td> </tr> <tr/> <tr> <td class="imdetail"><a name="XModifyBroadcaster" class="membertitle">::com::sun::star::<a href="../util/module-ix.html">util</a>::<a href="../util/XModifyBroadcaster.html">XModifyBroadcaster</a></a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><dl> <dt><b>Usage Restrictions</b></dt> <dd><i>optional</i></dd> <dt><b>Since </b></dt> <dd>OOo 2.0 </dd> </dl> </td> </tr> </table> </td> </tr> </table> <a name="PropertiesDetails"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle">Properties' Details</td> </tr> <tr> <td class="imdetail"><a name="Position" class="membertitle">Position</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>[ readonly ] ::com::sun::star::<a href="../awt/module-ix.html">awt</a>::<a href="../awt/Point.html">Point</a> <b>Position</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>contains the position of the top left cell of this range in the sheet (in 1/100 mm). </dd> <dd><p>This property contains the absolute position in the whole sheet, not the position in the visible area.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="Size" class="membertitle">Size</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>[ readonly ] ::com::sun::star::<a href="../awt/module-ix.html">awt</a>::<a href="../awt/Size.html">Size</a> <b>Size</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>contains the size of this range (in 1/100 mm). </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="ConditionalFormat" class="membertitle">ConditionalFormat</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><a href="XSheetConditionalEntries.html">XSheetConditionalEntries</a> <b>ConditionalFormat</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>contains the conditional formatting settings for this cell. </dd> <dd><p>After a conditional format has been changed it has to be reinserted into the property set.</p> </dd> <dt><b>See also</b></dt> <dd><a href="TableConditionalFormat.html">TableConditionalFormat</a></dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="ConditionalFormatLocal" class="membertitle">ConditionalFormatLocal</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><a href="XSheetConditionalEntries.html">XSheetConditionalEntries</a> <b>ConditionalFormatLocal</b>;<hr> <dl> <dt><b>Usage Restrictions</b></dt> <dd><i>optional</i></dd> <dt><b>Description</b></dt> <dd>contains the conditional formatting settings for this cell, using localized formulas. </dd> <dd><p>After a conditional format has been changed it has to be reinserted into the property set.</p> </dd> <dt><b>See also</b></dt> <dd><a href="TableConditionalFormat.html">TableConditionalFormat</a></dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="Validation" class="membertitle">Validation</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>::com::sun::star::<a href="../beans/module-ix.html">beans</a>::<a href="../beans/XPropertySet.html">XPropertySet</a> <b>Validation</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>contains the data validation settings for this cell. </dd> <dd><p>After the data validation settings have been changed the validation has to be reinserted into the property set.</p> </dd> <dt><b>See also</b></dt> <dd><a href="TableValidation.html">TableValidation</a></dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="ValidationLocal" class="membertitle">ValidationLocal</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>::com::sun::star::<a href="../beans/module-ix.html">beans</a>::<a href="../beans/XPropertySet.html">XPropertySet</a> <b>ValidationLocal</b>;<hr> <dl> <dt><b>Usage Restrictions</b></dt> <dd><i>optional</i></dd> <dt><b>Description</b></dt> <dd>contains the data validation settings for this cell, using localized formulas. </dd> <dd><p>After the data validation settings have been changed the validation has to be reinserted into the property set.</p> </dd> <dt><b>See also</b></dt> <dd><a href="TableValidation.html">TableValidation</a></dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="AbsoluteName" class="membertitle">AbsoluteName</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>[ readonly ] string <b>AbsoluteName</b>;<hr> <dl> <dt><b>Usage Restrictions</b></dt> <dd><i>optional</i></dd> <dt><b>Description</b></dt> <dd>Returns the absolute address of the range as string, e.g. "$Sheet1.$B$2:$D$5". </dd> </dl> </td> </tr> </table> </td> </tr> </table> <br> <a href="#_top_">Top of Page</a><hr size="3"><p class="copyright" align="center">Copyright © 2000, 2012 LibreOffice contributors and/or their affiliates. All rights reserved.</p><p class="copyright" align="center">LibreOffice was created by The Document Foundation, based on OpenOffice.org, which is Copyright 2000, 2010 Oracle and/or its affiliates.</p><p class="copyright" align="center">The Document Foundation acknowledges all community members, please find more info <a href="http://www.libreoffice.org/about-us/credits/" target="_blank">at our website</a>.<p> </p><p class="copyright" align="center"><a href="http://www.libreoffice.org/privacy" target="_blank">Privacy Policy</a> | <a href="http://www.libreoffice.org/imprint" target="_blank">Impressum (Legal Info)</a> | Copyright information: The source code of LibreOffice is licensed under the GNU Lesser General Public License (<a href="http://www.libreoffice.org/download/license/" target="_blank">LGPLv3</a>). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our <a href="http://wiki.documentfoundation.org/TradeMark_Policy" target="_blank">trademark policy</a>.</p> </div> <!-- id="adc-idlref" --> </body> </html>
