From 8aaa14a95b40109cdbfe00e63f5eab32d7c450f0 Mon Sep 17 00:00:00 2001 From: Vladimir Glazounov Date: Wed, 26 Aug 2009 08:17:39 +0000 Subject: CWS-TOOLING: integrate CWS hcshared22 2009-07-21 13:08:41 +0200 ufi r274186 : hidlst 2009-07-21 12:34:16 +0200 ufi r274179 : makefiles 2009-07-21 12:33:01 +0200 ufi r274177 : fixes 2009-07-21 12:22:32 +0200 ufi r274175 : hidlst 2009-07-21 10:20:12 +0200 ufi r274167 : bugfixes 2009-07-21 10:19:42 +0200 ufi r274166 : bugfixes 2009-07-21 10:07:53 +0200 ufi r274165 : errorfix 2009-07-21 09:56:18 +0200 ufi r274162 : vor build 2009-07-13 11:49:18 +0200 ufi r273923 : CWS-TOOLING: rebase CWS hcshared22 to trunk@273858 (milestone: DEV300:m52) 2009-07-10 12:29:33 +0200 ufi r273885 : makefiles 2009-07-10 09:48:46 +0200 ufi r273875 : vor rebase 2009-07-10 09:48:19 +0200 ufi r273874 : vor rebase 2009-07-10 09:47:23 +0200 ufi r273873 : vor rebase --- .../source/text/scalc/guide/calc_series.xhp | 131 ++++++++++----------- 1 file changed, 64 insertions(+), 67 deletions(-) (limited to 'helpcontent2/source/text/scalc/guide/calc_series.xhp') diff --git a/helpcontent2/source/text/scalc/guide/calc_series.xhp b/helpcontent2/source/text/scalc/guide/calc_series.xhp index 2cdce15710..5aea6cdfa0 100755 --- a/helpcontent2/source/text/scalc/guide/calc_series.xhp +++ b/helpcontent2/source/text/scalc/guide/calc_series.xhp @@ -1,8 +1,8 @@ - - + + + - - -Automatically Calculating Series -/text/scalc/guide/calc_series.xhp - - -Sun Microsystems, Inc. -FPE: Deleted screen shot, heavily reedited; dedr: reviewed - - - + + Automatically Calculating Series + /text/scalc/guide/calc_series.xhp + + + series; calculating -calculating; series -linear series -growth series -date series -powers of 2 calculations -cells; filling automatically -auto filling cells -AutoFill function -filling;cells, automatically -mw made "powers of 2;..." a one level entry and changed "AutoFill" entry -Automatically Filling in Data Based on Adjacent Cells + calculating; series + linear series + growth series + date series + powers of 2 calculations + cells; filling automatically + automatic cell filling + AutoFill function + filling;cells, automatically +mw made "powers of 2;..." a one level entry and changed "AutoFill" entryMW changed "auto filling cells" +Automatically Filling in Data Based on Adjacent Cells -You can automatically fill cells with data with the AutoFill command or the Series command. -Using AutoFill -AutoFill automatically generates a data series based on a defined pattern. - - -On a sheet, click in cell, and type a number. - - -Click in another cell and then click back in the cell where you typed the number. - - -Drag the fill handle in the bottom right corner of the cell across the cells that you want to fill, and release the mouse button. -The cells are filled with ascending numbers. - - -To quickly create a list of consecutive days, enter "Monday" in a cell, and drag the fill handle. -Hold down Command Ctrl if you do not want to fill the cells with different values. -If you select two or more adjacent cells that contain different numbers, and drag, the remaining cells are filled with the arithmetic pattern that is recognized in the numbers. The AutoFill function also recognizes customized lists that are defined under Tools - Options - %PRODUCTNAME Calc - Sort Lists. -You can double-click the fill handle to automatically fill all empty columns of the current data block. For example, first enter Jan into A1 and drag the fill handle down to A12 to get the twelve months in the first column. Now enter some values into B1 and C1. Select those two cells, and double-click the fill handle. This fills automatically the data block B1:C12. -Using a Defined Series - - -Select the cell range in the sheet that you want to fill. - - -Choose Edit - Fill - Series. - - -Select the parameters for the series. -If you select a linear series, the increment that you enter is added to each consecutive number in the series to create the next value. -If you select a growth series, the increment that you enter is multiplied by each consecutive number to create the next value. -If you select a date series, the increment that you enter is added to the time unit that you specify. - - -
- -Sort lists -
- - + You can automatically fill cells with data with the AutoFill command or the Series command. + Using AutoFill + AutoFill automatically generates a data series based on a defined pattern. + + + On a sheet, click in a cell, and type a number. + + + Click in another cell and then click back in the cell where you typed the number. + + + Drag the fill handle in the bottom right corner of the cell across the cells that you want to fill, and release the mouse button. + The cells are filled with ascending numbers. + + + To quickly create a list of consecutive days, enter Monday in a cell, and drag the fill handle. + Hold down Command +Ctrl if you do not want to fill the cells with different values. + If you select two or more adjacent cells that contain different numbers, and drag, the remaining cells are filled with the arithmetic pattern that is recognized in the numbers. The AutoFill function also recognizes customized lists that are defined under Tools - Options - %PRODUCTNAME Calc - Sort Lists. + You can double-click the fill handle to automatically fill all empty columns of the current data block. For example, first enter Jan into A1 and drag the fill handle down to A12 to get the twelve months in the first column. Now enter some values into B1 and C1. Select those two cells, and double-click the fill handle. This fills automatically the data block B1:C12. + Using a Defined Series + + + Select the cell range in the sheet that you want to fill. + + + Choose Edit - Fill - Series. + + + Select the parameters for the series. + If you select a linear series, the increment that you enter is added to each consecutive number in the series to create the next value. + If you select a growth series, the increment that you enter is multiplied by each consecutive number to create the next value. + If you select a date series, the increment that you enter is added to the time unit that you specify. + + +
+ + Sort lists +
+ + \ No newline at end of file -- cgit