aboutsummaryrefslogtreecommitdiff
path: root/source/sv/helpcontent2/source/text/scalc
diff options
context:
space:
mode:
Diffstat (limited to 'source/sv/helpcontent2/source/text/scalc')
-rw-r--r--source/sv/helpcontent2/source/text/scalc/00.po6
-rw-r--r--source/sv/helpcontent2/source/text/scalc/01.po94
-rw-r--r--source/sv/helpcontent2/source/text/scalc/guide.po34
3 files changed, 67 insertions, 67 deletions
diff --git a/source/sv/helpcontent2/source/text/scalc/00.po b/source/sv/helpcontent2/source/text/scalc/00.po
index 609f816d92d..5cf5cf7b8ca 100644
--- a/source/sv/helpcontent2/source/text/scalc/00.po
+++ b/source/sv/helpcontent2/source/text/scalc/00.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-03-31 10:35+0200\n"
+"POT-Creation-Date: 2020-04-27 15:54+0200\n"
"PO-Revision-Date: 2018-11-20 17:44+0000\n"
"Last-Translator: Påvel Nicklasson <pavelnicklasson@bahnhof.se>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
@@ -592,13 +592,13 @@ msgctxt ""
msgid "<variable id=\"einamen\">Choose <menuitem>Insert - Named Range or Expression</menuitem>.</variable>"
msgstr ""
-#. ASCUT
+#. VLxrw
#: 00000404.xhp
msgctxt ""
"00000404.xhp\n"
"par_id3146776\n"
"help.text"
-msgid "<variable id=\"eiextdata\">Choose <menuitem>Sheet - Link to External data</menuitem>.</variable>"
+msgid "<variable id=\"eiextdata\">Choose <menuitem>Sheet - Link to External Data</menuitem>.</variable>"
msgstr ""
#. ECgNS
diff --git a/source/sv/helpcontent2/source/text/scalc/01.po b/source/sv/helpcontent2/source/text/scalc/01.po
index b129b744b3c..a831c830a88 100644
--- a/source/sv/helpcontent2/source/text/scalc/01.po
+++ b/source/sv/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-04-15 12:52+0200\n"
+"POT-Creation-Date: 2020-04-27 15:54+0200\n"
"PO-Revision-Date: 2019-05-01 17:41+0000\n"
"Last-Translator: Robert <riedelkarlsson@gmail.com>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
@@ -4813,6 +4813,15 @@ msgctxt ""
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 ""
+#. ckYe4
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id301587321851330\n"
+"help.text"
+msgid "If you choose to omit the DatabaseField argument, your formula should be of the form =DCOUNT(Database; ; SearchCriteria)."
+msgstr ""
+
#. F7cy4
#: 04060101.xhp
msgctxt ""
@@ -4885,6 +4894,15 @@ msgctxt ""
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 ""
+#. ESpfH
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id31587322048553\n"
+"help.text"
+msgid "If you choose to omit the DatabaseField argument, your formula should be of the form =DCOUNTA(Database; ; SearchCriteria)."
+msgstr ""
+
#. xX6ve
#: 04060101.xhp
msgctxt ""
@@ -55465,13 +55483,13 @@ msgctxt ""
msgid "<variable id=\"CEILINGh1\"><link href=\"text/scalc/01/func_ceiling.xhp#ceiling\" name=\"CEILING\">CEILING</link></variable>"
msgstr ""
-#. E9m3Y
+#. Co8xT
#: func_ceiling.xhp
msgctxt ""
"func_ceiling.xhp\n"
"par_id3153422\n"
"help.text"
-msgid "<ahelp hid=\"HID_FUNC_OBERGRENZE\">Rounds a number up to the nearest multiple of s significance value.</ahelp>"
+msgid "<ahelp hid=\"HID_FUNC_OBERGRENZE\">Rounds a number to the nearest multiple of a significance value.</ahelp>"
msgstr ""
#. PfT3s
@@ -55483,13 +55501,13 @@ msgctxt ""
msgid "For a positive number and a positive significance value, the function rounds up (away from zero). For a negative number and a negative significance value, the direction of rounding is determined by the value of a mode parameter. The function returns an error if the number and significance values have opposite signs."
msgstr ""
-#. s9tRF
+#. 6AFh7
#: func_ceiling.xhp
msgctxt ""
"func_ceiling.xhp\n"
"par_id3163792\n"
"help.text"
-msgid "If the spreadsheet is exported to Microsoft Excel, the CEILING function is exported as the equivalent CEILING.MATH function that exists since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either CEILING.PRECISE that exists since Excel 2010, or CEILING.XCL that is exported as the CEILING function compatible with all Excel versions. Note that CEILING.XCL always rounds away from zero."
+msgid "If the spreadsheet is exported to Microsoft Excel, the CEILING function is exported as the equivalent CEILING.MATH function that has existed since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either CEILING.PRECISE that has existed since Excel 2010, or CEILING.XCL that is exported as the CEILING function compatible with all Excel versions."
msgstr ""
#. mZwNV
@@ -55636,15 +55654,6 @@ msgctxt ""
msgid "<emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to 1."
msgstr ""
-#. 6Vtow
-#: func_ceiling.xhp
-msgctxt ""
-"func_ceiling.xhp\n"
-"par_id461586211894475\n"
-"help.text"
-msgid "This function calculates identical results to the ISO.CEILING function"
-msgstr ""
-
#. 8WiRx
#: func_ceiling.xhp
msgctxt ""
@@ -55699,6 +55708,15 @@ msgctxt ""
msgid "For a positive number the function rounds up (away from zero). For a negative number, the direction of rounding is determined by the value of a mode parameter. The sign of the significance value is ignored."
msgstr ""
+#. aYczG
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id291516998575663\n"
+"help.text"
+msgid "This function exists for interoperability with Microsoft Excel 2013 or newer."
+msgstr ""
+
#. Km7yb
#: func_ceiling.xhp
msgctxt ""
@@ -55726,15 +55744,6 @@ msgctxt ""
msgid "<emph>Mode</emph> (optional) is a number, or a reference to a cell containing a number. If <emph>Mode</emph> is given and not equal to zero, a negative <emph>Number</emph> is rounded down (away from zero). If <emph>Mode</emph> is equal to zero or is not given, a negative <emph>Number</emph> is rounded up (towards zero)."
msgstr ""
-#. aYczG
-#: func_ceiling.xhp
-msgctxt ""
-"func_ceiling.xhp\n"
-"par_id291516998575663\n"
-"help.text"
-msgid "This function exists for interoperability with Microsoft Excel 2013 or newer."
-msgstr ""
-
#. je22s
#: func_ceiling.xhp
msgctxt ""
@@ -55942,13 +55951,13 @@ msgctxt ""
msgid "<input>=ISO.CEILING(3.45)</input> returns 4."
msgstr ""
-#. ENMYD
+#. xS2zM
#: func_ceiling.xhp
msgctxt ""
"func_ceiling.xhp\n"
"par_id181586214438808\n"
"help.text"
-msgid "<input>=ISO.CEILING(-45.67,2)</input> returns 44."
+msgid "<input>=ISO.CEILING(-45.67,2)</input> returns -44."
msgstr ""
#. GuEcB
@@ -57625,6 +57634,15 @@ msgctxt ""
msgid "For a positive number and a positive significance value, the function rounds down (towards zero). For a negative number and a negative significance value, the direction of rounding is determined by the value of a mode parameter. The function returns an error if the number and significance values have opposite signs."
msgstr ""
+#. 5kHtR
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id3163894\n"
+"help.text"
+msgid "If the spreadsheet is exported to Microsoft Excel, the FLOOR function is exported as the equivalent FLOOR.MATH function that has existed since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either FLOOR.PRECISE that has existed since Excel 2010, or FLOOR.XCL that is exported as the FLOOR function compatible with all Excel versions."
+msgstr ""
+
#. 2haGU
#: func_floor.xhp
msgctxt ""
@@ -57661,15 +57679,6 @@ msgctxt ""
msgid "<emph>Mode</emph> (optional) is a number, or a reference to a cell containing a number. The function only uses <emph>Mode</emph> if both <emph>Number</emph> and <emph>Significance</emph> are negative. Then if <emph>Mode</emph> is given and not equal to zero, numbers are rounded up (towards zero); if <emph>Mode</emph> is equal to zero or not given, negative numbers are rounded down (away from zero)."
msgstr ""
-#. 5kHtR
-#: func_floor.xhp
-msgctxt ""
-"func_floor.xhp\n"
-"par_id3163894\n"
-"help.text"
-msgid "If the spreadsheet is exported to Microsoft Excel, the FLOOR function is exported as the equivalent FLOOR.MATH function that has existed since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either FLOOR.PRECISE that has existed since Excel 2010, or FLOOR.XCL that is exported as the FLOOR function compatible with all Excel versions."
-msgstr ""
-
#. EU85r
#: func_floor.xhp
msgctxt ""
@@ -61495,22 +61504,22 @@ msgctxt ""
msgid "The function should be called with at least two parameters."
msgstr ""
-#. gwtEM
+#. hANRQ
#: func_rawsubtract.xhp
msgctxt ""
"func_rawsubtract.xhp\n"
"par_2016112109236\n"
"help.text"
-msgid "<item type=\"literal\">RAWSUBTRACT(0.987654321098765, 0.9876543210987)</item> returns 6.53921361504217E-14"
+msgid "<input>=RAWSUBTRACT(0.987654321098765, 0.9876543210987)</input> returns 6.53921361504217E-14"
msgstr ""
-#. QZT3B
+#. bgohX
#: func_rawsubtract.xhp
msgctxt ""
"func_rawsubtract.xhp\n"
"par_2016112109237\n"
"help.text"
-msgid "<item type=\"literal\">RAWSUBTRACT(0.987654321098765)</item> returns Err:511 (Missing variable) because RAWSUBTRACT requires a minimum of two numbers."
+msgid "<input>=RAWSUBTRACT(0.987654321098765)</input> returns Err:511 (Missing variable) because RAWSUBTRACT requires a minimum of two numbers."
msgstr ""
#. d9DP3
@@ -65185,15 +65194,6 @@ msgctxt ""
msgid "Between Groups"
msgstr ""
-#. vuDTW
-#: statistics_anova.xhp
-msgctxt ""
-"statistics_anova.xhp\n"
-"par_id411554944014360\n"
-"help.text"
-msgid "3.340385558"
-msgstr ""
-
#. tpzCU
#: statistics_anova.xhp
msgctxt ""
diff --git a/source/sv/helpcontent2/source/text/scalc/guide.po b/source/sv/helpcontent2/source/text/scalc/guide.po
index bda201cd29c..2d3c88c568b 100644
--- a/source/sv/helpcontent2/source/text/scalc/guide.po
+++ b/source/sv/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-03-31 10:35+0200\n"
+"POT-Creation-Date: 2020-04-27 15:54+0200\n"
"PO-Revision-Date: 2018-11-14 12:10+0000\n"
"Last-Translator: Anonymous Pootle User\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
@@ -11860,67 +11860,67 @@ msgctxt ""
msgid "Select the cell range for the subtotals that you want to calculate, and remember to include the column heading labels. Alternatively, click on a single cell within your data to allow Calc to automatically identify the range."
msgstr ""
-#. owkFH
+#. QiBqE
#: subtotaltool.xhp
msgctxt ""
"subtotaltool.xhp\n"
"par_id421585177574387\n"
"help.text"
-msgid "Select <menuitem>Data > Subtotals</menuitem> from the Menu bar to open the Subtotals dialog."
+msgid "Choose <menuitem>Data - Subtotals</menuitem> to open the Subtotals dialog."
msgstr ""
-#. AmnUD
+#. BwAst
#: subtotaltool.xhp
msgctxt ""
"subtotaltool.xhp\n"
"par_id41585177608508\n"
"help.text"
-msgid "In the Group by drop-down list on the first Group page, select a column by its label. Entries in the cell range from step 1 will be grouped and sorted by matching values in this column."
+msgid "In the <emph>Group by</emph> drop-down list on the <emph>First Group</emph> page, select a column by its label. Entries in the cell range from step 1 will be grouped and sorted by matching values in this column."
msgstr ""
-#. dq83u
+#. QmNL9
#: subtotaltool.xhp
msgctxt ""
"subtotaltool.xhp\n"
"par_id451585177625978\n"
"help.text"
-msgid "In the Calculate subtotals for box on the first Group page, select a column containing values to be subtotaled. If you later change values in this column, Calc will automatically recalculate the subtotals."
+msgid "In the <emph>Calculate subtotals for</emph> box on the <emph>First Group</emph> page, select a column containing values to be subtotaled. If you later change values in this column, Calc will automatically recalculate the subtotals."
msgstr ""
-#. xFgAD
+#. CQ9km
#: subtotaltool.xhp
msgctxt ""
"subtotaltool.xhp\n"
"par_id661585177644535\n"
"help.text"
-msgid "In the Use function box on the first Group page, select a function to calculate the subtotals for the column selected in step 4."
+msgid "In the <emph>Use function</emph> box on the <emph>First Group</emph> page, select a function to calculate the subtotals for the column selected in step 4."
msgstr ""
-#. EhUvq
+#. 3eTTE
#: subtotaltool.xhp
msgctxt ""
"subtotaltool.xhp\n"
"par_id351585177661529\n"
"help.text"
-msgid "Repeat steps 4 and 5 to create subtotals for other columns on the first Group page."
+msgid "Repeat steps 4 and 5 to create subtotals for other columns on the <emph>First Group</emph> page."
msgstr ""
-#. aQRn7
+#. 6GLDr
#: subtotaltool.xhp
msgctxt ""
"subtotaltool.xhp\n"
"par_id511585177679372\n"
"help.text"
-msgid "You can create two more subtotal categories by using the second Group and third Group pages and repeating steps 3 to 6. If you do not want to add more groups, then leave the Group by list for each page set to “- none -”."
+msgid "You can create two more subtotal categories by using the <emph>Second Group</emph> and <emph>Third Group</emph> pages and repeating steps 3 to 6. If you do not want to add more groups, then leave the Group by list for each page set to “- none -”."
msgstr ""
-#. AaCGA
+#. HDB52
#: subtotaltool.xhp
msgctxt ""
"subtotaltool.xhp\n"
"par_id301585177698777\n"
"help.text"
-msgid "Click OK. Calc will add subtotal and grand total rows to your cell range."
+msgid "Click <emph>OK</emph>. Calc will add subtotal and grand total rows to your cell range."
msgstr ""
#. iMTer
@@ -11950,13 +11950,13 @@ msgctxt ""
msgid "This feature is useful if you have many subtotals, as you can simply hide low-level details, such as individual entries, to produce a high-level summary of your data."
msgstr ""
-#. SEYEM
+#. C97jN
#: subtotaltool.xhp
msgctxt ""
"subtotaltool.xhp\n"
"par_id161585178829165\n"
"help.text"
-msgid "To turn off outlines, select <menuitem>Data > Group and Outline > Remove Outline</menuitem> from the Menu bar. To reinstate them, select <menuitem>Data > Group and Outline > AutoOutline</menuitem>."
+msgid "To turn off outlines, choose <menuitem>Data - Group and Outline - Remove Outline</menuitem>. To reinstate them, choose <menuitem>Data - Group and Outline - AutoOutline</menuitem>."
msgstr ""
#. oU9ew