| blob | 376d2117ac05ed0adfb5a7f6b951fff10b39302c |
4 <!--***********************************************************************
5 *
6 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
7 *
8 * Copyright 2008 by Sun Microsystems, Inc.
9 *
10 * OpenOffice.org - a multi-platform office productivity suite
11 *
12 * $RCSfile: 02140600.xhp,v $
13 * $Revision: 1.7 $
14 *
15 * This file is part of OpenOffice.org.
16 *
17 * OpenOffice.org is free software: you can redistribute it and/or modify
18 * it under the terms of the GNU Lesser General Public License version 3
19 * only, as published by the Free Software Foundation.
20 *
21 * OpenOffice.org is distributed in the hope that it will be useful,
22 * but WITHOUT ANY WARRANTY; without even the implied warranty of
23 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
24 * GNU Lesser General Public License version 3 for more details
25 * (a copy is included in the LICENSE file that accompanied this code).
26 *
27 * You should have received a copy of the GNU Lesser General Public License
28 * version 3 along with OpenOffice.org. If not, see
29 * <http://www.openoffice.org/license.html>
30 * for a copy of the LGPLv3 License.
31 *
32 ************************************************************************-->
35 <meta>
39 </topic>
40 <history>
43 </history>
44 </meta>
45 <body>
48 <paragraph role="heading" id="hd_id3148664" xml-lang="en-US" level="1" l10n="U" oldref="1">Fill Series</paragraph>
49 <paragraph role="paragraph" id="par_id3148797" xml-lang="en-US" l10n="U" oldref="2"><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>
50 </variable></paragraph>
51 <paragraph role="note" id="par_id3146976" xml-lang="en-US" l10n="U" oldref="41">Before filling a series, first select the cell range.</paragraph>
54 </section>
55 <paragraph role="paragraph" id="par_id3145748" xml-lang="en-US" l10n="U" oldref="3">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>
56 <paragraph role="heading" id="hd_id3147435" xml-lang="en-US" level="2" l10n="U" oldref="4">Direction</paragraph>
57 <paragraph role="paragraph" id="par_id3154729" xml-lang="en-US" l10n="U" oldref="5">Determines the direction of series creation.</paragraph>
58 <bookmark xml-lang="en-US" branch="hid/SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_BOTTOM" id="bm_id3147124" localize="false"/>
59 <paragraph role="heading" id="hd_id3145253" xml-lang="en-US" level="3" l10n="U" oldref="6">Down</paragraph>
60 <paragraph role="paragraph" id="par_id3155418" xml-lang="en-US" l10n="U" oldref="7"><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>
61 <bookmark xml-lang="en-US" branch="hid/SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_RIGHT" id="bm_id3153415" localize="false"/>
62 <paragraph role="heading" id="hd_id3155738" xml-lang="en-US" level="3" l10n="U" oldref="8">Right</paragraph>
63 <paragraph role="paragraph" id="par_id3149402" xml-lang="en-US" l10n="U" oldref="9"><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>
64 <bookmark xml-lang="en-US" branch="hid/SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_TOP" id="bm_id3155067" localize="false"/>
65 <paragraph role="heading" id="hd_id3146972" xml-lang="en-US" level="3" l10n="U" oldref="10">Up</paragraph>
66 <paragraph role="paragraph" id="par_id3153711" xml-lang="en-US" l10n="U" oldref="11"><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>
67 <bookmark xml-lang="en-US" branch="hid/SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_LEFT" id="bm_id3147341" localize="false"/>
68 <paragraph role="heading" id="hd_id3153764" xml-lang="en-US" level="3" l10n="U" oldref="12">Left</paragraph>
69 <paragraph role="paragraph" id="par_id3156382" xml-lang="en-US" l10n="U" oldref="13"><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>
70 <paragraph role="heading" id="hd_id3147344" xml-lang="en-US" level="2" l10n="U" oldref="14">Series Type</paragraph>
71 <paragraph role="paragraph" id="par_id3149257" xml-lang="en-US" l10n="U" oldref="15">Defines the series type. Choose between <emph>Linear, Growth, Date </emph>and <emph>AutoFill</emph>.</paragraph>
72 <bookmark xml-lang="en-US" branch="hid/SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_ARITHMETIC" id="bm_id3150298" localize="false"/>
73 <paragraph role="heading" id="hd_id3148488" xml-lang="en-US" level="3" l10n="U" oldref="16">Linear</paragraph>
74 <paragraph role="paragraph" id="par_id3159238" xml-lang="en-US" l10n="U" oldref="17"><ahelp hid="SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_ARITHMETIC">Creates a linear number series using the defined increment and end value.</ahelp></paragraph>
75 <bookmark xml-lang="en-US" branch="hid/SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_GEOMETRIC" id="bm_id3150784" localize="false"/>
76 <paragraph role="heading" id="hd_id3149210" xml-lang="en-US" level="3" l10n="U" oldref="18">Growth</paragraph>
77 <paragraph role="paragraph" id="par_id3150364" xml-lang="en-US" l10n="U" oldref="19"><ahelp hid="SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_GEOMETRIC">Creates a growth series using the defined increment and end value.</ahelp></paragraph>
78 <bookmark xml-lang="en-US" branch="hid/SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_DATE" id="bm_id3155378" localize="false"/>
79 <paragraph role="heading" id="hd_id3149528" xml-lang="en-US" level="3" l10n="U" oldref="20">Date</paragraph>
80 <paragraph role="paragraph" id="par_id3150887" xml-lang="en-US" l10n="U" oldref="21"><ahelp hid="SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_DATE">Creates a date series using the defined increment and end date.</ahelp></paragraph>
81 <bookmark xml-lang="en-US" branch="hid/SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_AUTOFILL" id="bm_id3152985" localize="false"/>
82 <paragraph role="heading" id="hd_id3150202" xml-lang="en-US" level="3" l10n="U" oldref="22">AutoFill</paragraph>
83 <paragraph role="paragraph" id="par_id3156288" xml-lang="en-US" l10n="U" oldref="23"><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>Tools - Options - %PRODUCTNAME Calc - Sort Lists</emph>.</paragraph>
84 <paragraph role="paragraph" id="par_id3155811" xml-lang="en-US" l10n="U" oldref="24">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>
87 </paragraph>
88 <paragraph role="heading" id="hd_id3148700" xml-lang="en-US" level="2" l10n="U" oldref="25">Unit of Time</paragraph>
89 <paragraph role="paragraph" id="par_id3153308" xml-lang="en-US" l10n="U" oldref="26">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>
90 <bookmark xml-lang="en-US" branch="hid/SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_DAY" id="bm_id3153913" localize="false"/>
91 <paragraph role="heading" id="hd_id3148868" xml-lang="en-US" level="3" l10n="U" oldref="27">Day</paragraph>
92 <paragraph role="paragraph" id="par_id3148605" xml-lang="en-US" l10n="U" oldref="28"><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>
93 <bookmark xml-lang="en-US" branch="hid/SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_DAY_OF_WEEK" id="bm_id3145074" localize="false"/>
94 <paragraph role="heading" id="hd_id3144771" xml-lang="en-US" level="3" l10n="U" oldref="29">Weekday</paragraph>
95 <paragraph role="paragraph" id="par_id3150108" xml-lang="en-US" l10n="U" oldref="30"><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>
96 <bookmark xml-lang="en-US" branch="hid/SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_MONTH" id="bm_id3159204" localize="false"/>
97 <paragraph role="heading" id="hd_id3154957" xml-lang="en-US" level="3" l10n="U" oldref="31">Month</paragraph>
98 <paragraph role="paragraph" id="par_id3149126" xml-lang="en-US" l10n="U" oldref="32"><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>
99 <bookmark xml-lang="en-US" branch="hid/SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_YEAR" id="bm_id3146777" localize="false"/>
100 <paragraph role="heading" id="hd_id3152870" xml-lang="en-US" level="3" l10n="U" oldref="33">Year</paragraph>
101 <paragraph role="paragraph" id="par_id3151300" xml-lang="en-US" l10n="U" oldref="34"><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>
102 <bookmark xml-lang="en-US" branch="hid/SC:EDIT:RID_SCDLG_FILLSERIES:ED_START_VALUES" id="bm_id3145357" localize="false"/>
103 <paragraph role="heading" id="hd_id3154762" xml-lang="en-US" level="2" l10n="U" oldref="35">Start Value</paragraph>
104 <paragraph role="paragraph" id="par_id3149381" xml-lang="en-US" l10n="U" oldref="36"><ahelp hid="SC:EDIT:RID_SCDLG_FILLSERIES:ED_START_VALUES">Determines the start value for the series.</ahelp> Use numbers, dates or times.</paragraph>
105 <bookmark xml-lang="en-US" branch="hid/SC:EDIT:RID_SCDLG_FILLSERIES:ED_END_VALUES" id="bm_id3153557" localize="false"/>
106 <paragraph role="heading" id="hd_id3153013" xml-lang="en-US" level="2" l10n="U" oldref="37">End Value</paragraph>
107 <paragraph role="paragraph" id="par_id3153487" xml-lang="en-US" l10n="U" oldref="38"><ahelp hid="SC:EDIT:RID_SCDLG_FILLSERIES:ED_END_VALUES">Determines the end value for the series.</ahelp> Use numbers, dates or times.</paragraph>
108 <bookmark xml-lang="en-US" branch="hid/SC:EDIT:RID_SCDLG_FILLSERIES:ED_INCREMENT" id="bm_id3151196" localize="false"/>
109 <paragraph role="heading" id="hd_id3149312" xml-lang="en-US" level="2" l10n="U" oldref="39">Increment</paragraph>
110 <paragraph role="paragraph" id="par_id3154739" xml-lang="en-US" l10n="U" oldref="40">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>
111 </body>
112 </helpdocument>