summaryrefslogtreecommitdiff
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.po69
1 files changed, 45 insertions, 24 deletions
diff --git a/source/en-GB/helpcontent2/source/text/scalc/01.po b/source/en-GB/helpcontent2/source/text/scalc/01.po
index b3fbb222230..599aaad7372 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: 2016-05-23 22:09+0200\n"
+"POT-Creation-Date: 2016-07-04 16:53+0200\n"
"PO-Revision-Date: 2016-05-26 14:02+0000\n"
"Last-Translator: Stuart Swales <stuart.swales.croftnuisk@gmail.com>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
@@ -13,7 +13,7 @@ msgstr ""
"Content-Transfer-Encoding: 8bit\n"
"Plural-Forms: nplurals=2; plural=(n != 1);\n"
"X-Accelerator-Marker: ~\n"
-"X-Generator: Pootle 2.7\n"
+"X-Generator: LibreOffice\n"
"X-POOTLE-MTIME: 1464271365.000000\n"
#: 01120000.xhp
@@ -4468,12 +4468,13 @@ msgid "<item type=\"input\">DCOUNT</item>"
msgstr "<item type=\"input\">DCOUNT</item>"
#: 04060101.xhp
+#, fuzzy
msgctxt ""
"04060101.xhp\n"
"par_id3149282\n"
"83\n"
"help.text"
-msgid "The formula in cell B16 is =DCOUNT(A1:E10;0;A13:E14)"
+msgid "The formula in cell B16 is =DCOUNT(A1:E10;D1;A13:E14)"
msgstr "The formula in cell B16 is =DCOUNT(A1:E10;0;A13:E14)"
#: 04060101.xhp
@@ -4509,8 +4510,8 @@ msgctxt ""
"par_id3151272\n"
"86\n"
"help.text"
-msgid "<emph>DatabaseField</emph> 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. <variable id=\"quotes\">To reference a column by means of the column header name, place quotation marks around the header name.</variable>"
-msgstr "<emph>DatabaseField</emph> specifies the column on which the function operates 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. <variable id=\"quotes\">To reference a column by means of the column header name, place quotation marks around the header name.</variable>"
+msgid "<emph>DatabaseField</emph> 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. <variable id=\"quotes\">For the DatabaseField parameter you can enter a reference to a header cell or a number to specify the column within the Database area, starting with 1. To reference a column by means of the literal column header name, place quotation marks around the header name.</variable>"
+msgstr ""
#: 04060101.xhp
msgctxt ""
@@ -4556,12 +4557,13 @@ msgid "DCOUNT"
msgstr "DCOUNT"
#: 04060101.xhp
+#, fuzzy
msgctxt ""
"04060101.xhp\n"
"par_id3156133\n"
"89\n"
"help.text"
-msgid "<ahelp hid=\"HID_FUNC_DBANZAHL\">DCOUNT counts the number of rows (records) in a database that match the specified search criteria and contain numerical values.</ahelp>"
+msgid "<ahelp hid=\"HID_FUNC_DBANZAHL\">DCOUNT counts the number of rows (records) in a database that match the specified search criteria and contain numerical values in the DatabaseField column.</ahelp>"
msgstr "<ahelp hid=\"HID_FUNC_DBANZAHL\">DCOUNT counts the number of rows (records) in a database that match the specified search criteria and contain numeric values.</ahelp>"
#: 04060101.xhp
@@ -4574,12 +4576,13 @@ msgid "Syntax"
msgstr "Syntax"
#: 04060101.xhp
+#, fuzzy
msgctxt ""
"04060101.xhp\n"
"par_id3153218\n"
"91\n"
"help.text"
-msgid "DCOUNT(Database; DatabaseField; SearchCriteria)"
+msgid "DCOUNT(Database; [DatabaseField]; SearchCriteria)"
msgstr "DCOUNT(Database; DatabaseField; SearchCriteria)"
#: 04060101.xhp
@@ -4588,8 +4591,8 @@ msgctxt ""
"par_id3153273\n"
"187\n"
"help.text"
-msgid "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. <embedvar href=\"text/scalc/01/04060101.xhp#quotes\"/>"
-msgstr "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. <embedvar href=\"text/scalc/01/04060101.xhp#quotes\"/>"
+msgid "If the DatabaseField argument is omitted, DCOUNT returns the count of all records that satisfy Criteria. <embedvar href=\"text/scalc/01/04060101.xhp#quotes\"/>"
+msgstr ""
#: 04060101.xhp
msgctxt ""
@@ -4601,21 +4604,23 @@ msgid "Example"
msgstr "Example"
#: 04060101.xhp
+#, fuzzy
msgctxt ""
"04060101.xhp\n"
"par_id3153623\n"
"93\n"
"help.text"
-msgid "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 <item type=\"input\">=DCOUNT(A1:E10;0;A13:E14)</item> in B16. The <emph>Function Wizard</emph> helps you to input ranges."
+msgid "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 <item type=\"input\">=DCOUNT(A1:E10;D1;A13:E14)</item> in B16. The <emph>Function Wizard</emph> helps you to input ranges."
msgstr "In the example above (scroll up, please), we want to know how many children have to travel more than 600 metres to school. The result is to be stored in cell B16. Set the cursor in cell B16. Enter the formula <item type=\"input\">=DCOUNT(A1:E10;0;A13:E14)</item> in B16. The <emph>Function Wizard</emph> helps you to input ranges."
#: 04060101.xhp
+#, fuzzy
msgctxt ""
"04060101.xhp\n"
"par_id3149142\n"
"94\n"
"help.text"
-msgid "<emph>Database</emph> is the range of data to be evaluated, including its headers: in this case A1:E10. <emph>DatabaseField</emph> specifies the column for the search criteria: in this case, the whole database. <emph>SearchCriteria</emph> is the range where you can enter the search parameters: in this case, A13:E14."
+msgid "<emph>Database</emph> is the range of data to be evaluated, including its headers: in this case A1:E10. <emph>DatabaseField</emph> specifies the column for the search criteria: in this case, the column with the numerical distance values. <emph>SearchCriteria</emph> is the range where you can enter the search parameters: in this case, A13:E14."
msgstr "<emph>Database</emph> is the range of data to be evaluated, including its headers: in this case A1:E10. <emph>DatabaseField</emph> specifies the column for the search criteria: in this case, the whole database. <emph>SearchCriteria</emph> is the range in which you can enter the search parameters: in this case, A13:E14."
#: 04060101.xhp
@@ -4663,17 +4668,27 @@ msgid "Syntax"
msgstr "Syntax"
#: 04060101.xhp
+#, fuzzy
msgctxt ""
"04060101.xhp\n"
"par_id3146893\n"
"100\n"
"help.text"
-msgid "DCOUNTA(Database; DatabaseField; SearchCriteria)"
+msgid "DCOUNTA(Database; [DatabaseField]; SearchCriteria)"
msgstr "DCOUNTA(Database; DatabaseField; SearchCriteria)"
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
+"par_id3153274\n"
+"189\n"
+"help.text"
+msgid "If the DatabaseField argument is omitted, DCOUNTA returns the count of all records that satisfy Criteria. <embedvar href=\"text/scalc/01/04060101.xhp#quotes\"/>"
+msgstr ""
+
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
"hd_id3149751\n"
"101\n"
"help.text"
@@ -5668,8 +5683,8 @@ msgctxt ""
"par_id3150654\n"
"185\n"
"help.text"
-msgid "When entering dates, slashes or dashes used as date separators may be interpreted as arithmetic operators. Therefore, dates entered in this format are not always recognized as dates and result in erroneous calculations. To keep dates from being interpreted as parts of formulas, place them in quotation marks, for example, \"07/20/54\"."
-msgstr "When entering dates, slashes or dashes used as date separators may be interpreted as arithmetic operators. Therefore, dates entered in this format are not always recognised as dates and result in erroneous calculations. To keep dates from being interpreted as parts of formulae, place them in quotation marks, for example, \"20/07/54\"."
+msgid "When entering dates as part of formulas, slashes or dashes used as date separators are interpreted as arithmetic operators. Therefore, dates entered in this format are not recognized as dates and result in erroneous calculations. To keep dates from being interpreted as parts of formulas use the DATE function, for example, DATE(1954;7;20), or place the date in quotation marks and use the ISO 8601 notation, for example, \"1954-07-20\". Avoid using locale dependent date formats such as \"07/20/54\", the calculation may produce errors if the document is loaded under different locale settings."
+msgstr ""
#: 04060102.xhp
msgctxt ""
@@ -9779,19 +9794,21 @@ msgid "<item type=\"input\">=N(123)</item> returns 123"
msgstr "<item type=\"input\">=N(123)</item> returns 123"
#: 04060104.xhp
+#, fuzzy
msgctxt ""
"04060104.xhp\n"
"par_id2337717\n"
"help.text"
-msgid "<item type=\"input\">=N(TRUE)</item> returns 1"
+msgid "<item type=\"input\">=N(TRUE())</item> returns 1"
msgstr "<item type=\"input\">=N(TRUE)</item> returns 1"
#: 04060104.xhp
+#, fuzzy
msgctxt ""
"04060104.xhp\n"
"par_id3153781\n"
"help.text"
-msgid "<item type=\"input\">=N(FALSE)</item> returns 0"
+msgid "<item type=\"input\">=N(FALSE())</item> returns 0"
msgstr "<item type=\"input\">=N(FALSE)</item> returns 0"
#: 04060104.xhp
@@ -25664,12 +25681,13 @@ msgid "Syntax"
msgstr "Syntax"
#: 04060111.xhp
+#, fuzzy
msgctxt ""
"04060111.xhp\n"
"par_id3150205\n"
"17\n"
"help.text"
-msgid "ISLEAPYEAR(\"Date\")"
+msgid "ISLEAPYEAR(Date)"
msgstr "ISLEAPYEAR(\"Date\")"
#: 04060111.xhp
@@ -25678,8 +25696,8 @@ msgctxt ""
"par_id3159239\n"
"18\n"
"help.text"
-msgid "<emph>Date</emph> specifies whether a given date falls within a leap year. The Date parameter must be a valid date according to the locale settings of %PRODUCTNAME."
-msgstr "<emph>Date</emph> specifies whether a given date falls within a leap year. The Date parameter must be a valid date according to the locale settings of %PRODUCTNAME."
+msgid "<emph>Date</emph> specifies whether a given date falls within a leap year. The Date parameter must be a valid date."
+msgstr ""
#: 04060111.xhp
msgctxt ""
@@ -25704,8 +25722,8 @@ msgctxt ""
"04060111.xhp\n"
"par_idN107E7\n"
"help.text"
-msgid "You may also use =ISLEAPYEAR(\"1968-02-29\") or =ISLEAPYEAR(\"2/29/68\")."
-msgstr "You may also use =ISLEAPYEAR(\"1968-02-29\") or =ISLEAPYEAR(\"29/02/68\")."
+msgid "You may also use =ISLEAPYEAR(DATE(1968;2;29)) or =ISLEAPYEAR(\"1968-02-29\") giving the date string in the ISO 8601 notation."
+msgstr ""
#: 04060111.xhp
msgctxt ""
@@ -61734,12 +61752,13 @@ msgid "<emph>Day</emph> is an integer indicating the day of the month."
msgstr "<emph>Day</emph> is an integer in the range 1 to 31 indicating the day of the month."
#: func_date.xhp
+#, fuzzy
msgctxt ""
"func_date.xhp\n"
"par_id3156260\n"
"10\n"
"help.text"
-msgid "If the values for month and day are out of bounds, they are carried over to the next digit. If you enter <item type=\"input\">=DATE(00;12;31)</item> the result will be 12/31/00. If, on the other hand, you enter <item type=\"input\">=DATE(00;13;31)</item> the result will be 1/31/01."
+msgid "If the values for month and day are out of bounds, they are carried over to the next digit. If you enter <item type=\"input\">=DATE(00;12;31)</item> the result will be 2000-12-31. If, on the other hand, you enter <item type=\"input\">=DATE(00;13;31)</item> the result will be 2001-01-31."
msgstr "If the values for month and day are higher than the bounding values, they are carried over to the next digit. If you enter <item type=\"input\">=DATE(00;12;31)</item> the result will be 31/12/00. If, on the other hand, you enter <item type=\"input\">=DATE(00;13;31)</item> the result will be 31/01/01."
#: func_date.xhp
@@ -66480,12 +66499,13 @@ msgid "Example"
msgstr "Example"
#: func_weeknumadd.xhp
+#, fuzzy
msgctxt ""
"func_weeknumadd.xhp\n"
"par_id3149973\n"
"229\n"
"help.text"
-msgid "In which week number does 12/24/2001 fall?"
+msgid "In which week number does 2001-12-24 fall?"
msgstr "In which week number does 2001-12-24 fall?"
#: func_weeknumadd.xhp
@@ -69202,11 +69222,12 @@ msgid "Set the regression type. Three types are available:"
msgstr "Set the regression type. Three types are available:"
#: statistics_regression.xhp
+#, fuzzy
msgctxt ""
"statistics_regression.xhp\n"
"par_id1701201620334364\n"
"help.text"
-msgid "<emph>Linear Regression</emph>: find a strait line in the form of <item type=\"literal\">y = a.x + b</item>, where <item type=\"literal\">a</item> is the slope and <item type=\"literal\">b</item> is the intercept that best fits the data."
+msgid "<emph>Linear Regression</emph>: find a straight line in the form of <item type=\"literal\">y = a.x + b</item>, where <item type=\"literal\">a</item> is the slope and <item type=\"literal\">b</item> is the intercept that best fits the data."
msgstr "<emph>Linear Regression</emph>: find a strait line in the form of <item type=\"literal\">y = a.x + b</item>, where <item type=\"literal\">a</item> is the slope and <item type=\"literal\">b</item> is the intercept that best fits the data."
#: statistics_regression.xhp