<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 adress 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 serch 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>OpenOffice 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>OpenOffice 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 adress 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 © 2011, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.</p> </div> <!-- id="adc-idlref" --> </body> </html>
distrib
>
Mandriva
>
current
>
i586
>
media
>
main-updates
>
by-pkgid
>
fc480f9d5aabed8eeaffe8ad3401a94c
>
files
>
5958
