From 5c2654302e9e4dcf45f802e8d31e53f55251c367 Mon Sep 17 00:00:00 2001 From: Eike Rathke Date: Fri, 1 Sep 2017 12:34:44 +0200 Subject: Rename Help CONVERT to CONVERT_OOO, CONVERT_ADD to CONVERT, tdf#69539 UI function name wise this was already done for 5.3, see https://bugs.documentfoundation.org/show_bug.cgi?id=69539 So CONVERT actually matches the ODF definition and Excel and what the user expects. Change-Id: Ifdcbedc324dc5b4c8e43f2428a5c02dbe97d48c0 --- source/text/scalc/01/04060106.xhp | 12 ++++++------ source/text/scalc/01/04060116.xhp | 10 +++++----- 2 files changed, 11 insertions(+), 11 deletions(-) (limited to 'source') diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp index f89d93a11b..7d49a29059 100644 --- a/source/text/scalc/01/04060106.xhp +++ b/source/text/scalc/01/04060106.xhp @@ -1431,21 +1431,21 @@
- CONVERT function + CONVERT_OOO function -CONVERT +CONVERT_OOO 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") +CONVERT_OOO(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. +=CONVERT_OOO(100;"ATS";"EUR") returns the Euro value of 100 Austrian Schillings. +=CONVERT_OOO(100;"EUR";"DEM") converts 100 Euros into German Marks.
@@ -1644,4 +1644,4 @@
- \ No newline at end of file + diff --git a/source/text/scalc/01/04060116.xhp b/source/text/scalc/01/04060116.xhp index ed09c359bf..d88285acca 100644 --- a/source/text/scalc/01/04060116.xhp +++ b/source/text/scalc/01/04060116.xhp @@ -383,10 +383,10 @@ =OCT2HEX(144;4) returns 0064.
-CONVERT_ADD function +CONVERT function -CONVERT_ADD +CONVERT 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. @@ -691,7 +691,7 @@
Syntax - CONVERT_ADD(Number; "FromUnit"; "ToUnit") + CONVERT(Number; "FromUnit"; "ToUnit") Number is the number to be converted. @@ -700,9 +700,9 @@ ToUnit is the unit to which conversion is taking place. Both units must be of the same type. Examples - =CONVERT_ADD(10;"HP";"PS") returns, rounded to two decimal places, 10.14. 10 HP equal 10.14 PS. + =CONVERT(10;"HP";"PS") returns, rounded to two decimal places, 10.14. 10 HP equal 10.14 PS. - =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. + =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.
FACTDOUBLE function -- cgit