From f8050a8d1ab674e1089d28ff5a6378126b68db2d Mon Sep 17 00:00:00 2001 From: Kurt Zenker Date: Fri, 11 Sep 2009 17:55:45 +0000 Subject: CWS-TOOLING: integrate CWS hcshared23 2009-09-09 15:34:15 +0200 ufi r275999 : again 2009-09-08 16:41:34 +0200 ufi r275941 : vor bauen 2009-09-08 16:35:18 +0200 ufi r275940 : vor bauen 2009-09-07 11:12:35 +0200 ufi r275878 : test --- helpcontent2/source/text/scalc/01/02140000.xhp | 4 +- helpcontent2/source/text/scalc/01/04050000.xhp | 1 - helpcontent2/source/text/scalc/01/04060101.xhp | 288 +-- helpcontent2/source/text/scalc/01/04060103.xhp | 270 +-- helpcontent2/source/text/scalc/01/04060106.xhp | 2231 ++++++++++---------- helpcontent2/source/text/scalc/01/04060109.xhp | 10 +- helpcontent2/source/text/scalc/01/04060110.xhp | 959 +++++---- helpcontent2/source/text/scalc/01/04060116.xhp | 30 +- helpcontent2/source/text/scalc/01/04060181.xhp | 3 +- helpcontent2/source/text/scalc/01/04060183.xhp | 8 +- helpcontent2/source/text/scalc/01/04060184.xhp | 589 +++--- helpcontent2/source/text/scalc/01/05100000.xhp | 18 +- helpcontent2/source/text/scalc/01/05120000.xhp | 79 +- helpcontent2/source/text/scalc/01/12090102.xhp | 136 +- helpcontent2/source/text/scalc/01/text2columns.xhp | 74 +- .../source/text/scalc/guide/address_auto.xhp | 4 +- helpcontent2/source/text/scalc/guide/auto_off.xhp | 6 +- .../source/text/scalc/guide/autofilter.xhp | 4 +- .../source/text/scalc/guide/autoformat.xhp | 12 +- .../source/text/scalc/guide/background.xhp | 10 +- helpcontent2/source/text/scalc/guide/borders.xhp | 16 +- helpcontent2/source/text/scalc/guide/calc_date.xhp | 8 +- .../source/text/scalc/guide/calc_series.xhp | 8 +- helpcontent2/source/text/scalc/guide/calculate.xhp | 8 +- .../source/text/scalc/guide/cell_protect.xhp | 16 +- .../source/text/scalc/guide/cell_unprotect.xhp | 6 +- helpcontent2/source/text/scalc/guide/cellcopy.xhp | 2 +- .../text/scalc/guide/cellreference_dragdrop.xhp | 4 +- .../source/text/scalc/guide/cellreferences.xhp | 8 +- .../source/text/scalc/guide/cellreferences_url.xhp | 136 +- .../text/scalc/guide/cellstyle_by_formula.xhp | 8 +- .../text/scalc/guide/cellstyle_conditional.xhp | 22 +- .../text/scalc/guide/cellstyle_minusvalue.xhp | 4 +- .../source/text/scalc/guide/consolidate.xhp | 24 +- helpcontent2/source/text/scalc/guide/csv_files.xhp | 155 +- .../source/text/scalc/guide/csv_formula.xhp | 20 +- .../source/text/scalc/guide/currency_format.xhp | 65 +- .../source/text/scalc/guide/database_define.xhp | 6 +- .../source/text/scalc/guide/database_filter.xhp | 4 +- .../source/text/scalc/guide/database_sort.xhp | 2 +- .../text/scalc/guide/datapilot_createtable.xhp | 12 +- .../text/scalc/guide/datapilot_deletetable.xhp | 2 +- .../text/scalc/guide/datapilot_edittable.xhp | 4 +- .../text/scalc/guide/datapilot_filtertable.xhp | 2 +- helpcontent2/source/text/scalc/guide/filters.xhp | 73 +- .../source/text/scalc/guide/formula_value.xhp | 2 +- helpcontent2/source/text/scalc/guide/main.xhp | 1 + helpcontent2/source/text/scalc/guide/makefile.mk | 1 + .../source/text/scalc/guide/multitables.xhp | 99 +- .../source/text/scalc/guide/numbers_text.xhp | 95 + .../source/text/scalc/guide/table_cellmerge.xhp | 85 +- .../source/text/scalc/guide/text_numbers.xhp | 71 +- .../source/text/scalc/guide/text_rotate.xhp | 77 +- 53 files changed, 2972 insertions(+), 2810 deletions(-) create mode 100644 helpcontent2/source/text/scalc/guide/numbers_text.xhp (limited to 'helpcontent2/source/text/scalc') diff --git a/helpcontent2/source/text/scalc/01/02140000.xhp b/helpcontent2/source/text/scalc/01/02140000.xhp index 099e15ed31..3cec3cfc64 100644 --- a/helpcontent2/source/text/scalc/01/02140000.xhp +++ b/helpcontent2/source/text/scalc/01/02140000.xhp @@ -62,8 +62,8 @@ Series - Filling cells using context menus: - +Filling cells using context menus: + Call the context menu when positioned in a cell and choose Selection List. diff --git a/helpcontent2/source/text/scalc/01/04050000.xhp b/helpcontent2/source/text/scalc/01/04050000.xhp index 9dfb952df9..78ad2f2957 100644 --- a/helpcontent2/source/text/scalc/01/04050000.xhp +++ b/helpcontent2/source/text/scalc/01/04050000.xhp @@ -42,7 +42,6 @@ sheets;creating -sheets;inserting diff --git a/helpcontent2/source/text/scalc/01/04060101.xhp b/helpcontent2/source/text/scalc/01/04060101.xhp index acbe5c86d1..30bbd09e1c 100755 --- a/helpcontent2/source/text/scalc/01/04060101.xhp +++ b/helpcontent2/source/text/scalc/01/04060101.xhp @@ -79,28 +79,28 @@ - Name - +Name + - Grade - +Grade + - Age - +Age + - Distance to School - +Distance to School + - Weight - +Weight + @@ -109,28 +109,28 @@ - Andy - +Andy + - 3 - +3 + - 9 - +9 + - 150 - +150 + - 40 - +40 + @@ -139,28 +139,28 @@ - Betty - +Betty + - 4 - +4 + - 10 - +10 + - 1000 - +1000 + - 42 - +42 + @@ -169,28 +169,28 @@ - Charles - +Charles + - 3 - +3 + - 10 - +10 + - 300 - +300 + - 51 - +51 + @@ -199,28 +199,28 @@ - Daniel - +Daniel + - 5 - +5 + - 11 - +11 + - 1200 - +1200 + - 48 - +48 + @@ -229,28 +229,28 @@ - Eva - +Eva + - 2 - +2 + - 8 - +8 + - 650 - +650 + - 33 - +33 + @@ -259,31 +259,31 @@ - F - rank - +F +rank + - 2 - +2 + - 7 - +7 + - 3 - 00 - +3 +00 + - 4 - 2 - +4 +2 + @@ -292,28 +292,28 @@ - Greta - +Greta + - 1 - +1 + - 7 - +7 + - 200 - +200 + - 36 - +36 + @@ -322,28 +322,28 @@ - Harry - +Harry + - 3 - +3 + - 9 - +9 + - 1200 - +1200 + - 44 - +44 + @@ -352,28 +352,28 @@ - Irene - +Irene + - 2 - +2 + - 8 - +8 + - 1000 - +1000 + - 42 - +42 + @@ -412,28 +412,28 @@ - Name - +Name + - Grade - +Grade + - Age - +Age + - Distance to School - +Distance to School + - Weight - +Weight + @@ -448,8 +448,8 @@ - >600 - +>600 + @@ -475,13 +475,13 @@ - DCOUNT - +DCOUNT + - 5 - +5 + @@ -497,12 +497,12 @@ oldref="192">Database Function Parameters: The following items are the parameter definitions for all database functions: - Database is the cell range defining the database. +Database is the cell range defining the database. - DatabaseField specifies the column where the function operates on after the search criteria of the first parameter is applied and the data rows are selected. It is not related to the search criteria itself. Use the number 0 to specify the whole data range. To reference a column by means of the column header name, place quotation marks around the header name. +DatabaseField specifies the column where the function operates on after the search criteria of the first parameter is applied and the data rows are selected. It is not related to the search criteria itself. Use the number 0 to specify the whole data range. To reference a column by means of the column header name, place quotation marks around the header name. - SearchCriteria is the cell range containing search criteria. If you write several criteria in one row they are connected by AND. If you write the criteria in different rows they are connected by OR. Empty cells in the search criteria range will be ignored. +SearchCriteria is the cell range containing search criteria. If you write several criteria in one row they are connected by AND. If you write the criteria in different rows they are connected by OR. Empty cells in the search criteria range will be ignored. Choose Tools - Options - %PRODUCTNAME Calc - Calculate to define how $[officename] Calc acts when searching for identical entries. See also the Wiki page about Conditional Counting and Summation. @@ -519,12 +519,12 @@ oldref="90">Syntax DCOUNT(Database; DatabaseField; SearchCriteria) For the DatabaseField parameter you can enter a cell to specify the column, or enter the number 0 for the entire database. The parameter cannot be empty. - + Example In the example above (scroll up, please), we want to know how many children have to travel more than 600 meters to school. The result is to be stored in cell B16. Set the cursor in cell B16. Enter the formula =DCOUNT(A1:E10;0;A13:E14) in B16. The Function Wizard helps you to input ranges. - Database is the range of data to be evaluated, including its headers: in this case A1:E10. DatabaseField specifies the column for the search criteria: in this case, the whole database. SearchCriteria is the range where you can enter the search parameters: in this case, A13:E14. +Database is the range of data to be evaluated, including its headers: in this case A1:E10. DatabaseField specifies the column for the search criteria: in this case, the whole database. SearchCriteria is the range where you can enter the search parameters: in this case, A13:E14. To learn how many children in second grade are over 7 years of age, delete the entry >600 in cell D14 and enter 2 in cell B14 under Grade, and enter >7 in cell C14 to the right. The result is 2. Two children are in second grade and over 7 years of age. As both criteria are in the same row, they are connected by AND.
@@ -563,13 +563,13 @@ oldref="108">Example In the above example (scroll up, please), we want to determine what grade a child is in, whose name was entered in cell A14. The formula is entered in cell B16 and differs slightly from the earlier examples because only one column (one database field) can be entered for DatabaseField. Enter the following formula: - =DGET(A1:E10;"Grade";A13:E14) - +=DGET(A1:E10;"Grade";A13:E14) + Enter the name Frank in A14, and you see the result 2. Frank is in second grade. Enter "Age" instead of "Grade" and you will get Frank's age. Or enter the value 11 in cell C14 only, and delete the other entries in this row. Edit the formula in B16 as follows: - =DGET(A1:E10;"Name";A13:E14) - +=DGET(A1:E10;"Name";A13:E14) + Instead of the grade, the name is queried. The answer appears at once: Daniel is the only child aged 11.
@@ -590,8 +590,8 @@ oldref="119">Example To find out how much the heaviest child in each grade weighed in the above example (scroll up, please), enter the following formula in B16: - =DMAX(A1:E10;"Weight";A13:E14) - +=DMAX(A1:E10;"Weight";A13:E14) + Under Grade, enter 1, 2, 3, and so on, one after the other. After entering a grade number, the weight of the heaviest child in that grade appears.
@@ -612,8 +612,8 @@ oldref="127">Example To find the shortest distance to school for the children in each grade in the above example (scroll up, please), enter the following formula in B16: - =DMIN(A1:E10;"Distance to School";A13:E14) - +=DMIN(A1:E10;"Distance to School";A13:E14) + In row 14, under Grade, enter 1, 2, 3, and so on, one after the other. The shortest distance to school for each grade appears.
@@ -634,8 +634,8 @@ oldref="135">Example To find the average weight of all children of the same age in the above example (scroll up, please), enter the following formula in B16: - =DAVERAGE(A1:E10;"Weight";A13:E14) - +=DAVERAGE(A1:E10;"Weight";A13:E14) + In row 14, under Age, enter 7, 8, 9, and so on, one after the other. The average weight of all children of the same age appears.
@@ -672,8 +672,8 @@ oldref="149">Example To find the standard deviation of the weight for all children of the same age in the example (scroll up, please), enter the following formula in B16: - =DSTDEV(A1:E10;"Weight";A13:E14) - +=DSTDEV(A1:E10;"Weight";A13:E14) + In row 14, under Age, enter 7, 8, 9, and so on, one after the other. The result shown is the standard deviation of the weight of all children of this age.
@@ -693,8 +693,8 @@ oldref="157">Example To find the standard deviation of the weight for all children of the same age at Joe's birthday party (scroll up, please), enter the following formula in B16: - =DSTDEVP(A1:E10;"Weight";A13:E14) - +=DSTDEVP(A1:E10;"Weight";A13:E14) + In row 14, under Age, enter 7, 8, 9, and so on, one after the other. The result is the standard deviation of the weight for all same-aged children whose weight was checked.
@@ -715,8 +715,8 @@ oldref="165">Example To find the length of the combined distance to school of all children at Joe's birthday party (scroll up, please) who are in second grade, enter the following formula in B16: - =DSUM(A1:E10;"Distance to School";A13:E14) - +=DSUM(A1:E10;"Distance to School";A13:E14) + Enter 2 in row 14 under Grade. The sum (1950) of the distances to school of all the children who are in second grade is displayed.
@@ -736,8 +736,8 @@ oldref="174">Example To find the variance of the weight of all children of the same age of the above example (scroll up, please), enter the following formula in B16: - =DVAR(A1:E10;"Weight";A13:E14) - +=DVAR(A1:E10;"Weight";A13:E14) + In row 14, under Age, enter 7, 8, 9, and so on, one after the other. You will see as a result the variance of the weight values for all children of this age.
@@ -757,8 +757,8 @@ oldref="182">Example To find the variance of the weight for all children of the same age at Joe's birthday party (scroll up, please), enter the following formula in B16: - =DVARP(A1:E10;"Weight";A13:E14) - +=DVARP(A1:E10;"Weight";A13:E14) + In row 14, under Age, enter 7, 8, 9, and so on, one after the other. The variance of the weight values for all children of this age attending Joe's birthday party appears.
diff --git a/helpcontent2/source/text/scalc/01/04060103.xhp b/helpcontent2/source/text/scalc/01/04060103.xhp index dcf75321b0..dd0f670eec 100644 --- a/helpcontent2/source/text/scalc/01/04060103.xhp +++ b/helpcontent2/source/text/scalc/01/04060103.xhp @@ -62,17 +62,17 @@ oldref="361">Syntax AMORDEGRC(Cost; DatePurchased; FirstPeriod; Salvage; Period; Rate; Basis) - Cost is the acquisition costs. +Cost is the acquisition costs. - DatePurchased is the date of acquisition. +DatePurchased is the date of acquisition. - FirstPeriod is the end date of the first settlement period. +FirstPeriod is the end date of the first settlement period. - Salvage is the salvage value of the capital asset at the end of the depreciable life. +Salvage is the salvage value of the capital asset at the end of the depreciable life. - Period is the settlement period to be considered. +Period is the settlement period to be considered. - Rate is the rate of depreciation. +Rate is the rate of depreciation.
@@ -87,17 +87,17 @@ oldref="371">Syntax AMORLINC(Cost; DatePurchased; FirstPeriod; Salvage; Period; Rate; Basis) - Cost means the acquisition costs. +Cost means the acquisition costs. - DatePurchased is the date of acquisition. +DatePurchased is the date of acquisition. - FirstPeriod is the end date of the first settlement period. +FirstPeriod is the end date of the first settlement period. - Salvage is the salvage value of the capital asset at the end of the depreciable life. +Salvage is the salvage value of the capital asset at the end of the depreciable life. - Period is the settlement period to be considered. +Period is the settlement period to be considered. - Rate is the rate of depreciation. +Rate is the rate of depreciation.
@@ -113,17 +113,17 @@ oldref="337">Syntax ACCRINT(Issue; FirstInterest; Settlement; Rate; Par; Frequency; Basis) - Issue is the issue date of the security. +Issue is the issue date of the security. - FirstInterest is the first interest date of the security. +FirstInterest is the first interest date of the security. - Settlement is the date at which the interest accrued up until then is to be calculated. +Settlement is the date at which the interest accrued up until then is to be calculated. - Rate is the annual nominal rate of interest (coupon interest rate) +Rate is the annual nominal rate of interest (coupon interest rate) - Par is the par value of the security. +Par is the par value of the security. - Frequency is the number of interest payments per year (1, 2 or 4). +Frequency is the number of interest payments per year (1, 2 or 4). Example @@ -143,13 +143,13 @@ oldref="350">Syntax ACCRINTM(Issue; Settlement; Rate; Par; Basis) - Issue is the issue date of the security. +Issue is the issue date of the security. - Settlement is the date at which the interest accrued up until then is to be calculated. +Settlement is the date at which the interest accrued up until then is to be calculated. - Rate is the annual nominal rate of interest (coupon interest rate). +Rate is the annual nominal rate of interest (coupon interest rate). - Par is the par value of the security. +Par is the par value of the security. Example @@ -169,13 +169,13 @@ oldref="392">Syntax RECEIVED("Settlement"; "Maturity"; Investment; Discount; Basis) - Settlement is the date of purchase of the security. +Settlement is the date of purchase of the security. - Maturity is the date on which the security matures (expires). +Maturity is the date on which the security matures (expires). - Investment is the purchase sum. +Investment is the purchase sum. - Discount is the percentage discount on acquisition of the security. +Discount is the percentage discount on acquisition of the security. Example @@ -197,23 +197,23 @@ Syntax PV(Rate; NPer; Pmt; FV; Type) - Rate defines the interest rate per period. +Rate defines the interest rate per period. - NPer is the total number of periods (payment period). +NPer is the total number of periods (payment period). - Pmt is the regular payment made per period. +Pmt is the regular payment made per period. - FV (optional) defines the future value remaining after the final installment has been made. +FV (optional) defines the future value remaining after the final installment has been made. - Type (optional) denotes due date for payments. Type = 1 means due at the beginning of a period and Type = 0 (default) means due at the end of the period. +Type (optional) denotes due date for payments. Type = 1 means due at the beginning of a period and Type = 0 (default) means due at the end of the period. - - + + Example What is the present value of an investment, if 500 currency units are paid out monthly and the annual interest rate is 8%? The payment period is 48 months and 20,000 currency units are to remain at the end of the payment period. - =PV(8%/12;48;500;20000) = -35,019.37 currency units. Under the named conditions, you must deposit 35,019.37 currency units today, if you want to receive 500 currency units per month for 48 months and have 20,000 currency units left over at the end. Cross-checking shows that 48 x 500 currency units + 20,000 currency units = 44,000 currency units. The difference between this amount and the 35,000 currency units deposited represents the interest paid. +=PV(8%/12;48;500;20000) = -35,019.37 currency units. Under the named conditions, you must deposit 35,019.37 currency units today, if you want to receive 500 currency units per month for 48 months and have 20,000 currency units left over at the end. Cross-checking shows that 48 x 500 currency units + 20,000 currency units = 44,000 currency units. The difference between this amount and the 35,000 currency units deposited represents the interest paid. If you enter references instead of these values into the formula, you can calculate any number of "If-then" scenarios. Please note: references to constants must be defined as absolute references. Examples of this type of application are found under the depreciation functions.
@@ -231,18 +231,18 @@ oldref="22">Syntax SYD(Cost; Salvage; Life; Period) - Cost is the initial cost of an asset. +Cost is the initial cost of an asset. - Salvage is the value of an asset after depreciation. +Salvage is the value of an asset after depreciation. - Life is the period fixing the time span over which an asset is depreciated. +Life is the period fixing the time span over which an asset is depreciated. - Period defines the period for which the depreciation is to be calculated. +Period defines the period for which the depreciation is to be calculated. Example A video system initially costing 50,000 currency units is to be depreciated annually for the next 5 years. The salvage value is to be 10,000 currency units. You want to calculate depreciation for the first year. - =SYD(50000;10000;5;1)=13,333.33 currency units. The depreciation amount for the first year is 13,333.33 currency units. +=SYD(50000;10000;5;1)=13,333.33 currency units. The depreciation amount for the first year is 13,333.33 currency units. To have an overview of depreciation rates per period, it is best to define a depreciation table. By entering the different depreciation formulas available in %PRODUCTNAME Calc next to each other, you can see which depreciation form is the most appropriate. Enter the table as follows: @@ -250,28 +250,28 @@ - A - +A + - B - +B + - C - +C + - D - +D + - E - +E + @@ -280,28 +280,28 @@ - Initial Cost - +Initial Cost + - Salvage Value - +Salvage Value + - Useful Life - +Useful Life + - Time Period - +Time Period + - Deprec. SYD - +Deprec. SYD + @@ -310,28 +310,28 @@ - 50,000 currency units - +50,000 currency units + - 10,000 currency units - +10,000 currency units + - 5 - +5 + - 1 - +1 + - 13,333.33 currency units - +13,333.33 currency units + @@ -346,8 +346,8 @@ - 2 - +2 + @@ -367,13 +367,13 @@ - 3 - +3 + - 8,000.00 currency units - +8,000.00 currency units + @@ -388,13 +388,13 @@ - 4 - +4 + - 5,333.33 currency units - +5,333.33 currency units + @@ -409,13 +409,13 @@ - 5 - +5 + - 2,666.67 currency units - +2,666.67 currency units + @@ -430,13 +430,13 @@ - 6 - +6 + - 0.00 currency units - +0.00 currency units + @@ -451,8 +451,8 @@ - 7 - +7 + @@ -469,8 +469,8 @@ - 8 - +8 + @@ -487,8 +487,8 @@ - 9 - +9 + @@ -505,8 +505,8 @@ - 10 - +10 + @@ -532,8 +532,8 @@ - >0 - +>0 + @@ -541,26 +541,26 @@ - Total - +Total + - 40,000.00 currency units - +40,000.00 currency units +
The formula in E2 is as follows: - =SYD($A$2;$B$2;$C$2;D2) - +=SYD($A$2;$B$2;$C$2;D2) + This formula is duplicated in column E down to E11 (select E2, then drag down the lower right corner with the mouse). Cell E13 contains the formula used to check the total of the depreciation amounts. It uses the SUMIF function as the negative values in E8:E11 must not be considered. The condition >0 is contained in cell A13. The formula in E13 is as follows: - =SUMIF(E2:E11;A13) - +=SUMIF(E2:E11;A13) + Now view the depreciation for a 10 year period, or at a salvage value of 1 currency unit, or enter a different initial cost, and so on.
@@ -576,13 +576,13 @@ oldref="381">Syntax DISC("Settlement"; "Maturity"; Price; Redemption; Basis) - Settlement is the date of purchase of the security. +Settlement is the date of purchase of the security. - Maturity is the date on which the security matures (expires). +Maturity is the date on which the security matures (expires). - Price is the price of the security per 100 currency units of par value. +Price is the price of the security per 100 currency units of par value. - Redemption is the redemption value of the security per 100 currency units of par value. +Redemption is the redemption value of the security per 100 currency units of par value. Example @@ -604,15 +604,15 @@ oldref="404">Syntax DURATION_ADD("Settlement"; "Maturity"; Coupon; Yield; Frequency; Basis) - Settlement is the date of purchase of the security. +Settlement is the date of purchase of the security. - Maturity is the date on which the security matures (expires). +Maturity is the date on which the security matures (expires). - Coupon is the annual coupon interest rate (nominal rate of interest) +Coupon is the annual coupon interest rate (nominal rate of interest) - Yield is the annual yield of the security. +Yield is the annual yield of the security. - Frequency is the number of interest payments per year (1, 2 or 4). +Frequency is the number of interest payments per year (1, 2 or 4). Example @@ -636,14 +636,14 @@ oldref="91">Syntax EFFECTIVE(Nom; P) - Nom is the nominal interest. +Nom is the nominal interest. - P is the number of interest payment periods per year. +P is the number of interest payment periods per year. Example If the annual nominal interest rate is 9.75% and four interest calculation periods are defined, what is the actual interest rate (effective rate)? - =EFFECTIVE(9.75%;4) = 10.11% The annual effective rate is therefore 10.11%. +=EFFECTIVE(9.75%;4) = 10.11% The annual effective rate is therefore 10.11%.
effective interest rates @@ -658,9 +658,9 @@ oldref="416">Syntax EFFECT_ADD(NominalRate; NPerY) - NominalRate is the annual nominal rate of interest. +NominalRate is the annual nominal rate of interest. - NPerY is the number of interest payments per year. +NPerY is the number of interest payments per year. Example What is the effective annual rate of interest for a 5.25% nominal rate and quarterly payment. @@ -682,15 +682,15 @@ oldref="102">Syntax DDB(Cost; Salvage; Life; Period; Factor) - Cost fixes the initial cost of an asset. +Cost fixes the initial cost of an asset. - Salvage fixes the value of an asset at the end of its life. +Salvage fixes the value of an asset at the end of its life. Life is the number of periods (for example, years or months) defining how long the asset is to be used. Period states the period for which the value is to be calculated. - Factor (optional) is the factor by which depreciation decreases. If a value is not entered, the default is factor 2. +Factor (optional) is the factor by which depreciation decreases. If a value is not entered, the default is factor 2. Example A computer system with an initial cost of 75,000 currency units is to be depreciated monthly over 5 years. The value at the end of the depreciation is to be 1 currency unit. The factor is 2. @@ -712,20 +712,20 @@ oldref="116">Syntax DB(Cost; Salvage; Life; Period; Month) - Cost is the initial cost of an asset. +Cost is the initial cost of an asset. - Salvage is the value of an asset at the end of the depreciation. +Salvage is the value of an asset at the end of the depreciation. - Life defines the period over which an asset is depreciated. +Life defines the period over which an asset is depreciated. - Period is the length of each period. The length must be entered in the same date unit as the depreciation period. +Period is the length of each period. The length must be entered in the same date unit as the depreciation period. - Month (optional) denotes the number of months for the first year of depreciation. If an entry is not defined, 12 is used as the default. +Month (optional) denotes the number of months for the first year of depreciation. If an entry is not defined, 12 is used as the default. Example A computer system with an initial cost of 25,000 currency units is to be depreciated over a three year period. The salvage value is to be 1,000 currency units. One period is 30 days. - =DB(25000;1000;36;1;6) = 1,075.00 currency units +=DB(25000;1000;36;1;6) = 1,075.00 currency units The fixed-declining depreciation of the computer system is 1,075.00 currency units.
@@ -741,9 +741,9 @@ oldref="130">Syntax IRR(Values; Guess) - Values represents an array containing the values. +Values represents an array containing the values. - Guess (optional) is the estimated value. An iterative method is used to calculate the internal rate of return. If you can provide only few values, you should provide an initial guess to enable the iteration. +Guess (optional) is the estimated value. An iterative method is used to calculate the internal rate of return. If you can provide only few values, you should provide an initial guess to enable the iteration. Example Under the assumption that cell contents are A1=-10000, A2=3500, A3=7600 and A4=1000, the formula =IRR(A1:A4) gives a result of 80.24%. @@ -761,18 +761,18 @@ oldref="316">Syntax ISPMT(Rate; Period; TotalPeriods; Invest) - Rate sets the periodic interest rate. +Rate sets the periodic interest rate. - Period is the number of installments for calculation of interest. +Period is the number of installments for calculation of interest. - TotalPeriods is the total number of installment periods. +TotalPeriods is the total number of installment periods. - Invest is the amount of the investment. +Invest is the amount of the investment. Example For a credit amount of 120,000 currency units with a two-year term and monthly installments, at a yearly interest rate of 12% the level of interest after 1.5 years is required. - =ISPMT(1%;18;24;120000) = -300 currency units. The monthly interest after 1.5 years amounts to 300 currency units. +=ISPMT(1%;18;24;120000) = -300 currency units. The monthly interest after 1.5 years amounts to 300 currency units.
Financial Functions Part Two diff --git a/helpcontent2/source/text/scalc/01/04060106.xhp b/helpcontent2/source/text/scalc/01/04060106.xhp index 52357b0a82..0774564c79 100644 --- a/helpcontent2/source/text/scalc/01/04060106.xhp +++ b/helpcontent2/source/text/scalc/01/04060106.xhp @@ -3,1458 +3,1425 @@ - +* +* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. +* +* Copyright 2008 by Sun Microsystems, Inc. +* +* OpenOffice.org - a multi-platform office productivity suite +* +* $RCSfile: soffice2xmlhelp.xsl,v $ +* $Revision: 1.12 $ +* +* This file is part of OpenOffice.org. +* +* OpenOffice.org is free software: you can redistribute it and/or modify +* it under the terms of the GNU Lesser General Public License version 3 +* only, as published by the Free Software Foundation. +* +* OpenOffice.org is distributed in the hope that it will be useful, +* but WITHOUT ANY WARRANTY; without even the implied warranty of +* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +* GNU Lesser General Public License version 3 for more details +* (a copy is included in the LICENSE file that accompanied this code). +* +* You should have received a copy of the GNU Lesser General Public License +* version 3 along with OpenOffice.org. If not, see +* +* for a copy of the LGPLv3 License. +* +************************************************************************ +--> - - Mathematical Functions - /text/scalc/01/04060106.xhp - - - + +Mathematical Functions +/text/scalc/01/04060106.xhp + + + mathematical functions - Function Wizard; mathematical - functions; mathematical functions - trigonometric functions -mw added "trigonometric..." +Function Wizard; mathematical +functions; mathematical functions +trigonometric functions + Mathematical Functions - This category contains the Mathematical functions for Calc. +This category contains the Mathematical functions for Calc. To open the Function Wizard, choose Insert - Function.
ABS function - absolute values - values;absolute +absolute values +values;absolute mw added two entries ABS - Returns the absolute value of a number. - Syntax - ABS(Number) - - Number is the number whose absolute value is to be calculated. The absolute value of a number is its value without the +/- sign. - Example - - =ABS(-56) returns 56. - - =ABS(12) returns 12. - - =ABS(0) returns 0.see also SIGN -
-
+oldref="33">ABS +Returns the absolute value of a number. +Syntax +ABS(Number) +Number is the number whose absolute value is to be calculated. The absolute value of a number is its value without the +/- sign. +Example + +=ABS(-56) returns 56. + +=ABS(12) returns 12. + +=ABS(0) returns 0.see also SIGN +
+
COUNTBLANK function - counting;empty cells - empty cells;counting +counting;empty cells +empty cells;counting mw added two entries COUNTBLANK - Returns the number of empty cells. - Syntax - COUNTBLANK(Range) - Returns the number of empty cells in the cell range Range. - Example - - =COUNTBLANK(A1:B2) returns 4 if cells A1, A2, B1, and B2 are all empty.see also COUNTIF -
-
+oldref="42">COUNTBLANK +Returns the number of empty cells. +Syntax +COUNTBLANK(Range) + Returns the number of empty cells in the cell range Range. +Example + +=COUNTBLANK(A1:B2) returns 4 if cells A1, A2, B1, and B2 are all empty.see also COUNTIF +
+
ACOS function ACOS - Returns the inverse trigonometric cosine of a number. - Syntax - ACOS(Number) - This function returns the inverse trigonometric cosine of Number, that is the angle (in radians) whose cosine is Number. The angle returned is between 0 and PI. - To return the angle in degrees, use the DEGREES function. - Example - - =ACOS(-1) returns 3.14159265358979 (PI radians) - - =DEGREES(ACOS(0.5)) returns 60. The cosine of 60 degrees is 0.5.see also COS, SIN, TAN, COT, -ASIN, ATAN, ATAN2, ACOT -
-
+oldref="50">ACOS +Returns the inverse trigonometric cosine of a number. +Syntax +ACOS(Number) + This function returns the inverse trigonometric cosine of Number, that is the angle (in radians) whose cosine is Number. The angle returned is between 0 and PI. +To return the angle in degrees, use the DEGREES function. +Example + +=ACOS(-1) returns 3.14159265358979 (PI radians) + +=DEGREES(ACOS(0.5)) returns 60. The cosine of 60 degrees is 0.5.see also COS, SIN, TAN, COT, ASIN, ATAN, ATAN2, ACOT +
+
ACOSH function ACOSH - Returns the inverse hyperbolic cosine of a number. - Syntax - ACOSH(Number) - This function returns the inverse hyperbolic cosine of Number, that is the number whose hyperbolic cosine is Number. - Number must be greater than or equal to 1. - Example - - =ACOSH(1) returns 0. - - =ACOSH(COSH(4)) returns 4.see also ASINH, ATANH, ACOTH, -COSH, SINH, TANH, COTH +oldref="60">ACOSH +Returns the inverse hyperbolic cosine of a number. +Syntax +ACOSH(Number) + This function returns the inverse hyperbolic cosine of Number, that is the number whose hyperbolic cosine is Number. + Number must be greater than or equal to 1. +Example + +=ACOSH(1) returns 0. + +=ACOSH(COSH(4)) returns 4.see also ASINH, ATANH, ACOTH, COSH, SINH, TANH, COTH
-
+
ACOT function ACOT - Returns the inverse cotangent (the arccotangent) of the given number. - Syntax - ACOT(Number) - This function returns the inverse trigonometric cotangent of Number, that is the angle (in radians) whose cotangent is Number. The angle returned is between 0 and PI. - To return the angle in degrees, use the DEGREES function. - Example - - =ACOT(1) returns 0.785398163397448 (PI/4 radians). - - =DEGREES(ACOT(1)) returns 45. The tangent of 45 degrees is 1. see also COS, SIN, TAN, COT, -ACOS, ASIN, ATAN, ATAN2 -
-
+oldref="70">ACOT +Returns the inverse cotangent (the arccotangent) of the given number. +Syntax +ACOT(Number) + This function returns the inverse trigonometric cotangent of Number, that is the angle (in radians) whose cotangent is Number. The angle returned is between 0 and PI. +To return the angle in degrees, use the DEGREES function. +Example + +=ACOT(1) returns 0.785398163397448 (PI/4 radians). + +=DEGREES(ACOT(1)) returns 45. The tangent of 45 degrees is 1. see also COS, SIN, TAN, COT, ACOS, ASIN, ATAN, ATAN2 +
+
ACOTH function ACOTH - Returns the inverse hyperbolic cotangent of the given number. - Syntax - ACOTH(Number) - This function returns the inverse hyperbolic cotangent of Number, that is the number whose hyperbolic cotangent is Number. - An error results if Number is between -1 and 1 inclusive. - Example - - =ACOTH(1.1) returns inverse hyperbolic cotangent of 1.1, approximately 1.52226.see also ACOSH, ASINH, ATANH, -COSH, SINH, TANH, COTH +oldref="80">ACOTH +Returns the inverse hyperbolic cotangent of the given number. +Syntax +ACOTH(Number) + This function returns the inverse hyperbolic cotangent of Number, that is the number whose hyperbolic cotangent is Number. +An error results if Number is between -1 and 1 inclusive. +Example + +=ACOTH(1.1) returns inverse hyperbolic cotangent of 1.1, approximately 1.52226.see also ACOSH, ASINH, ATANH, COSH, SINH, TANH, COTH
-
+
ASIN function ASIN - Returns the inverse trigonometric sine of a number. - Syntax - ASIN(Number) - This function returns the inverse trigonometric sine of Number, that is the angle (in radians) whose sine is Number. The angle returned is between -PI/2 and +PI/2. - To return the angle in degrees, use the DEGREES function. - Example - - =ASIN(0) returns 0. - - =ASIN(1) returns 1.5707963267949 (PI/2 radians). - - =DEGREES(ASIN(0.5)) returns 30. The sine of 30 degrees is 0.5.see also COS, SIN, TAN, COT, -ACOS, ATAN, ATAN2, ACOT -
-
+oldref="90">ASIN +Returns the inverse trigonometric sine of a number. +Syntax +ASIN(Number) + This function returns the inverse trigonometric sine of Number, that is the angle (in radians) whose sine is Number. The angle returned is between -PI/2 and +PI/2. +To return the angle in degrees, use the DEGREES function. +Example + +=ASIN(0) returns 0. + +=ASIN(1) returns 1.5707963267949 (PI/2 radians). + +=DEGREES(ASIN(0.5)) returns 30. The sine of 30 degrees is 0.5.see also COS, SIN, TAN, COT, ACOS, ATAN, ATAN2, ACOT +
+
ASINH function ASINH - Returns the inverse hyperbolic sine of a number. - Syntax - ASINH(Number) - This function returns the inverse hyperbolic sine of Number, that is the number whose hyperbolic sine is Number. - Example - - =ASINH(-90) returns approximately -5.1929877. - - =ASINH(SINH(4)) returns 4.see also ACOSH, ATANH, ACOTH, +oldref="100">ASINH +Returns the inverse hyperbolic sine of a number. +Syntax +ASINH(Number) + This function returns the inverse hyperbolic sine of Number, that is the number whose hyperbolic sine is Number. +Example + +=ASINH(-90) returns approximately -5.1929877. + +=ASINH(SINH(4)) returns 4.see also ACOSH, ATANH, ACOTH, COSH, SINH, TANH, COTH
-
+
ATAN function ATAN - Returns the inverse trigonometric tangent of a number. - Syntax - ATAN(Number) - This function returns the inverse trigonometric tangent of Number, that is the angle (in radians) whose tangent is Number. The angle returned is between -PI/2 and PI/2. - To return the angle in degrees, use the DEGREES function. - Example - - =ATAN(1) returns 0.785398163397448 (PI/4 radians). - - =DEGREES(ATAN(1)) returns 45. The tangent of 45 degrees is 1.see also COS, SIN, TAN, COT, +oldref="110">ATAN +Returns the inverse trigonometric tangent of a number. +Syntax +ATAN(Number) + This function returns the inverse trigonometric tangent of Number, that is the angle (in radians) whose tangent is Number. The angle returned is between -PI/2 and PI/2. +To return the angle in degrees, use the DEGREES function. +Example + +=ATAN(1) returns 0.785398163397448 (PI/4 radians). + +=DEGREES(ATAN(1)) returns 45. The tangent of 45 degrees is 1.see also COS, SIN, TAN, COT, ACOS, ASIN, ATAN2, ACOT
-
+
ATAN2 function ATAN2 - Returns the inverse trigonometric tangent of the specified x and y coordinates. - Syntax - ATAN2(NumberX; NumberY) - - NumberX is the value of the x coordinate. - - NumberY is the value of the y coordinate. - ATAN2 returns the inverse trigonometric tangent, that is, the angle (in radians) between the x-axis and a line from point NumberX, NumberY to the origin. The angle returned is between -PI and PI. - To return the angle in degrees, use the DEGREES function. - Example - - =ATAN2(20;20) returns 0.785398163397448 (PI/4 radians). - - =DEGREES(ATAN2(12.3;12.3)) returns 45. The tangent of 45 degrees is 1.see also COS, SIN, TAN, COT, +oldref="120">ATAN2 +Returns the inverse trigonometric tangent of the specified x and y coordinates. +Syntax +ATAN2(NumberX; NumberY) +NumberX is the value of the x coordinate. +NumberY is the value of the y coordinate. +ATAN2 returns the inverse trigonometric tangent, that is, the angle (in radians) between the x-axis and a line from point NumberX, NumberY to the origin. The angle returned is between -PI and PI. +To return the angle in degrees, use the DEGREES function. +Example + +=ATAN2(20;20) returns 0.785398163397448 (PI/4 radians). + +=DEGREES(ATAN2(12.3;12.3)) returns 45. The tangent of 45 degrees is 1.see also COS, SIN, TAN, COT, ACOS, ASIN, ATAN, ACOT
-
+
ATANH function ATANH - Returns the inverse hyperbolic tangent of a number. - Syntax - ATANH(Number) - This function returns the inverse hyperbolic tangent of Number, that is the number whose hyperbolic tangent is Number. - Number must obey the condition -1 < number < 1. - Example - - =ATANH(0) returns 0.see also ACOSH, ASINH, ACOTH, +oldref="130">ATANH +Returns the inverse hyperbolic tangent of a number. +Syntax +ATANH(Number) + This function returns the inverse hyperbolic tangent of Number, that is the number whose hyperbolic tangent is Number. + Number must obey the condition -1 < number < 1. +Example + +=ATANH(0) returns 0.see also ACOSH, ASINH, ACOTH, COSH, SINH, TANH, COTH
-
+
COS function COS - Returns the cosine of the given angle (in radians). - Syntax - COS(Number) - Returns the (trigonometric) cosine of Number, the angle in radians. - To return the cosine of an angle in degrees, use the RADIANS function. - Examples - - =COS(PI()/2) returns 0, the cosine of PI/2 radians. - - =COS(RADIANS(60)) returns 0.5, the cosine of 60 degrees.see also SIN, TAN, COT, +oldref="149">COS +Returns the cosine of the given angle (in radians). +Syntax +COS(Number) + Returns the (trigonometric) cosine of Number, the angle in radians. +To return the cosine of an angle in degrees, use the RADIANS function. +Examples + +=COS(PI()/2) returns 0, the cosine of PI/2 radians. + +=COS(RADIANS(60)) returns 0.5, the cosine of 60 degrees.see also SIN, TAN, COT, ACOS, ASIN, ATAN, ATAN2, ACOT
-
+
COSH function COSH - Returns the hyperbolic cosine of a number. - Syntax - COSH(Number) - Returns the hyperbolic cosine of Number. - Example - - =COSH(0) returns 1, the hyperbolic cosine of 0.see also SINH, TANH, COTH, +oldref="159">COSH +Returns the hyperbolic cosine of a number. +Syntax +COSH(Number) +Returns the hyperbolic cosine of Number. +Example + +=COSH(0) returns 1, the hyperbolic cosine of 0.see also SINH, TANH, COTH, ACOSH, ASINH, ATANH, ACOTH,
-
+
COT function COT - Returns the cotangent of the given angle (in radians). - Syntax - COT(Number) - Returns the (trigonometric) cotangent of Number, the angle in radians. - To return the cotangent of an angle in degrees, use the RADIANS function. - The cotangent of an angle is equivalent to 1 divided by the tangent of that angle. - Examples: - - =COT(PI()/4) returns 1, the cotangent of PI/4 radians. - - =COT(RADIANS(45)) returns 1, the cotangent of 45 degrees.see also COS, SIN, TAN, +oldref="169">COT +Returns the cotangent of the given angle (in radians). +Syntax +COT(Number) + Returns the (trigonometric) cotangent of Number, the angle in radians. +To return the cotangent of an angle in degrees, use the RADIANS function. +The cotangent of an angle is equivalent to 1 divided by the tangent of that angle. +Examples: + +=COT(PI()/4) returns 1, the cotangent of PI/4 radians. + +=COT(RADIANS(45)) returns 1, the cotangent of 45 degrees.see also COS, SIN, TAN, ACOS, ASIN, ATAN, ATAN2, ACOT
-
+
COTH function COTH - Returns the hyperbolic cotangent of a given number (angle). - Syntax - COTH(Number) - Returns the hyperbolic cotangent of Number. - Example - - =COTH(1) returns the hyperbolic cotangent of 1, approximately 1.3130.see also COSH, SINH, TANH, +oldref="178">COTH +Returns the hyperbolic cotangent of a given number (angle). +Syntax +COTH(Number) + Returns the hyperbolic cotangent of Number. +Example + +=COTH(1) returns the hyperbolic cotangent of 1, approximately 1.3130.see also COSH, SINH, TANH, ACOSH, ASINH, ATANH, ACOTH,
-
+
DEGREES function - converting;radians, into degrees +converting;radians, into degrees mw added one entry DEGREES - Converts radians into degrees. - Syntax - DEGREES(Number) - - Number is the angle in radians to be converted to degrees. - Example - - =DEGREES(PI()) returns 180 degrees.see also RADIANS -
-
+oldref="188">DEGREES +Converts radians into degrees. +Syntax +DEGREES(Number) +Number is the angle in radians to be converted to degrees. +Example + +=DEGREES(PI()) returns 180 degrees.see also RADIANS +
+
EXP function EXP - Returns e raised to the power of a number. The constant e has a value of approximately 2.71828182845904. - Syntax - EXP(Number) - - Number is the power to which e is to be raised. - Example - - =EXP(1) returns 2.71828182845904, the mathematical constant e to Calc's accuracy.see also POWER, LN, -
-
+oldref="198">EXP +Returns e raised to the power of a number. The constant e has a value of approximately 2.71828182845904. +Syntax +EXP(Number) +Number is the power to which e is to be raised. +Example + +=EXP(1) returns 2.71828182845904, the mathematical constant e to Calc's accuracy.see also POWER, LN, +
+
FACT function - factorials;numbers +factorials;numbers mw added one entry FACT - Returns the factorial of a number. - Syntax - FACT(Number) - Returns Number!, the factorial of Number, calculated as 1*2*3*4* ... * Number. - =FACT(0) returns 1 by definition. - The factorial of a negative number returns the "invalid argument" error. - Example - - =FACT(3) returns 6. - - =FACT(0) returns 1.see also FACTDOUBLE, MULTINOMIAL, PRODUCT -
-
+oldref="208">FACT +Returns the factorial of a number. +Syntax +FACT(Number) + Returns Number!, the factorial of Number, calculated as 1*2*3*4* ... * Number. +=FACT(0) returns 1 by definition. +The factorial of a negative number returns the "invalid argument" error. +Example + +=FACT(3) returns 6. + +=FACT(0) returns 1.see also FACTDOUBLE, MULTINOMIAL, PRODUCT +
+
INT function - numbers;rounding down to next integer - rounding;down to next integer +numbers;rounding down to next integer +rounding;down to next integer mw added two entries INT - Rounds a number down to the nearest integer. - Syntax - INT(Number) - Returns Number rounded down to the nearest integer. - Negative numbers round down to the integer below. - Example - - =INT(5.7) returns 5. - - =INT(-1.3) returns -2.see also TRUNC, ROUND, ROUNDDOWN, ROUNDUP, +oldref="218">INT +Rounds a number down to the nearest integer. +Syntax +INT(Number) +Returns Number rounded down to the nearest integer. +Negative numbers round down to the integer below. +Example + +=INT(5.7) returns 5. + +=INT(-1.3) returns -2.see also TRUNC, ROUND, ROUNDDOWN, ROUNDUP, CEILING, FLOOR, EVEN, ODD, MROUND,
-
+
EVEN function - numbers;rounding up/down to even integers - rounding;up/down to even integers +numbers;rounding up/down to even integers +rounding;up/down to even integers mw added two entries EVEN - Rounds a positive number up to the next even integer and a negative number down to the next even integer. - Syntax - EVEN(Number) - Returns Number rounded to the next even integer up, away from zero. - Examples - - =EVEN(2.3) returns 4. - - =EVEN(2) returns 2. - - =EVEN(0) returns 0. - - =EVEN(-0.5) returns -2.see also CEILING, FLOOR, ODD, MROUND, +oldref="227">EVEN +Rounds a positive number up to the next even integer and a negative number down to the next even integer. +Syntax +EVEN(Number) + Returns Number rounded to the next even integer up, away from zero. +Examples + +=EVEN(2.3) returns 4. + +=EVEN(2) returns 2. + +=EVEN(0) returns 0. + +=EVEN(-0.5) returns -2.see also CEILING, FLOOR, ODD, MROUND, INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP
-
+
GCD function - greatest common divisor +greatest common divisor mw added one entry GCD - Returns the greatest common divisor of two or more integers. - The greatest common divisor is the positive largest integer which will divide, without remainder, each of the given integers. - Syntax - GCD(Integer1; Integer2; ...; Integer30) - - Integer1 To 30 are up to 30 integers whose greatest common divisor is to be calculated. - Example - - =GCD(16;32;24) gives the result 8, because 8 is the largest number that can divide 16, 24 and 32 without a remainder. - - =GCD(B1:B3) where cells B1, B2, B3 contain 9, 12, 9 gives 3. -
-
+oldref="237">GCD +Returns the greatest common divisor of two or more integers. +The greatest common divisor is the positive largest integer which will divide, without remainder, each of the given integers. +Syntax +GCD(Integer1; Integer2; ...; Integer30) +Integer1 To 30 are up to 30 integers whose greatest common divisor is to be calculated. +Example + +=GCD(16;32;24) gives the result 8, because 8 is the largest number that can divide 16, 24 and 32 without a remainder. + +=GCD(B1:B3) where cells B1, B2, B3 contain 9, 12, 9 gives 3. +
+
GCD_ADD function GCD_ADD - The result is the greatest common divisor of a list of numbers. - - Syntax - GCD_ADD(Number(s)) - - Number(s) is a list of up to 30 numbers. - Example - - =GCD_ADD(5;15;25) returns 5. -
-
+oldref="677">GCD_ADD + The result is the greatest common divisor of a list of numbers. + +Syntax +GCD_ADD(Number(s)) +Number(s) is a list of up to 30 numbers. +Example + +=GCD_ADD(5;15;25) returns 5. +
+
ISEVEN function - even integers +even integers mw added one entry ISEVENlink from Information cat - Returns TRUE if the value is an even integer, or FALSE if the value is odd. - Syntax - ISEVEN(Value) - - Value is the value to be checked. - If Value is not an integer any digits after the decimal point are ignored. The sign of Value is also ignored. - Example - - =ISEVEN(48) returns TRUE - - =ISEVEN(33) returns FALSE - - =ISEVEN(0) returns TRUE - - =ISEVEN(-2.1) returns TRUE - - =ISEVEN(3.999) returns FALSEsee also ISODD -
-
+oldref="245">ISEVENlink from Information cat +Returns TRUE if the value is an even integer, or FALSE if the value is odd. +Syntax +ISEVEN(Value) +Value is the value to be checked. +If Value is not an integer any digits after the decimal point are ignored. The sign of Value is also ignored. +Example + +=ISEVEN(48) returns TRUE + +=ISEVEN(33) returns FALSE + +=ISEVEN(0) returns TRUE + +=ISEVEN(-2.1) returns TRUE + +=ISEVEN(3.999) returns FALSEsee also ISODD +
+
ISODD function - odd integers +odd integers mw added one entry ISODDlink from Information cat - Returns TRUE if the value is odd, or FALSE if the number is even. - Syntax - ISODD(value) - - Value is the value to be checked. - If Value is not an integer any digits after the decimal point are ignored. The sign of Value is also ignored. - Example - - =ISODD(33) returns TRUE - - =ISODD(48) returns FALSE - - =ISODD(3.999) returns TRUE - - =ISODD(-3.1) returns TRUEsee also ISEVEN -
-
+oldref="255">ISODDlink from Information cat +Returns TRUE if the value is odd, or FALSE if the number is even. +Syntax +ISODD(value) +Value is the value to be checked. +If Value is not an integer any digits after the decimal point are ignored. The sign of Value is also ignored. +Example + +=ISODD(33) returns TRUE + +=ISODD(48) returns FALSE + +=ISODD(3.999) returns TRUE + +=ISODD(-3.1) returns TRUEsee also ISEVEN +
+
LCM function - least common multiples - lowest common multiples +least common multiples +lowest common multiples mw added two entries LCM - Returns the least common multiple of one or more integers. - Syntax - LCM(Integer1; Integer2; ...; Integer30) - - Integer1 to 30 are up to 30 integers whose lowest common multiple is to be calculated. - Example - If you enter the numbers 512;1024 and 2000 in the Integer 1;2 and 3 text boxes, 128000 will be returned as the result. -
-
+oldref="265">LCM +Returns the least common multiple of one or more integers. +Syntax +LCM(Integer1; Integer2; ...; Integer30) +Integer1 to 30 are up to 30 integers whose lowest common multiple is to be calculated. +Example +If you enter the numbers 512;1024 and 2000 in the Integer 1;2 and 3 text boxes, 128000 will be returned as the result. +
+
LCM_ADD function LCM_ADD - The result is the lowest common multiple of a list of numbers. - - Syntax - LCM_ADD(Number(s)) - - Number(s) is a list of up to 30 numbers. - Example - - =LCM_ADD(5;15;25) returns 75. -
-
+oldref="684">LCM_ADD + The result is the lowest common multiple of a list of numbers. + +Syntax +LCM_ADD(Number(s)) +Number(s) is a list of up to 30 numbers. +Example + +=LCM_ADD(5;15;25) returns 75. +
+
COMBIN function - number of combinations +number of combinations mw added one entry COMBINshould be statistical-->add a link there - Returns the number of combinations for elements without repetition. - Syntax - COMBIN(Count1; Count2) - - Count1 is the number of items in the set. - - Count2 is the number of items to choose from the set. - COMBIN returns the number of ordered ways to choose these items. For example if there are 3 items A, B and C in a set, you can choose 2 items in 3 different ways, namely AB, AC and BC. - COMBIN implements the formula: Count1!/(Count2!*(Count1-Count2)!) - Example - - =COMBIN(3;2) returns 3.see also COMBINA -
-
+oldref="273">COMBINshould be statistical-->add a link there +Returns the number of combinations for elements without repetition. +Syntax +COMBIN(Count1; Count2) +Count1 is the number of items in the set. +Count2 is the number of items to choose from the set. +COMBIN returns the number of ordered ways to choose these items. For example if there are 3 items A, B and C in a set, you can choose 2 items in 3 different ways, namely AB, AC and BC. +COMBIN implements the formula: Count1!/(Count2!*(Count1-Count2)!) +Example + +=COMBIN(3;2) returns 3.see also COMBINA +
+
COMBINA function - number of combinations with repetitions +number of combinations with repetitions mw added one entry COMBINAshould be statistical-->add a link there - Returns the number of combinations of a subset of items including repetitions. - Syntax - COMBINA(Count1; Count2) - - Count1 is the number of items in the set. - - Count2 is the number of items to choose from the set. - COMBINA returns the number of unique ways to choose these items, where the order of choosing is irrelevant, and repetition of items is allowed. For example if there are 3 items A, B and C in a set, you can choose 2 items in 6 different ways, namely AB, BA, AC, CA, BC and CB. - COMBINA implements the formula: (Count1+Count2-1)! / (Count2!(Count1-1)!)i88052 - Example - - =COMBINA(3;2) returns 6.see also COMBIN -
-
+oldref="282">COMBINAshould be statistical-->add a link there +Returns the number of combinations of a subset of items including repetitions. +Syntax +COMBINA(Count1; Count2) +Count1 is the number of items in the set. +Count2 is the number of items to choose from the set. +COMBINA returns the number of unique ways to choose these items, where the order of choosing is irrelevant, and repetition of items is allowed. For example if there are 3 items A, B and C in a set, you can choose 2 items in 6 different ways, namely AB, BA, AC, CA, BC and CB. +COMBINA implements the formula: (Count1+Count2-1)! / (Count2!(Count1-1)!)i88052 +Example + +=COMBINA(3;2) returns 6.see also COMBIN +
+
TRUNC function - decimal places;cutting off +decimal places;cutting off mw added one entry TRUNC - Truncates a number by removing decimal places. - Syntax - TRUNC(Number; Count) - Returns Number with at most Count decimal places. Excess decimal places are simply removed, irrespective of sign. - - TRUNC(Number; 0) behaves as INT(Number) for positive numbers, but effectively rounds towards zero for negative numbers. - The visible decimal places of the result are specified in Tools - Options - %PRODUCTNAME Calc - Calculate. - Example - - =TRUNC(1.239;2) returns 1.23. The 9 is lost. - - =TRUNC(-1.234999;3) returns -1.234. All the 9s are lost.see also INT, ROUND, ROUNDDOWN, ROUNDUP, +oldref="291">TRUNC +Truncates a number by removing decimal places. +Syntax +TRUNC(Number; Count) +Returns Number with at most Count decimal places. Excess decimal places are simply removed, irrespective of sign. + +TRUNC(Number; 0) behaves as INT(Number) for positive numbers, but effectively rounds towards zero for negative numbers. +The visible decimal places of the result are specified in Tools - Options - %PRODUCTNAME Calc - Calculate. +Example + +=TRUNC(1.239;2) returns 1.23. The 9 is lost. + +=TRUNC(-1.234999;3) returns -1.234. All the 9s are lost.see also INT, ROUND, ROUNDDOWN, ROUNDUP, CEILING, FLOOR, EVEN, ODD, MROUND
-
+
LN function - natural logarithm +natural logarithm mw added one entry LN - Returns the natural logarithm based on the constant e of a number. The constant e has a value of approximately 2.71828182845904. - Syntax - LN(Number) - - Number is the value whose natural logarithm is to be calculated. - Example - - =LN(3) returns the natural logarithm of 3 (approximately 1.0986). - - =LN(EXP(321)) returns 321.see also LOG, LOG10, EXP, -
-
+oldref="301">LN +Returns the natural logarithm based on the constant e of a number. The constant e has a value of approximately 2.71828182845904. +Syntax +LN(Number) +Number is the value whose natural logarithm is to be calculated. +Example + +=LN(3) returns the natural logarithm of 3 (approximately 1.0986). + +=LN(EXP(321)) returns 321.see also LOG, LOG10, EXP, +
+
LOG function - logarithms +logarithms mw added one entry LOG - Returns the logarithm of a number to the specified base. - Syntax - LOG(Number; Base) - - Number is the value whose logarithm is to be calculated. - - Base (optional) is the base for the logarithm calculation. If omitted, Base 10 is assumed. - Example - - =LOG(10;3) returns the logarithm to base 3 of 10 (approximately 2.0959). - - =LOG(7^4;7) returns 4.see also LOG10, LN, POWER, -
-
+oldref="311">LOG +Returns the logarithm of a number to the specified base. +Syntax +LOG(Number; Base) +Number is the value whose logarithm is to be calculated. +Base (optional) is the base for the logarithm calculation. If omitted, Base 10 is assumed. +Example + +=LOG(10;3) returns the logarithm to base 3 of 10 (approximately 2.0959). + +=LOG(7^4;7) returns 4.see also LOG10, LN, POWER, +
+
LOG10 function - base-10 logarithm +base-10 logarithm mw added one entry LOG10 - Returns the base-10 logarithm of a number. - Syntax - LOG10(Number) - Returns the logarithm to base 10 of Number. - Example - - =LOG10(5) returns the base-10 logarithm of 5 (approximately 0.69897).see also LOG, LN, POWER -
-
+oldref="322">LOG10 +Returns the base-10 logarithm of a number. +Syntax +LOG10(Number) +Returns the logarithm to base 10 of Number. +Example + +=LOG10(5) returns the base-10 logarithm of 5 (approximately 0.69897).see also LOG, LN, POWER +
+
CEILING function - rounding;up to multiples of significance +rounding;up to multiples of significance mw added one entry CEILING - Rounds a number up to the nearest multiple of Significance. - Syntax - CEILING(Number; Significance; Mode) - - Number is the number that is to be rounded up. - - Significance is the number to whose multiple the value is to be rounded up. - - Mode is an optional value. If the Mode value is given and not equal to zero, and if Number and Significance are negative, then rounding is done based on the absolute value of Number. This parameter is ignored when exporting to MS Excel as Excel does not know any third parameter. - If both parameters Number and Significance are negative and the Mode value is equal to zero or is not given, the results in $[officename] and Excel will differ after the import has been completed. If you export the spreadsheet to Excel, use Mode=1 to see the same results in Excel as in Calc. - Example - - =CEILING(-11;-2) returns -10 - - =CEILING(-11;-2;0) returns -10 - - =CEILING(-11;-2;1) returns -12see also FLOOR, EVEN, ODD, MROUND, +oldref="332">CEILING +Rounds a number up to the nearest multiple of Significance. +Syntax +CEILING(Number; Significance; Mode) +Number is the number that is to be rounded up. +Significance is the number to whose multiple the value is to be rounded up. +Mode is an optional value. If the Mode value is given and not equal to zero, and if Number and Significance are negative, then rounding is done based on the absolute value of Number. This parameter is ignored when exporting to MS Excel as Excel does not know any third parameter. +If both parameters Number and Significance are negative and the Mode value is equal to zero or is not given, the results in $[officename] and Excel will differ after the import has been completed. If you export the spreadsheet to Excel, use Mode=1 to see the same results in Excel as in Calc. +Example + +=CEILING(-11;-2) returns -10 + +=CEILING(-11;-2;0) returns -10 + +=CEILING(-11;-2;1) returns -12see also FLOOR, EVEN, ODD, MROUND, INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP
-
+
PI function PI - Returns 3.14159265358979, the value of the mathematical constant PI to 14 decimal places. - Syntax - PI() - Example - - =PI() returns 3.14159265358979. -
-
+oldref="343">PI +Returns 3.14159265358979, the value of the mathematical constant PI to 14 decimal places. +Syntax +PI() +Example + +=PI() returns 3.14159265358979. +
+
MULTINOMIAL function MULTINOMIAL - Returns the factorial of the sum of the arguments divided by the product of the factorials of the arguments. - Syntax - MULTINOMIAL(Number(s)) - - Number(s) is a list of up to 30 numbers. - Example - - =MULTINOMIAL(F11:H11) returns 1260, if F11 to H11 contain the values 2, 3 and 4. This corresponds to the formula =(2+3+4)! / (2!*3!*4!) -
-
+oldref="635">MULTINOMIAL + Returns the factorial of the sum of the arguments divided by the product of the factorials of the arguments. +Syntax +MULTINOMIAL(Number(s)) +Number(s) is a list of up to 30 numbers. +Example + +=MULTINOMIAL(F11:H11) returns 1260, if F11 to H11 contain the values 2, 3 and 4. This corresponds to the formula =(2+3+4)! / (2!*3!*4!) +
+
POWER function POWER - Returns a number raised to a power. - Syntax - POWER(Base; Power) - Returns Base raised to the power of Power. - The same result may be achieved by using the exponentiation operator ^: - - Base^Power - - Example - - =POWER(4;3) returns 64, which is 4 to the power of 3. - =4^3 also returns 4 to the power of 3.see also EXP, LOG, SQRT -
-
+oldref="350">POWER +Returns a number raised to a power. +Syntax +POWER(Base; Power) +Returns Base raised to the power of Power. +The same result may be achieved by using the exponentiation operator ^: + +Base^Power + +Example + +=POWER(4;3) returns 64, which is 4 to the power of 3. +=4^3 also returns 4 to the power of 3.see also EXP, LOG, SQRT +
+
SERIESSUM function SERIESSUM - Sums the first terms of a power series. - SERIESSUM(x;n;m;coefficients) = coefficient_1*x^n + coefficient_2*x^(n+m) + coefficient_3*x^(n+2m) +...+ coefficient_i*x^(n+(i-1)m) - Syntax - SERIESSUM(X; N; M; Coefficients) - - X is the input value for the power series. - - N is the initial power - - M is the increment to increase N - - Coefficients is a series of coefficients. For each coefficient the series sum is extended by one section. -
-
+oldref="642">SERIESSUM +Sums the first terms of a power series. +SERIESSUM(x;n;m;coefficients) = coefficient_1*x^n + coefficient_2*x^(n+m) + coefficient_3*x^(n+2m) +...+ coefficient_i*x^(n+(i-1)m) +Syntax +SERIESSUM(X; N; M; Coefficients) +X is the input value for the power series. +N is the initial power +M is the increment to increase N +Coefficients is a series of coefficients. For each coefficient the series sum is extended by one section. +
+
PRODUCT function - numbers;multiplying - multiplying;numbers +numbers;multiplying +multiplying;numbers mw added two entries PRODUCT - Multiplies all the numbers given as arguments and returns the product. - Syntax - PRODUCT(Number1; Number2; ...; Number30) - - Number1 to 30 are up to 30 arguments whose product is to be calculated. - PRODUCT returns number1 * number2 * number3 * ... - Example - - =PRODUCT(2;3;4) returns 24.see also FACT, SUM -
-
+oldref="361">PRODUCT +Multiplies all the numbers given as arguments and returns the product. +Syntax +PRODUCT(Number1; Number2; ...; Number30) +Number1 to 30 are up to 30 arguments whose product is to be calculated. +PRODUCT returns number1 * number2 * number3 * ... +Example + +=PRODUCT(2;3;4) returns 24.see also FACT, SUM +
+
SUMSQ function - square number additions - sums;of square numbers +square number additions +sums;of square numbers mw added two entries SUMSQ - If you want to calculate the sum of the squares of numbers (totaling up of the squares of the arguments), enter these into the text fields. - Syntax - SUMSQ(Number1; Number2; ...; Number30) - - Number1 to 30 are up to 30 arguments the sum of whose squares is to be calculated. - Example - If you enter the numbers 2; 3 and 4 in the Number 1; 2 and 3 text boxes, 29 is returned as the result. -
-
+oldref="369">SUMSQ +If you want to calculate the sum of the squares of numbers (totaling up of the squares of the arguments), enter these into the text fields. +Syntax +SUMSQ(Number1; Number2; ...; Number30) +Number1 to 30 are up to 30 arguments the sum of whose squares is to be calculated. +Example +If you enter the numbers 2; 3 and 4 in the Number 1; 2 and 3 text boxes, 29 is returned as the result. +
+
MOD function - remainders of divisions +remainders of divisions mw added one entry MOD - Returns the remainder when one integer is divided by another. - Syntax - MOD(Dividend; Divisor) - For integer arguments this function returns Dividend modulo Divisor, that is the remainder when Dividend is divided by Divisor. - This function is implemented as Dividend - Divisor * INT(Dividend/Divisor) , and this formula gives the result if the arguments are not integer. - Example - - =MOD(22;3) returns 1, the remainder when 22 is divided by 3. - - =MOD(11.25;2.5) returns 1.25.see also QUOTIENT, INT, -
-
+oldref="387">MOD +Returns the remainder when one integer is divided by another. +Syntax +MOD(Dividend; Divisor) + For integer arguments this function returns Dividend modulo Divisor, that is the remainder when Dividend is divided by Divisor. +This function is implemented as Dividend - Divisor * INT(Dividend/Divisor) , and this formula gives the result if the arguments are not integer. +Example + +=MOD(22;3) returns 1, the remainder when 22 is divided by 3. + +=MOD(11.25;2.5) returns 1.25.see also QUOTIENT, INT, +
+
QUOTIENT function - divisions +divisions mw added one entry QUOTIENT - Returns the integer part of a division operation. - Syntax - QUOTIENT(Numerator; Denominator) - Returns the integer part of Numerator divided by Denominator. - QUOTIENT is equivalent to INT(numerator/denominator), except that it may report errors with different error codes. - Example - - =QUOTIENT(11;3) returns 3. The remainder of 2 is lost.see also MOD, INT -
-
+oldref="652">QUOTIENT +Returns the integer part of a division operation. +Syntax +QUOTIENT(Numerator; Denominator) +Returns the integer part of Numerator divided by Denominator. +QUOTIENT is equivalent to INT(numerator/denominator), except that it may report errors with different error codes. +Example + +=QUOTIENT(11;3) returns 3. The remainder of 2 is lost.see also MOD, INT +
+
RADIANS function - converting;degrees, into radians +converting;degrees, into radians mw added one entry RADIANS - Converts degrees to radians. - Syntax - RADIANS(Number) - - Number is the angle in degrees to be converted to radians. - Example - - =RADIANS(90) returns 1.5707963267949, which is PI/2 to Calc's accuracy.see also DEGREES -
-
+oldref="377">RADIANS +Converts degrees to radians. +Syntax +RADIANS(Number) +Number is the angle in degrees to be converted to radians. +Example + +=RADIANS(90) returns 1.5707963267949, which is PI/2 to Calc's accuracy.see also DEGREES +
+
ROUND function -ROUND -Rounds a number to a certain number of decimal places. -Syntax -ROUND(Number; Count) -Returns Number rounded to Count decimal places. If Count is omitted or zero, the function rounds to the nearest integer. If Count is negative, the function rounds to the nearest 10, 100, 1000, etc. -This function rounds to the nearest number. See ROUNDDOWN and ROUNDUP for alternatives. -Example - +ROUND +Rounds a number to a certain number of decimal places. +Syntax +ROUND(Number; Count) +Returns Number rounded to Count decimal places. If Count is omitted or zero, the function rounds to the nearest integer. If Count is negative, the function rounds to the nearest 10, 100, 1000, etc. +This function rounds to the nearest number. See ROUNDDOWN and ROUNDUP for alternatives. +Example + =ROUND(2.348;2) returns 2.35 - + =ROUND(-32.4834;3) returns -32.483. Change the cell format to see all decimals. - + =ROUND(2.348;0) returns 2. - + =ROUND(2.5) returns 3. - + =ROUND(987.65;-2) returns 1000.see also INT, TRUNC, ROUNDDOWN, ROUNDUP, CEILING, FLOOR, EVEN, ODD, MROUND
-
+
ROUNDDOWN function ROUNDDOWN - Rounds a number down, toward zero, to a certain precision. - Syntax - ROUNDDOWN(Number; Count) - Returns Number rounded down (towards zero) to Count decimal places. If Count is omitted or zero, the function rounds down to an integer. If Count is negative, the function rounds down to the next 10, 100, 1000, etc. - This function rounds towards zero. See ROUNDUP and ROUND for alternatives. - Example - - =ROUNDDOWN(1.234;2) returns 1.23. - - =ROUNDDOWN(45.67;0) returns 45. - - =ROUNDDOWN(-45.67) returns -45. - - =ROUNDDOWN(987.65;-2) returns 900.see also INT, TRUNC, ROUND, ROUNDUP, +oldref="24">ROUNDDOWN +Rounds a number down, toward zero, to a certain precision. +Syntax +ROUNDDOWN(Number; Count) +Returns Number rounded down (towards zero) to Count decimal places. If Count is omitted or zero, the function rounds down to an integer. If Count is negative, the function rounds down to the next 10, 100, 1000, etc. +This function rounds towards zero. See ROUNDUP and ROUND for alternatives. +Example + +=ROUNDDOWN(1.234;2) returns 1.23. + +=ROUNDDOWN(45.67;0) returns 45. + +=ROUNDDOWN(-45.67) returns -45. + +=ROUNDDOWN(987.65;-2) returns 900.see also INT, TRUNC, ROUND, ROUNDUP, CEILING, FLOOR, EVEN, ODD, MROUND
-
+
ROUNDUP function ROUNDUP - Rounds a number up, away from zero, to a certain precision. - Syntax - ROUNDUP(Number; Count) - Returns Number rounded up (away from zero) to Count decimal places. If Count is omitted or zero, the function rounds up to an integer. If Count is negative, the function rounds up to the next 10, 100, 1000, etc. - This function rounds away from zero. See ROUNDDOWN and ROUND for alternatives. - Example - - =ROUNDUP(1.1111;2) returns 1.12. - - =ROUNDUP(1.2345;1) returns 1.3. - - =ROUNDUP(45.67;0) returns 46. - - =ROUNDUP(-45.67) returns -46. - - =ROUNDUP(987.65;-2) returns 1000.see also INT, TRUNC, ROUND, ROUNDDOWN, +oldref="140">ROUNDUP +Rounds a number up, away from zero, to a certain precision. +Syntax +ROUNDUP(Number; Count) +Returns Number rounded up (away from zero) to Count decimal places. If Count is omitted or zero, the function rounds up to an integer. If Count is negative, the function rounds up to the next 10, 100, 1000, etc. +This function rounds away from zero. See ROUNDDOWN and ROUND for alternatives. +Example + +=ROUNDUP(1.1111;2) returns 1.12. + +=ROUNDUP(1.2345;1) returns 1.3. + +=ROUNDUP(45.67;0) returns 46. + +=ROUNDUP(-45.67) returns -46. + +=ROUNDUP(987.65;-2) returns 1000.see also INT, TRUNC, ROUND, ROUNDDOWN, CEILING, FLOOR, EVEN, ODD, MROUND
-
+
SIN function SIN - Returns the sine of the given angle (in radians). - Syntax - SIN(Number) - Returns the (trigonometric) sine of Number, the angle in radians. - To return the sine of an angle in degrees, use the RADIANS function. - Example - - =SIN(PI()/2) returns 1, the sine of PI/2 radians. - - =SIN(RADIANS(30)) returns 0.5, the sine of 30 degrees.see also COS, TAN, COT, +oldref="408">SIN +Returns the sine of the given angle (in radians). +Syntax +SIN(Number) +Returns the (trigonometric) sine of Number, the angle in radians. +To return the sine of an angle in degrees, use the RADIANS function. +Example + +=SIN(PI()/2) returns 1, the sine of PI/2 radians. + +=SIN(RADIANS(30)) returns 0.5, the sine of 30 degrees.see also COS, TAN, COT, ACOS, ASIN, ATAN, ATAN2, ACOT
-
+
SINH function SINH - Returns the hyperbolic sine of a number. - Syntax - SINH(Number) - Returns the hyperbolic sine of Number. - Example - - =SINH(0) returns 0, the hyperbolic sine of 0.see also COSH, TANH, COTH, +oldref="418">SINH +Returns the hyperbolic sine of a number. +Syntax +SINH(Number) +Returns the hyperbolic sine of Number. +Example + +=SINH(0) returns 0, the hyperbolic sine of 0.see also COSH, TANH, COTH, ACOSH, ASINH, ATANH, ACOTH
-
+
SUM function - adding;numbers in cell ranges +adding;numbers in cell ranges mw added one entry SUM - Adds all the numbers in a range of cells. - Syntax - SUM(Number1; Number2; ...; Number30) - - Number 1 to Number 30 are up to 30 arguments whose sum is to be calculated. - Example - If you enter the numbers 2; 3 and 4 in the Number 1; 2 and 3 text boxes, 9 will be returned as the result. - - =SUM(A1;A3;B5) calculates the sum of the three cells. =SUM (A1:E10) calculates the sum of all cells in the A1 to E10 cell range. - Conditions linked by AND can be used with the function SUM() in the following manner: - Example assumption: You have entered invoices into a table. Column A contains the date value of the invoice, column B the amounts. You want to find a formula that you can use to return the total of all amounts only for a specific month, e.g. only the amount for the period >=2008-01-01 to <2008-02-01. The range with the date values covers A1:A40, the range containing the amounts to be totaled is B1:B40. C1 contains the start date, 2008-01-01, of the invoices to be included and C2 the date, 2008-02-01, that is no longer included. - Enter the following formula as an array formula: - - =SUM((A1:A40>=C1)*(A1:A40<C2)*B1:B40) - - In order to enter this as an array formula, you must press the Shift+Command +oldref="428">SUM +Adds all the numbers in a range of cells. +Syntax +SUM(Number1; Number2; ...; Number30) +Number 1 to Number 30 are up to 30 arguments whose sum is to be calculated. +Example +If you enter the numbers 2; 3 and 4 in the Number 1; 2 and 3 text boxes, 9 will be returned as the result. + +=SUM(A1;A3;B5) calculates the sum of the three cells. =SUM (A1:E10) calculates the sum of all cells in the A1 to E10 cell range. +Conditions linked by AND can be used with the function SUM() in the following manner: +Example assumption: You have entered invoices into a table. Column A contains the date value of the invoice, column B the amounts. You want to find a formula that you can use to return the total of all amounts only for a specific month, e.g. only the amount for the period >=2008-01-01 to <2008-02-01. The range with the date values covers A1:A40, the range containing the amounts to be totaled is B1:B40. C1 contains the start date, 2008-01-01, of the invoices to be included and C2 the date, 2008-02-01, that is no longer included. +Enter the following formula as an array formula: + +=SUM((A1:A40>=C1)*(A1:A40<C2)*B1:B40) + +In order to enter this as an array formula, you must press the Shift+Command + Ctrl+ Enter keys instead of simply pressing the Enter key to close the formula. The formula will then be shown in the Formula bar enclosed in braces. - {=SUM((A1:A40>=C1)*(A1:A40<C2)*B1:B40)} - The formula is based on the fact that the result of a comparison is 1 if the criterion is met and 0 if it is not met. The individual comparison results will be treated as an array and used in matrix multiplication, and at the end the individual values will be totaled to give the result matrix. -
-
+{=SUM((A1:A40>=C1)*(A1:A40<C2)*B1:B40)} +The formula is based on the fact that the result of a comparison is 1 if the criterion is met and 0 if it is not met. The individual comparison results will be treated as an array and used in matrix multiplication, and at the end the individual values will be totaled to give the result matrix. +
+
SUMIF function - adding;specified numbers +adding;specified numbers mw added one entry SUMIF - Adds the cells specified by a given criteria. This function is used to browse a range when you search for a certain value. - - Syntax - SUMIF(Range; Criteria; SumRange) - - Range is the range to which the criteria are to be applied. - - Criteria is the cell in which the search criterion is shown, or the search criterion itself. If the criteria is written into the formula, it has to be surrounded by double quotes. - - SumRange is the range from which values are summed. If this parameter has not been indicated, the values found in the Range are summed. - SUMIF supports the reference concatenation operator (~) only in the Criteria parameter, and only if the optional SumRange parameter is not given. - Example - To sum up only negative numbers: =SUMIF(A1:A10;"<0") - - - =SUMIF(A1:A10;">0";B1:10) - sums values from the range B1:B10 only if the corresponding values in the range A1:A10 are >0. - See COUNTIF() for some more syntax examples that can be used with SUMIF(). -
-
+oldref="436">SUMIF +Adds the cells specified by a given criteria. This function is used to browse a range when you search for a certain value. + +Syntax +SUMIF(Range; Criteria; SumRange) +Range is the range to which the criteria are to be applied. +Criteria is the cell in which the search criterion is shown, or the search criterion itself. If the criteria is written into the formula, it has to be surrounded by double quotes. +SumRange is the range from which values are summed. If this parameter has not been indicated, the values found in the Range are summed. +SUMIF supports the reference concatenation operator (~) only in the Criteria parameter, and only if the optional SumRange parameter is not given. +Example +To sum up only negative numbers: =SUMIF(A1:A10;"<0") + + +=SUMIF(A1:A10;">0";B1:10) - sums values from the range B1:B10 only if the corresponding values in the range A1:A10 are >0. +See COUNTIF() for some more syntax examples that can be used with SUMIF(). +
+
TAN function TAN - Returns the tangent of the given angle (in radians). - Syntax - TAN(Number) - Returns the (trigonometric) tangent of Number, the angle in radians. - To return the tangent of an angle in degrees, use the RADIANS function. - Example - - =TAN(PI()/4) returns 1, the tangent of PI/4 radians. - - =TAN(RADIANS(45)) returns 1, the tangent of 45 degrees.see also COS, SIN, COT, +oldref="446">TAN +Returns the tangent of the given angle (in radians). +Syntax +TAN(Number) +Returns the (trigonometric) tangent of Number, the angle in radians. +To return the tangent of an angle in degrees, use the RADIANS function. +Example + +=TAN(PI()/4) returns 1, the tangent of PI/4 radians. + +=TAN(RADIANS(45)) returns 1, the tangent of 45 degrees.see also COS, SIN, COT, ACOS, ASIN, ATAN, ATAN2, ACOT
-
+
TANH function TANH - Returns the hyperbolic tangent of a number. - Syntax - TANH(Number) - Returns the hyperbolic tangent of Number. - Example - - =TANH(0) returns 0, the hyperbolic tangent of 0.see also COSH, SINH, COTH, +oldref="456">TANH +Returns the hyperbolic tangent of a number. +Syntax +TANH(Number) +Returns the hyperbolic tangent of Number. +Example + +=TANH(0) returns 0, the hyperbolic tangent of 0.see also COSH, SINH, COTH, ACOSH, ASINH, ATANH, ACOTH
-
+
AutoFilter function; subtotals - sums;of filtered data - filtered data; sums - SUBTOTAL function +sums;of filtered data +filtered data; sums +SUBTOTAL function mw made "sums..." a two level entry SUBTOTAL - Calculates subtotals. If a range already contains subtotals, these are not used for further calculations. Use this function with the AutoFilters to take only the filtered records into account. - Syntax - SUBTOTAL(Function; Range) - - Function is a number that stands for one of the following functions: - - - - Function index - - - Function - - - - - 1 - - - AVERAGE - - - - - 2 - - - COUNT - - - - - 3 - - - COUNTA - - - - - 4 - - - MAX - - - - - 5 - - - MIN - - - - - 6 - - - PRODUCT - - - - - 7 - - - STDEV - - - - - 8 - - - STDEVP - - - - - 9 - - - SUM - - - - - 10 - - - VAR - - - - - 11 - - - VARP - - -
+oldref="466">SUBTOTAL +Calculates subtotals. If a range already contains subtotals, these are not used for further calculations. Use this function with the AutoFilters to take only the filtered records into account. +Syntax +SUBTOTAL(Function; Range) +Function is a number that stands for one of the following functions: + + + +Function index + + +Function + + + + +1 + + +AVERAGE + + + + +2 + + +COUNT + + + + +3 + + +COUNTA + + + + +4 + + +MAX + + + + +5 + + +MIN + + + + +6 + + +PRODUCT + + + + +7 + + +STDEV + + + + +8 + + +STDEVP + + + + +9 + + +SUM + + + + +10 + + +VAR + + + + +11 + + +VARP + + +
- - Range is the range whose cells are included. - Example - You have a table in the cell range A1:B5 containing cities in column A and accompanying figures in column B. You have used an AutoFilter so that you only see rows containing the city Hamburg. You want to see the sum of the figures that are displayed; that is, just the subtotal for the filtered rows. In this case the correct formula would be: - - =SUBTOTAL(9;B2:B5) - -
-
+Range is the range whose cells are included. +Example +You have a table in the cell range A1:B5 containing cities in column A and accompanying figures in column B. You have used an AutoFilter so that you only see rows containing the city Hamburg. You want to see the sum of the figures that are displayed; that is, just the subtotal for the filtered rows. In this case the correct formula would be: + +=SUBTOTAL(9;B2:B5) + +
+
Euro; converting - EUROCONVERT function +EUROCONVERT function EUROCONVERTinsert link in financial - Converts between old European national currency and to and from Euros. - - Syntax - - EUROCONVERT(Value; "From_currency"; "To_currency", full_precision, triangulation_precision) - - Value is the amount of the currency to be converted. - - From_currency and To_currency are the currency units to convert from and to respectively. These must be text, the official abbreviation for the currency (for example, "EUR"). The rates (shown per Euro) were set by the European Commission. - - Full_precision is optional. If omitted or False, the result is rounded according to the decimals of the To currency. If Full_precision is True, the result is not rounded. - - Triangulation_precision is optional. If Triangulation_precision is given and >=3, the intermediate result of a triangular conversion (currency1,EUR,currency2) is rounded to that precision. If Triangulation_precision is omitted, the intermediate result is not rounded. Also if To currency is "EUR", Triangulation_precision is used as if triangulation was needed and conversion from EUR to EUR was applied. - - Examples - - - =EUROCONVERT(100;"ATS";"EUR") converts 100 Austrian Schillings into Euros. - - =EUROCONVERT(100;"EUR";"DEM") converts 100 Euros into German Marks. -
-
+oldref="564">EUROCONVERTinsert link in financial +Converts between old European national currency and to and from Euros. +Syntax + +EUROCONVERT(Value; "From_currency"; "To_currency", full_precision, triangulation_precision) +Value is the amount of the currency to be converted. +From_currency and To_currency are the currency units to convert from and to respectively. These must be text, the official abbreviation for the currency (for example, "EUR"). The rates (shown per Euro) were set by the European Commission. +Full_precision is optional. If omitted or False, the result is rounded according to the decimals of the To currency. If Full_precision is True, the result is not rounded. +Triangulation_precision is optional. If Triangulation_precision is given and >=3, the intermediate result of a triangular conversion (currency1,EUR,currency2) is rounded to that precision. If Triangulation_precision is omitted, the intermediate result is not rounded. Also if To currency is "EUR", Triangulation_precision is used as if triangulation was needed and conversion from EUR to EUR was applied. +Examples + + +=EUROCONVERT(100;"ATS";"EUR") converts 100 Austrian Schillings into Euros. + +=EUROCONVERT(100;"EUR";"DEM") converts 100 Euros into German Marks. +
+
+CONVERT function + + +CONVERT +Converts a value from one unit of measurement to another unit of measurement. The conversion factors are given in a list in the configuration. +At one time the list of conversion factors included the legacy European currencies and the Euro (see examples below). We suggest using the new function EUROCONVERT for converting these currencies. +Syntax +CONVERT(value;"text";"text") +Example + +=CONVERT(100;"ATS";"EUR") returns the Euro value of 100 Austrian Schillings. +=CONVERT(100;"EUR";"DEM") converts 100 Euros into German Marks. +
+
ODD function - rounding;up/down to nearest odd integer +rounding;up/down to nearest odd integer mw added one entry ODD - Rounds a positive number up to the nearest odd integer and a negative number down to the nearest odd integer. - Syntax - ODD(Number) - Returns Number rounded to the next odd integer up, away from zero. - Example - - =ODD(1.2) returns 3. - - =ODD(1) returns 1. - - =ODD(0) returns 1. - - =ODD(-3.1) returns -5.see also CEILING, FLOOR, EVEN, MROUND, +oldref="502">ODD +Rounds a positive number up to the nearest odd integer and a negative number down to the nearest odd integer. +Syntax +ODD(Number) + Returns Number rounded to the next odd integer up, away from zero. +Example + +=ODD(1.2) returns 3. + +=ODD(1) returns 1. + +=ODD(0) returns 1. + +=ODD(-3.1) returns -5.see also CEILING, FLOOR, EVEN, MROUND, INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP
-
+
FLOOR function - rounding;down to nearest multiple of significance +rounding;down to nearest multiple of significance mw added one entry FLOOR - Rounds a number down to the nearest multiple of Significance. - Syntax - FLOOR(Number; Significance; Mode) - - Number is the number that is to be rounded down. - - Significance is the value to whose multiple the number is to be rounded down. - - Mode is an optional value. If the Mode value is given and not equal to zero, and if Number and Significance are negative, then rounding is done based on the absolute value of the number. This parameter is ignored when exporting to MS Excel as Excel does not know any third parameter. - If both parameters Number and Significance are negative, and if the Mode value is equal to zero or is not specified, then the results in $[officename] Calc and Excel will differ after exporting. If you export the spreadsheet to Excel, use Mode=1 to see the same results in Excel as in Calc. - Example - - =FLOOR( -11;-2) returns -12 - - =FLOOR( -11;-2;0) returns -12 - - =FLOOR( -11;-2;1) returns -10see also CEILING, EVEN, ODD, MROUND, +oldref="512">FLOOR +Rounds a number down to the nearest multiple of Significance. +Syntax +FLOOR(Number; Significance; Mode) +Number is the number that is to be rounded down. +Significance is the value to whose multiple the number is to be rounded down. +Mode is an optional value. If the Mode value is given and not equal to zero, and if Number and Significance are negative, then rounding is done based on the absolute value of the number. This parameter is ignored when exporting to MS Excel as Excel does not know any third parameter. +If both parameters Number and Significance are negative, and if the Mode value is equal to zero or is not specified, then the results in $[officename] Calc and Excel will differ after exporting. If you export the spreadsheet to Excel, use Mode=1 to see the same results in Excel as in Calc. +Example + +=FLOOR( -11;-2) returns -12 + +=FLOOR( -11;-2;0) returns -12 + +=FLOOR( -11;-2;1) returns -10see also CEILING, EVEN, ODD, MROUND, INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP,
-
+
SIGN function - algebraic signs +algebraic signs mw added one entry SIGN - Returns the sign of a number. Returns 1 if the number is positive, -1 if negative and 0 if zero. - Syntax - SIGN(Number) - - Number is the number whose sign is to be determined. - Example - - =SIGN(3.4) returns 1. - - =SIGN(-4.5) returns -1.see also ABS -
-
+oldref="523">SIGN +Returns the sign of a number. Returns 1 if the number is positive, -1 if negative and 0 if zero. +Syntax +SIGN(Number) +Number is the number whose sign is to be determined. +Example + +=SIGN(3.4) returns 1. + +=SIGN(-4.5) returns -1.see also ABS +
+
MROUND function - nearest multiple +nearest multiple mw added one entry MROUND - Returns a number rounded to the nearest multiple of another number. - Syntax - MROUND(Number; Multiple) - Returns Number rounded to the nearest multiple of Multiple. - An alternative implementation would be Multiple * ROUND(Number/Multiple). - Example - - =MROUND(15.5;3) returns 15, as 15.5 is closer to 15 (= 3*5) than to 18 (= 3*6). - - =MROUND(1.4;0.5) returns 1.5 (= 0.5*3).see also CEILING, FLOOR, EVEN, ODD, +oldref="658">MROUND +Returns a number rounded to the nearest multiple of another number. +Syntax +MROUND(Number; Multiple) +Returns Number rounded to the nearest multiple of Multiple. +An alternative implementation would be Multiple * ROUND(Number/Multiple). +Example + +=MROUND(15.5;3) returns 15, as 15.5 is closer to 15 (= 3*5) than to 18 (= 3*6). + +=MROUND(1.4;0.5) returns 1.5 (= 0.5*3).see also CEILING, FLOOR, EVEN, ODD, INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP
-
+
SQRT function - square roots;positive numbers +square roots;positive numbers mw added one entry SQRT - Returns the positive square root of a number. - Syntax - SQRT(Number) - Returns the positive square root of Number. - Number must be positive. - Example - - =SQRT(16) returns 4. - - =SQRT(-16) returns an invalid argument error.see also SQRTPI, POWER -
-
+oldref="532">SQRT +Returns the positive square root of a number. +Syntax +SQRT(Number) +Returns the positive square root of Number. + Number must be positive. +Example + +=SQRT(16) returns 4. + +=SQRT(-16) returns an invalid argument error.see also SQRTPI, POWER +
+
SQRTPI function - square roots;products of Pi +square roots;products of Pi mw added one entry SQRTPI - Returns the square root of (PI times a number). - Syntax - SQRTPI(Number) - Returns the positive square root of (PI multiplied by Number). - This is equivalent to SQRT(PI()*Number). - Example - - =SQRTPI(2) returns the squareroot of (2PI), approximately 2.506628.see also SQRT -
-
+oldref="665">SQRTPI +Returns the square root of (PI times a number). +Syntax +SQRTPI(Number) +Returns the positive square root of (PI multiplied by Number). +This is equivalent to SQRT(PI()*Number). +Example + +=SQRTPI(2) returns the squareroot of (2PI), approximately 2.506628.see also SQRT +
+
random numbers; between limits - RANDBETWEEN function +RANDBETWEEN function mw changed "random numbers;" RANDBETWEEN - Returns an integer random number in a specified range. - Syntax - RANDBETWEEN(Bottom; Top) - Returns an integer random number between integers Bottom and Top (both inclusive). - This function produces a new random number each time Calc recalculates. To force Calc to recalculate manually press Shift+Command +oldref="671">RANDBETWEEN +Returns an integer random number in a specified range. +Syntax +RANDBETWEEN(Bottom; Top) +Returns an integer random number between integers Bottom and Top (both inclusive). +This function produces a new random number each time Calc recalculates. To force Calc to recalculate manually press Shift+Command Ctrl+F9. - To generate random numbers which never recalculate, copy cells containing this function, and use Edit - Paste Special (with Paste All and Formulas not marked and Numbers marked). - Example - - =RANDBETWEEN(20;30) returns an integer of between 20 and 30.see also RAND +To generate random numbers which never recalculate, copy cells containing this function, and use Edit - Paste Special (with Paste All and Formulas not marked and Numbers marked). +Example + +=RANDBETWEEN(20;30) returns an integer of between 20 and 30.see also RAND
-
+
RAND function - random numbers;between 0 and 1 +random numbers;between 0 and 1 mw added one entry RAND - Returns a random number between 0 and 1.The value of 0 can be returned, the value of 1 not.this is really true after issue 53642 will be fixed - Syntax - RAND() - This function produces a new random number each time Calc recalculates. To force Calc to recalculate manually press Shift+Command +oldref="542">RAND +Returns a random number between 0 and 1.The value of 0 can be returned, the value of 1 not.this is really true after issue 53642 will be fixed +Syntax +RAND() +This function produces a new random number each time Calc recalculates. To force Calc to recalculate manually press Shift+Command Ctrl+F9. - To generate random numbers which never recalculate, copy cells each containing =RAND(), and use Edit - Paste Special (with Paste All and Formulas not marked and Numbers marked). - Example - - =RAND() returns a random number between 0 and 1.see also RANDBETWEEN +To generate random numbers which never recalculate, copy cells each containing =RAND(), and use Edit - Paste Special (with Paste All and Formulas not marked and Numbers marked). +Example + +=RAND() returns a random number between 0 and 1.see also RANDBETWEEN
-
+
COUNTIF function - counting;specified cells +counting;specified cells mw added one entry -COUNTIF -Returns the number of cells that meet with certain criteria within a cell range. +COUNTIF +Returns the number of cells that meet with certain criteria within a cell range. -Syntax -COUNTIF(Range; Criteria) - -Range is the range to which the criteria are to be applied. - -Criteria indicates the criteria in the form of a number, an expression or a character string. These criteria determine which cells are counted. You may also enter a search text in the form of a regular expression, e.g. b.* for all words that begin with b. You may also indicate a cell range that contains the search criterion. If you search for literal text, enclose the text in double quotes. -Example -A1:A10 is a cell range containing the numbers 2000 to 2009. Cell B1 contains the number 2006. In cell B2, you enter a formula: - +Syntax +COUNTIF(Range; Criteria) +Range is the range to which the criteria are to be applied. +Criteria indicates the criteria in the form of a number, an expression or a character string. These criteria determine which cells are counted. You may also enter a search text in the form of a regular expression, e.g. b.* for all words that begin with b. You may also indicate a cell range that contains the search criterion. If you search for literal text, enclose the text in double quotes. +Example +A1:A10 is a cell range containing the numbers 2000 to 2009. Cell B1 contains the number 2006. In cell B2, you enter a formula: + =COUNTIF(A1:A10;2006) - this returns 1 - + =COUNTIF(A1:A10;B1) - this returns 1 - + =COUNTIF(A1:A10;">=2006") - this returns 4 - + =COUNTIF(A1:A10;"<"&B1) - when B1 contains 2006, this returns 6 - + =COUNTIF(A1:A10;C2) where cell C2 contains the text >2006 counts the number of cells in the range A1:A10 which are >2006 -To count only negative numbers: =COUNTIF(A1:A10;"<0") +To count only negative numbers: =COUNTIF(A1:A10;"<0")
- -
- + +
+ \ No newline at end of file diff --git a/helpcontent2/source/text/scalc/01/04060109.xhp b/helpcontent2/source/text/scalc/01/04060109.xhp index 2e056abf28..ab90880518 100644 --- a/helpcontent2/source/text/scalc/01/04060109.xhp +++ b/helpcontent2/source/text/scalc/01/04060109.xhp @@ -571,17 +571,19 @@ HYPERLINK When you click a cell that contains the HYPERLINK function, the hyperlink opens. - If you use the optional cell text parameter, the formula locates the URL, and then displays the text. + If you use the optional CellText parameter, the formula locates the URL, and then displays the text or number. To open a hyperlinked cell with the keyboard, select the cell, press F2 to enter the Edit mode, move the cursor in front of the hyperlink, press Shift+F10, and then choose Open Hyperlink. Syntax HYPERLINK("URL") or HYPERLINK("URL"; "CellText") - - URL specifies the link target. The optional CellText parameter is the text that is displayed in the cell and the result of the function. If the CellText parameter is not specified, the URL is displayed in the cell text and in the result of the function. + + URL specifies the link target. The optional CellText parameter is the text or a number that is displayed in the cell and will be returned as the result. If the CellText parameter is not specified, the URL is displayed in the cell text and will be returned as the result. + The number 0 is returned for empty cells and matrix elements. Example =HYPERLINK("http://www.example.org") displays the text "http://www.example.org" in the cell and executes the hyperlink http://www.example.org when clicked. =HYPERLINK("http://www.example.org";"Click here") displays the text "Click here" in the cell and executes the hyperlink http://www.example.org when clicked. + =HYPERLINK("http://www.example.org";12345) displays the number 12345 and executes the hyperlink http://www.example.org when clicked. =HYPERLINK($B4) where cell B4 contains http://www.example.org. The function adds http://www.example.org to the URL of the hyperlink cell and returns the same text which is used as formula result. @@ -589,7 +591,7 @@ =HYPERLINK("#Sheet1.A1";"Go to top") displays the text Go to top and jumps to cell Sheet1.A1 in this document. - =HYPERLINK("file:///C:/writer.odt#Specification";"Go to Writer bookmark") displays the text Go to Writer bookmark, loads the specified text document and jumps to bookmark "Specification". + =HYPERLINK("file:///C:/writer.odt#Specification";"Go to Writer bookmark")displays the text Go to Writer bookmark, loads the specified text document and jumps to bookmark "Specification".
GETPIVOTDATA function diff --git a/helpcontent2/source/text/scalc/01/04060110.xhp b/helpcontent2/source/text/scalc/01/04060110.xhp index 4cebc8fbbb..94801039de 100644 --- a/helpcontent2/source/text/scalc/01/04060110.xhp +++ b/helpcontent2/source/text/scalc/01/04060110.xhp @@ -10,8 +10,8 @@ * * OpenOffice.org - a multi-platform office productivity suite * - * $RCSfile: 04060110.xhp,v $ - * $Revision: 1.17.4.1 $ + * $RCSfile: soffice2xmlhelp.xsl,v $ + * $Revision: 1.12 $ * * This file is part of OpenOffice.org. * @@ -35,534 +35,633 @@ - -Text Functions -/text/scalc/01/04060110.xhp - - - + + Text Functions + /text/scalc/01/04060110.xhp + + + text in cells; functions -functions; text functions -Function Wizard;text + functions; text functions + Function Wizard;text -Text Functions -This section contains descriptions of the Text functions. +Text Functions + This section contains descriptions of the Text functions. -
- -
+
+ +
ARABIC function -ARABIC -Calculates the value of a Roman number. The value range must be between 0 and 3999. -Syntax -ARABIC("Text") - -Text is the text that represents a Roman number. -Example - -=ARABIC("MXIV") returns 1014 - -=ARABIC("MMII") returns 2002 -
-
+ARABIC + Calculates the value of a Roman number. The value range must be between 0 and 3999. + Syntax + ARABIC("Text") + + Text is the text that represents a Roman number. + Example + + =ARABIC("MXIV") returns 1014 + + =ARABIC("MMII") returns 2002 +
+
ASC function i79585 -ASC -The ASC function converts full-width to half-width ASCII and katakana characters. Returns a text string. -See http://wiki.services.openoffice.org/mwiki/index.php?title=Calc/Features/JIS_and_ASC_functions for a conversion table. -Syntax -ASC("Text") - -Text is the text that contains characters to be converted. -See also JIS function. -
-
+ASC + The ASC function converts full-width to half-width ASCII and katakana characters. Returns a text string. + See http://wiki.services.openoffice.org/mwiki/index.php?title=Calc/Features/JIS_and_ASC_functions for a conversion table. + Syntax + ASC("Text") + + Text is the text that contains characters to be converted. + See also JIS function. +
+
BAHTTEXT function i66350 -BAHTTEXT -Converts a number to Thai text, including the Thai currency names. -Syntax -BAHTTEXT(Number) - -Number is any number. "Baht" is appended to the integral part of the number, and "Satang" is appended to the decimal part of the number. -Example - -=BAHTTEXT(12.65) returns a string in Thai characters with the meaning of "Twelve Baht and sixty five Satang". -
-
+BAHTTEXT + Converts a number to Thai text, including the Thai currency names. + Syntax + BAHTTEXT(Number) + + Number is any number. "Baht" is appended to the integral part of the number, and "Satang" is appended to the decimal part of the number. + Example + + =BAHTTEXT(12.65) returns a string in Thai characters with the meaning of "Twelve Baht and sixty five Satang". +
+
BASE function -BASE -Converts a positive integer to a specified base into a text from the numbering system. The digits 0-9 and the letters A-Z are used. -Syntax -BASE(Number; Radix; [MinimumLength]) - -Number is the positive integer to be converted. - -Radix indicates the base of the number system. It may be any positive integer between 2 and 36. - -MinimumLength (optional) determines the minimum length of the character sequence that has been created. If the text is shorter than the indicated minimum length, zeros are added to the left of the string. -Example +BASE + Converts a positive integer to a specified base into a text from the numbering system. The digits 0-9 and the letters A-Z are used. + Syntax + BASE(Number; Radix; [MinimumLength]) + + Number is the positive integer to be converted. + + Radix indicates the base of the number system. It may be any positive integer between 2 and 36. + + MinimumLength (optional) determines the minimum length of the character sequence that has been created. If the text is shorter than the indicated minimum length, zeros are added to the left of the string. + Example decimal system; converting to - -=BASE(17;10;4) returns 0017 in the decimal system. + + =BASE(17;10;4) returns 0017 in the decimal system. binary system; converting to - -=BASE(17;2) returns 10001 in the binary system. + + =BASE(17;2) returns 10001 in the binary system. hexadecimal system; converting to - -=BASE(255;16;4) returns 00FF in the hexadecimal system. -
-
+ + =BASE(255;16;4) returns 00FF in the hexadecimal system. +
+
CHAR function -CHAR -Converts a number into a character according to the current code table. The number can be a two-digit or three-digit integer number. - -Syntax -CHAR(Number) - -Number is a number between 1 and 255 representing the code value for the character. -Example - -=CHAR(100) returns the character d. -
-
+CHAR + Converts a number into a character according to the current code table. The number can be a two-digit or three-digit integer number. + + Syntax + CHAR(Number) + + Number is a number between 1 and 255 representing the code value for the character. + Example + + =CHAR(100) returns the character d. + ="abc" & CHAR(10) & "def" inserts a newline character into the string. +
+
CLEAN function -CLEAN -All non-printing characters are removed from the string. -Syntax -CLEAN("Text") - -Text refers to the text from which to remove all non-printable characters. -
-
+CLEAN + All non-printing characters are removed from the string. + Syntax + CLEAN("Text") + + Text refers to the text from which to remove all non-printable characters. +
+
CODE function -CODE -Returns a numeric code for the first character in a text string. -Syntax -CODE("Text") - -Text is the text for which the code of the first character is to be found. - -Example - -=CODE("Hieronymus") returns 72, =CODE("hieroglyphic") returns 104. -The code used here does not refer to ASCII, but to the code table currently loaded. -
-
+CODE + Returns a numeric code for the first character in a text string. + Syntax + CODE("Text") + + Text is the text for which the code of the first character is to be found. + + Example + + =CODE("Hieronymus") returns 72, =CODE("hieroglyphic") returns 104. + The code used here does not refer to ASCII, but to the code table currently loaded. +
+
CONCATENATE function -CONCATENATE -Combines several text strings into one string. -Syntax -CONCATENATE("Text1"; ...; "Text30") - -Text 1; Text 2; ... represent up to 30 text passages which are to be combined into one string. -Example - -=CONCATENATE("Good ";"Morning ";"Mrs. ";"Doe") returns: Good Morning Mrs. Doe. -
-
+CONCATENATE + Combines several text strings into one string. + Syntax + CONCATENATE("Text1"; ...; "Text30") + + Text 1; Text 2; ... represent up to 30 text passages which are to be combined into one string. + Example + + =CONCATENATE("Good ";"Morning ";"Mrs. ";"Doe") returns: Good Morning Mrs. Doe. +
+
DECIMAL function -DECIMAL -Converts text with characters from a number system to a positive integer in the base radix given. The radix must be in the range 2 to 36. Spaces and tabs are ignored. The Text field is not case-sensitive. -If the radix is 16, a leading x or X or 0x or 0X, and an appended h or H, is disregarded. If the radix is 2, an appended b or B is disregarded. Other characters that do not belong to the number system generate an error. -Syntax -DECIMAL("Text"; Radix) - -Text is the text to be converted. To differentiate between a hexadecimal number, such as A1 and the reference to cell A1, you must place the number in quotation marks, for example, "A1" or "FACE". - -Radix indicates the base of the number system. It may be any positive integer between 2 and 36. -Example - -=DECIMAL("17";10) returns 17. - -=DECIMAL("FACE";16) returns 64206. - -=DECIMAL("0101";2) returns 5. -
-
+DECIMAL + Converts text with characters from a number system to a positive integer in the base radix given. The radix must be in the range 2 to 36. Spaces and tabs are ignored. The Text field is not case-sensitive. + If the radix is 16, a leading x or X or 0x or 0X, and an appended h or H, is disregarded. If the radix is 2, an appended b or B is disregarded. Other characters that do not belong to the number system generate an error. + Syntax + DECIMAL("Text"; Radix) + + Text is the text to be converted. To differentiate between a hexadecimal number, such as A1 and the reference to cell A1, you must place the number in quotation marks, for example, "A1" or "FACE". + + Radix indicates the base of the number system. It may be any positive integer between 2 and 36. + Example + + =DECIMAL("17";10) returns 17. + + =DECIMAL("FACE";16) returns 64206. + + =DECIMAL("0101";2) returns 5. +
+
DOLLAR function -DOLLAR -Converts a number to an amount in the currency format, rounded to a specified decimal place. In the Value field enter the number to be converted to currency. Optionally, you may enter the number of decimal places in the Decimals field. If no value is specified, all numbers in currency format will be displayed with two decimal places. -You set the currency format in your system settings. -Syntax -DOLLAR(Value; Decimals) - -Value is a number, a reference to a cell containing a number, or a formula which returns a number. - -Decimals is the optional number of decimal places. -Example - -=DOLLAR(255) returns $255.00. - -=DOLLAR(367.456;2) returns $367.46. Use the decimal separator that corresponds to the current locale setting. -
-
+DOLLAR + Converts a number to an amount in the currency format, rounded to a specified decimal place. In the Value field enter the number to be converted to currency. Optionally, you may enter the number of decimal places in the Decimals field. If no value is specified, all numbers in currency format will be displayed with two decimal places. + You set the currency format in your system settings. + Syntax + DOLLAR(Value; Decimals) + + Value is a number, a reference to a cell containing a number, or a formula which returns a number. + + Decimals is the optional number of decimal places. + Example + + =DOLLAR(255) returns $255.00. + + =DOLLAR(367.456;2) returns $367.46. Use the decimal separator that corresponds to the current locale setting. +
+
EXACT function -EXACT -Compares two text strings and returns TRUE if they are identical. This function is case-sensitive. -Syntax -EXACT("Text1"; "Text2") - -Text1 refers to the first text to compare. - -Text2 is the second text to compare. -Example - -=EXACT("Sun microsystems";"Sun Microsystems") returns FALSE. -
-
+EXACT + Compares two text strings and returns TRUE if they are identical. This function is case-sensitive. + Syntax + EXACT("Text1"; "Text2") + + Text1 refers to the first text to compare. + + Text2 is the second text to compare. + Example + + =EXACT("Sun microsystems";"Sun Microsystems") returns FALSE. +
+
FIND function -FIND -Looks for a string of text within another string. You can also define where to begin the search. The search term can be a number or any string of characters. The search is case-sensitive. -Syntax -FIND("FindText"; "Text"; Position) - -FindText refers to the text to be found. - -Text is the text where the search takes place. - -Position (optional) is the position in the text from which the search starts. -Example - -=FIND(76;998877665544) returns 6. -
-
+FIND + Looks for a string of text within another string. You can also define where to begin the search. The search term can be a number or any string of characters. The search is case-sensitive. + Syntax + FIND("FindText"; "Text"; Position) + + FindText refers to the text to be found. + + Text is the text where the search takes place. + + Position (optional) is the position in the text from which the search starts. + Example + + =FIND(76;998877665544) returns 6. +
+
FIXED function -FIXED -Returns a number as text with a specified number of decimal places and optional thousands separators. -Syntax -FIXED(Number; Decimals; NoThousandsSeparators) - -Number refers to the number to be formatted. - -Decimals refers to the number of decimal places to be displayed. - -NoThousandsSeparators (optional) determines whether the thousands separator is used. If the parameter is a number not equal to 0, the thousands separator is suppressed. If the parameter is equal to 0 or if it is missing altogether, the thousands separators of your current locale setting are displayed. -Example - -=FIXED(1234567.89;3) returns 1,234,567.890 as a text string. - -=FIXED(1234567.89;3;1) returns 1234567.890 as a text string. -
-
+FIXED + Returns a number as text with a specified number of decimal places and optional thousands separators. + Syntax + FIXED(Number; Decimals; NoThousandsSeparators) + + Number refers to the number to be formatted. + + Decimals refers to the number of decimal places to be displayed. + + NoThousandsSeparators (optional) determines whether the thousands separator is used. If the parameter is a number not equal to 0, the thousands separator is suppressed. If the parameter is equal to 0 or if it is missing altogether, the thousands separators of your current locale setting are displayed. + Example + + =FIXED(1234567.89;3) returns 1,234,567.890 as a text string. + + =FIXED(1234567.89;3;1) returns 1234567.890 as a text string. +
+
JIS function -JIS -The JIS function converts half-width to full-width ASCII and katakana characters. Returns a text string. -See http://wiki.services.openoffice.org/mwiki/index.php?title=Calc/Features/JIS_and_ASC_functions for a conversion table. -Syntax -JIS("Text") - -Text is the text that contains characters to be converted. -See also ASC function. -
-
+JIS + The JIS function converts half-width to full-width ASCII and katakana characters. Returns a text string. + See http://wiki.services.openoffice.org/mwiki/index.php?title=Calc/Features/JIS_and_ASC_functions for a conversion table. + Syntax + JIS("Text") + + Text is the text that contains characters to be converted. + See also ASC function. +
+
LEFT function -LEFT -Returns the first character or characters of a text. -Syntax -LEFT("Text"; Number) - -Text is the text where the initial partial words are to be determined. - -Number (optional) specifies the number of characters for the start text. If this parameter is not defined, one character is returned. -Example - -=LEFT("output";3) returns “out”. -
-
+LEFT + Returns the first character or characters of a text. + Syntax + LEFT("Text"; Number) + + Text is the text where the initial partial words are to be determined. + + Number (optional) specifies the number of characters for the start text. If this parameter is not defined, one character is returned. + Example + + =LEFT("output";3) returns “out”. +
+
LEN function -LEN -Returns the length of a string including spaces. -Syntax -LEN("Text") - -Text is the text whose length is to be determined. -Example - -=LEN("Good Afternoon") returns 14. - -=LEN(12345.67) returns 8. -
-
+LEN + Returns the length of a string including spaces. + Syntax + LEN("Text") + + Text is the text whose length is to be determined. + Example + + =LEN("Good Afternoon") returns 14. + + =LEN(12345.67) returns 8. +
+
LOWER function -LOWER -Converts all uppercase letters in a text string to lowercase. -Syntax -LOWER("Text") - -Text refers to the text to be converted. -Example - -=LOWER("Sun") returns sun. -
-
+LOWER + Converts all uppercase letters in a text string to lowercase. + Syntax + LOWER("Text") + + Text refers to the text to be converted. + Example + + =LOWER("Sun") returns sun. +
+
MID function -MID -Returns a text string of a text. The parameters specify the starting position and the number of characters. -Syntax -MID("Text"; Start; Number) - -Text is the text containing the characters to extract. - -Start is the position of the first character in the text to extract. - -Number specifies the number of characters in the part of the text. -Example - -=MID("Sun Microsystems";5;5) returns Micro. -
-
+MID + Returns a text string of a text. The parameters specify the starting position and the number of characters. + Syntax + MID("Text"; Start; Number) + + Text is the text containing the characters to extract. + + Start is the position of the first character in the text to extract. + + Number specifies the number of characters in the part of the text. + Example + + =MID("Sun Microsystems";5;5) returns Micro. +
+
PROPER function -PROPER -Capitalizes the first letter in all words of a text string. -Syntax -PROPER("Text") - -Text refers to the text to be converted. -Example - -=PROPER("sun microsystems") returns Sun Microsystems. -
-
+PROPER + Capitalizes the first letter in all words of a text string. + Syntax + PROPER("Text") + + Text refers to the text to be converted. + Example + + =PROPER("sun microsystems") returns Sun Microsystems. +
+
REPLACE function -REPLACE -Replaces part of a text string with a different text string. This function can be used to replace both characters and numbers (which are automatically converted to text). The result of the function is always displayed as text. If you intend to perform further calculations with a number which has been replaced by text, you will need to convert it back to a number using the VALUE function. -Any text containing numbers must be enclosed in quotation marks if you do not want it to be interpreted as a number and automatically converted to text. -Syntax -REPLACE("Text"; Position; Length; "NewText") - -Text refers to text of which a part will be replaced. - -Position refers to the position within the text where the replacement will begin. - -Length is the number of characters in Text to be replaced. - -NewText refers to the text which replaces Text. -Example - -=REPLACE("1234567";1;1;"444") returns "444234567". One character at position 1 is replaced by the complete NewText. -
-
+REPLACE + Replaces part of a text string with a different text string. This function can be used to replace both characters and numbers (which are automatically converted to text). The result of the function is always displayed as text. If you intend to perform further calculations with a number which has been replaced by text, you will need to convert it back to a number using the VALUE function. + Any text containing numbers must be enclosed in quotation marks if you do not want it to be interpreted as a number and automatically converted to text. + Syntax + REPLACE("Text"; Position; Length; "NewText") + + Text refers to text of which a part will be replaced. + + Position refers to the position within the text where the replacement will begin. + + Length is the number of characters in Text to be replaced. + + NewText refers to the text which replaces Text. + Example + + =REPLACE("1234567";1;1;"444") returns "444234567". One character at position 1 is replaced by the complete NewText. +
+
REPT function -REPT -Repeats a character string by the given number of copies. -Syntax -REPT("Text"; Number) - -Text is the text to be repeated. - -Number is the number of repetitions. -The result can be a maximum of 255 characters. -Example - -=REPT("Good morning";2) returns Good morningGood morning. -
- + -
+RIGHT + Returns the last character or characters of a text. + Syntax + RIGHT("Text"; Number) + + Text is the text of which the right part is to be determined. + + Number (optional) is the number of characters from the right part of the text. + Example + + =RIGHT("Sun";2) returns un. +
+
ROMAN function -ROMAN -Converts a number into a Roman numeral. The value range must be between 0 and 3999, the modes can be integers from 0 to 4. -Syntax -ROMAN(Number; Mode) - -Number is the number that is to be converted into a Roman numeral. - -Mode (optional) indicates the degree of simplification. The higher the value, the greater is the simplification of the Roman number. -Example - -=ROMAN(999) returns CMXCIX - -=ROMAN(999;0) returns CMXCIX - -=ROMAN (999;1) returns LMVLIV - -=ROMAN(999;2) returns XMIX - -=ROMAN(999;3) returns VMIV - -=ROMAN(999;4) returns IM -
- + -
+SEARCH + Returns the position of a text segment within a character string. You can set the start of the search as an option. The search text can be a number or any sequence of characters. The search is not case-sensitive. + + Syntax + SEARCH("FindText"; "Text"; Position) + + FindText is the text to be searched for. + + Text is the text where the search will take place. + + Position (optional) is the position in the text where the search is to start. + Example + + =SEARCH(54;998877665544) returns 10. +
+
SUBSTITUTE function -SUBSTITUTE -Substitutes new text for old text in a string. -Syntax -SUBSTITUTE("Text"; "SearchText"; "NewText"; Occurrence) - -Text is the text in which text segments are to be exchanged. - -SearchText is the text segment that is to be replaced (a number of times). - -NewText is the text that is to replace the text segment. - -Occurrence (optional) indicates which occurrence of the search text is to be replaced. If this parameter is missing the search text is replaced throughout. -Example - -=SUBSTITUTE("123123123";"3";"abc") returns 12abc12abc12abc. - -=SUBSTITUTE("123123123";"3";"abc";2) returns 12312abc123. -
-
+SUBSTITUTE + Substitutes new text for old text in a string. + Syntax + SUBSTITUTE("Text"; "SearchText"; "NewText"; Occurrence) + + Text is the text in which text segments are to be exchanged. + + SearchText is the text segment that is to be replaced (a number of times). + + NewText is the text that is to replace the text segment. + + Occurrence (optional) indicates which occurrence of the search text is to be replaced. If this parameter is missing the search text is replaced throughout. + Example + + =SUBSTITUTE("123123123";"3";"abc") returns 12abc12abc12abc. + + =SUBSTITUTE("123123123";"3";"abc";2) returns 12312abc123. +
+
T function -T -This function returns the target text, or a blank text string if the target is not text. -Syntax -T(Value) -If Value is a text string or refers to a text string, T returns that text string; otherwise it returns a blank text string. -Example - -=T(12345) returns an empty string. - -=T("12345") returns the string 12345. -
-
+T + This function returns the target text, or a blank text string if the target is not text. + Syntax + T(Value) + If Value is a text string or refers to a text string, T returns that text string; otherwise it returns a blank text string. + Example + + =T(12345) returns an empty string. + + =T("12345") returns the string 12345. +
+
TEXT function -TEXT -Converts a number into text according to a given format. -Syntax -TEXT(Number; Format) - -Number is the numerical value to be converted. - -Format is the text which defines the format. Use decimal and thousands separators according to the language set in the cell format. -Example - -=TEXT(12.34567;"###.##") returns the text 12.35 - -=TEXT(12.34567;"000.00") returns the text 012.35 -
-
+TEXT + Converts a number into text according to a given format. + Syntax + TEXT(Number; Format) + + Number is the numerical value to be converted. + + Format is the text which defines the format. Use decimal and thousands separators according to the language set in the cell format. + Example + + =TEXT(12.34567;"###.##") returns the text 12.35 + + =TEXT(12.34567;"000.00") returns the text 012.35 +
+
TRIM function -TRIM -Removes spaces from a string, leaving only a single space character between words. -Syntax -TRIM("Text") - -Text refers to text in which spaces are removed. -Example - -=TRIM("hello") returns hello. -
-
+TRIM + Removes spaces from a string, leaving only a single space character between words. + Syntax + TRIM("Text") + + Text refers to text in which spaces are removed. + Example + + =TRIM("hello") returns hello. +
+
+ +UNICHAR function + +UNICHAR + Converts a code number into a Unicode character or letter. + Syntax + UNICHAR(number) + Example + =UNICHAR(169) returns the Copyright character ©. +
+
+ +UNICODE function + +UNICODE + Returns the numeric code for the first Unicode character in a text string. + Syntax + UNICODE("Text") + Example + =UNICODE("©") returns the Unicode number 169 for the Copyright character. +
+
UPPER function -UPPER -Converts the string specified in the text field to uppercase. -Syntax -UPPER("Text") - -Text refers to the lower case letters you want to convert to upper case. -Example - -=UPPER("Good Morning") returns GOOD MORNING. -
-
+UPPER + Converts the string specified in the text field to uppercase. + Syntax + UPPER("Text") + + Text refers to the lower case letters you want to convert to upper case. + Example + + =UPPER("Good Morning") returns GOOD MORNING. +
+
VALUE function -VALUE -Converts a text string into a number. -Syntax -VALUE("Text") - -Text is the text to be converted to a number. -Example - -=VALUE("4321") returns 4321. -
+VALUE + Converts a text string into a number. + Syntax + VALUE("Text") + + Text is the text to be converted to a number. + Example + + =VALUE("4321") returns 4321. +
- -
- - + +
+ + \ No newline at end of file diff --git a/helpcontent2/source/text/scalc/01/04060116.xhp b/helpcontent2/source/text/scalc/01/04060116.xhp index c416f15632..b03519e274 100755 --- a/helpcontent2/source/text/scalc/01/04060116.xhp +++ b/helpcontent2/source/text/scalc/01/04060116.xhp @@ -11,7 +11,7 @@ * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: soffice2xmlhelp.xsl,v $ - * $Revision: 1.10 $ + * $Revision: 1.12 $ * * This file is part of OpenOffice.org. * @@ -392,10 +392,11 @@ =OCT2HEX(144;4) returns 0064.
-CONVERT function +CONVERT_ADD function -CONVERTwas CONVERT_ADD before. Now CONVERT was changed to EUROCONVERT, and CONVERT_ADD was changed to CONVERT +CONVERT_ADD Converts a value from one unit of measure to the corresponding value in another unit of measure. Enter the units of measures directly as text in quotation marks or as a reference. If you enter the units of measure in cells, they must correspond exactly with the following list which is case sensitive: For example, in order to enter a lower case l (for liter) in a cell, enter the apostrophe ' immediately followed by l. @@ -504,7 +505,7 @@
- Each unit of measure must be preceded by a prefix character from the following list: + Each unit of measure can be preceded by a prefix character from the following list: @@ -529,11 +530,26 @@ e, h, k, M, G, T, P, E, Z, Y + + + Information units "bit" and "byte" may also be prefixed by one of the following IEC 60027-2 / IEEE 1541 prefixes: + + + ki kibi 1024 + Mi mebi 1048576 + Gi gibi 1073741824 + Ti tebi 1099511627776 + Pi pebi 1125899906842620 + Ei exbi 1152921504606850000 + Zi zebi 1180591620717410000000 + Yi yobi 1208925819614630000000000 + +
Syntax - CONVERT(Number; "FromUnit"; "ToUnit") + CONVERT_ADD(Number; "FromUnit"; "ToUnit") Number is the number to be converted. @@ -543,9 +559,9 @@ Examples - =CONVERT(10;"HP";"PS") returns, rounded to two decimal places, 10.14. 10 HP equal 10.14 PS. + =CONVERT_ADD(10;"HP";"PS") returns, rounded to two decimal places, 10.14. 10 HP equal 10.14 PS. - =CONVERT(10;"km";"mi") returns, rounded to two decimal places, 6.21. 10 kilometers equal 6.21 miles. The k is the permitted prefix character for the factor 10^3. + =CONVERT_ADD(10;"km";"mi") returns, rounded to two decimal places, 6.21. 10 kilometers equal 6.21 miles. The k is the permitted prefix character for the factor 10^3.
FACTDOUBLE function diff --git a/helpcontent2/source/text/scalc/01/04060181.xhp b/helpcontent2/source/text/scalc/01/04060181.xhp index 500a562f2f..a33723f370 100755 --- a/helpcontent2/source/text/scalc/01/04060181.xhp +++ b/helpcontent2/source/text/scalc/01/04060181.xhp @@ -417,6 +417,7 @@
CHISQDIST function +chi-square distribution CHISQDIST Returns the value of the probability density function or the cumulative distribution function for the chi-square distribution. @@ -456,4 +457,4 @@
- \ No newline at end of file + diff --git a/helpcontent2/source/text/scalc/01/04060183.xhp b/helpcontent2/source/text/scalc/01/04060183.xhp index 7ef96b3843..9c6ab30e93 100755 --- a/helpcontent2/source/text/scalc/01/04060183.xhp +++ b/helpcontent2/source/text/scalc/01/04060183.xhp @@ -188,13 +188,15 @@ LOGNORMDIST Returns the cumulative lognormal distribution. Syntax -LOGNORMDIST(Number; Mean; StDev) +LOGNORMDIST(Number; Mean; StDev; Cumulative) Number is the probability value for which the standard logarithmic distribution is to be calculated. -Mean is the mean value of the standard logarithmic distribution. +Mean (optional) is the mean value of the standard logarithmic distribution. -StDev is the standard deviation of the standard logarithmic distribution. +StDev (optional) is the standard deviation of the standard logarithmic distribution. + +Cumulative (optional) = 0 calculates the density function, Cumulative = 1 calculates the distribution. Example =LOGNORMDIST(0.1;0;1) returns 0.01. diff --git a/helpcontent2/source/text/scalc/01/04060184.xhp b/helpcontent2/source/text/scalc/01/04060184.xhp index 735a1b6d79..83ed0d9440 100755 --- a/helpcontent2/source/text/scalc/01/04060184.xhp +++ b/helpcontent2/source/text/scalc/01/04060184.xhp @@ -3,45 +3,45 @@ - +* +* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. +* +* Copyright 2008 by Sun Microsystems, Inc. +* +* OpenOffice.org - a multi-platform office productivity suite +* +* $RCSfile: soffice2xmlhelp.xsl,v $ +* $Revision: 1.10 $ +* +* This file is part of OpenOffice.org. +* +* OpenOffice.org is free software: you can redistribute it and/or modify +* it under the terms of the GNU Lesser General Public License version 3 +* only, as published by the Free Software Foundation. +* +* OpenOffice.org is distributed in the hope that it will be useful, +* but WITHOUT ANY WARRANTY; without even the implied warranty of +* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +* GNU Lesser General Public License version 3 for more details +* (a copy is included in the LICENSE file that accompanied this code). +* +* You should have received a copy of the GNU Lesser General Public License +* version 3 along with OpenOffice.org. If not, see +* +* for a copy of the LGPLv3 License. +* +************************************************************************ +--> + - - Statistical Functions Part Four - /text/scalc/01/04060184.xhp - - - - Statistical Functions Part Four + +Statistical Functions Part Four +/text/scalc/01/04060184.xhp + + + +Statistical Functions Part Four
@@ -49,354 +49,323 @@ MAX - Returns the maximum value in a list of arguments. - Returns 0 if no numeric value and no error was encountered in the cell range(s) passed as cell reference(s). Text cells are ignored by MIN() and MAX(). The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered. Passing a literal string argument to MIN() or MAX(), e.g. MIN("string"), still results in an error. - Syntax - MAX(Number1; Number2; ...Number30) - - Number1; Number2;...Number30 are numerical values or ranges. - Example - - =MAX(A1;A2;A3;50;100;200) returns the largest value from the list. - - =MAX(A1:B100) returns the largest value from the list. -
-
+Returns the maximum value in a list of arguments. +Returns 0 if no numeric value and no error was encountered in the cell range(s) passed as cell reference(s). Text cells are ignored by MIN() and MAX(). The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered. Passing a literal string argument to MIN() or MAX(), e.g. MIN("string"), still results in an error. +Syntax +MAX(Number1; Number2; ...Number30) +Number1; Number2;...Number30 are numerical values or ranges. +Example + +=MAX(A1;A2;A3;50;100;200) returns the largest value from the list. + +=MAX(A1:B100) returns the largest value from the list. +
+
MAXA function MAXA - Returns the maximum value in a list of arguments. In opposite to MAX, here you can enter text. The value of the text is 0. - The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered. - Syntax - MAXA(Value1; Value2; ... Value30) - - Value1; Value2;...Value30 are values or ranges. Text has the value of 0. - Example - - =MAXA(A1;A2;A3;50;100;200;"Text") returns the largest value from the list. - - =MAXA(A1:B100) returns the largest value from the list. -
-
+oldref="139">MAXA +Returns the maximum value in a list of arguments. In opposite to MAX, here you can enter text. The value of the text is 0. +The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered. +Syntax +MAXA(Value1; Value2; ... Value30) +Value1; Value2;...Value30 are values or ranges. Text has the value of 0. +Example + +=MAXA(A1;A2;A3;50;100;200;"Text") returns the largest value from the list. + +=MAXA(A1:B100) returns the largest value from the list. +
+
MEDIAN function MEDIAN - Returns the median of a set of numbers. In a set containing an uneven number of values, the median will be the number in the middle of the set and in a set containing an even number of values, it will be the mean of the two values in the middle of the set. - Syntax - MEDIAN(Number1; Number2; ...Number30) - - Number1; Number2;...Number30 are values or ranges, which represent a sample. Each number can also be replaced by a reference. - Example - for an odd number: =MEDIAN(1;5;9;20;21) returns 9 as the median value. - for an even number: =MEDIAN(1;5;9;20) returns the average of the two middle values 5 and 9, thus 7. -
-
+oldref="11">MEDIAN +Returns the median of a set of numbers. In a set containing an uneven number of values, the median will be the number in the middle of the set and in a set containing an even number of values, it will be the mean of the two values in the middle of the set. +Syntax +MEDIAN(Number1; Number2; ...Number30) +Number1; Number2;...Number30 are values or ranges, which represent a sample. Each number can also be replaced by a reference. +Example +for an odd number: =MEDIAN(1;5;9;20;21) returns 9 as the median value. +for an even number: =MEDIAN(1;5;9;20) returns the average of the two middle values 5 and 9, thus 7. +
+
MIN function MIN - Returns the minimum value in a list of arguments. - Returns 0 if no numeric value and no error was encountered in the cell range(s) passed as cell reference(s). Text cells are ignored by MIN() and MAX(). The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered. Passing a literal string argument to MIN() or MAX(), e.g. MIN("string"), still results in an error. - Syntax - MIN(Number1; Number2; ...Number30) - - Number1; Number2;...Number30 are numerical values or ranges. - Example - - =MIN(A1:B100) returns the smallest value in the list. -
-
+oldref="19">MIN +Returns the minimum value in a list of arguments. +Returns 0 if no numeric value and no error was encountered in the cell range(s) passed as cell reference(s). Text cells are ignored by MIN() and MAX(). The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered. Passing a literal string argument to MIN() or MAX(), e.g. MIN("string"), still results in an error. +Syntax +MIN(Number1; Number2; ...Number30) +Number1; Number2;...Number30 are numerical values or ranges. +Example + +=MIN(A1:B100) returns the smallest value in the list. +
+
MINA function MINA - Returns the minimum value in a list of arguments. Here you can also enter text. The value of the text is 0. - The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered. - Syntax - MINA(Value1; Value2; ... Value30) - - Value1; Value2;...Value30 are values or ranges. Text has the value of 0. - Example - - =MINA(1;"Text";20) returns 0. - - =MINA(A1:B100) returns the smallest value in the list. -
-
+oldref="148">MINA +Returns the minimum value in a list of arguments. Here you can also enter text. The value of the text is 0. +The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered. +Syntax +MINA(Value1; Value2; ... Value30) +Value1; Value2;...Value30 are values or ranges. Text has the value of 0. +Example + +=MINA(1;"Text";20) returns 0. + +=MINA(A1:B100) returns the smallest value in the list. +
+
AVEDEV function - averages;statistical functions +averages;statistical functions mw added "averages;" AVEDEV Returns the average of the absolute deviations of data points from their mean. Displays the diffusion in a data set. Syntax AVEDEV(Number1; Number2; ...Number30) - -Number1, Number2,...Number30 are values or ranges that represent a sample. Each number can also be replaced by a reference. +Number1, Number2,...Number30 are values or ranges that represent a sample. Each number can also be replaced by a reference. Example -=AVEDEV(A1:A50) - + =AVEDEV(A1:A50) +
AVERAGE function AVERAGE - Returns the average of the arguments. - Syntax - AVERAGE(Number1; Number2; ...Number30) - - Number1; Number2;...Number 0 are numerical values or ranges. - Example - - =AVERAGE(A1:A50) - -
-
+oldref="35">AVERAGE +Returns the average of the arguments. +Syntax +AVERAGE(Number1; Number2; ...Number30) +Number1; Number2;...Number 0 are numerical values or ranges. +Example + +=AVERAGE(A1:A50) + +
+
AVERAGEA function AVERAGEA - Returns the average of the arguments. The value of a text is 0. - Syntax - AVERAGEA(Value1; Value2; ... Value30) - - Value1; Value2;...Value30 are values or ranges. Text has the value of 0. - Example - - =AVERAGEA(A1:A50) - -
-
+oldref="157">AVERAGEA +Returns the average of the arguments. The value of a text is 0. +Syntax +AVERAGEA(Value1; Value2; ... Value30) +Value1; Value2;...Value30 are values or ranges. Text has the value of 0. +Example + +=AVERAGEA(A1:A50) + +
+
MODE function - most common value +most common value mw added one entry MODE - Returns the most common value in a data set. If there are several values with the same frequency, it returns the smallest value. An error occurs when a value doesn't appear twice. - Syntax - MODE(Number1; Number2; ...Number30) - - Number1; Number2;...Number30 are numerical values or ranges. - Example - - =MODE(A1:A50) - -
-
+oldref="43">MODE +Returns the most common value in a data set. If there are several values with the same frequency, it returns the smallest value. An error occurs when a value doesn't appear twice. +Syntax +MODE(Number1; Number2; ...Number30) +Number1; Number2;...Number30 are numerical values or ranges. +Example + +=MODE(A1:A50) + +
+
NEGBINOMDIST function - negative binomial distribution +negative binomial distribution mw added one entry NEGBINOMDIST - Returns the negative binomial distribution. - Syntax - NEGBINOMDIST(X; R; SP) - - X represents the value returned for unsuccessful tests. - - R represents the value returned for successful tests. - - SP is the probability of the success of an attempt. - Example - - =NEGBINOMDIST(1;1;0.5) returns 0.25. -
-
+oldref="51">NEGBINOMDIST +Returns the negative binomial distribution. +Syntax +NEGBINOMDIST(X; R; SP) +X represents the value returned for unsuccessful tests. +R represents the value returned for successful tests. +SP is the probability of the success of an attempt. +Example + +=NEGBINOMDIST(1;1;0.5) returns 0.25. +
+
NORMINV function - normal distribution;inverse of +normal distribution;inverse of mw added one entry NORMINV - Returns the inverse of the normal cumulative distribution. - Syntax - NORMINV(Number; Mean; StDev) - - Number represents the probability value used to determine the inverse normal distribution. - - Mean represents the mean value in the normal distribution. - - StDev represents the standard deviation of the normal distribution. - Example - - =NORMINV(0.9;63;5) returns 69.41. If the average egg weighs 63 grams with a standard deviation of 5, then there will be 90% probability that the egg will not be heavier than 69.41g grams. -
-
+oldref="61">NORMINV +Returns the inverse of the normal cumulative distribution. +Syntax +NORMINV(Number; Mean; StDev) +Number represents the probability value used to determine the inverse normal distribution. +Mean represents the mean value in the normal distribution. +StDev represents the standard deviation of the normal distribution. +Example + +=NORMINV(0.9;63;5) returns 69.41. If the average egg weighs 63 grams with a standard deviation of 5, then there will be 90% probability that the egg will not be heavier than 69.41g grams. +
+
NORMDIST function - density function +density function mw added one entry NORMDIST - Returns the density function or the normal cumulative distribution. - Syntax - NORMDIST(Number; Mean; StDev; C) - - Number is the value of the distribution based on which the normal distribution is to be calculated. - - Mean is the mean value of the distribution. - - StDev is the standard deviation of the distribution. - - C = 0 calculates the density function; C = 1 calculates the distribution. - Example - - =NORMDIST(70;63;5;0) returns 0.03. - - =NORMDIST(70;63;5;1) returns 0.92. -
-
+oldref="71">NORMDIST +Returns the density function or the normal cumulative distribution. +Syntax +NORMDIST(Number; Mean; StDev; C) +Number is the value of the distribution based on which the normal distribution is to be calculated. +Mean is the mean value of the distribution. +StDev is the standard deviation of the distribution. +C is optional. C = 0 calculates the density function, C = 1 calculates the distribution. +Example + +=NORMDIST(70;63;5;0) returns 0.03. + +=NORMDIST(70;63;5;1) returns 0.92. +
+
PEARSON function PEARSON - Returns the Pearson product moment correlation coefficient r. - Syntax - PEARSON(Data1; Data2) - - Data1 represents the array of the first data set. - - Data2 represents the array of the second data set. - Example - - =PEARSON(A1:A30;B1:B30) returns the Pearson correlation coefficient of both data sets. -
-
+oldref="83">PEARSON +Returns the Pearson product moment correlation coefficient r. +Syntax +PEARSON(Data1; Data2) +Data1 represents the array of the first data set. +Data2 represents the array of the second data set. +Example + +=PEARSON(A1:A30;B1:B30) returns the Pearson correlation coefficient of both data sets. +
+
PHI function PHI - Returns the values of the distribution function for a standard normal distribution. - Syntax - PHI(Number) - - Number represents the value based on which the standard normal distribution is calculated. - Example - - =PHI(2.25) = 0.03 - - =PHI(-2.25) = 0.03 - - =PHI(0) = 0.4 -
-
+oldref="92">PHI +Returns the values of the distribution function for a standard normal distribution. +Syntax +PHI(Number) +Number represents the value based on which the standard normal distribution is calculated. +Example + +=PHI(2.25) = 0.03 + +=PHI(-2.25) = 0.03 + +=PHI(0) = 0.4 +
+
POISSON function POISSON - Returns the Poisson distribution. - Syntax - POISSON(Number; Mean; C) - - Number represents the value based on which the Poisson distribution is calculated. - - Mean represents the middle value of the Poisson distribution. - - C (optional) = 0 or False calculates the density function; C = 1 or True calculates the distribution. When omitted, the default value True is inserted when you save the document, for best compatibility with other programs and older versions of %PRODUCTNAME. - Example - - =POISSON(60;50;1) returns 0.93. -
-
+Returns the Poisson distribution. +Syntax +POISSON(Number; Mean; C) +Number represents the value based on which the Poisson distribution is calculated. +Mean represents the middle value of the Poisson distribution. +C (optional) = 0 or False calculates the density function; C = 1 or True calculates the distribution. When omitted, the default value True is inserted when you save the document, for best compatibility with other programs and older versions of %PRODUCTNAME. +Example + +=POISSON(60;50;1) returns 0.93. +
+
PERCENTILE function PERCENTILE - Returns the alpha-percentile of data values in an array. A percentile returns the scale value for a data series which goes from the smallest (Alpha=0) to the largest value (alpha=1) of a data series. For Alpha = 25%, the percentile means the first quartile; Alpha = 50% is the MEDIAN. - Syntax - PERCENTILE(Data; Alpha) - - Data represents the array of data. - - Alpha represents the percentage of the scale between 0 and 1. - Example - - =PERCENTILE(A1:A50;0.1) represents the value in the data set, which equals 10% of the total data scale in A1:A50. -
-
+oldref="112">PERCENTILE +Returns the alpha-percentile of data values in an array. A percentile returns the scale value for a data series which goes from the smallest (Alpha=0) to the largest value (alpha=1) of a data series. For Alpha = 25%, the percentile means the first quartile; Alpha = 50% is the MEDIAN. +Syntax +PERCENTILE(Data; Alpha) +Data represents the array of data. +Alpha represents the percentage of the scale between 0 and 1. +Example + +=PERCENTILE(A1:A50;0.1) represents the value in the data set, which equals 10% of the total data scale in A1:A50. +
+
PERCENTRANK function PERCENTRANK - Returns the percentage rank of a value in a sample. - Syntax - PERCENTRANK(Data; Value) - - Data represents the array of data in the sample. - - Value represents the value whose percentile rank must be determined. - Example - - =PERCENTRANK(A1:A50;50) returns the percentage rank of the value 50 from the total range of all values found in A1:A50. If 50 falls outside the total range, an error message will appear. -
-
+oldref="121">PERCENTRANK +Returns the percentage rank of a value in a sample. +Syntax +PERCENTRANK(Data; Value) +Data represents the array of data in the sample. +Value represents the value whose percentile rank must be determined. +Example + +=PERCENTRANK(A1:A50;50) returns the percentage rank of the value 50 from the total range of all values found in A1:A50. If 50 falls outside the total range, an error message will appear. +
+
QUARTILE function QUARTILE - Returns the quartile of a data set. - Syntax - QUARTILE(Data; Type) - - Data represents the array of data in the sample. - - Type represents the type of quartile. (0 = MIN, 1 = 25%, 2 = 50% (MEDIAN), 3 = 75% and 4 = MAX.) - Example - - =QUARTILE(A1:A50;2) returns the value of which 50% of the scale corresponds to the lowest to highest values in the range A1:A50. -
+oldref="130">QUARTILE +Returns the quartile of a data set. +Syntax +QUARTILE(Data; Type) +Data represents the array of data in the sample. +Type represents the type of quartile. (0 = MIN, 1 = 25%, 2 = 50% (MEDIAN), 3 = 75% and 4 = MAX.) +Example + +=QUARTILE(A1:A50;2) returns the value of which 50% of the scale corresponds to the lowest to highest values in the range A1:A50. +
- -
- + +
+ \ No newline at end of file diff --git a/helpcontent2/source/text/scalc/01/05100000.xhp b/helpcontent2/source/text/scalc/01/05100000.xhp index 0c5030dec8..da8e65cd41 100644 --- a/helpcontent2/source/text/scalc/01/05100000.xhp +++ b/helpcontent2/source/text/scalc/01/05100000.xhp @@ -56,7 +56,7 @@
- How to apply a cell style: @@ -68,7 +68,7 @@ -Cell Styles +Cell Styles Displays the list of the available Cell Styles for indirect cell formatting. @@ -85,7 +85,7 @@ -Page Styles +Page Styles Displays the Page Styles available for indirect page formatting.
@@ -101,7 +101,7 @@
-Fill Format Mode Turns the Fill Format mode on and off. Use the paint can to assign the Style selected in the Styles and Formatting window. @@ -117,7 +117,7 @@
- How to apply a new style with the paint can: @@ -134,7 +134,7 @@ -New Style from Selection Creates a new style based on the formatting of a selected object. Assign a name for the style in the Create Style dialog. @@ -151,7 +151,7 @@
-Update Style Updates the Style selected in the Styles and Formatting window with the current formatting of the selected object. @@ -168,11 +168,11 @@
-Style List +Style List Displays the list of the styles from the selected style category. In the context menu you can choose commands to create a new style, delete a user-defined style, or change the selected style. -Style GroupsUFI: use "groups" to be consistent with Writer Lists the available style groups. diff --git a/helpcontent2/source/text/scalc/01/05120000.xhp b/helpcontent2/source/text/scalc/01/05120000.xhp index a57f05498d..fe6bde6aeb 100644 --- a/helpcontent2/source/text/scalc/01/05120000.xhp +++ b/helpcontent2/source/text/scalc/01/05120000.xhp @@ -10,8 +10,8 @@ * * OpenOffice.org - a multi-platform office productivity suite * - * $RCSfile: 05120000.xhp,v $ - * $Revision: 1.9.4.1 $ + * $RCSfile: soffice2xmlhelp.xsl,v $ + * $Revision: 1.8 $ * * This file is part of OpenOffice.org. * @@ -35,60 +35,67 @@ - -Conditional Formatting -/text/scalc/01/05120000.xhp - - - + + Conditional Formatting + /text/scalc/01/05120000.xhp + + + -Conditional Formatting -Choose Conditional Formatting to define format styles depending on certain conditions. +Conditional Formatting + Choose Conditional Formatting to define format styles depending on certain conditions. If a style was already assigned to a cell, it remains unchanged. The style entered here is then evaluated. You can enter three conditions that query the contents of cell values or formulas. The conditions are evaluated from 1 to 3. If the condition 1 matches the condition, the defined style will be used. Otherwise, condition 2 is evaluated, and its defined style used. If this style does not match, condition 3 is evaluated. -
- -
-To apply conditional formatting, AutoCalculate must be enabled. Choose Tools - Cell Contents - AutoCalculate (you see a check mark next to the command when AutoCalculate is enabled). +
+ +
+ To apply conditional formatting, AutoCalculate must be enabled. Choose Tools - Cell Contents - AutoCalculate (you see a check mark next to the command when AutoCalculate is enabled). conditional formatting; conditions -Condition 1/2/3 -Mark the boxes corresponding to each condition and enter the corresponding condition. To close the dialog, click OK. +Condition 1/2/3 + Mark the boxes corresponding to each condition and enter the corresponding condition. To close the dialog, click OK. -Cell Value / Formula -Specifies if conditional formatting is dependent on a cell value or a formula. If you select a formula as a reference, the Cell Value Condition box is displayed to the right of the Cell value/Formula field. If the condition is "Formula is", enter a cell reference. If the cell reference is a value other than zero, the condition matches. +Cell Value / Formula + Specifies if conditional formatting is dependent on a cell value or a formula. If you select a formula as a reference, the Cell Value Condition box is displayed to the right of the Cell value/Formula field. If the condition is "Formula is", enter a cell reference. If the cell reference is a value other than zero, the condition matches. -Cell Value Condition -Choose a condition for the format to be applied to the selected cells. +Cell Value Condition + Choose a condition for the format to be applied to the selected cells. -Cell Style -Choose the style to be applied if the specified condition matches. +Cell Style + Choose the style to be applied if the specified condition matches. + + + +New Style + If you haven't already defined a style to be used, you can click New Style to open the Organizer tab page of the Cell Style dialog. Define a new style there and click OK. -Parameter field -Enter a reference, value or formula. Enter a reference, value or formula in the parameter field, or in both parameter fields if you have selected a condition that requires two parameters. You can also enter formulas containing relative references. -Once the parameters have been defined, the condition is complete. It may appear as: -Cell value is equal 0: Cell style Null value (You must have already defined a cell style with this name before assigning it to a condition). -Cell value is between $B$20 and $B$21: Cell style Result (The corresponding value limits must already exist in cells B20 and B21) -Formula is SUM($A$1:$A$5)=10: Cell style Result (The selected cells are formatted with the Result style if the sum of the contents in cells A1 to A5 is equal to 10. - -
- - - -
- - +Parameter field + Enter a reference, value or formula. Enter a reference, value or formula in the parameter field, or in both parameter fields if you have selected a condition that requires two parameters. You can also enter formulas containing relative references. + Once the parameters have been defined, the condition is complete. It may appear as: + Cell value is equal 0: Cell style Null value (You must have already defined a cell style with this name before assigning it to a condition). + Cell value is between $B$20 and $B$21: Cell style Result (The corresponding value limits must already exist in cells B20 and B21) + Formula is SUM($A$1:$A$5)=10: Cell style Result (The selected cells are formatted with the Result style if the sum of the contents in cells A1 to A5 is equal to 10. + +
+ + + +
+ + \ No newline at end of file diff --git a/helpcontent2/source/text/scalc/01/12090102.xhp b/helpcontent2/source/text/scalc/01/12090102.xhp index 8aae0bc50a..47127050f1 100644 --- a/helpcontent2/source/text/scalc/01/12090102.xhp +++ b/helpcontent2/source/text/scalc/01/12090102.xhp @@ -10,8 +10,8 @@ * * OpenOffice.org - a multi-platform office productivity suite * - * $RCSfile: 12090102.xhp,v $ - * $Revision: 1.10.4.2 $ + * $RCSfile: soffice2xmlhelp.xsl,v $ + * $Revision: 1.8 $ * * This file is part of OpenOffice.org. * @@ -35,87 +35,97 @@ - -DataPilot -/text/scalc/01/12090102.xhp - - - + + DataPilot + /text/scalc/01/12090102.xhp + + + DataPilot function;show details -DataPilot function;drill down + DataPilot function;drill down -DataPilot -Specify the layout of the table that is generated by the DataPilot. -
- -
- -The DataPilot displays data fields as buttons which you can drag and drop to define the DataPilot table. +DataPilot + Specify the layout of the table that is generated by the DataPilot. +
+ +
+ + The DataPilot displays data fields as buttons which you can drag and drop to define the DataPilot table. UFI: changed help id from 59001 to dply_page -Layout -To define the layout of a DataPilot table, drag and drop data field buttons onto the Page Fields, Row Fields, Column Fields, and Data Fields areas. You can also use drag and drop to rearrange the data fields on a DataPilot table. -$[officename] automatically adds a caption to buttons that are dragged into the Data Fields area. The caption contains the name of the data field as well as the formula that created the data. -To change the function that is used by a data field, double-click a button in the Data Fields area to open the Data Field dialog. You can also double-click buttons in the Row Fields or Column Fields areas. +Layout + To define the layout of a DataPilot table, drag and drop data field buttons onto the Page Fields, Row Fields, Column Fields, and Data Fields areas. You can also use drag and drop to rearrange the data fields on a DataPilot table. + $[officename] automatically adds a caption to buttons that are dragged into the Data Fields area. The caption contains the name of the data field as well as the formula that created the data. + To change the function that is used by a data field, double-click a button in the Data Fields area to open the Data Field dialog. You can also double-click buttons in the Row Fields or Column Fields areas. -Remove -Removes the selected data field from the table layout. +Remove + Removes the selected data field from the table layout. -Options -Opens the Data Field dialog where you can change the function that is associated with the selected field. +Options + Opens the Data Field dialog where you can change the function that is associated with the selected field. -More -Displays or hides additional options for defining the DataPilot table. -Result -Specify the settings for displaying the results of the DataPilot table. +More + Displays or hides additional options for defining the DataPilot table. + Result + Specify the settings for displaying the results of the DataPilot table. + + +Selection from + Select the area that contains the data for the current datapilot table. -Results to -Select the area where you want to display the results of the DataPilot table. - -If the selected area contains data, the DataPilot overwrites the data. To prevent the loss of existing data, let the DataPilot automatically select the area to display the results. +Results to + Select the area where you want to display the results of the DataPilot table. + + If the selected area contains data, the DataPilot overwrites the data. To prevent the loss of existing data, let the DataPilot automatically select the area to display the results. -Ignore empty rows -Ignores empty fields in the data source. +Ignore empty rows + Ignores empty fields in the data source. -Identify categories -Automatically assigns rows without labels to the category of the row above.i93137 +Identify categories + Automatically assigns rows without labels to the category of the row above.i93137 -Total columns -Calculates and displays the grand total of the column calculation. +Total columns + Calculates and displays the grand total of the column calculation. -Total rows -Calculates and displays the grand total of the row calculation. +Total rows + Calculates and displays the grand total of the row calculation. -Add filter -Adds a Filter button to DataPilot tables that are based on spreadsheet data. +Add filter + Adds a Filter button to DataPilot tables that are based on spreadsheet data. -Opens the Filter dialog. +Opens the Filter dialog. -Enable drill to details -Select this check box and double-click an item label in the table to show or hide details for the item. Clear this check box and double-click a cell in the table to edit the contents of the cell. -To examine details inside a DataPilot table -Do one of the following: - - -Select a range of cells and choose Data - Group and Outline - Show Details. - - -Double-click a field in the table. - - -If you double-click a field which has adjacent fields at the same level, the Show Detail dialog opens: +Enable drill to details + Select this check box and double-click an item label in the table to show or hide details for the item. Clear this check box and double-click a cell in the table to edit the contents of the cell. + To examine details inside a DataPilot table + Do one of the following: + + + Select a range of cells and choose Data - Group and Outline - Show Details. + + + Double-click a field in the table. + + + If you double-click a field which has adjacent fields at the same level, the Show Detail dialog opens: -Show Detail -Choose the field that you want to view the details for. -
-DataPilot shortcut keys -
- - +Show Detail + Choose the field that you want to view the details for. +
+ DataPilot shortcut keys +
+ + \ No newline at end of file diff --git a/helpcontent2/source/text/scalc/01/text2columns.xhp b/helpcontent2/source/text/scalc/01/text2columns.xhp index 390bd02d1e..6091817ab9 100644 --- a/helpcontent2/source/text/scalc/01/text2columns.xhp +++ b/helpcontent2/source/text/scalc/01/text2columns.xhp @@ -10,8 +10,8 @@ * * OpenOffice.org - a multi-platform office productivity suite * - * $RCSfile: text2columns.xhp,v $ - * $Revision: 1.5.4.1 $ + * $RCSfile: soffice2xmlhelp.xsl,v $ + * $Revision: 1.8 $ * * This file is part of OpenOffice.org. * @@ -35,42 +35,42 @@ - -Text to Columns -/text/scalc/01/text2columns.xhp - - - + + Text to Columns + /text/scalc/01/text2columns.xhp + + + text to columns -Text to Columns -Opens the Text to Columns dialog, where you enter settings to expand the contents of selected cells to multiple cells. +Text to Columns + Opens the Text to Columns dialog, where you enter settings to expand the contents of selected cells to multiple cells. -
- -
-To expand cell contents to multiple cells -You can expand cells that contain comma separated values (CSV) into multiple cells in the same row. -For example, cell A1 contains the comma separated values 1,2,3,4, and cell A2 contains the text A,B,C,D. - - -Select the cell or cells that you want to expand. - - -Choose Data - Text to Columns. -You see the Text to Columns dialog. - - -Select the separator options. The preview shows how the current cell contents will be transformed into multiple cells. - - -You can select a fixed width and then click the ruler on the preview to set cell breakup positions. -You can select or enter separator characters to define the positions of breaking points. The separator characters are removed from the resulting cell contents. -In the example, you select the comma as a delimiter character. Cells A1 and B1 will be expanded to four columns. A1 contains 1, B1 contains 2, and so on. -
- - -
- - +
+ +
+ To expand cell contents to multiple cells + You can expand cells that contain comma separated values (CSV) into multiple cells in the same row. + For example, cell A1 contains the comma separated values 1,2,3,4, and cell A2 contains the text A,B,C,D. + + + Select the cell or cells that you want to expand. + + + Choose Data - Text to Columns. + You see the Text to Columns dialog. + + + Select the separator options. The preview shows how the current cell contents will be transformed into multiple cells. + + + You can select a fixed width and then click the ruler on the preview to set cell breakup positions. + You can select or enter separator characters to define the positions of breaking points. The separator characters are removed from the resulting cell contents. + In the example, you select the comma as a delimiter character. Cells A1 and A2 will be expanded to four columns each. A1 contains 1, B1 contains 2, and so on. +
+ + +
+ + \ No newline at end of file diff --git a/helpcontent2/source/text/scalc/guide/address_auto.xhp b/helpcontent2/source/text/scalc/guide/address_auto.xhp index f6089588b9..776c22c5ca 100644 --- a/helpcontent2/source/text/scalc/guide/address_auto.xhp +++ b/helpcontent2/source/text/scalc/guide/address_auto.xhp @@ -68,9 +68,9 @@ In the example spreadsheet, you can use the string 'Column One' in a formula to refer to the cell range B3 to B5, or 'Column Two' for the cell range C2 to C5. You can also use 'Row One' for the cell range B3 to D3, or 'Row Two' for the cell range B4 to D4. The result of a formula that uses a cell name, for example, SUM('Column One'), is 600. - This function is active by default. To turn this function off, choose Tools - Options - %PRODUCTNAME Calc - Calculate and clear the Automatically find column and row labels check box. + This function is active by default. To turn this function off, choose Tools - Options - %PRODUCTNAME Calc - Calculate and clear the Automatically find column and row labels check box. If you want a name to be automatically recognized by Calc, the name must start with a letter and be composed of alphanumeric characters. If you enter the name in the formula yourself, enclose the name in single quotation marks ('). If a single quotation mark appears in a name, you must enter a backslash in front of the quotation mark, for example, 'Harry\'s Bar'. - +
mw changed reference to deleted Calc guide address_byname.xhp to refer to Calc guide value_with_name.xhpUFI: changed embedvar links to embed links diff --git a/helpcontent2/source/text/scalc/guide/auto_off.xhp b/helpcontent2/source/text/scalc/guide/auto_off.xhp index 433a6ddfb3..18752f198a 100755 --- a/helpcontent2/source/text/scalc/guide/auto_off.xhp +++ b/helpcontent2/source/text/scalc/guide/auto_off.xhp @@ -64,13 +64,13 @@ The following shows you how to deactivate and reactivate the automatic changes in $[officename] Calc: Automatic Text or Number Completion When making an entry in a cell, $[officename] Calc automatically suggests matching input found in the same column. This function is known as AutoInput. - To turn the AutoInput on and off, set or remove the check mark in front of Tools - Cell Contents - AutoInput. + To turn the AutoInput on and off, set or remove the check mark in front of Tools - Cell Contents - AutoInput. Automatic Conversion to Date Format - $[officename] Calc automatically converts certain entries to dates. For example, the entry 1.1 may be interpreted as January 1 of the current year, according to the locale settings of your operating system, and then displayed according to the date format applied to the cell.for sure 1.1 will not be interpreted as a date in the USofA !! + $[officename] Calc automatically converts certain entries to dates. For example, the entry 1.1 may be interpreted as January 1 of the current year, according to the locale settings of your operating system, and then displayed according to the date format applied to the cell.for sure 1.1 will not be interpreted as a date in the USofA !! To ensure that an entry is interpreted as text, add an apostrophe at the beginning of the entry. The apostrophe is not displayed in the cell. Quotation Marks Replaced by Custom Quotes - Choose Tools - AutoCorrect Options. Go to the Custom Quotes tab and unmark Replace. + Choose Tools - AutoCorrect Options. Go to the Custom Quotes tab and unmark Replace. Cell Content Always Begins With Uppercase Choose Tools - AutoCorrect Options. Go to the Options tab. Unmark Capitalize first letter of every sentence. diff --git a/helpcontent2/source/text/scalc/guide/autofilter.xhp b/helpcontent2/source/text/scalc/guide/autofilter.xhp index 44f5c29145..d18ef5a2fc 100755 --- a/helpcontent2/source/text/scalc/guide/autofilter.xhp +++ b/helpcontent2/source/text/scalc/guide/autofilter.xhp @@ -58,7 +58,7 @@ Select the columns you want to use AutoFilter on. - Choose Data - Filter - AutoFilter. The combo box arrows are visible in the first row of the range selected. + Choose Data - Filter - AutoFilter. The combo box arrows are visible in the first row of the range selected. Run the filter by clicking the drop-down arrow in the column heading and choosing an item. @@ -67,7 +67,7 @@ When you apply an additional AutoFilter on another column of a filtered data range, then the other combo boxes list only the filtered data. To display all records again, select the "all" entry in the AutoFilter combo box. If you choose "Standard", the Standard Filter dialog appears, allowing you to set up a standard filter. Choose "Top 10" to display the highest 10 values only. - To stop using AutoFilter, reselect all cells selected in step 1 and once again choose Data - Filter - AutoFilter. + To stop using AutoFilter, reselect all cells selected in step 1 and once again choose Data - Filter - AutoFilter. To assign different AutoFilters to different sheets, you must first define a database range on each sheet. The arithmetic functions also take account of the cells that are not visible due to an applied filter. For example, a sum of an entire column will also total the values in the filtered cells. Apply the SUBTOTAL function if only the cells visible after the application of a filter are to be taken into account.
diff --git a/helpcontent2/source/text/scalc/guide/autoformat.xhp b/helpcontent2/source/text/scalc/guide/autoformat.xhp index fafbb4dfc0..921e114cdd 100755 --- a/helpcontent2/source/text/scalc/guide/autoformat.xhp +++ b/helpcontent2/source/text/scalc/guide/autoformat.xhp @@ -49,7 +49,7 @@ sheets;AutoFormat function MW deleted "applying;" Applying Automatic Formatting to a Selected Cell Range + oldref="11">Applying Automatic Formatting to a Selected Cell Range You can use the AutoFormat feature to quickly apply a format to a sheet or a selected cell range. To Apply an AutoFormat to a Sheet or Selected Cell Range @@ -61,10 +61,10 @@ Choose Format - AutoFormat. - To select which properties to include in an AutoFormat, click More. + To select which properties to include in an AutoFormat, click More. - Click OK. + Click OK. The format is applied to the selected range of cells. @@ -83,13 +83,13 @@ Choose Format - AutoFormat. - Click Add. + Click Add. - In the Name box of the Add AutoFormat dialog, enter a name for the format. + In the Name box of the Add AutoFormat dialog, enter a name for the format. - Click OK. + Click OK.
diff --git a/helpcontent2/source/text/scalc/guide/background.xhp b/helpcontent2/source/text/scalc/guide/background.xhp index ed7837de5b..b0dd08eda9 100644 --- a/helpcontent2/source/text/scalc/guide/background.xhp +++ b/helpcontent2/source/text/scalc/guide/background.xhp @@ -58,21 +58,21 @@ Select the cells. - Choose Format - Cells (or Format Cells from the context menu). + Choose Format - Cells (or Format Cells from the context menu). - On the Background tab page, select the background color. + On the Background tab page, select the background color. Graphics in the Background of Cells - Choose Insert - Picture - From File. + Choose Insert - Picture - From File. - Select the graphic and click Open. - The graphic is inserted anchored to the current cell. You can move and scale the graphic as you want. In your context menu you can use the Arrange - To Background command to place this in the background. To select a graphic that has been placed in the background, use the Navigator + Select the graphic and click Open. + The graphic is inserted anchored to the current cell. You can move and scale the graphic as you want. In your context menu you can use the Arrange - To Background command to place this in the background. To select a graphic that has been placed in the background, use the Navigator Navigator. diff --git a/helpcontent2/source/text/scalc/guide/borders.xhp b/helpcontent2/source/text/scalc/guide/borders.xhp index e69deb7cb4..755d431395 100755 --- a/helpcontent2/source/text/scalc/guide/borders.xhp +++ b/helpcontent2/source/text/scalc/guide/borders.xhp @@ -56,13 +56,13 @@ Choose Format - Cells. - In the dialog, click the Borders tab. + In the dialog, click the Borders tab. - Choose the border options you want to apply and click OK. + Choose the border options you want to apply and click OK. - The options in the Line arrangement area can be used to apply multiple border styles. + The options in the Line arrangement area can be used to apply multiple border styles. Selection of cells Depending on the selection of cells, the area looks different. @@ -118,7 +118,7 @@ You cannot apply borders to multiple selections.Default Settings - Click one of the Default icons to set or reset multiple borders. + Click one of the Default icons to set or reset multiple borders. The thin gray lines inside an icon show the borders that will be reset or cleared. @@ -131,7 +131,7 @@ Examples - Select a block of about 8x8 cells, then choose Format - Cells - Borders. + Select a block of about 8x8 cells, then choose Format - Cells - Borders. default icon row of Borders tab page @@ -148,7 +148,7 @@ Now you can continue to see which lines the other icons will set or remove.User Defined Settings - In the User defined area, you can click to set or remove individual lines. The preview shows lines in three different states. + In the User defined area, you can click to set or remove individual lines. The preview shows lines in three different states. Repeatedly click an edge or a corner to switch through the three different states.
@@ -204,7 +204,7 @@
Examples - Select a single cell, then choose Format - Cells - Borders. + Select a single cell, then choose Format - Cells - Borders. Click the lower edge to set a very thin line as a lower border. All other lines will be removed from the cell. setting a thin lower border @@ -213,7 +213,7 @@ setting a thick line as a border - Click the second Default icon from the left to set all four borders. Then repeatedly click the lower edge until a white line is shown. This removes the lower border. + Click the second Default icon from the left to set all four borders. Then repeatedly click the lower edge until a white line is shown. This removes the lower border. removing lower border diff --git a/helpcontent2/source/text/scalc/guide/calc_date.xhp b/helpcontent2/source/text/scalc/guide/calc_date.xhp index 30fc2a99fb..ce4851ddc5 100755 --- a/helpcontent2/source/text/scalc/guide/calc_date.xhp +++ b/helpcontent2/source/text/scalc/guide/calc_date.xhp @@ -59,10 +59,10 @@ - After pressing the Enter key you will see the result in date format. Since the result should show the difference between two dates as a number of days, you must format cell A3 as a number. + After pressing the Enter key you will see the result in date format. Since the result should show the difference between two dates as a number of days, you must format cell A3 as a number. - Place the cursor in cell A3, right-click to open a context menu and choose Format Cells. + Place the cursor in cell A3, right-click to open a context menu and choose Format Cells. The Format Cells dialog appears. On the Numbers tab, the "Number" category will appear already highlighted. The format is set to "General", which causes the result of a calculation containing date entries to be displayed as a date. To display the result as a number, set the number format to "-1,234" and close the dialog with the OK button. @@ -71,10 +71,10 @@ The number of days between today's date and the specified date is displayed in cell A3. - Experiment with some additional formulas: in A4 enter =A3*24 to calculate the hours, in A5 enter =A4*60 for the minutes, and in A6 enter =A5*60 for seconds. Press the Enter key after each formula. + Experiment with some additional formulas: in A4 enter =A3*24 to calculate the hours, in A5 enter =A4*60 for the minutes, and in A6 enter =A5*60 for seconds. Press the Enter key after each formula. - The time since your date of birth will be calculated and displayed in the various units. The values are calculated as of the exact moment when you entered the last formula and pressed the Enter key. This value is not automatically updated, although "Now" continuously changes. In the Tools menu, the menu item Cell Contents - AutoCalculate is normally active; however, automatic calculation does not apply to the function NOW. This ensures that your computer is not solely occupied with updating the sheet. + The time since your date of birth will be calculated and displayed in the various units. The values are calculated as of the exact moment when you entered the last formula and pressed the Enter key. This value is not automatically updated, although "Now" continuously changes. In the Tools menu, the menu item Cell Contents - AutoCalculate is normally active; however, automatic calculation does not apply to the function NOW. This ensures that your computer is not solely occupied with updating the sheet.
diff --git a/helpcontent2/source/text/scalc/guide/calc_series.xhp b/helpcontent2/source/text/scalc/guide/calc_series.xhp index 5aea6cdfa0..806acd7d59 100755 --- a/helpcontent2/source/text/scalc/guide/calc_series.xhp +++ b/helpcontent2/source/text/scalc/guide/calc_series.xhp @@ -73,7 +73,7 @@ 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. + 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 @@ -84,9 +84,9 @@ 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. + 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.
diff --git a/helpcontent2/source/text/scalc/guide/calculate.xhp b/helpcontent2/source/text/scalc/guide/calculate.xhp index 6bcba3f555..50fc1fd1e6 100644 --- a/helpcontent2/source/text/scalc/guide/calculate.xhp +++ b/helpcontent2/source/text/scalc/guide/calculate.xhp @@ -54,22 +54,22 @@ Click in a cell, and type a number - Press Enter. + Press Enter. The cursor moves down to the next cell. Enter another number. - Press the Tab key. + Press the Tab key. The cursor moves to the right into the next cell. Type in a formula, for example, =A3 * A4 / 100. - + - Press Enter. + Press Enter. The result of the formula appears in the cell. If you want, you can edit the formula in the input line of the Formula bar. When you edit a formula, the new result is calculated automatically. diff --git a/helpcontent2/source/text/scalc/guide/cell_protect.xhp b/helpcontent2/source/text/scalc/guide/cell_protect.xhp index a32b7bd6c1..2e67ff433e 100755 --- a/helpcontent2/source/text/scalc/guide/cell_protect.xhp +++ b/helpcontent2/source/text/scalc/guide/cell_protect.xhp @@ -51,7 +51,7 @@ hiding;formulas formulas;hiding MW transferred "modifying;..." and "changing;..." into one index entry -Protecting Cells from Changes +Protecting Cells from Changes In %PRODUCTNAME Calc you can protect sheets and the document as a whole. You can choose whether the cells are protected against accidental changes, whether the formulas can be viewed from within Calc, whether the cells are visible or whether the cells can be printed. Protection can be provided by means of a password, but it does not have to be. If you have assigned a password, protection can only be removed once the correct password has been entered. @@ -62,20 +62,20 @@ Select the cells that you want to specify the cell protection options for. - Choose Format - Cells and click the Cell Protection tab. + Choose Format - Cells and click the Cell Protection tab. Select the protection options that you want. - Select Protected to prevent changes to the contents and the format of a cell. - Select Hide formula to hide and to protect formulas from changes. - Select Hide when printing to hide protected cells in the printed document. The cells are not hidden on screen. + Select Protected to prevent changes to the contents and the format of a cell. + Select Hide formula to hide and to protect formulas from changes. + Select Hide when printing to hide protected cells in the printed document. The cells are not hidden onscreen. - Click OK. + Click OK. Apply the protection options. - To protect the cells from being changed / viewed / printed according to your settings in the Format - Cells dialog, choose Tools - Protect Document - Sheet. + To protect the cells from being changed / viewed / printed according to your settings in the Format - Cells dialog, choose Tools - Protect Document - Sheet. To protect the structure of the document, for example the count, names, and order of the sheets, from being changed, choose Tools - Protect Document - Document. @@ -83,7 +83,7 @@ If you forget your password, you cannot deactivate the protection. If you only want to protect cells from accidental changes, set the sheet protection, but do not enter a password. - Click OK. + Click OK.
diff --git a/helpcontent2/source/text/scalc/guide/cell_unprotect.xhp b/helpcontent2/source/text/scalc/guide/cell_unprotect.xhp index e61d2b59eb..e1c1397cd4 100755 --- a/helpcontent2/source/text/scalc/guide/cell_unprotect.xhp +++ b/helpcontent2/source/text/scalc/guide/cell_unprotect.xhp @@ -46,17 +46,17 @@ unprotecting cells Unprotecting Cells + oldref="14">Unprotecting Cells Click the sheet for which you want to cancel the protection. - Select Tools - Protect Document, then choose Sheet or Document to remove the check mark indicating the protected status. + Select Tools - Protect Document, then choose Sheet or Document to remove the check mark indicating the protected status. - If you have assigned a password, enter it in this dialog and click OK. + If you have assigned a password, enter it in this dialog and click OK. The cells can now be edited, the formulas can be viewed, and all cells can be printed until you reactivate the protection for the sheet or document. diff --git a/helpcontent2/source/text/scalc/guide/cellcopy.xhp b/helpcontent2/source/text/scalc/guide/cellcopy.xhp index f966aa8b07..1fb57a4747 100755 --- a/helpcontent2/source/text/scalc/guide/cellcopy.xhp +++ b/helpcontent2/source/text/scalc/guide/cellcopy.xhp @@ -75,7 +75,7 @@ - Cells were hidden using the Hide command in the context menu of the row or column headers, or through an outline. + Cells were hidden using the Hide command in the context menu of the row or column headers, or through an outline. Copy, delete, move, or format a selection of currently visible cells. diff --git a/helpcontent2/source/text/scalc/guide/cellreference_dragdrop.xhp b/helpcontent2/source/text/scalc/guide/cellreference_dragdrop.xhp index 2fe2452ffc..faca94621c 100755 --- a/helpcontent2/source/text/scalc/guide/cellreference_dragdrop.xhp +++ b/helpcontent2/source/text/scalc/guide/cellreference_dragdrop.xhp @@ -55,7 +55,7 @@ Open the document that contains the source cells. - To set the source range as the range, select the cells and choose Insert - Names - Define. Save the source document, and do not close it. + To set the source range as the range, select the cells and choose Insert - Names - Define. Save the source document, and do not close it. Open the sheet in which you want to insert something. @@ -67,7 +67,7 @@ In the Navigator, the source file object appears under "Range names". - Using the Drag Mode icon in Navigator, choose whether you want the reference to be a hyperlink, link, or copy. + Using the Drag Mode icon in Navigator, choose whether you want the reference to be a hyperlink, link, or copy. Click the name under "Range names" in the Navigator, and drag into the cell of the current sheet where you want to insert the reference. diff --git a/helpcontent2/source/text/scalc/guide/cellreferences.xhp b/helpcontent2/source/text/scalc/guide/cellreferences.xhp index 07d3f82612..9899931b29 100755 --- a/helpcontent2/source/text/scalc/guide/cellreferences.xhp +++ b/helpcontent2/source/text/scalc/guide/cellreferences.xhp @@ -63,19 +63,19 @@ - Click the Sheet 2 tab at the bottom of the spreadsheet. Set the cursor in cell A1 there and enter text or a number. + Click the Sheet 2 tab at the bottom of the spreadsheet. Set the cursor in cell A1 there and enter text or a number. - If you switch back to Sheet1, you will see the same content in cell A1 there. If the contents of Sheet2.A1 change, then the contents of Sheet1.A1 also change. + If you switch back to Sheet1, you will see the same content in cell A1 there. If the contents of Sheet2.A1 change, then the contents of Sheet1.A1 also change. To Reference a Cell in Another Document - Choose File - Open, to load an existing spreadsheet document. + Choose File - Open, to load an existing spreadsheet document. - Choose File - New, to open a new spreadsheet document. Set the cursor in the cell where you want to insert the external data and enter an equals sign to indicate that you want to begin a formula. + Choose File - New, to open a new spreadsheet document. Set the cursor in the cell where you want to insert the external data and enter an equals sign to indicate that you want to begin a formula. Now switch to the document you have just loaded. Click the cell with the data that you want to insert in the new document. diff --git a/helpcontent2/source/text/scalc/guide/cellreferences_url.xhp b/helpcontent2/source/text/scalc/guide/cellreferences_url.xhp index 49db1f1b47..a11288e033 100755 --- a/helpcontent2/source/text/scalc/guide/cellreferences_url.xhp +++ b/helpcontent2/source/text/scalc/guide/cellreferences_url.xhp @@ -3,78 +3,78 @@ - +* +* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. +* +* Copyright 2008 by Sun Microsystems, Inc. +* +* OpenOffice.org - a multi-platform office productivity suite +* +* $RCSfile: soffice2xmlhelp.xsl,v $ +* $Revision: 1.8 $ +* +* This file is part of OpenOffice.org. +* +* OpenOffice.org is free software: you can redistribute it and/or modify +* it under the terms of the GNU Lesser General Public License version 3 +* only, as published by the Free Software Foundation. +* +* OpenOffice.org is distributed in the hope that it will be useful, +* but WITHOUT ANY WARRANTY; without even the implied warranty of +* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +* GNU Lesser General Public License version 3 for more details +* (a copy is included in the LICENSE file that accompanied this code). +* +* You should have received a copy of the GNU Lesser General Public License +* version 3 along with OpenOffice.org. If not, see +* +* for a copy of the LGPLv3 License. +* +************************************************************************ +--> + - - References to Other Sheets and Referencing URLs - /text/scalc/guide/cellreferences_url.xhp - - - + +References to Other Sheets and Referencing URLs +/text/scalc/guide/cellreferences_url.xhp + + + HTML; in sheet cells - references; URL in cells - cells; Internet references - URL; in Calc +references; URL in cells +cells; Internet references +URL; in Calc mw deleted "sheet references;" Referencing URLs +oldref="15">Referencing URLs - For example, if you found an Internet page containing current stock exchange information in spreadsheet cells, you can load this page in $[officename] Calc by using the following procedure: - - - In a $[officename] Calc document, position the cursor in the cell into which you want to insert the external data. - - - Choose Insert - Link to External Data. The External Data dialog appears. - - - Enter the URL of the document or Web page in the dialog. The URL must be in the format: http://www.my-bank.com/table.html. The URL for local or local area network files is the path seen in the File - Open dialog. - $[officename] loads the Web page or file in the "background", that is, without displaying it. In the large list box of the External Data dialog, you can see the name of all the sheets or named ranges you can choose from. - - - Select one or more sheets or named ranges. You can also activate the automatic update function every "n" minutes and click OK. - The contents will be inserted as a link in the $[officename] Calc document. - - - Save your spreadsheet. When you open it again later, $[officename] Calc will update the linked cells following an inquiry. - - - Under Tools - Options - %PRODUCTNAME Calc - General you can choose to have the update, when opened, automatically carried out either always, upon request or never. The update can be started manually in the dialog under Edit - Links. - - -
- - -
- +For example, if you found an Internet page containing current stock exchange information in spreadsheet cells, you can load this page in $[officename] Calc by using the following procedure: + + +In a $[officename] Calc document, position the cursor in the cell into which you want to insert the external data. + + +Choose Insert - Link to External Data. The External Data dialog appears. + + +Enter the URL of the document or Web page in the dialog. The URL must be in the format: http://www.my-bank.com/table.html. The URL for local or local area network files is the path seen in the File - Open dialog. +$[officename] loads the Web page or file in the "background", that is, without displaying it. In the large list box of the External Data dialog, you can see the name of all the sheets or named ranges you can choose from. + + +Select one or more sheets or named ranges. You can also activate the automatic update function every "n" seconds and click OK. +The contents will be inserted as a link in the $[officename] Calc document. + + +Save your spreadsheet. When you open it again later, $[officename] Calc will update the linked cells following an inquiry. + + +Under Tools - Options - %PRODUCTNAME Calc - General you can choose to have the update, when opened, automatically carried out either always, upon request or never. The update can be started manually in the dialog under Edit - Links. + + +
+ + +
+ \ No newline at end of file diff --git a/helpcontent2/source/text/scalc/guide/cellstyle_by_formula.xhp b/helpcontent2/source/text/scalc/guide/cellstyle_by_formula.xhp index f83a1dc4ef..5ed2826561 100755 --- a/helpcontent2/source/text/scalc/guide/cellstyle_by_formula.xhp +++ b/helpcontent2/source/text/scalc/guide/cellstyle_by_formula.xhp @@ -48,7 +48,7 @@ formulas;assigning cell formats mw deleted "applying;" Assigning Formats by Formula + oldref="13">Assigning Formats by Formula The STYLE() function can be added to an existing formula in a cell. For example, together with the CURRENT function, you can color a cell depending on its value. The formula =...+STYLE(IF(CURRENT()>3; "Red"; "Green")) applies the cell style "Red" to cells if the value is greater than 3, otherwise the cell style "Green" is applied. If you would like to apply a formula to all cells in a selected area, you can use the @@ -58,7 +58,7 @@ Select all the desired cells. - Select the menu command Edit - Find & Replace. + Select the menu command Edit - Find & Replace. For the Search for term, enter: .* @@ -68,10 +68,10 @@ Enter the following formula in the Replace with field: =&+STYLE(IF(CURRENT()>3;"Red";"Green")) - The "&" symbol designates the current contents of the Search for field. The line must begin with an equal sign, since it is a formula. It is assumed that the cell styles "Red" and "Green" already exist. + The "&" symbol designates the current contents of the Search for field. The line must begin with an equal sign, since it is a formula. It is assumed that the cell styles "Red" and "Green" already exist. - Mark the fields Regular expressions and Current selection only. Click Find All. + Mark the fields Regular expressions and Current selection only. Click Find All. All cells with contents that were included in the selection are now highlighted. diff --git a/helpcontent2/source/text/scalc/guide/cellstyle_conditional.xhp b/helpcontent2/source/text/scalc/guide/cellstyle_conditional.xhp index 6bd9c55a11..fe5b0785f5 100755 --- a/helpcontent2/source/text/scalc/guide/cellstyle_conditional.xhp +++ b/helpcontent2/source/text/scalc/guide/cellstyle_conditional.xhp @@ -54,8 +54,8 @@ Applying Conditional Formatting - Using the menu command Format - Conditional formatting, the dialog allows you to define up to three conditions per cell, which must be met in order for the selected cells to have a particular format. - To apply conditional formatting, AutoCalculate must be enabled. Choose Tools - Cell Contents - AutoCalculate (you see a check mark next to the command when AutoCalculate is enabled). + Using the menu command Format - Conditional formatting, the dialog allows you to define up to three conditions per cell, which must be met in order for the selected cells to have a particular format. + To apply conditional formatting, AutoCalculate must be enabled. Choose Tools - Cell Contents - AutoCalculate (you see a check mark next to the command when AutoCalculate is enabled). With conditional formatting, you can, for example, highlight the totals that exceed the average value of all totals. If the totals change, the formatting changes correspondingly, without having to apply other styles manually. To Define the Conditions @@ -63,7 +63,7 @@ Select the cells to which you want to apply a conditional style. - Choose Format - Conditional Formatting. + Choose Format - Conditional Formatting. Enter the condition(s) into the dialog box. The dialog is described in detail in $[officename] Help, and an example is provided below: @@ -76,7 +76,7 @@ First of all, write a table in which a few different values occur. For your test you can create tables with any random numbers: - In one of the cells enter the formula =RAND(), and you will obtain a random number between 0 and 1. If you want integers of between 0 and 50, enter the formula =INT(RAND()*50). + In one of the cells enter the formula =RAND(), and you will obtain a random number between 0 and 1. If you want integers of between 0 and 50, enter the formula =INT(RAND()*50). Copy the formula to create a row of random numbers. Click the bottom right corner of the selected cell, and drag to the right until the desired cell range is selected. @@ -90,13 +90,13 @@ The next step is to apply a cell style to all values that represent above-average turnover, and one to those that are below the average. Ensure that the Styles and Formatting window is visible before proceeding. - Click in a blank cell and select the command Format Cells in the context menu. + Click in a blank cell and select the command Format Cells in the context menu. - In the Format Cells dialog on the Background tab, select a background color. Click OK. + In the Format Cells dialog on the Background tab, select a background color. Click OK. - In the Styles and Formatting window, click the New Style from Selection icon. Enter the name of the new style. For this example, name the style "Above". + In the Styles and Formatting window, click the New Style from Selection icon. Enter the name of the new style. For this example, name the style "Above". To define a second style, click again in a blank cell and proceed as described above. Assign a different background color for the cell and assign a name (for this example, "Below"). @@ -107,7 +107,7 @@ In our particular example, we are calculating the average of the random values. The result is placed in a cell: - Set the cursor in a blank cell, for example, J14, and choose Insert - Function. + Set the cursor in a blank cell, for example, J14, and choose Insert - Function. Select the AVERAGE function. Use the mouse to select all your random numbers. If you cannot see the entire range, because the Function Wizard is obscuring it, you can temporarily shrink the dialog using the Shrink / Maximize icon. @@ -124,7 +124,7 @@ Select all cells with the random numbers. - Choose the Format - Conditional Formatting command to open the corresponding dialog. + Choose the Format - Conditional Formatting command to open the corresponding dialog. Define the condition as follows: If cell value is less than J14, format with cell style "Below", and if cell value is greater than or equal to J14, format with cell style "Above". @@ -144,10 +144,10 @@ Select the cells that are to receive this same formatting. - Choose Edit - Paste Special. The Paste Special dialog appears. + Choose Edit - Paste Special. The Paste Special dialog appears. - In the Selection area, check only the Formats box. All other boxes must be unchecked. Click OK. + In the Selection area, check only the Formats box. All other boxes must be unchecked. Click OK.
diff --git a/helpcontent2/source/text/scalc/guide/cellstyle_minusvalue.xhp b/helpcontent2/source/text/scalc/guide/cellstyle_minusvalue.xhp index 6df51672f5..9b1f686f2b 100755 --- a/helpcontent2/source/text/scalc/guide/cellstyle_minusvalue.xhp +++ b/helpcontent2/source/text/scalc/guide/cellstyle_minusvalue.xhp @@ -53,10 +53,10 @@ You can format cells with a number format that highlights negative numbers in red. Alternatively, you can define your own number format in which negative numbers are highlighted in other colors. - Select the cells and choose Format - Cells. + Select the cells and choose Format - Cells. - On the Numbers tab, select a number format and mark Negative numbers red check box. Click OK. + On the Numbers tab, select a number format and mark Negative numbers red check box. Click OK. The cell number format is defined in two parts. The format for positive numbers and zero is defined in front of the semicolon; after the semicolon the formula for negative numbers is defined. You can change the code (RED) under Format code. For example, instead of RED, enter YELLOW. If the new code appears in the list after clicking the Add icon, this is a valid entry. diff --git a/helpcontent2/source/text/scalc/guide/consolidate.xhp b/helpcontent2/source/text/scalc/guide/consolidate.xhp index 78cd98a38c..79f02fbbb8 100755 --- a/helpcontent2/source/text/scalc/guide/consolidate.xhp +++ b/helpcontent2/source/text/scalc/guide/consolidate.xhp @@ -57,40 +57,40 @@ Open the document that contains the cell ranges to be consolidated. - Choose Data - Consolidate to open the Consolidate dialog. + Choose Data - Consolidate to open the Consolidate dialog. - From the Source data area box select a source cell range to consolidate with other areas. - If the range is not named, click in the field next to the Source data area. A blinking text cursor appears. Type a reference for the first source data range or select the range with the mouse. + From the Source data area box select a source cell range to consolidate with other areas. + If the range is not named, click in the field next to the Source data area. A blinking text cursor appears. Type a reference for the first source data range or select the range with the mouse. - Click Add to insert the selected range in the Consolidation areas field. + Click Add to insert the selected range in the Consolidation areas field. - Select additional ranges and click Add after each selection. + Select additional ranges and click Add after each selection. - Specify where you want to display the result by selecting a target range from the Copy results to box. - If the target range is not named, click in the field next to Copy results to and enter the reference of the target range. Alternatively, you can select the range using the mouse or position the cursor in the top left cell of the target range. + Specify where you want to display the result by selecting a target range from the Copy results to box. + If the target range is not named, click in the field next to Copy results to and enter the reference of the target range. Alternatively, you can select the range using the mouse or position the cursor in the top left cell of the target range. - Select a function from the Function box. The function specifies how the values of the consolidation ranges are linked. The "Sum" function is the default setting. + Select a function from the Function box. The function specifies how the values of the consolidation ranges are linked. The "Sum" function is the default setting. - Click OK to consolidate the ranges. + Click OK to consolidate the ranges. Additional Settings - Click More in the Consolidate dialog to display additional settings: + Click More in the Consolidate dialog to display additional settings: - Select Link to source data to insert the formulas that generate the results in the target range, rather than the actual results. If you link the data, any values modified in the source range are automatically updated in the target range. + Select Link to source data to insert the formulas that generate the results in the target range, rather than the actual results. If you link the data, any values modified in the source range are automatically updated in the target range. The corresponding cell references in the target range are inserted in consecutive rows, which are automatically ordered and then hidden from view. Only the final result, based on the selected function, is displayed. - Under Consolidate by, select either Row labels or Column labels if the cells of the source data range are not to be consolidated corresponding to the identical position of the cell in the range, but instead according to a matching row label or column label. + Under Consolidate by, select either Row labels or Column labels if the cells of the source data range are not to be consolidated corresponding to the identical position of the cell in the range, but instead according to a matching row label or column label. To consolidate by row labels or column labels, the label must be contained in the selected source ranges. The text in the labels must be identical, so that rows or columns can be accurately matched. If the row or column label does not match any that exist in the target range, it will be appended as a new row or column. diff --git a/helpcontent2/source/text/scalc/guide/csv_files.xhp b/helpcontent2/source/text/scalc/guide/csv_files.xhp index 58574514c8..9fc1d70b89 100755 --- a/helpcontent2/source/text/scalc/guide/csv_files.xhp +++ b/helpcontent2/source/text/scalc/guide/csv_files.xhp @@ -33,87 +33,86 @@ ************************************************************************ --> - - - Importing and Exporting CSV Files - /text/scalc/guide/csv_files.xhp - - - + + Importing and Exporting CSV Files +/text/scalc/guide/csv_files.xhp + + + number series import - data series import - exporting; tables as text - importing; tables as text - delimited values and files - comma separated files and values - text file import and export - csv files;importing and exporting - tables; importing/exporting as text - text documents; importing to spreadsheets - opening;text csv files - saving;as text csv +data series import +exporting; tables as text +importing; tables as text +delimited values and files +comma separated files and values +text file import and export +csv files;importing and exporting +tables; importing/exporting as text +text documents; importing to spreadsheets +opening;text csv files +saving;as text csv MW deleted "importing;text data bases" and copied 4 index entries from scalc/guide/csv_formula.xhpmw added "saving;" and "opening;" Opening and Saving Text CSV Files - Comma Separated Values (CSV) is text file format that you can use to exchange data from a database or a spreadsheet between applications. Each line in a Text CSV file represents a record in the database, or a row in a spreadsheet. Each field in a database record or cell in a spreadsheet row is usually separated by a comma. However, you can use other characters to delimit a field, such as a tabulator character. - If the content of a field or cell contains a comma, the contents of the field or cell must be enclosed by single quotes (') or double quotes ("). - To Open a Text CSV File in Calc - - - Choose File - Open. - - - Locate the CSV file that you want to open. - If the file has a *.csv extension, select the file. - If the CSV file has another extension, select the file, and then select "Text CSV" in the File type box - - - Click Open. - The Text Import dialog opens. - - - Specify the options to divide the text in the file into columns. - You can preview the layout of the imported data at the bottom of the Text Import dialog. - Right-click a column in the preview to set the format or to hide the column. - If the CSV file uses a text delimiter character that is not listed in the Text delimiter box, click in the box, and type the character. - - - Click OK. - - - To Save a Sheet as a Text CSV File - When you export a spreadsheet to CSV format, only the data on the current sheet is saved. All other information, including formulas and formatting, is lost. - - - Open the Calc sheet that you want to save as a Text CSV file. - Only the current sheet can be exported. - - - Choose File - Save as. - - - In the File name box, enter a name for the file. - - - In the File type box, select "Text CSV". - - - (Optional) Set the field options for the Text CSV file. - Select Edit filter settings. - In the Export of text files dialog, select the options that you want. - Click OK. - - - Click Save. - - -
- - - Tools - Options - %PRODUCTNAME Calc - View - Export text files - Import text files -
- +Comma Separated Values (CSV) is a text file format that you can use to exchange data from a database or a spreadsheet between applications. Each line in a Text CSV file represents a record in the database, or a row in a spreadsheet. Each field in a database record or cell in a spreadsheet row is usually separated by a comma. However, you can use other characters to delimit a field, such as a tabulator character. +If the field or cell contains a comma, the field or cell must be enclosed by single quotes (') or double quotes ("). +To Open a Text CSV File in Calc + + +Choose File - Open. + + +Locate the CSV file that you want to open. +If the file has a *.csv extension, select the file. +If the CSV file has another extension, select the file, and then select "Text CSV" in the File type box + + +Click Open. +The Text Import dialog opens. + + +Specify the options to divide the text in the file into columns. +You can preview the layout of the imported data at the bottom of the Text Import dialog. +Right-click a column in the preview to set the format or to hide the column. +Check the text delimiter box that matches the character used as text delimiter in the file. In case of an unlisted delimiter, type the character into the input box. + + +Click OK. + + +To Save a Sheet as a Text CSV File +When you export a spreadsheet to CSV format, only the data on the current sheet is saved. All other information, including formulas and formatting, is lost. + + +Open the Calc sheet that you want to save as a Text CSV file. +Only the current sheet can be exported. + + +Choose File - Save as. + + +In the File name box, enter a name for the file. + + +In the File type box, select "Text CSV". + + +(Optional) Set the field options for the Text CSV file. +Select Edit filter settings. +In the Export of text files dialog, select the options that you want. +Click OK. + + +Click Save. + + +
+ + +Tools - Options - %PRODUCTNAME Calc - View +Export text files +Import text files +
+ \ No newline at end of file diff --git a/helpcontent2/source/text/scalc/guide/csv_formula.xhp b/helpcontent2/source/text/scalc/guide/csv_formula.xhp index 5e29c0ea5b..906c6e28ce 100755 --- a/helpcontent2/source/text/scalc/guide/csv_formula.xhp +++ b/helpcontent2/source/text/scalc/guide/csv_formula.xhp @@ -53,16 +53,16 @@ oldref="15">To Import a CSV File - Choose File - Open. + Choose File - Open. - In the File type field, select the format "Text CSV". Select the file and click Open. When a file has the .csv extension, the file type is automatically recognized. + In the File type field, select the format "Text CSV". Select the file and click Open. When a file has the .csv extension, the file type is automatically recognized. You will see the Text Import dialog. Click OK. - If the csv file contains formulas, but you want to import the results of those formulas, then choose Tools - Options - %PRODUCTNAME Calc - View and clear the Formulas check box. + If the csv file contains formulas, but you want to import the results of those formulas, then choose Tools - Options - %PRODUCTNAME Calc - View and clear the Formulas check box. To Export Formulas and Values as CSV Files @@ -70,26 +70,26 @@ If you want to export the formulas as formulas, for example, in the form =SUM(A1:B5), proceed as follows: - Choose Tools - Options - %PRODUCTNAME Calc - View. - Under Display, mark the Formulas check box. Click OK. - If you want to export the calculation results instead of the formulas, do not mark Formulas. + Choose Tools - Options - %PRODUCTNAME Calc - View. + Under Display, mark the Formulas check box. Click OK. + If you want to export the calculation results instead of the formulas, do not mark Formulas. - Choose File - Save as. You will see the Save as dialog. + Choose File - Save as. You will see the Save as dialog. In the File type field select the format "Text CSV". - Enter a name and click Save. + Enter a name and click Save. - From the Export of text files dialog that appears, select the character set and the field and text delimiters for the data to be exported, and confirm with OK. + From the Export of text files dialog that appears, select the character set and the field and text delimiters for the data to be exported, and confirm with OK. If the numbers use commas as decimal separators or thousands separators, do not select the comma as the field delimiter. If the text contains double quotation marks, you must select the single quotation mark as separator.not possible to have a table here because that would break the numbering in XML. - If necessary, after you have saved, clear the Formulas check box to see the calculated results in the table again. + If necessary, after you have saved, clear the Formulas check box to see the calculated results in the table again.
diff --git a/helpcontent2/source/text/scalc/guide/currency_format.xhp b/helpcontent2/source/text/scalc/guide/currency_format.xhp index 7eb6a0b67e..b7d1544a9a 100644 --- a/helpcontent2/source/text/scalc/guide/currency_format.xhp +++ b/helpcontent2/source/text/scalc/guide/currency_format.xhp @@ -35,41 +35,40 @@ - - Cells in Currency Format - /text/scalc/guide/currency_format.xhp - - - + +Cells in Currency Format +/text/scalc/guide/currency_format.xhp + + + currency formats; spreadsheets - cells; currency formats - international currency formats - formats; currency formats in cells - currencies; default currencies - defaults;currency formats - changing;currency formats +cells; currency formats +international currency formats +formats; currency formats in cells +currencies; default currencies +defaults;currency formats +changing;currency formats mw changed one index entry Cells in Currency Format +oldref="46">Cells in Currency Format - In %PRODUCTNAME Calc you can give numbers any currency format. When you click the Currency icon -Icon - in the Formatting - bar to format a number, the cell is given the default currency format set under Tools - Options - Language Settings - Languages. - Exchanging of %PRODUCTNAME Calc documents can lead to misunderstandings, if your %PRODUCTNAME Calc document is loaded by a user who uses a different default currency format. - In %PRODUCTNAME Calc you can define that a number that you have formatted as "1,234.50 €", still remains in euros in another country and does not become dollars. - You can change the currency format in the Format Cells dialog (choose Format - Cells - Numbers tab) by two country settings. In the Language combo box select the basic setting for currency symbol, decimal and thousands separators. In the Format list box you can select possible variations from the default format for the language. - - - For example, if the language is set to "Default" and you are using a german locale setting, the currency format will be "1.234,00 €". A point is used before the thousand digits and a comma before the decimal places. If you now select the subordinate currency format "$ English (US)" from the Format list box , you will get the following format: "$ 1.234,00". As you can see, the separators have remained the same. Only the currency symbol has been changed and converted, but the underlying format of the notation remains the same as in the locale setting. - - - If, under Language, you convert the cells to "English (US)", the English-language locale setting is also transferred and the default currency format is now "$ 1,234.00". - - -
- - Format - Cell - Numbers -
- +In %PRODUCTNAME Calc you can give numbers any currency format. When you click the Currency icon +Icon + in the Formatting bar to format a number, the cell is given the default currency format set under Tools - Options - Language Settings - Languages. +Exchanging of %PRODUCTNAME Calc documents can lead to misunderstandings, if your %PRODUCTNAME Calc document is loaded by a user who uses a different default currency format. +In %PRODUCTNAME Calc you can define that a number that you have formatted as "1,234.50 €", still remains in euros in another country and does not become dollars. +You can change the currency format in the Format Cells dialog (choose Format - Cells - Numbers tab) by two country settings. In the Language combo box select the basic setting for decimal and thousands separators. In the Format list box you can select the currency symbol and its position. + + +For example, if the language is set to "Default" and you are using a german locale setting, the currency format will be "1.234,00 €". A point is used before the thousand digits and a comma before the decimal places. If you now select the subordinate currency format "$ English (US)" from the Format list box , you will get the following format: "$ 1.234,00". As you can see, the separators have remained the same. Only the currency symbol has been changed and converted, but the underlying format of the notation remains the same as in the locale setting. + + +If, under Language, you convert the cells to "English (US)", the English-language locale setting is also transferred and the default currency format is now "$ 1,234.00". + + +
+ +Format - Cells - Numbers +
+ \ No newline at end of file diff --git a/helpcontent2/source/text/scalc/guide/database_define.xhp b/helpcontent2/source/text/scalc/guide/database_define.xhp index fd95524886..bbcdeda893 100755 --- a/helpcontent2/source/text/scalc/guide/database_define.xhp +++ b/helpcontent2/source/text/scalc/guide/database_define.xhp @@ -60,16 +60,16 @@ Choose Data - Define Range. - In the Name box, enter a name for the database range. + In the Name box, enter a name for the database range. - Click More. + Click More. Specify the options for the database range. - Click OK. + Click OK.
diff --git a/helpcontent2/source/text/scalc/guide/database_filter.xhp b/helpcontent2/source/text/scalc/guide/database_filter.xhp index 077d5037c9..2a008bbcb8 100755 --- a/helpcontent2/source/text/scalc/guide/database_filter.xhp +++ b/helpcontent2/source/text/scalc/guide/database_filter.xhp @@ -59,10 +59,10 @@ Choose Data - Filter - Standard Filter. - In the Standard Filter dialog, specify the filter options that you want. + In the Standard Filter dialog, specify the filter options that you want. - Click OK. + Click OK. The records that match the filter options that you specified are shown. diff --git a/helpcontent2/source/text/scalc/guide/database_sort.xhp b/helpcontent2/source/text/scalc/guide/database_sort.xhp index 2aaf2e1177..debf70ce97 100755 --- a/helpcontent2/source/text/scalc/guide/database_sort.xhp +++ b/helpcontent2/source/text/scalc/guide/database_sort.xhp @@ -61,7 +61,7 @@ Select the sort options that you want. - Click OK. + Click OK.
diff --git a/helpcontent2/source/text/scalc/guide/datapilot_createtable.xhp b/helpcontent2/source/text/scalc/guide/datapilot_createtable.xhp index 9bc374e69f..d52bd4fb4b 100755 --- a/helpcontent2/source/text/scalc/guide/datapilot_createtable.xhp +++ b/helpcontent2/source/text/scalc/guide/datapilot_createtable.xhp @@ -51,17 +51,17 @@ Position the cursor within a range of cells containing values, row and column headings. - Choose Data - DataPilot - Start. The Select Source dialog appears. Choose Current selection and confirm with OK. The table headings are shown as buttons in the DataPilot dialog. Drag these buttons as required and drop them into the layout areas "Page Fields", "Column Fields", "Row Fields" and "Data Fields". + Choose Data - DataPilot - Start. The Select Source dialog appears. Choose Current selection and confirm with OK. The table headings are shown as buttons in the DataPilot dialog. Drag these buttons as required and drop them into the layout areas "Page Fields", "Column Fields", "Row Fields" and "Data Fields". Drag the desired buttons into one of the four areas. - Drag a button to the Page Fields area to create a button and a listbox on top of the generated datapilot table. The listbox can be used to filter the DataPilot table by the contents of the selected item. You can use drag-and-drop within the generated DataPilot table to use another page field as a filter. - If the button is dropped in the Data Fields area it will be given a caption that also shows the formula that will be used to calculate the data. + Drag a button to the Page Fields area to create a button and a listbox on top of the generated datapilot table. The listbox can be used to filter the DataPilot table by the contents of the selected item. You can use drag-and-drop within the generated DataPilot table to use another page field as a filter. + If the button is dropped in the Data Fields area it will be given a caption that also shows the formula that will be used to calculate the data. - By double-clicking on one of the fields in the Data Fields area you can call up the Data Field dialog. + By double-clicking on one of the fields in the Data Fields area you can call up the Data Field dialog. Use the Data Field dialog to select the calculations to be used for the data. To make a multiple selection, press the Command @@ -76,10 +76,10 @@ Remove a button by dragging it back to the area of the other buttons at the right of the dialog. - To open the Data Field dialog, double-click one of the buttons in the Row or Column area. Use the dialog to select if and to what extent %PRODUCTNAME calculates display subtotals. + To open the Data Field dialog, double-click one of the buttons in the Row or Column area. Use the dialog to select if and to what extent %PRODUCTNAME calculates display subtotals. - Exit the DataPilot dialog by pressing OK. A Filter button will now be inserted, or a page button for every data field that you dropped in the Page Fields area. The DataPilot table is inserted further down. + Exit the DataPilot dialog by pressing OK. A Filter button will now be inserted, or a page button for every data field that you dropped in the Page Fields area. The DataPilot table is inserted further down.
diff --git a/helpcontent2/source/text/scalc/guide/datapilot_deletetable.xhp b/helpcontent2/source/text/scalc/guide/datapilot_deletetable.xhp index 20b7ddf137..680fc89aa6 100755 --- a/helpcontent2/source/text/scalc/guide/datapilot_deletetable.xhp +++ b/helpcontent2/source/text/scalc/guide/datapilot_deletetable.xhp @@ -47,7 +47,7 @@ Deleting DataPilot Tables - In order to delete a DataPilot table, select any cell in the DataPilot table, then choose Delete in the context menu. + In order to delete a DataPilot table, select any cell in the DataPilot table, then choose Delete in the context menu.
diff --git a/helpcontent2/source/text/scalc/guide/datapilot_edittable.xhp b/helpcontent2/source/text/scalc/guide/datapilot_edittable.xhp index b127c48274..821d21dc6f 100644 --- a/helpcontent2/source/text/scalc/guide/datapilot_edittable.xhp +++ b/helpcontent2/source/text/scalc/guide/datapilot_edittable.xhp @@ -49,9 +49,9 @@ Click one of the buttons in the table that the DataPilot has created and hold the mouse button down. A special symbol will appear next to the mouse pointer. By dragging the button to a different position in the same row you can alter the order of the columns. If you drag a button to the left edge of the table into the row headings area, you can change a column into a row. - In the DataPilot dialog, you can drag a button to the Page Fields area to create a button and a listbox on top of the generated DataPilot table. The listbox can be used to filter the DataPilot table by the contents of the selected item. You can use drag-and-drop within the generated DataPilot table to use another page field as a filter. + In the DataPilot dialog, you can drag a button to the Page Fields area to create a button and a listbox on top of the generated DataPilot table. The listbox can be used to filter the DataPilot table by the contents of the selected item. You can use drag-and-drop within the generated DataPilot table to use another page field as a filter. To remove a button from the table, just drag it out of the DataPilot table. Release the mouse button when the mouse pointer positioned within the sheet has become a 'not allowed' icon. The button is deleted. - To edit the DataPilot table, click a cell inside the DataPilot table and open the context menu. In the context menu you find the command Start, which displays the DataPilot dialog for the current DataPilot table. + To edit the DataPilot table, click a cell inside the DataPilot table and open the context menu. In the context menu you find the command Start, which displays the DataPilot dialog for the current DataPilot table. In the DataPilot table, you can use drag-and-drop or cut/paste commands to rearrange the order of data fields. By double-clicking on some buttons inside the DataPilot table you can hide the subelements below it.
diff --git a/helpcontent2/source/text/scalc/guide/datapilot_filtertable.xhp b/helpcontent2/source/text/scalc/guide/datapilot_filtertable.xhp index 8ccc274ede..b80637dfdc 100644 --- a/helpcontent2/source/text/scalc/guide/datapilot_filtertable.xhp +++ b/helpcontent2/source/text/scalc/guide/datapilot_filtertable.xhp @@ -48,7 +48,7 @@ oldref="35">Filtering DataPilot Tables You can use filters to remove unwanted data from a DataPilot table.UFI: removed help id -Click the Filter button in the sheet to call up the dialog for the filter conditions. Alternatively, call up the context menu of the DataPilot table and select the Filter command. The Filter dialog appears. Here you can filter the DataPilot table. +Click the Filter button in the sheet to call up the dialog for the filter conditions. Alternatively, call up the context menu of the DataPilot table and select the Filter command. The Filter dialog appears. Here you can filter the DataPilot table.
diff --git a/helpcontent2/source/text/scalc/guide/filters.xhp b/helpcontent2/source/text/scalc/guide/filters.xhp index d530d44b41..5439789333 100755 --- a/helpcontent2/source/text/scalc/guide/filters.xhp +++ b/helpcontent2/source/text/scalc/guide/filters.xhp @@ -1,9 +1,8 @@ - - - - + + - -Applying Multiple Sheets -/text/scalc/guide/multitables.xhp - - - - - - + + Applying Multiple Sheets + /text/scalc/guide/multitables.xhp + + + sheets; inserting -inserting; sheets -sheets; selecting multiple -appending sheets -selecting;multiple sheets -multiple sheets -calculating;multiple sheets - - MW moved "sheets;simultaneous.." to edit_multitables.xhp, transferred 2 entries from there and added "calculating;" - Applying Multiple Sheets + inserting; sheets + sheets; selecting multiple + appending sheets + selecting;multiple sheets + multiple sheets + calculating;multiple sheets +MW moved "sheets;simultaneous.." to edit_multitables.xhp, transferred 2 entries from there and added "calculating;" +Applying Multiple Sheets - Inserting a Sheet - - - Choose Insert - Sheet to insert a new sheet or an existing sheet from another file. - - - Selecting Multiple Sheets - The sheet tab of the current sheet is always visible in white in front of the other sheet tabs. The other sheet tabs are gray when they are not selected. By clicking other sheet tabs while pressing Command Ctrl you can select multiple sheets. - You can use Shift+CommandCtrl+Page Up or Page Down to select multiple sheets using the keyboard. - Undoing a Selection - To undo the selection of a sheet, click its sheet tab again while pressing the Command Ctrl key. The sheet that is currently visible cannot be removed from the selection. - Calculating Across Multiple Sheets - You can refer to a range of sheets in a formula by specifying the first and last sheet of the range, for example, =SUM(Sheet1.A1:Sheet3.A1) sums up all A1 cells on Sheet1 through Sheet3. -
- - - - -
- - + Inserting a Sheet + + + Choose Insert - Sheet to insert a new sheet or an existing sheet from another file. + + + +Click to select all sheets in the document. + +Click to deselect all sheets in the document, except the current sheet. + Selecting Multiple Sheets + The sheet tab of the current sheet is always visible in white in front of the other sheet tabs. The other sheet tabs are gray when they are not selected. By clicking other sheet tabs while pressing Command +Ctrl you can select multiple sheets. + You can use Shift+Command +Ctrl+Page Up or Page Down to select multiple sheets using the keyboard. + Undoing a Selection + To undo the selection of a sheet, click its sheet tab again while pressing the Command +Ctrl key. The sheet that is currently visible cannot be removed from the selection. + Calculating Across Multiple Sheets + You can refer to a range of sheets in a formula by specifying the first and last sheet of the range, for example, =SUM(Sheet1.A1:Sheet3.A1) sums up all A1 cells on Sheet1 through Sheet3. +
+ + +
+ + \ No newline at end of file diff --git a/helpcontent2/source/text/scalc/guide/numbers_text.xhp b/helpcontent2/source/text/scalc/guide/numbers_text.xhp new file mode 100644 index 0000000000..5d8e0a1636 --- /dev/null +++ b/helpcontent2/source/text/scalc/guide/numbers_text.xhp @@ -0,0 +1,95 @@ + + + + + + + + + Converting Text to Numbers + /text/scalc/guide/numbers_text.xhp + + + +converting;text to numbers +formats; text as numbers + +Converting Text to Numbers + +
+ Calc converts text inside cells to the respective numeric values if an unambiguous conversion is possible. If no conversion is possible, Calc returns a #VALUE! error. + Only integer numbers including exponent are converted, and ISO 8601 dates and times in their extended formats with separators. Anything else, like fractional numbers with decimal separators or dates other than ISO 8601, is not converted, as the text string would be locale dependent. Leading and trailing blanks are ignored. + The following ISO 8601 formats are converted: + + + CCYY-MM-DD + + + CCYY-MM-DDThh:mm + + + CCYY-MM-DDThh:mm:ss + + + CCYY-MM-DDThh:mm:ss,s + + + CCYY-MM-DDThh:mm:ss.s + + + hh:mm + + + hh:mm:ss + + + hh:mm:ss,s + + + hh:mm:ss.s + + + The century code CC may not be omitted. Instead of the T date and time separator, exactly one space character may be used. + If a date is given, it must be a valid Gregorian calendar date. In this case the optional time must be in the range 00:00 to 23:59:59.99999... + If only a time string is given, it may have an hours value of more than 24, while minutes and seconds can have a maximum value of 59. + The conversion is done for single arguments only, as in =A1+A2, or ="1E2"+1. Cell range arguments are not affected, so SUM(A1:A2) differs from A1+A2 if at least one of the two cells contain a convertible string. + Strings inside formulas are also converted, such as in ="1999-11-22"+42, which returns the date 42 days after November 22nd, 1999. Calculations involving localized dates as strings inside the formula return an error. For example, the localized date string "11/22/1999" or "22.11.1999" cannot be used for the automatic conversion. +
+
+ + + Format - Cells - Numbers + +
+ + \ No newline at end of file diff --git a/helpcontent2/source/text/scalc/guide/table_cellmerge.xhp b/helpcontent2/source/text/scalc/guide/table_cellmerge.xhp index 19fe8186d8..c21f78cbf6 100644 --- a/helpcontent2/source/text/scalc/guide/table_cellmerge.xhp +++ b/helpcontent2/source/text/scalc/guide/table_cellmerge.xhp @@ -1,8 +1,8 @@ - - + + + - - -Merging and Splitting Cells -/text/scalc/guide/table_cellmerge.xhp - - -Sun Microsystems, Inc. -converted from old format - fpe - - - + + Merging and Splitting Cells + /text/scalc/guide/table_cellmerge.xhp + + + cells; merging/unmerging -tables; merging cells -cell merges -unmerging cells -merging;cells + tables; merging cells + cell merges + unmerging cells + merging;cells MW made "cell merges;..." a one level entry -Merging and Unmerging Cells +Merging and Unmerging Cells mw created this file out of the shared guide "table_cellmerge.xhp", see also bug #63021 -You can select adjacent cells, then merge them into a single cell. Conversely, you can take a large cell that has been created by merging single cells, and divide it back into individual cells. -Merging Cells - - -Select the adjacent cells. - - -Choose Format - Merge Cells. - - -Canceling the merging of cells - - -Place the cursor in the cell to be split. - - -Choose Format - Merge Cells. - - - - - - + You can select adjacent cells, then merge them into a single cell. Conversely, you can take a large cell that has been created by merging single cells, and divide it back into individual cells. + When you copy cells into a target range containing merged cells, the target range gets unmerged first, then the copied cells are pasted in. If the copied cells are merged cells, they retain their merge state. + Merging Cells + + + Select the adjacent cells. + + + Choose Format - Merge Cells. + + + Canceling the merging of cells + + + Place the cursor in the cell to be split. + + + Choose Format - Merge Cells. + + + + + + \ No newline at end of file diff --git a/helpcontent2/source/text/scalc/guide/text_numbers.xhp b/helpcontent2/source/text/scalc/guide/text_numbers.xhp index 3e583349c3..940a88fdf8 100644 --- a/helpcontent2/source/text/scalc/guide/text_numbers.xhp +++ b/helpcontent2/source/text/scalc/guide/text_numbers.xhp @@ -1,7 +1,8 @@ - - - + ************************************************************************ + --> + - - -Formatting Numbers as Text -/text/scalc/guide/text_numbers.xhp - - -Sun Microsystems, Inc. -converted from old format - fpe - - - + + Formatting Numbers as Text + /text/scalc/guide/text_numbers.xhp + + + numbers; as text -text formats; for numbers -numbers; entering without number formats -formats; numbers as text -cell formats; text/numbers -formatting;numbers as text + text formats; for numbers + numbers; entering without number formats + formats; numbers as text + cell formats; text/numbers + formatting;numbers as text -Formatting Numbers as Text +Formatting Numbers as Text -
-You can format numbers as text in $[officename] Calc. Open the context menu of a cell or range of cells and choose Format Cells - Numbers, then select "Text" from the Category list. Any numbers subsequently entered into the formatted range are interpreted as text. The display of these "numbers" is left-justified, just as with other text. -When numbers are formatted as text, they cannot be used in calculations or formulas. -If you have already entered normal numbers in cells and have afterwards changed the format of the cells to "Text", the numbers will remain normal numbers. They will not be converted. Only numbers entered afterwards, or numbers which are then edited, will become text numbers. -If you decide to enter a number directly as text, enter an apostrophe (') first. For example, for years in column headings, you can enter '1999, '2000 and '2001. The apostrophe is not visible in the cell, it only indicates that the entry is to be recognized as a text. This is useful if, for example, you enter a telephone number or postal code that begins with a zero (0), because a zero (0) at the start of a sequence of digits is removed in normal number formats. -
-
- -Format - Cell - Numbers - -
- - +
+ You can format numbers as text in $[officename] Calc. Open the context menu of a cell or range of cells and choose Format Cells - Numbers, then select "Text" from the Category list. Any numbers subsequently entered into the formatted range are interpreted as text. The display of these "numbers" is left-justified, just as with other text. + If you have already entered normal numbers in cells and have afterwards changed the format of the cells to "Text", the numbers will remain normal numbers. They will not be converted. Only numbers entered afterwards, or numbers which are then edited, will become text numbers. + If you decide to enter a number directly as text, enter an apostrophe (') first. For example, for years in column headings, you can enter '1999, '2000 and '2001. The apostrophe is not visible in the cell, it only indicates that the entry is to be recognized as a text. This is useful if, for example, you enter a telephone number or postal code that begins with a zero (0), because a zero (0) at the start of a sequence of digits is removed in normal number formats. +
+
+ + + Format - Cells - Numbers + +
+ + \ No newline at end of file diff --git a/helpcontent2/source/text/scalc/guide/text_rotate.xhp b/helpcontent2/source/text/scalc/guide/text_rotate.xhp index b6e7b59488..cb8fe44a77 100755 --- a/helpcontent2/source/text/scalc/guide/text_rotate.xhp +++ b/helpcontent2/source/text/scalc/guide/text_rotate.xhp @@ -1,7 +1,8 @@ - - - + ************************************************************************ + --> + - - -Rotating Text -/text/scalc/guide/text_rotate.xhp - - -Sun Microsystems, Inc. -converted from old format - fpe - - - + + Rotating Text + /text/scalc/guide/text_rotate.xhp + + + cells; rotating text -rotating; text in cells -text in cells; writing vertically + rotating; text in cells + text in cells; writing vertically -Rotating Text +Rotating Text - - -Select the cells whose text you want to rotate. - - -Choose Format - Cells. You will see the Format Cells dialog. - - -Click the Alignment tab. - - -In the Text direction area use the mouse to select in the preview wheel the direction in which the text is to be rotated. Click OK. - - -In the Text direction area, if you press the ABCD button, the text is written vertically in the direction of the characters. + + + Select the cells whose text you want to rotate. + + + Choose Format - Cells. You will see the Format Cells dialog. + + + Click the Alignment tab. + + + In the Text direction area use the mouse to select in the preview wheel the direction in which the text is to be rotated. Click OK. + + removed a wrong para, i104207
-Format - Cells -Format - Cells - Alignment -
- - + Format - Cells + Format - Cells - Alignment +
+ + \ No newline at end of file -- cgit