1cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?> 2cdf0e10cSrcweir 302dbb15cSAndrew Rist<!--*********************************************************** 4cdf0e10cSrcweir * 502dbb15cSAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 602dbb15cSAndrew Rist * or more contributor license agreements. See the NOTICE file 702dbb15cSAndrew Rist * distributed with this work for additional information 802dbb15cSAndrew Rist * regarding copyright ownership. The ASF licenses this file 902dbb15cSAndrew Rist * to you under the Apache License, Version 2.0 (the 1002dbb15cSAndrew Rist * "License"); you may not use this file except in compliance 1102dbb15cSAndrew Rist * with the License. You may obtain a copy of the License at 12cdf0e10cSrcweir * 1302dbb15cSAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 14cdf0e10cSrcweir * 1502dbb15cSAndrew Rist * Unless required by applicable law or agreed to in writing, 1602dbb15cSAndrew Rist * software distributed under the License is distributed on an 1702dbb15cSAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 1802dbb15cSAndrew Rist * KIND, either express or implied. See the License for the 1902dbb15cSAndrew Rist * specific language governing permissions and limitations 2002dbb15cSAndrew Rist * under the License. 21cdf0e10cSrcweir * 2202dbb15cSAndrew Rist ***********************************************************--> 2302dbb15cSAndrew Rist 24cdf0e10cSrcweir<helpdocument version="1.0"> 25cdf0e10cSrcweir<meta> 26cdf0e10cSrcweir<topic id="textscalc0102140600xml" indexer="include" status="PUBLISH"> 27cdf0e10cSrcweir<title id="tit" xml-lang="en-US">Fill Series</title> 28cdf0e10cSrcweir<filename>/text/scalc/01/02140600.xhp</filename> 29cdf0e10cSrcweir</topic> 3006cf5254Smseidel<comment>Inserted link for AutoFill</comment> 31cdf0e10cSrcweir</meta> 32cdf0e10cSrcweir<body> 33cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:FillSeries" id="bm_id709198" localize="false"/> 34cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:FillSeries" id="bm_id3150791" localize="false"/> 35*666afc3eSmseidel<paragraph role="heading" id="hd_id3148664" xml-lang="en-US" level="1" l10n="U">Fill Series</paragraph> 36*666afc3eSmseidel<paragraph role="paragraph" id="par_id3148797" xml-lang="en-US" l10n="U"><variable id="reihenfuellentext"><ahelp hid=".uno:FillSeries">Automatically generate series with the options in this dialog. Determine direction, increment, time unit and series type.</ahelp> 37cdf0e10cSrcweir</variable></paragraph> 38*666afc3eSmseidel<paragraph role="note" id="par_id3146976" xml-lang="en-US" l10n="U">Before filling a series, first select the cell range.</paragraph> 39cdf0e10cSrcweir<section id="howtoget"> 40cdf0e10cSrcweir<embed href="text/scalc/00/00000402.xhp#bausreihe"/> 41cdf0e10cSrcweir</section> 42*666afc3eSmseidel<paragraph role="paragraph" id="par_id3145748" xml-lang="en-US" l10n="U">To automatically continue a series using the assumed completion rules, choose the <emph>AutoFill</emph> option after opening the <emph>Fill Series</emph> dialog.</paragraph> 43*666afc3eSmseidel<paragraph role="heading" id="hd_id3147435" xml-lang="en-US" level="2" l10n="U">Direction</paragraph> 44*666afc3eSmseidel<paragraph role="paragraph" id="par_id3154729" xml-lang="en-US" l10n="U">Determines the direction of series creation.</paragraph> 45cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCDLG_FILLSERIES:BTN_BOTTOM" id="bm_id3147124" localize="false"/> 46*666afc3eSmseidel<paragraph role="heading" id="hd_id3145253" xml-lang="en-US" level="3" l10n="U">Down</paragraph> 47*666afc3eSmseidel<paragraph role="paragraph" id="par_id3155418" xml-lang="en-US" l10n="U"><ahelp hid="SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_BOTTOM">Creates a downward series in the selected cell range for the column using the defined increment to the end value.</ahelp></paragraph> 48cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCDLG_FILLSERIES:BTN_RIGHT" id="bm_id3153415" localize="false"/> 49*666afc3eSmseidel<paragraph role="heading" id="hd_id3155738" xml-lang="en-US" level="3" l10n="U">Right</paragraph> 50*666afc3eSmseidel<paragraph role="paragraph" id="par_id3149402" xml-lang="en-US" l10n="U"><ahelp hid="SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_RIGHT">Creates a series running from left to right within the selected cell range using the defined increment to the end value.</ahelp></paragraph> 51cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCDLG_FILLSERIES:BTN_TOP" id="bm_id3155067" localize="false"/> 52*666afc3eSmseidel<paragraph role="heading" id="hd_id3146972" xml-lang="en-US" level="3" l10n="U">Up</paragraph> 53*666afc3eSmseidel<paragraph role="paragraph" id="par_id3153711" xml-lang="en-US" l10n="U"><ahelp hid="SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_TOP">Creates an upward series in the cell range of the column using the defined increment to the end value.</ahelp></paragraph> 54cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCDLG_FILLSERIES:BTN_LEFT" id="bm_id3147341" localize="false"/> 55*666afc3eSmseidel<paragraph role="heading" id="hd_id3153764" xml-lang="en-US" level="3" l10n="U">Left</paragraph> 56*666afc3eSmseidel<paragraph role="paragraph" id="par_id3156382" xml-lang="en-US" l10n="U"><ahelp hid="SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_LEFT">Creates a series running from right to left in the selected cell range using the defined increment to the end value.</ahelp></paragraph> 57*666afc3eSmseidel<paragraph role="heading" id="hd_id3147344" xml-lang="en-US" level="2" l10n="U">Series Type</paragraph> 58*666afc3eSmseidel<paragraph role="paragraph" id="par_id3149257" xml-lang="en-US" l10n="U">Defines the series type. Choose between <emph>Linear, Growth, Date</emph> and <emph>AutoFill</emph>.</paragraph> 59cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCDLG_FILLSERIES:BTN_ARITHMETIC" id="bm_id3150298" localize="false"/> 60*666afc3eSmseidel<paragraph role="heading" id="hd_id3148488" xml-lang="en-US" level="3" l10n="U">Linear</paragraph> 61*666afc3eSmseidel<paragraph role="paragraph" id="par_id3159238" xml-lang="en-US" l10n="U"><ahelp hid="SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_ARITHMETIC">Creates a linear number series using the defined increment and end value.</ahelp></paragraph> 62cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCDLG_FILLSERIES:BTN_GEOMETRIC" id="bm_id3150784" localize="false"/> 63*666afc3eSmseidel<paragraph role="heading" id="hd_id3149210" xml-lang="en-US" level="3" l10n="U">Growth</paragraph> 64*666afc3eSmseidel<paragraph role="paragraph" id="par_id3150364" xml-lang="en-US" l10n="U"><ahelp hid="SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_GEOMETRIC">Creates a growth series using the defined increment and end value.</ahelp></paragraph> 65cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCDLG_FILLSERIES:BTN_DATE" id="bm_id3155378" localize="false"/> 66*666afc3eSmseidel<paragraph role="heading" id="hd_id3149528" xml-lang="en-US" level="3" l10n="U">Date</paragraph> 67*666afc3eSmseidel<paragraph role="paragraph" id="par_id3150887" xml-lang="en-US" l10n="U"><ahelp hid="SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_DATE">Creates a date series using the defined increment and end date.</ahelp></paragraph> 68cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCDLG_FILLSERIES:BTN_AUTOFILL" id="bm_id3152985" localize="false"/> 69*666afc3eSmseidel<paragraph role="heading" id="hd_id3150202" xml-lang="en-US" level="3" l10n="U">AutoFill</paragraph> 70*666afc3eSmseidel<paragraph role="paragraph" id="par_id3156288" xml-lang="en-US" l10n="U"><ahelp hid="SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_AUTOFILL">Forms a series directly in the sheet.</ahelp> The AutoFill function takes account of customized lists. For example, by entering <emph>January</emph> in the first cell, the series is completed using the list defined under <emph><switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - %PRODUCTNAME Calc - Sort Lists</emph>.</paragraph> 71*666afc3eSmseidel<paragraph role="paragraph" id="par_id3155811" xml-lang="en-US" l10n="U">AutoFill tries to complete a value series by using a defined pattern. The series 1,3,5 is automatically completed with 7,9,11,13, and so on. Date and time series are completed accordingly; for example, after 01.01.99 and 15.01.99, an interval of 14 days is used.</paragraph> 72cdf0e10cSrcweir<paragraph role="paragraph" id="par_id2956483" xml-lang="en-US" l10n="NEW" localize="false"> 73cdf0e10cSrcweir<embedvar href="text/scalc/guide/calc_series.xhp#calc_series"/> 74cdf0e10cSrcweir</paragraph> 75*666afc3eSmseidel<paragraph role="heading" id="hd_id3148700" xml-lang="en-US" level="2" l10n="U">Unit of Time</paragraph> 76*666afc3eSmseidel<paragraph role="paragraph" id="par_id3153308" xml-lang="en-US" l10n="U">In this area you can specify the desired unit of time. This area is only active if the <emph>Date</emph> option has been chosen in the <emph>Series type</emph> area.</paragraph> 77cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCDLG_FILLSERIES:BTN_DAY" id="bm_id3153913" localize="false"/> 78*666afc3eSmseidel<paragraph role="heading" id="hd_id3148868" xml-lang="en-US" level="3" l10n="U">Day</paragraph> 79*666afc3eSmseidel<paragraph role="paragraph" id="par_id3148605" xml-lang="en-US" l10n="U"><ahelp hid="SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_DAY">Use the <emph>Date</emph> series type and this option to create a series using seven days.</ahelp></paragraph> 80cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCDLG_FILLSERIES:BTN_DAY_OF_WEEK" id="bm_id3145074" localize="false"/> 81*666afc3eSmseidel<paragraph role="heading" id="hd_id3144771" xml-lang="en-US" level="3" l10n="U">Weekday</paragraph> 82*666afc3eSmseidel<paragraph role="paragraph" id="par_id3150108" xml-lang="en-US" l10n="U"><ahelp hid="SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_DAY_OF_WEEK">Use the <emph>Date</emph> series type and this option to create a series of five day sets.</ahelp></paragraph> 83cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCDLG_FILLSERIES:BTN_MONTH" id="bm_id3159204" localize="false"/> 84*666afc3eSmseidel<paragraph role="heading" id="hd_id3154957" xml-lang="en-US" level="3" l10n="U">Month</paragraph> 85*666afc3eSmseidel<paragraph role="paragraph" id="par_id3149126" xml-lang="en-US" l10n="U"><ahelp hid="SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_MONTH">Use the <emph>Date</emph> series type and this option to form a series from the names or abbreviations of the months.</ahelp></paragraph> 86cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCDLG_FILLSERIES:BTN_YEAR" id="bm_id3146777" localize="false"/> 87*666afc3eSmseidel<paragraph role="heading" id="hd_id3152870" xml-lang="en-US" level="3" l10n="U">Year</paragraph> 88*666afc3eSmseidel<paragraph role="paragraph" id="par_id3151300" xml-lang="en-US" l10n="U"><ahelp hid="SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_YEAR">Use the <emph>Date</emph> series type and this option to create a series of years.</ahelp></paragraph> 89cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:Edit:RID_SCDLG_FILLSERIES:ED_START_VALUES" id="bm_id3145357" localize="false"/> 90*666afc3eSmseidel<paragraph role="heading" id="hd_id3154762" xml-lang="en-US" level="2" l10n="U">Start Value</paragraph> 91*666afc3eSmseidel<paragraph role="paragraph" id="par_id3149381" xml-lang="en-US" l10n="U"><ahelp hid="SC:EDIT:RID_SCDLG_FILLSERIES:ED_START_VALUES">Determines the start value for the series.</ahelp> Use numbers, dates or times.</paragraph> 92cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:Edit:RID_SCDLG_FILLSERIES:ED_END_VALUES" id="bm_id3153557" localize="false"/> 93*666afc3eSmseidel<paragraph role="heading" id="hd_id3153013" xml-lang="en-US" level="2" l10n="U">End Value</paragraph> 94*666afc3eSmseidel<paragraph role="paragraph" id="par_id3153487" xml-lang="en-US" l10n="U"><ahelp hid="SC:EDIT:RID_SCDLG_FILLSERIES:ED_END_VALUES">Determines the end value for the series.</ahelp> Use numbers, dates or times.</paragraph> 95cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:Edit:RID_SCDLG_FILLSERIES:ED_INCREMENT" id="bm_id3151196" localize="false"/> 96*666afc3eSmseidel<paragraph role="heading" id="hd_id3149312" xml-lang="en-US" level="2" l10n="U">Increment</paragraph> 97*666afc3eSmseidel<paragraph role="paragraph" id="par_id3154739" xml-lang="en-US" l10n="U">The term "increment" denotes the amount by which a given value increases.<ahelp hid="SC:EDIT:RID_SCDLG_FILLSERIES:ED_INCREMENT"> Determines the value by which the series of the selected type increases by each step.</ahelp> Entries can only be made if the linear, growth or date series types have been selected.</paragraph> 98cdf0e10cSrcweir</body> 99cdf0e10cSrcweir</helpdocument> 100