<html> <head> <title>Interface XCellSeries</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="XCellSeries-xref.html" class="navimain">Use</a></td> <td class="navimain"><a href="http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Fill_Series" 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">Attributes' Summary</td> <td class="navisub"><a href="#MethodsDetails" class="navisub">Methods' Details</a></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 XCellSeries</td> </tr> <tr> <td/></tr> <tr> <td><dl> <dt><b>Description</b></dt> <dd>provides methods to fill out a cell range automatically with values based on a start value, step count and fill mode. </dd> <dt><b>See also</b></dt> <dd><a href="SheetCellRange.html">SheetCellRange</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/Fill_Series">Spreadsheets - Fill Series</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="#fillSeries">fillSeries</a></td> <td class="imsum_right">fills all cells in the range based on the specified settings. </td> </tr> <tr> <td class="imsum_left"><a href="#fillAuto">fillAuto</a></td> <td class="imsum_right">fills all cells in the range in a way that is specified by the first cell(s) in the 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="fillSeries" class="membertitle">fillSeries</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">void</td> </tr> <tr> <td valign="top"><b>fillSeries</b>(</td> <td valign="top">[in] <a href="FillDirection.html">FillDirection</a></td> <td valign="bottom"> nFillDirection,</td> </tr> <tr> <td/><td valign="top">[in] <a href="FillMode.html">FillMode</a></td> <td valign="bottom"> nFillMode,</td> </tr> <tr> <td/><td valign="top">[in] <a href="FillDateMode.html">FillDateMode</a></td> <td valign="bottom"> nFillDateMode,</td> </tr> <tr> <td/><td valign="top">[in] double</td> <td valign="bottom"> fStep,</td> </tr> <tr> <td/><td valign="top">[in] double</td> <td valign="bottom"> fEndValue );</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>fills all cells in the range based on the specified settings. </dd> <dt><b>Parameter nFillDirection</b></dt> <dd>specifies the direction to fill the rows/columns of the range. </dd> <dt><b>Parameter nFillMode</b></dt> <dd>specifies the type of the series. </dd> <dt><b>Parameter nFillDateMode</b></dt> <dd>specifies the calculation mode for date values. </dd> <dt><b>Parameter fStep</b></dt> <dd>contains the value used to increase/decrease the series values. </dd> <dt><b>Parameter fEndValue</b></dt> <dd>contains the threshold value on which the calculation of the current series stops. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="fillAuto" class="membertitle">fillAuto</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">void</td> </tr> <tr> <td valign="top"><b>fillAuto</b>(</td> <td valign="top">[in] <a href="FillDirection.html">FillDirection</a></td> <td valign="bottom"> nFillDirection,</td> </tr> <tr> <td/><td valign="top">[in] long</td> <td valign="bottom"> nSourceCount );</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>fills all cells in the range in a way that is specified by the first cell(s) in the range. </dd> <dt><b>Parameter nFillDirection</b></dt> <dd>specifies the direction to fill the rows/columns of the range. </dd> <dt><b>Parameter nSourceCount</b></dt> <dd>contains the number of cells in each row/column used to constitute the fill algorithm. </dd> </dl> </td> </tr> </table> </td> </tr> </table> <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>
