update translations for master

and force-fix errors using pocheck

Change-Id: I569b418ab52bf1703326225f0b341c580ccdf55e

1 files changed, 61 insertions, 7 deletions

diff --git a/source/sq/helpcontent2/source/text/scalc/guide.po b/source/sq/helpcontent2/source/text/scalc/guide.po
index 02e2c08565d..73bd170fad2 100644
--- a/source/sq/helpcontent2/source/text/scalc/guide.po
+++ b/source/sq/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: 2022-12-07 19:22+0100\n"
+"POT-Creation-Date: 2023-03-02 11:50+0100\n"
 "PO-Revision-Date: 2018-11-14 12:10+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -2410,13 +2410,13 @@ msgctxt ""
 msgid "Referencing a Cell in Another Document"
 msgstr ""
 
-#. DLuhq
+#. FkFV9
 #: cellreferences.xhp
 msgctxt ""
 "cellreferences.xhp\n"
 "bm_id3147436\n"
 "help.text"
-msgid "<bookmark_value>sheet references</bookmark_value>      <bookmark_value>references; to cells in other sheets/documents</bookmark_value>      <bookmark_value>cells; operating in another document</bookmark_value>      <bookmark_value>documents;references</bookmark_value>"
+msgid "<bookmark_value>sheet references</bookmark_value>      <bookmark_value>references; to cells in other sheets/documents</bookmark_value>      <bookmark_value>addresses; to cells in other sheets/documents</bookmark_value>      <bookmark_value>cells; operating in another document</bookmark_value>      <bookmark_value>documents;references</bookmark_value>      <bookmark_value>cell;address</bookmark_value>      <bookmark_value>address; of cell</bookmark_value>"
 msgstr ""
 
 #. a5WVc
@@ -2563,13 +2563,31 @@ msgctxt ""
 msgid "Switch back to the new spreadsheet. In the input line you will now see how $[officename] Calc has added the reference to the formula for you."
 msgstr ""
 
-#. VyHdU
+#. fYYAT
 #: cellreferences.xhp
 msgctxt ""
 "cellreferences.xhp\n"
 "par_id5888241\n"
 "help.text"
-msgid "The reference to a cell of another document contains the name of the other document in single inverted commas, then a hash #, then the name of the sheet of the other document, followed by a point and the name of the cell."
+msgid "The reference to a cell of another document contains the fully qualified name of the other document between single quotes <literal>(')</literal>, then a hash <literal>#</literal>, then the name of the sheet of the other document, followed by a period and the name or reference of the cell."
+msgstr ""
+
+#. Wh2Pc
+#: cellreferences.xhp
+msgctxt ""
+"cellreferences.xhp\n"
+"par_id51672076541215\n"
+"help.text"
+msgid "For example, <switchinline select=\"sys\"><caseinline select=\"WIN\">'file:///C:/Users/user/Documents/Price list.ods'#$'Information SKU'.H51</caseinline><defaultinline>'file:///home/user/Documents/Price list.ods'#$'Information SKU'.H51</defaultinline></switchinline>."
+msgstr ""
+
+#. iwcWF
+#: cellreferences.xhp
+msgctxt ""
+"cellreferences.xhp\n"
+"par_id451672076939681\n"
+"help.text"
+msgid "The path and document name URI <emph>must always</emph> be enclosed in single quotes. If the name contains single quotes (') they must be escaped using two single quotes (''). Only a sheet name may not be quoted if it does not contain a space or a character that would be an operator or the name would be pure numeric (for example, '123' must be quoted)."
 msgstr ""
 
 #. ACCDQ
@@ -10699,13 +10717,13 @@ msgctxt ""
 msgid "Addresses and References, Absolute and Relative"
 msgstr ""
 
-#. ZvNEh
+#. yEuFn
 #: relativ_absolut_ref.xhp
 msgctxt ""
 "relativ_absolut_ref.xhp\n"
 "bm_id3156423\n"
 "help.text"
-msgid "<bookmark_value>addressing; relative and absolute</bookmark_value><bookmark_value>references; absolute/relative</bookmark_value><bookmark_value>absolute addresses in spreadsheets</bookmark_value><bookmark_value>relative addresses</bookmark_value><bookmark_value>absolute references in spreadsheets</bookmark_value><bookmark_value>relative references</bookmark_value><bookmark_value>references; to cells</bookmark_value><bookmark_value>cells; references</bookmark_value>"
+msgid "<bookmark_value>addressing; relative and absolute</bookmark_value><bookmark_value>references; absolute/relative</bookmark_value><bookmark_value>absolute addresses in spreadsheets</bookmark_value><bookmark_value>relative addresses</bookmark_value><bookmark_value>absolute references in spreadsheets</bookmark_value><bookmark_value>relative references</bookmark_value><bookmark_value>references; to cells</bookmark_value><bookmark_value>cells; references</bookmark_value><bookmark_value>range of cells; defining</bookmark_value><bookmark_value>cell references;ranges union</bookmark_value><bookmark_value>cell references;ranges concatenation</bookmark_value><bookmark_value>cell references;ranges intersection</bookmark_value>"
 msgstr ""
 
 #. SCMmK
@@ -10717,6 +10735,42 @@ msgctxt ""
 msgid "<variable id=\"relativ_absolut_ref\"><link href=\"text/scalc/guide/relativ_absolut_ref.xhp\">Addresses and References, Absolute and Relative</link></variable>"
 msgstr ""
 
+#. Yxi9x
+#: relativ_absolut_ref.xhp
+msgctxt ""
+"relativ_absolut_ref.xhp\n"
+"hd_id191672069640769\n"
+"help.text"
+msgid "Cell references"
+msgstr ""
+
+#. ByUqP
+#: relativ_absolut_ref.xhp
+msgctxt ""
+"relativ_absolut_ref.xhp\n"
+"par_id451672069651941\n"
+"help.text"
+msgid "An individual cell is fully identified by the sheet it belongs, the column identifier (letter) located along the top of the columns and a row identifier (number) found along the left-hand side of the spreadsheet. On spreadsheets read from left to right, the complete reference for the upper left cell of the sheet is <emph>Sheet.A1</emph>."
+msgstr ""
+
+#. hGDKu
+#: relativ_absolut_ref.xhp
+msgctxt ""
+"relativ_absolut_ref.xhp\n"
+"hd_id211672069771744\n"
+"help.text"
+msgid "Cell ranges"
+msgstr ""
+
+#. ocLKM
+#: relativ_absolut_ref.xhp
+msgctxt ""
+"relativ_absolut_ref.xhp\n"
+"par_id161672070752816\n"
+"help.text"
+msgid "You can reference a set of cells by referencing them in ranges. Ranges can be a block of cells, entire set of columns and entire set of rows. The range A1:B2 is the first four cells in the upper left corner of the sheet. Range A:E contains all the cells of column A, B, C, D and E. Range 2:5 contains all the cells of row 2, 3, 4 and 5."
+msgstr ""
+
 #. 6AVDc
 #: relativ_absolut_ref.xhp
 msgctxt ""