From b645686c03bd35e7b0fb413af3f94301f7ce8dca Mon Sep 17 00:00:00 2001 From: tagezi Date: Mon, 2 Nov 2015 22:34:50 +0200 Subject: added the attribute localize="false" for scalc added the attribute localize="false" in paragraphs for the scalc module which does not need translation Change-Id: I570449bfed68368a77ebbfcbd641eaffeff7d57d Reviewed-on: https://gerrit.libreoffice.org/19747 Reviewed-by: Adolfo Jayme Barrientos Tested-by: Adolfo Jayme Barrientos --- source/text/scalc/01/04060102.xhp | 96 +++++++++++++++++++-------------------- source/text/scalc/01/04060103.xhp | 2 +- source/text/scalc/01/04060105.xhp | 2 +- source/text/scalc/01/04060107.xhp | 76 +++++++++++++++---------------- source/text/scalc/01/04060109.xhp | 4 +- source/text/scalc/01/04060118.xhp | 16 +++---- source/text/scalc/01/04060119.xhp | 8 ++-- source/text/scalc/01/04060181.xhp | 8 ++-- source/text/scalc/01/05080300.xhp | 4 +- source/text/scalc/01/05120000.xhp | 2 +- 10 files changed, 109 insertions(+), 109 deletions(-) diff --git a/source/text/scalc/01/04060102.xhp b/source/text/scalc/01/04060102.xhp index 2d1ee1ec52..db41ffd403 100644 --- a/source/text/scalc/01/04060102.xhp +++ b/source/text/scalc/01/04060102.xhp @@ -86,123 +86,123 @@ Functions
- - + +
- - + +
- - + +
- - + +
- - + +
- - + +
- - + +
- - + +
- - + +
- - + +
- - + +
- - + +
- - + +
- - + +
- - + +
- - + +
- - + +
- - + +
- - + +
- - + +
- - + +
- - + +
- - + +
- - + +
diff --git a/source/text/scalc/01/04060103.xhp b/source/text/scalc/01/04060103.xhp index c72a05e9c3..7c3618ae74 100644 --- a/source/text/scalc/01/04060103.xhp +++ b/source/text/scalc/01/04060103.xhp @@ -192,7 +192,7 @@ 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. - + ThenValue (optional) is the value that is returned if the logical test is TRUE. OtherwiseValue (optional) is the value that is returned if the logical test is FALSE. - + Without deselecting the range, select the MUNIT function. Mark the Array check box. Enter the desired dimensions for the array unit, in this case 5, and click OK. You can also enter the =Munit(5) formula in the last cell of the selected range (E5), and press Shift+Command+EnterShift+Ctrl+Enter. You now see a unit array with a range of A1:E5. - - + +
@@ -570,8 +570,8 @@ Select a single column range in which to enter the frequency according to the class limits. You must select one field more than the class ceiling. In this example, select the range C1:C6. Call up the FREQUENCY function in the Function Wizard. Select the Data range in (A1:A11), and then the Classes range in which you entered the class limits (B1:B6). Select the Array check box and click OK. You will see the frequency count in the range C1:C6. - - + +
@@ -586,8 +586,8 @@ Array represents a square array in which the determinants are defined. You can find a general introduction to using Array functions on top of this page. - - + +
@@ -601,8 +601,8 @@ MINVERSE(Array) Array represents a square array that is to be inverted. - - + + Example Select a square range and select MINVERSE. Select the output array, select the Array field and click OK. @@ -619,8 +619,8 @@ Array at first place represents the first array used in the array product. Array at second place represents the second array with the same number of rows. - - + + Example Select a square range. Choose the MMULT function. Select the first Array, then select the second Array. Using Function Wizard, mark the Array check box. Click OK. The output array will appear in the first selected range. @@ -635,8 +635,8 @@ TRANSPOSE(Array) Array represents the array in the spreadsheet that is to be transposed. - - + + Example In the spreadsheet, select the range in which the transposed array can appear. If the original array has n rows and m columns, your selected range must have at least m rows and n columns. Then enter the formula directly, select the original array and press Shift+Command+EnterShift+Ctrl+Enter. Or, if you are using the Function Wizard, mark the Array check box. The transposed array appears in the selected target range and is protected automatically against changes. @@ -657,11 +657,11 @@ iflinearType is FALSE the straight line found is forced to pass through the origin (the constant a is zero; y = bx). If omitted, linearType defaults to TRUE (the line is not forced through the origin). ifstats is omitted or FALSE only the top line of the statistics table is returned. If TRUE the entire table is returned. LINEST returns a table (array) of statistics as below and must be entered as an array formula (for example by using CommandCtrl+Shift+Return rather than just Return). - - + + - - + + Example This function returns an array and is handled in the same way as the other array functions. Select a range for the answers and then the function. Select data_Y. If you want, you can enter other parameters. Select Array and click OK. @@ -1014,8 +1014,8 @@ F5: The degrees of freedom from the variance analysis. E6: The sum of the squared deviation of the estimated Y values from their linear mean. F6: The sum of the squared deviation of the estimated Y value from the given Y values. - - + +
@@ -1035,11 +1035,11 @@ for bug #i31051# FunctionType (optional). If Function_Type = 0, functions in the form y = m^x will be calculated. Otherwise, y = b*m^x functions will be calculated. Stats (optional). If Stats=0, only the regression coefficient is calculated. - - + + - - + + Example See LINEST. However, no square sum will be returned. @@ -1158,8 +1158,8 @@ for bug #i31051# Calculation: A1*C1 + B1*D1 + A2*C2 + B2*D2 + A3*C3 + B3*D3 You can use SUMPRODUCT to calculate the scalar product of two vectors. SUMPRODUCT returns a single number, it is not necessary to enter the function as an array function. - - + +
@@ -1174,8 +1174,8 @@ for bug #i31051# ArrayX represents the first array whose elements are to be squared and added. ArrayY represents the second array whose elements are to be squared and subtracted. - - + +
@@ -1190,8 +1190,8 @@ for bug #i31051# ArrayX represents the first array whose elements are to be squared and added. ArrayY represents the second array, whose elements are to be squared and added. - - + +
@@ -1206,8 +1206,8 @@ for bug #i31051# ArrayX represents the first array whose elements are to be subtracted and squared. ArrayY represents the second array, whose elements are to be subtracted and squared. - - + +
@@ -1226,11 +1226,11 @@ for bug #i31051# NewDataX (optional) represents the array of the X data, which are used for recalculating values. LinearType(Optional). If LinearType = 0, then lines will be calculated through the zero point. Otherwise, offset lines will also be calculated. The default is LinearType <> 0. - - + + - - + + Example Select a spreadsheet range in which the trend data will appear. Select the function. Enter the output data or select it with the mouse. Mark the Array field. click OK. The trend data calculated from the output data is displayed. @@ -1252,11 +1252,11 @@ for bug #i31051# NewDataX (optional) represents the X data array, in which the values are recalculated. FunctionType(optional). If FunctionType = 0, functions in the form y = m^x will be calculated. Otherwise, y = b*m^x functions will be calculated. - - + + - - + + Example This function returns an array and is handled in the same way as the other array functions. Select a range where you want the answers to appear and select the function. Select DataY. Enter any other parameters, mark Array and click OK. diff --git a/source/text/scalc/01/04060109.xhp b/source/text/scalc/01/04060109.xhp index aab9735357..7ece367d89 100644 --- a/source/text/scalc/01/04060109.xhp +++ b/source/text/scalc/01/04060109.xhp @@ -401,7 +401,7 @@ Width (optional) is the horizontal width for an area that starts at the new reference position. Arguments Rows and Columns must not lead to zero or negative start row or column. Arguments Height and Width must not lead to zero or negative count of rows or columns. - + Time is an optional time range in seconds. If this parameter is missing the style will not be changed after a certain amount of time has passed. Style2 is the optional name of a cell style assigned to the cell after a certain amount of time has passed. If this parameter is missing "Default" is assumed. - + Factor (optional) is the depreciation factor. Factor = 2 is double rate depreciation. Type is an optional parameter. Type = 1 means a switch to linear depreciation. In Type = 0 no switch is made. - - + + Example What is the declining-balance double-rate depreciation for a period if the initial cost is 35,000 currency units and the value at the end of the depreciation is 7,500 currency units. The depreciation period is 3 years. The depreciation from the 10th to the 20th period is calculated. @@ -340,8 +340,8 @@ Type (optional) is the due date of the periodic payment, either at the beginning or at the end of a period. Guess (optional) determines the estimated value of the interest with iterative calculation. - - + + Example What is the constant interest rate for a payment period of 3 periods if 10 currency units are paid regularly and the present cash value is 900 currency units. @@ -533,8 +533,8 @@ PV (optional) is the (present) cash value of an investment. Type (optional) defines whether the payment is due at the beginning or the end of a period. - - + + Example What is the value at the end of an investment if the interest rate is 4% and the payment period is two years, with a periodic payment of 750 currency units. The investment has a present value of 2,500 currency units. @@ -580,8 +580,8 @@ FV (optional) is the future value, which is reached at the end of the last period. Type (optional) is the due date of the payment at the beginning or at the end of the period. - - + + Example How many payment periods does a payment period cover with a periodic interest rate of 6%, a periodic payment of 153.75 currency units and a present cash value of 2.600 currency units. diff --git a/source/text/scalc/01/04060119.xhp b/source/text/scalc/01/04060119.xhp index c0b42232c9..d2301cf82f 100644 --- a/source/text/scalc/01/04060119.xhp +++ b/source/text/scalc/01/04060119.xhp @@ -54,8 +54,8 @@ FV (optional) is the desired (future) value. Type (optional) defines the due date. F = 1 for payment at the beginning of a period and F = 0 for payment at the end of a period. - - + + Example How high is the periodic monthly payment at an annual interest rate of 8.75% over a period of 3 years? The cash value is 5,000 currency units and is always paid at the beginning of a period. The future value is 8,000 currency units. @@ -529,8 +529,8 @@ FV (optional) is the desired value (future value) to be reached at the end of the periodic payments. Type (optional) is the due date for the periodic payments. Type=1 is payment at the beginning and Type=0 is payment at the end of each period. - - + + Example What are the periodic payments at a yearly interest rate of 1.99% if the payment time is 3 years and the cash value is 25,000 currency units. There are 36 months as 36 payment periods, and the interest rate per payment period is 1.99%/12. diff --git a/source/text/scalc/01/04060181.xhp b/source/text/scalc/01/04060181.xhp index 53bbbfb2d9..8ea42e9d79 100644 --- a/source/text/scalc/01/04060181.xhp +++ b/source/text/scalc/01/04060181.xhp @@ -202,7 +202,7 @@ oldref="547">COUNTIF Start (optional) is the lower bound for Number. End (optional) is the upper bound for Number. - + COUNTIF Beta is a parameter to the distribution. Start (optional) is the lower bound for Number. End (optional) is the upper bound for Number. - + Example =BETA.INV(0.5;5;10) returns the value 0.3257511553. @@ -252,7 +252,7 @@ oldref="547">COUNTIF End (optional) is the upper bound for Number. Cumulative (optional) can be 0 or False to calculate the probability density function. It can be any other value or True or omitted to calculate the cumulative distribution function. - + COUNTIF Cumulative (required) can be 0 or False to calculate the probability density function. It can be any other value or True to calculate the cumulative distribution function. Start (optional) is the lower bound for Number. End (optional) is the upper bound for Number. - + Examples =BETA.DIST(2;8;10;1;1;3) returns the value 0.6854706 =BETA.DIST(2;8;10;0;1;3) returns the value 1.4837646 diff --git a/source/text/scalc/01/05080300.xhp b/source/text/scalc/01/05080300.xhp index c2016dad8c..c564b7c1e7 100644 --- a/source/text/scalc/01/05080300.xhp +++ b/source/text/scalc/01/05080300.xhp @@ -36,8 +36,8 @@
- - + + diff --git a/source/text/scalc/01/05120000.xhp b/source/text/scalc/01/05120000.xhp index 9296881824..78387699e7 100644 --- a/source/text/scalc/01/05120000.xhp +++ b/source/text/scalc/01/05120000.xhp @@ -136,7 +136,7 @@ Apply a color scale to a range consist of displaying a bicolor or tricolor gradi If you have defined a conditional formatting on a cell range and you try now to define a new conditional formatting on a part of this range, a warning message will be displayed, asking if you want to edit the existing conditional formatting (on the whole range) or define a new conditional formatting overlapping it (on the selected range).
- +
-- cgit v1.2.3