aboutsummaryrefslogtreecommitdiff
path: root/source/ug/helpcontent2/source/text/scalc
diff options
context:
space:
mode:
Diffstat (limited to 'source/ug/helpcontent2/source/text/scalc')
-rw-r--r--source/ug/helpcontent2/source/text/scalc/01.po6
-rw-r--r--source/ug/helpcontent2/source/text/scalc/02.po110
-rw-r--r--source/ug/helpcontent2/source/text/scalc/guide.po10
3 files changed, 99 insertions, 27 deletions
diff --git a/source/ug/helpcontent2/source/text/scalc/01.po b/source/ug/helpcontent2/source/text/scalc/01.po
index f29dfcde455..ab3a8dd5815 100644
--- a/source/ug/helpcontent2/source/text/scalc/01.po
+++ b/source/ug/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-06-22 17:23+0200\n"
+"POT-Creation-Date: 2020-07-02 14:37+0200\n"
"PO-Revision-Date: 2018-11-12 14:10+0000\n"
"Last-Translator: Anonymous Pootle User\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
@@ -18763,13 +18763,13 @@ msgctxt ""
msgid "<item type=\"input\">=SUM(OFFSET(A1;2;2;5;6))</item> determines the total of the area that starts in cell C3 and has a height of 5 rows and a width of 6 columns (area=C3:H7)."
msgstr ""
-#. 5KEjE
+#. VCAvt
#: 04060109.xhp
msgctxt ""
"04060109.xhp\n"
"par_id3153740\n"
"help.text"
-msgid "If the width or height is included, the OFFSET function returns a range and thus must be entered as an <link href=\"text/scalc/01/04060107.xhp\">array formula</link>. If both the width and height are missing, a cell reference is returned."
+msgid "If <emph>Width</emph> or <emph>Height</emph> are given, the OFFSET function returns a cell range reference. If <emph>Reference</emph> is a single cell reference and both <emph>Width</emph> and <emph>Height</emph> are omitted, a single cell reference is returned."
msgstr ""
#. AFMxC
diff --git a/source/ug/helpcontent2/source/text/scalc/02.po b/source/ug/helpcontent2/source/text/scalc/02.po
index 029846b9bca..afb4d1cd1ae 100644
--- a/source/ug/helpcontent2/source/text/scalc/02.po
+++ b/source/ug/helpcontent2/source/text/scalc/02.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-01-07 14:09+0100\n"
+"POT-Creation-Date: 2020-06-29 13:08+0200\n"
"PO-Revision-Date: 2018-11-14 12:11+0000\n"
"Last-Translator: Anonymous Pootle User\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
@@ -394,59 +394,131 @@ msgctxt ""
msgid "<bookmark_value>functions;sum function icon</bookmark_value> <bookmark_value>formula bar;sum function</bookmark_value> <bookmark_value>sum icon</bookmark_value> <bookmark_value>AutoSum button, see sum icon</bookmark_value>"
msgstr ""
-#. EUeEf
+#. vYDYK
#: 06030000.xhp
msgctxt ""
"06030000.xhp\n"
"hd_id3157909\n"
"help.text"
-msgid "<link href=\"text/scalc/02/06030000.xhp\" name=\"Sum\">Sum</link>"
-msgstr "<link href=\"text/scalc/02/06030000.xhp\" name=\"يىغىندا\">يىغىندا</link>"
+msgid "<link href=\"text/scalc/02/06030000.xhp\" name=\"Sum\">Select Function</link>"
+msgstr ""
-#. M5UpW
+#. KEkiG
#: 06030000.xhp
msgctxt ""
"06030000.xhp\n"
"par_id3150543\n"
"help.text"
-msgid "<ahelp hid=\"HID_INSWIN_SUMME\">Inserts the sum of a cell range into the current cell, or inserts sum values into selected cells. Click in a cell, click this icon, and optionally adjust the cell range. Or select some cells into which the sum values will be inserted, then click the icon.</ahelp>"
-msgstr "<ahelp hid=\"HID_INSWIN_SUMME\">نۆۋەتتىكى كاتەكچىدە قىستۇرىدىغان كاتەكچە دائىرىسىدىكى كاتەكچە سانى، ياكى كاتەكچە دائىرىسىدىكى سانلىق قىممەت يىغىندىسىنى تاللىغان كاتەكچىگە قىستۇرىدۇ. مەلۇم كاتەكچە چېكىپ، ئاندىن قايتا بۇ سىنبەلگىنى چېكىپ ئاندىن كاتەكچە دائىرىسى خالىغانچە تەڭشىلىدۇ. ياكى سانلىق قىممەت يىغىندىسىنى قىستۇرىدىغان بىر قىسىم كاتەكچىنى تاللاپ ئاندىن بۇ سىنبەلگىنى چېكىڭ.</ahelp>"
+msgid "<ahelp hid=\"HID_INSWIN_SUMME\">Insert a function of a cell range into the current cell. The function can be Sum, Average, Minimum, Maximum and Count. Click in a cell, click this icon, select the function in the drop down list and optionally adjust the cell range. Or select some cells into which the function value will be inserted, then click the icon. The function result is added at the bottom of the range.</ahelp>"
+msgstr ""
-#. urwhB
+#. KDxsW
#: 06030000.xhp
msgctxt ""
"06030000.xhp\n"
"par_id3153770\n"
"help.text"
-msgid "<image id=\"img_id3147434\" src=\"cmd/sc_autosum.png\" width=\"0.1665in\" height=\"0.1665in\"><alt id=\"alt_id3147434\">Icon</alt></image>"
-msgstr "<image id=\"img_id3147434\" src=\"cmd/sc_autosum.png\" width=\"0.222inch\" height=\"0.222inch\"><alt id=\"alt_id3147434\">سىنبەلگە</alt></image>"
+msgid "<image id=\"img_id3147434\" src=\"cmd/sc_autosum.svg\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3147434\">Icon Select Function</alt></image>"
+msgstr ""
-#. hfmVm
+#. DaEgA
#: 06030000.xhp
msgctxt ""
"06030000.xhp\n"
"par_id3152577\n"
"help.text"
-msgid "Sum"
-msgstr "يىغىندا"
+msgid "Select Function"
+msgstr ""
-#. DEYk8
+#. SpBhw
+#: 06030000.xhp
+msgctxt ""
+"06030000.xhp\n"
+"hd_id161592658402954\n"
+"help.text"
+msgid "Select Function applied with no selected range"
+msgstr ""
+
+#. 59eGX
#: 06030000.xhp
msgctxt ""
"06030000.xhp\n"
"par_id3156444\n"
"help.text"
-msgid "$[officename] automatically suggests a cell range, provided that the spreadsheet contains data. If the cell range already contains a sum function, you can combine it with the new one to yield the total sum of the range. If the range contains filters, the Subtotal function is inserted instead of the Sum function."
-msgstr "ئەگەر ئېلېكترونلۇق جەدۋەلدە سانلىق مەلۇمات بولسا، $[officename] كاتەكچە دائىرىسىدىن بىرنى ئۆزلۈكىدىن تاللايدۇ. ئەگەر مەزكۇر كاتەكچە دائىرىسىدە يىغىندا فونكسىيىسى بولسا ئۇنداقتا ئىككى فونكسىيىنى بىرلەشتۈرۈپ مەزكۇر دائىرىنىڭ يىغىندىسىغا ئېرىشىدۇ. ئەگەر دائىرىدە سۈزگۈچ بولسا ئۇنداقتا يىغىندا فونكسىيىسىنى قىستۇرماي تۈرگە ئايرىپ جەملەش فونكسىيىسىنى قىستۇرىدۇ."
+msgid "$[officename] automatically suggests a cell range, provided that the spreadsheet contains data. If the cell range already contains a function, you can combine it with the new one to yield the function applied to the range data. If the range contains filters, the Subtotal function is inserted instead of the selected function."
+msgstr ""
-#. HRZZS
+#. vpnqf
#: 06030000.xhp
msgctxt ""
"06030000.xhp\n"
"par_id3153189\n"
"help.text"
-msgid "Click the <emph>Accept</emph> icon (green check mark) to use the formula displayed in the input line."
-msgstr "<emph>قوشۇل</emph> سىنبەلگىسى (يېشىل كۆپ تاللاش بەلگىسى) نى چېكىپ، تەھرىرلەش ستونىدا كۆرۈنگەن فورمۇلانى ئىشلىتىدۇ."
+msgid "Click the <emph>Accept</emph> icon to use the formula displayed in the input line or <emph>Cancel</emph>."
+msgstr ""
+
+#. TVD6h
+#: 06030000.xhp
+msgctxt ""
+"06030000.xhp\n"
+"par_id231592663499228\n"
+"help.text"
+msgid "<image src=\"cmd/sc_ok.svg\" id=\"img_id521592663499228\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id171592663499228\">Accept Icon</alt></image>"
+msgstr ""
+
+#. iHTEW
+#: 06030000.xhp
+msgctxt ""
+"06030000.xhp\n"
+"par_id481592663499228\n"
+"help.text"
+msgid "Accept"
+msgstr ""
+
+#. VFj6u
+#: 06030000.xhp
+msgctxt ""
+"06030000.xhp\n"
+"par_id311592663828848\n"
+"help.text"
+msgid "<image src=\"cmd/sc_cancel.svg\" id=\"img_id641592663828848\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id111592663828848\">Icon Cancel</alt></image>"
+msgstr ""
+
+#. 7xGcL
+#: 06030000.xhp
+msgctxt ""
+"06030000.xhp\n"
+"par_id431592663828848\n"
+"help.text"
+msgid "Cancel"
+msgstr ""
+
+#. GPtKR
+#: 06030000.xhp
+msgctxt ""
+"06030000.xhp\n"
+"hd_id261592658395518\n"
+"help.text"
+msgid "Select Function applied on a selected range"
+msgstr ""
+
+#. JPrPQ
+#: 06030000.xhp
+msgctxt ""
+"06030000.xhp\n"
+"par_id911592658130888\n"
+"help.text"
+msgid "When the selected range has two or more rows, the function is calculated for each column. The results are placed in empty cells on the first available row below the range, one result per column."
+msgstr ""
+
+#. iHksB
+#: 06030000.xhp
+msgctxt ""
+"06030000.xhp\n"
+"par_id991592658144387\n"
+"help.text"
+msgid "When the selected range has one row, the function result is placed in the first available cell on the right of the selected range."
+msgstr ""
#. NYGR7
#: 06040000.xhp
diff --git a/source/ug/helpcontent2/source/text/scalc/guide.po b/source/ug/helpcontent2/source/text/scalc/guide.po
index f1c4af43165..8b77d2d37c1 100644
--- a/source/ug/helpcontent2/source/text/scalc/guide.po
+++ b/source/ug/helpcontent2/source/text/scalc/guide.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-04-27 15:54+0200\n"
+"POT-Creation-Date: 2020-06-29 13:08+0200\n"
"PO-Revision-Date: 2018-11-14 12:11+0000\n"
"Last-Translator: Anonymous Pootle User\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
@@ -3517,13 +3517,13 @@ msgctxt ""
msgid "If the file has a *.csv extension, select the file."
msgstr ""
-#. 4sFF8
+#. DQq7Q
#: csv_files.xhp
msgctxt ""
"csv_files.xhp\n"
"par_idN108A5\n"
"help.text"
-msgid "If the CSV file has another extension, select the file, and then select \"Text CSV\" in the <item type=\"menuitem\">File type</item> box"
+msgid "If the CSV file has another extension, select the file, and then select \"Text CSV\" in the <emph>Filter</emph> box"
msgstr ""
#. FEBAD
@@ -3643,13 +3643,13 @@ msgctxt ""
msgid "In the <item type=\"menuitem\">File name</item> box, enter a name for the file."
msgstr ""
-#. GECC7
+#. EDhEz
#: csv_files.xhp
msgctxt ""
"csv_files.xhp\n"
"par_idN1090D\n"
"help.text"
-msgid "In the <item type=\"menuitem\">File type</item> box, select \"Text CSV\"."
+msgid "In the <emph>Filter</emph> box, select \"Text CSV\"."
msgstr ""
#. 2JC8V