aboutsummaryrefslogtreecommitdiff
path: root/source/en-GB/helpcontent2/source/text/scalc/01.po
diff options
context:
space:
mode:
Diffstat (limited to 'source/en-GB/helpcontent2/source/text/scalc/01.po')
-rw-r--r--source/en-GB/helpcontent2/source/text/scalc/01.po216
1 files changed, 72 insertions, 144 deletions
diff --git a/source/en-GB/helpcontent2/source/text/scalc/01.po b/source/en-GB/helpcontent2/source/text/scalc/01.po
index 7360b0a7675..f380b78cbce 100644
--- a/source/en-GB/helpcontent2/source/text/scalc/01.po
+++ b/source/en-GB/helpcontent2/source/text/scalc/01.po
@@ -3,7 +3,7 @@ msgid ""
msgstr ""
"Project-Id-Version: PACKAGE VERSION\n"
"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2020-09-28 11:22+0200\n"
+"POT-Creation-Date: 2020-10-23 13:36+0200\n"
"PO-Revision-Date: 2020-03-03 11:15+0000\n"
"Last-Translator: Stuart Swales <stuart.swales.croftnuisk@gmail.com>\n"
"Language-Team: English (United Kingdom) <https://weblate.documentfoundation.org/projects/libo_help-master/textscalc01/en_GB/>\n"
@@ -12589,13 +12589,13 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_LOG\">Returns the logarithm of a number to the specified base.</ahelp>"
msgstr "<ahelp hid=\"HID_FUNC_LOG\">Returns the logarithm of a number to the specified base.</ahelp>"
-#. uDAq7
+#. ShWCR
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
"par_id3144732\n"
"help.text"
-msgid "LOG(Number [; Base])"
+msgid "LOG(Number[; Base])"
msgstr ""
#. Eiqiq
@@ -12841,15 +12841,6 @@ msgctxt ""
msgid "<item type=\"literal\">Base^Exponent</item>"
msgstr "<item type=\"literal\">Base^Power</item>"
-#. dRQh7
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id241599040594931\n"
-"help.text"
-msgid "<literal>=POWER(0,0)</literal> returns 1."
-msgstr ""
-
#. D3Ghv
#: 04060106.xhp
msgctxt ""
@@ -13255,13 +13246,13 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_RUNDEN\">Rounds a number to a certain number of decimal places.</ahelp>"
msgstr "<ahelp hid=\"HID_FUNC_RUNDEN\">Returns a number rounded to a certain number of decimal places.</ahelp>"
-#. kj4B7
+#. p64i9
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
"par_id3158182\n"
"help.text"
-msgid "ROUND(Number [; Count])"
+msgid "ROUND(Number[; Count])"
msgstr ""
#. yE5Jb
@@ -13354,13 +13345,13 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_ABRUNDEN\">Rounds a number down, toward zero, to a certain precision.</ahelp>"
msgstr "<ahelp hid=\"HID_FUNC_ABRUNDEN\">Rounds a number down, towards zero, to a certain precision.</ahelp>"
-#. MnKJo
+#. uqe8Y
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
"par_id3146051\n"
"help.text"
-msgid "ROUNDDOWN(Number [; Count])"
+msgid "ROUNDDOWN(Number[; Count])"
msgstr ""
#. EXn4P
@@ -13444,13 +13435,13 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_AUFRUNDEN\">Rounds a number up, away from zero, to a certain precision.</ahelp>"
msgstr "<ahelp hid=\"HID_FUNC_AUFRUNDEN\">Rounds a number up, away from zero, to a certain precision.</ahelp>"
-#. Gz3SM
+#. smgCC
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
"par_id3163328\n"
"help.text"
-msgid "ROUNDUP(Number [; Count])"
+msgid "ROUNDUP(Number[; Count])"
msgstr ""
#. x59Ls
@@ -13921,13 +13912,13 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_SUMMEWENN\">Adds the cells specified by a given criteria.</ahelp> This function is used to browse a range when you search for a certain value."
msgstr "<ahelp hid=\"HID_FUNC_SUMMEWENN\">Adds the cells specified by a given criteria.</ahelp> This function is used to browse a range when you search for a certain value."
-#. KsFtX
+#. PcPNo
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
"par_id3152028\n"
"help.text"
-msgid "SUMIF(Range; Criteria [; SumRange])"
+msgid "SUMIF(Range; Criteria[; SumRange])"
msgstr ""
#. rYzXG
@@ -14443,13 +14434,13 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_UMRECHNEN\">Converts between old European national currency and to and from Euros.</ahelp>"
msgstr "<ahelp hid=\"HID_FUNC_UMRECHNEN\">Converts between old European national currency and to and from euro.</ahelp>"
-#. G7CMF
+#. qh8S5
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
"par_id3143748\n"
"help.text"
-msgid "EUROCONVERT(Value; \"From_currency\"; \"To_currency\" [; full_precision [; triangulation_precision]])"
+msgid "EUROCONVERT(Value; \"From_currency\"; \"To_currency\"[; full_precision][; triangulation_precision])"
msgstr ""
#. 4KJUc
@@ -14551,14 +14542,14 @@ msgctxt ""
msgid "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."
msgstr "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."
-#. o7nsC
+#. GhdsH
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
"par_id0908200902131191\n"
"help.text"
-msgid "CONVERT_OOO(value; \"text\"; \"text\")"
-msgstr ""
+msgid "CONVERT_OOO(value;\"text\";\"text\")"
+msgstr "CONVERT_OOO(value;\"text\";\"text\")"
#. egbGd
#: 04060106.xhp
@@ -17233,13 +17224,13 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_VARIATION\">Calculates the points of an exponential trend in an array.</ahelp>"
msgstr "<ahelp hid=\"HID_FUNC_VARIATION\">Calculates the points of an exponential trend in an array.</ahelp>"
-#. GMVAK
+#. 8VMBq
#: 04060107.xhp
msgctxt ""
"04060107.xhp\n"
"par_id3166377\n"
"help.text"
-msgid "GROWTH(DataY [; [ DataX ] [; [ NewDataX ] [; FunctionType ] ] ])"
+msgid "GROWTH(DataY [; DataX [; NewDataX [; FunctionType]]])"
msgstr ""
#. CA3qD
@@ -18988,31 +18979,31 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_WAHL\">Uses an index to return a value from a list of up to 30 values.</ahelp>"
msgstr "<ahelp hid=\"HID_FUNC_WAHL\">Uses an index to return a value from a list of 1 to 30 values.</ahelp>"
-#. V8cAu
+#. r7bDk
#: 04060109.xhp
msgctxt ""
"04060109.xhp\n"
"par_id3155425\n"
"help.text"
-msgid "CHOOSE(Index; Value 1 [; Value 2 [; ... [; Value 30]]])"
+msgid "CHOOSE(Index; Value1 [; Value2 [; ... [; Value254]]])"
msgstr ""
-#. CNK7e
+#. dt8SY
#: 04060109.xhp
msgctxt ""
"04060109.xhp\n"
"par_id3144755\n"
"help.text"
-msgid "<emph>Index</emph> is a reference or number between 1 and 30 indicating which value is to be taken from the list."
-msgstr "<emph>Index</emph> is a reference or number in the range 1 to 30 indicating which value is to be taken from the list."
+msgid "<emph>Index</emph> is a reference or number between 1 and 254 indicating which value is to be taken from the list."
+msgstr ""
-#. GGWDt
+#. nR3mX
#: 04060109.xhp
msgctxt ""
"04060109.xhp\n"
"par_id3149939\n"
"help.text"
-msgid "<emph>Value 1, Value 2, ..., Value 30</emph> is the list of values entered as a reference to a cell or as individual values."
+msgid "<emph>Value1, Value2, ..., Value254</emph> is the list of values entered as a reference to a cell or as individual values."
msgstr ""
#. s64Du
@@ -27970,13 +27961,13 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_VDB\">Returns the depreciation of an asset for a specified or partial period using a variable declining balance method.</ahelp>"
msgstr "<ahelp hid=\"HID_FUNC_VDB\">Returns the depreciation of an asset for a specified or partial period using a variable declining balance method.</ahelp>"
-#. pUVVr
+#. DSd3v
#: 04060118.xhp
msgctxt ""
"04060118.xhp\n"
"par_id3149025\n"
"help.text"
-msgid "VDB(Cost; Salvage; Life; Start; End [; Factor [; NoSwitch]])"
+msgid "VDB(Cost; Salvage; Life; S; End [; Factor [; NoSwitch]])"
msgstr ""
#. zGhDb
@@ -42271,15 +42262,6 @@ msgctxt ""
msgid "Name"
msgstr "Name"
-#. 3juWm
-#: 04060199.xhp
-msgctxt ""
-"04060199.xhp\n"
-"par_id401599494815994\n"
-"help.text"
-msgid "Example"
-msgstr ""
-
#. PcMRq
#: 04060199.xhp
msgctxt ""
@@ -42505,15 +42487,6 @@ msgctxt ""
msgid "Name"
msgstr "Name"
-#. CCsqC
-#: 04060199.xhp
-msgctxt ""
-"04060199.xhp\n"
-"par_id201599495083374\n"
-"help.text"
-msgid "Example"
-msgstr ""
-
#. AdNBV
#: 04060199.xhp
msgctxt ""
@@ -42712,15 +42685,6 @@ msgctxt ""
msgid "Name"
msgstr "Name"
-#. Y4cRR
-#: 04060199.xhp
-msgctxt ""
-"04060199.xhp\n"
-"par_id201599494708332\n"
-"help.text"
-msgid "Example"
-msgstr ""
-
#. s2CGS
#: 04060199.xhp
msgctxt ""
@@ -42802,15 +42766,6 @@ msgctxt ""
msgid "Name"
msgstr "Name"
-#. tfD9G
-#: 04060199.xhp
-msgctxt ""
-"04060199.xhp\n"
-"par_id521599494740206\n"
-"help.text"
-msgid "Example"
-msgstr ""
-
#. 52L2C
#: 04060199.xhp
msgctxt ""
@@ -43828,6 +43783,24 @@ msgctxt ""
msgid "<variable id=\"zellattributetext\"><ahelp hid=\".uno:FormatCellDialog\">Allows you to specify a variety of formatting options and to apply attributes to the selected cells.</ahelp></variable>"
msgstr "<variable id=\"zellattributetext\"><ahelp hid=\".uno:FormatCellDialog\">Allows you to specify a variety of formatting options and to apply attributes to the selected cells.</ahelp></variable>"
+#. C3jH9
+#: 05020000.xhp
+msgctxt ""
+"05020000.xhp\n"
+"hd_id3145785\n"
+"help.text"
+msgid "<link href=\"text/shared/01/05020300.xhp\" name=\"Numbers\">Numbers</link>"
+msgstr "<link href=\"text/shared/01/05020300.xhp\" name=\"Numbers\">Numbers</link>"
+
+#. ZgrYD
+#: 05020000.xhp
+msgctxt ""
+"05020000.xhp\n"
+"hd_id3146119\n"
+"help.text"
+msgid "<link href=\"text/shared/01/05020100.xhp\" name=\"Font\">Font</link>"
+msgstr "<link href=\"text/shared/01/05020100.xhp\" name=\"Font\">Font</link>"
+
#. BW9bs
#: 05020600.xhp
msgctxt ""
@@ -44665,15 +44638,6 @@ msgctxt ""
msgid "Page Style"
msgstr "Page Style"
-#. vEZHA
-#: 05070000.xhp
-msgctxt ""
-"05070000.xhp\n"
-"bm_id651593596384469\n"
-"help.text"
-msgid "<bookmark_value>style;page</bookmark_value><bookmark_value>page;style</bookmark_value><bookmark_value>format;page</bookmark_value><bookmark_value>formatting;page</bookmark_value>"
-msgstr ""
-
#. YjqDi
#: 05070000.xhp
msgctxt ""
@@ -45403,32 +45367,32 @@ msgctxt ""
msgid "<ahelp hid=\".uno:AddPrintArea\">Adds the current selection to the defined print areas.</ahelp>"
msgstr "<ahelp hid=\".uno:AddPrintArea\">Adds the current selection to the defined print areas.</ahelp>"
-#. U9JPr
+#. fcvcu
#: 05100000.xhp
msgctxt ""
"05100000.xhp\n"
"tit\n"
"help.text"
-msgid "Styles in Calc"
-msgstr ""
+msgid "Styles"
+msgstr "Styles"
-#. rJpRh
+#. 3fyBn
#: 05100000.xhp
msgctxt ""
"05100000.xhp\n"
"bm_id3150447\n"
"help.text"
-msgid "<bookmark_value>Stylist, see Styles window</bookmark_value><bookmark_value>Styles window</bookmark_value><bookmark_value>formats; Styles window</bookmark_value><bookmark_value>formatting; Styles window</bookmark_value><bookmark_value>paint can for applying styles</bookmark_value><bookmark_value>styles in spreadsheets</bookmark_value><bookmark_value>styles; in Calc</bookmark_value>"
-msgstr ""
+msgid "<bookmark_value>Stylist, see Styles window</bookmark_value> <bookmark_value>Styles window</bookmark_value> <bookmark_value>formats; Styles window</bookmark_value> <bookmark_value>formatting; Styles window</bookmark_value> <bookmark_value>paint can for applying styles</bookmark_value>"
+msgstr "<bookmark_value>Stylist, see Styles window</bookmark_value> <bookmark_value>Styles window</bookmark_value> <bookmark_value>formats; Styles window</bookmark_value> <bookmark_value>formatting; Styles window</bookmark_value> <bookmark_value>paint can for applying styles</bookmark_value>"
-#. WerNG
+#. eA3vo
#: 05100000.xhp
msgctxt ""
"05100000.xhp\n"
"hd_id3150447\n"
"help.text"
-msgid "<link href=\"text/scalc/01/05100000.xhp\" name=\"Styles\">Styles in Calc</link>"
-msgstr ""
+msgid "<link href=\"text/scalc/01/05100000.xhp\" name=\"Styles\">Styles</link>"
+msgstr "<link href=\"text/scalc/01/05100000.xhp\" name=\"Styles\">Styles</link>"
#. bBG57
#: 05100000.xhp
@@ -45475,15 +45439,24 @@ msgctxt ""
msgid "Double-click the style in the Styles window."
msgstr "Double-click the style in the Styles window."
-#. SbgEE
+#. DCJfB
#: 05100000.xhp
msgctxt ""
"05100000.xhp\n"
-"par_id3145801\n"
+"hd_id3153877\n"
"help.text"
-msgid "<ahelp hid=\".\">Displays the list of the available Cell Styles.</ahelp>"
+msgid "Cell Styles"
msgstr ""
+#. DAX9B
+#: 05100000.xhp
+msgctxt ""
+"05100000.xhp\n"
+"par_id3145801\n"
+"help.text"
+msgid "<ahelp hid=\".\">Displays the list of the available Cell Styles for <link href=\"text/shared/00/00000005.xhp#formatierung\" name=\"indirect cell formatting\">indirect cell formatting</link>.</ahelp>"
+msgstr "<ahelp hid=\".\">Displays the list of the available Cell Styles for <link href=\"text/shared/00/00000005.xhp#formatierung\" name=\"indirect cell formatting\">indirect cell formatting</link>.</ahelp>"
+
#. JcMEc
#: 05100000.xhp
msgctxt ""
@@ -45502,23 +45475,23 @@ msgctxt ""
msgid "Cell Styles"
msgstr "Cell Styles"
-#. 7FwJf
+#. hkDXo
#: 05100000.xhp
msgctxt ""
"05100000.xhp\n"
-"hd_id171593598056580\n"
+"hd_id3153963\n"
"help.text"
-msgid "<link href=\"text/scalc/01/05070000.xhp\" name=\"page styles\">Page Styles</link>"
+msgid "Page Styles"
msgstr ""
-#. 4XFww
+#. DxrsL
#: 05100000.xhp
msgctxt ""
"05100000.xhp\n"
"par_id3147003\n"
"help.text"
-msgid "<ahelp hid=\".\">Displays the Page Styles available.</ahelp>"
-msgstr ""
+msgid "<ahelp hid=\".\">Displays the Page Styles available for indirect page formatting.</ahelp>"
+msgstr "<ahelp hid=\".\">Displays the Page Styles available for indirect page formatting.</ahelp>"
#. cM9f4
#: 05100000.xhp
@@ -52189,15 +52162,6 @@ msgctxt ""
msgid "<ahelp hid=\"modules/scalc/ui/datafieldoptionsdialog/hierarchy\">Select the hierarchy that you want to use. The pivot table must be based on an external source data that contains data hierarchies.</ahelp>"
msgstr "<ahelp hid=\"modules/scalc/ui/datafieldoptionsdialog/hierarchy\">Select the hierarchy that you want to use. The pivot table must be based on an external source data that contains data hierarchies.</ahelp>"
-#. ZjDq9
-#: 12090106.xhp
-msgctxt ""
-"12090106.xhp\n"
-"par_id681598453957935\n"
-"help.text"
-msgid "Calc does not provide multiple hierarchies for a single field and so this option is normally grayed. If you use a pivot table data source extension, that extension could define multiple hierarchies for some fields and then the option could become available. See the documentation supplied with that extension for more details\"."
-msgstr ""
-
#. B9FE5
#: 12090200.xhp
msgctxt ""
@@ -53188,15 +53152,6 @@ msgctxt ""
msgid "This function is part of the Open Document Format for Office Applications (OpenDocument) standard Version 1.2. (ISO/IEC 26300:2-2015)"
msgstr "This function is part of the Open Document Format for Office Applications (OpenDocument) standard Version 1.2. (ISO/IEC 26300:2-2015)"
-#. BFcB6
-#: ODFF.xhp
-msgctxt ""
-"ODFF.xhp\n"
-"hd_id1000013\n"
-"help.text"
-msgid "This function is part of the Open Document Format for Office Applications (OpenDocument) standard Version 1.3."
-msgstr ""
-
#. SGHPh
#: calculate.xhp
msgctxt ""
@@ -53224,24 +53179,6 @@ msgctxt ""
msgid "<ahelp hid=\".\">Commands to calculate formula cells.</ahelp>"
msgstr ""
-#. J8xZD
-#: cell_styles.xhp
-msgctxt ""
-"cell_styles.xhp\n"
-"tit\n"
-"help.text"
-msgid "Cell Styles"
-msgstr ""
-
-#. 8o4Ez
-#: cell_styles.xhp
-msgctxt ""
-"cell_styles.xhp\n"
-"hd_id811593560413206\n"
-"help.text"
-msgid "<link href=\"text/scalc/01/cell_styles.xhp\" name=\"Cell Style\">Cell Styles</link>"
-msgstr ""
-
#. AZNrM
#: common_func.xhp
msgctxt ""
@@ -64429,15 +64366,6 @@ msgctxt ""
msgid "Calculation"
msgstr "Calculation"
-#. Q8ewH
-#: func_yearfrac.xhp
-msgctxt ""
-"func_yearfrac.xhp\n"
-"par_id3154502\n"
-"help.text"
-msgid "0 or missing"
-msgstr ""
-
#. CkPny
#: func_yearfrac.xhp
msgctxt ""