update translations

and force-fix errors using pocheck
(based on 5-0 templates)

Change-Id: Ia5f050e72d6aa24ae5ec73898e7c05ca2d4103cb

3 files changed, 204 insertions, 114 deletions

diff --git a/source/ur/sc/source/ui/miscdlgs.po b/source/ur/sc/source/ui/miscdlgs.po
index c8618c1d73f..3f2766e9d6c 100644
--- a/source/ur/sc/source/ui/miscdlgs.po
+++ b/source/ur/sc/source/ui/miscdlgs.po
@@ -3,17 +3,18 @@ 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: 2014-11-18 11:23+0100\n"
-"PO-Revision-Date: 2012-02-24 15:57+0200\n"
-"Last-Translator: Yasir <urdulizer@gmail.com>\n"
+"POT-Creation-Date: 2015-04-22 23:40+0200\n"
+"PO-Revision-Date: 2015-05-14 05:26+0000\n"
+"Last-Translator: system user <>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
 "Language: ur\n"
 "MIME-Version: 1.0\n"
 "Content-Type: text/plain; charset=UTF-8\n"
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=2; plural=(n != 1);\n"
-"X-Generator: LibreOffice\n"
+"X-Generator: Pootle 2.7\n"
 "X-Accelerator-Marker: ~\n"
+"X-POOTLE-MTIME: 1431581218.000000\n"
 
 #: acredlin.src
 msgctxt ""
@@ -220,7 +221,7 @@ msgctxt ""
 "STR_TITLE_AUTHOR\n"
 "string.text"
 msgid "Author"
-msgstr ""
+msgstr "مؤلف"
 
 #: conflictsdlg.src
 msgctxt ""
diff --git a/source/ur/sc/source/ui/src.po b/source/ur/sc/source/ui/src.po
index 923828fd8ae..bc8f1bfd4b6 100644
--- a/source/ur/sc/source/ui/src.po
+++ b/source/ur/sc/source/ui/src.po
@@ -3,18 +3,18 @@ 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: 2015-05-11 16:12+0200\n"
-"PO-Revision-Date: 2012-09-21 22:38+0000\n"
-"Last-Translator: khunshan <ahmad.khunshan@gmail.com>\n"
+"POT-Creation-Date: 2015-06-24 17:05+0200\n"
+"PO-Revision-Date: 2015-05-14 05:27+0000\n"
+"Last-Translator: system user <>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
 "Language: ur\n"
 "MIME-Version: 1.0\n"
 "Content-Type: text/plain; charset=UTF-8\n"
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=2; plural=(n != 1);\n"
-"X-Generator: LibreOffice\n"
+"X-Generator: Pootle 2.7\n"
 "X-Accelerator-Marker: ~\n"
-"X-POOTLE-MTIME: 1348267123.0\n"
+"X-POOTLE-MTIME: 1431581239.000000\n"
 
 #: condformatdlg.src
 msgctxt ""
@@ -338,7 +338,7 @@ msgctxt ""
 "Automatic\n"
 "stringlist.text"
 msgid "Automatic"
-msgstr ""
+msgstr "خودکار"
 
 #: condformatdlg.src
 msgctxt ""
@@ -374,7 +374,7 @@ msgctxt ""
 "Value\n"
 "stringlist.text"
 msgid "Value"
-msgstr ""
+msgstr "قیمت"
 
 #: condformatdlg.src
 msgctxt ""
@@ -740,18 +740,36 @@ msgstr ""
 msgctxt ""
 "condformatdlg.src\n"
 "RID_COND_ENTRY.LB_ICONSET_TYPE\n"
-"3 Smilies\n"
+"3 Smileys\n"
+"stringlist.text"
+msgid "3 Smileys"
+msgstr ""
+
+#: condformatdlg.src
+msgctxt ""
+"condformatdlg.src\n"
+"RID_COND_ENTRY.LB_ICONSET_TYPE\n"
+"3 Stars\n"
+"stringlist.text"
+msgid "3 Stars"
+msgstr ""
+
+#: condformatdlg.src
+msgctxt ""
+"condformatdlg.src\n"
+"RID_COND_ENTRY.LB_ICONSET_TYPE\n"
+"3 Triangles\n"
 "stringlist.text"
-msgid "3 Smilies"
+msgid "3 Triangles"
 msgstr ""
 
 #: condformatdlg.src
 msgctxt ""
 "condformatdlg.src\n"
 "RID_COND_ENTRY.LB_ICONSET_TYPE\n"
-"3 Colored Smilies\n"
+"3 Colored Smileys\n"
 "stringlist.text"
-msgid "3 Colored Smilies"
+msgid "3 Colored Smileys"
 msgstr ""
 
 #: condformatdlg.src
@@ -838,6 +856,15 @@ msgstr ""
 #: condformatdlg.src
 msgctxt ""
 "condformatdlg.src\n"
+"RID_COND_ENTRY.LB_ICONSET_TYPE\n"
+"5 Boxes\n"
+"stringlist.text"
+msgid "5 Boxes"
+msgstr ""
+
+#: condformatdlg.src
+msgctxt ""
+"condformatdlg.src\n"
 "RID_ICON_SET_ENTRY\n"
 "FT_ICON_SET_ENTRY_TEXT\n"
 "fixedtext.text"
@@ -5885,6 +5912,15 @@ msgstr ""
 msgctxt ""
 "popup.src\n"
 "RID_POPUP_CELLS\n"
+"SID_EDIT_POSTIT\n"
+"menuitem.text"
+msgid "Edit Co~mment"
+msgstr ""
+
+#: popup.src
+msgctxt ""
+"popup.src\n"
+"RID_POPUP_CELLS\n"
 "SID_DELETE_NOTE\n"
 "menuitem.text"
 msgid "D~elete Comment"
@@ -8101,7 +8137,7 @@ msgctxt ""
 "RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_GET_DAY_OF_WEEK\n"
 "1\n"
 "string.text"
-msgid "Returns the day of the week for the date value as an integer (1-7)."
+msgid "Returns the day of the week for the date value as an integer."
 msgstr ""
 
 #: scfuncs.src
@@ -9380,7 +9416,7 @@ msgctxt ""
 "6\n"
 "string.text"
 msgid "Life"
-msgstr ""
+msgstr "سطور"
 
 #: scfuncs.src
 msgctxt ""
@@ -9929,7 +9965,7 @@ msgctxt ""
 "4\n"
 "string.text"
 msgid "value "
-msgstr ""
+msgstr "قیمت"
 
 #: scfuncs.src
 msgctxt ""
@@ -9956,7 +9992,7 @@ msgctxt ""
 "2\n"
 "string.text"
 msgid "Values"
-msgstr ""
+msgstr "قیمت"
 
 #: scfuncs.src
 msgctxt ""
@@ -13231,7 +13267,7 @@ msgctxt ""
 "RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_FLOOR\n"
 "7\n"
 "string.text"
-msgid "If given and not equal to zero then rounded down according to amount when a negative number and significance."
+msgid "If given and not equal to zero then rounded towards zero with negative number and significance."
 msgstr ""
 
 #: scfuncs.src
@@ -13240,7 +13276,7 @@ msgctxt ""
 "RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_FLOOR_MS\n"
 "1\n"
 "string.text"
-msgid "Rounds number down to the nearest multiple of significance, regardless of sign of significance."
+msgid "Rounds number towards zero to the nearest multiple of absolute value of significance."
 msgstr ""
 
 #: scfuncs.src
@@ -13282,6 +13318,114 @@ msgstr ""
 #: scfuncs.src
 msgctxt ""
 "scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_FLOOR_MATH\n"
+"1\n"
+"string.text"
+msgid "Rounds number down to the nearest multiple of significance, regardless of sign of significance."
+msgstr ""
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_FLOOR_MATH\n"
+"2\n"
+"string.text"
+msgid "Number"
+msgstr ""
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_FLOOR_MATH\n"
+"3\n"
+"string.text"
+msgid "The number to be rounded down."
+msgstr ""
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_FLOOR_MATH\n"
+"4\n"
+"string.text"
+msgid "Significance"
+msgstr ""
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_FLOOR_MATH\n"
+"5\n"
+"string.text"
+msgid "The number to whose multiple the value is to be rounded down."
+msgstr ""
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_FLOOR_MATH\n"
+"6\n"
+"string.text"
+msgid "Mode"
+msgstr ""
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_FLOOR_MATH\n"
+"7\n"
+"string.text"
+msgid "For negative numbers; if given and not equal to or less than zero rounds towards zero."
+msgstr ""
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_FLOOR_PRECISE\n"
+"1\n"
+"string.text"
+msgid "Rounds number down (towards -∞) to the nearest multiple of significance."
+msgstr ""
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_FLOOR_PRECISE\n"
+"2\n"
+"string.text"
+msgid "Number"
+msgstr ""
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_FLOOR_PRECISE\n"
+"3\n"
+"string.text"
+msgid "The number to be rounded down."
+msgstr ""
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_FLOOR_PRECISE\n"
+"4\n"
+"string.text"
+msgid "Significance"
+msgstr ""
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_FLOOR_PRECISE\n"
+"5\n"
+"string.text"
+msgid "The number to whose multiple the value is to be rounded down. Sign has no meaning."
+msgstr ""
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
 "RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_GCD\n"
 "1\n"
 "string.text"
@@ -15068,7 +15212,7 @@ msgctxt ""
 "4\n"
 "string.text"
 msgid "Type"
-msgstr ""
+msgstr "نوعیت:"
 
 #: scfuncs.src
 msgctxt ""
@@ -15113,7 +15257,7 @@ msgctxt ""
 "4\n"
 "string.text"
 msgid "Type"
-msgstr ""
+msgstr "نوعیت:"
 
 #: scfuncs.src
 msgctxt ""
@@ -15311,7 +15455,7 @@ msgctxt ""
 "4\n"
 "string.text"
 msgid "value"
-msgstr ""
+msgstr "قیمت"
 
 #: scfuncs.src
 msgctxt ""
@@ -15374,7 +15518,7 @@ msgctxt ""
 "4\n"
 "string.text"
 msgid "value"
-msgstr ""
+msgstr "قیمت"
 
 #: scfuncs.src
 msgctxt ""
@@ -15482,7 +15626,7 @@ msgctxt ""
 "2\n"
 "string.text"
 msgid "value"
-msgstr ""
+msgstr "قیمت"
 
 #: scfuncs.src
 msgctxt ""
@@ -15518,7 +15662,7 @@ msgctxt ""
 "6\n"
 "string.text"
 msgid "Type"
-msgstr ""
+msgstr "نوعیت:"
 
 #: scfuncs.src
 msgctxt ""
@@ -15545,7 +15689,7 @@ msgctxt ""
 "2\n"
 "string.text"
 msgid "value"
-msgstr ""
+msgstr "قیمت"
 
 #: scfuncs.src
 msgctxt ""
@@ -15581,7 +15725,7 @@ msgctxt ""
 "6\n"
 "string.text"
 msgid "Type"
-msgstr ""
+msgstr "نوعیت:"
 
 #: scfuncs.src
 msgctxt ""
@@ -20378,7 +20522,7 @@ msgctxt ""
 "8\n"
 "string.text"
 msgid "Type"
-msgstr ""
+msgstr "نوعیت:"
 
 #: scfuncs.src
 msgctxt ""
@@ -24142,7 +24286,7 @@ msgctxt ""
 "RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_ENCODEURL\n"
 "3\n"
 "string.text"
-msgid "A string to be URL encoded"
+msgid "A string to be URL-encoded"
 msgstr ""
 
 #: scfuncs.src
@@ -25513,7 +25657,7 @@ msgctxt ""
 "STR_ADD_AUTOFORMAT_LABEL\n"
 "string.text"
 msgid "Name"
-msgstr ""
+msgstr "~نام"
 
 #: scstring.src
 msgctxt ""
@@ -25601,15 +25745,16 @@ msgctxt ""
 "STR_SHEET\n"
 "string.text"
 msgid "Sheet"
-msgstr ""
+msgstr "اوراق"
 
 #: scstring.src
+#, fuzzy
 msgctxt ""
 "scstring.src\n"
 "STR_CELL\n"
 "string.text"
 msgid "Cell"
-msgstr ""
+msgstr "خانے"
 
 #: scstring.src
 msgctxt ""
diff --git a/source/ur/sc/uiconfig/scalc/ui.po b/source/ur/sc/uiconfig/scalc/ui.po
index 3d79fea0d39..d9463a8d0d4 100644
--- a/source/ur/sc/uiconfig/scalc/ui.po
+++ b/source/ur/sc/uiconfig/scalc/ui.po
@@ -3,16 +3,18 @@ msgid ""
 msgstr ""
 "Project-Id-Version: LibO 40l10n\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2015-05-11 16:12+0200\n"
-"PO-Revision-Date: 2012-11-17 19:02+0200\n"
-"Last-Translator: Automatically generated\n"
+"POT-Creation-Date: 2015-06-24 17:05+0200\n"
+"PO-Revision-Date: 2015-05-14 05:27+0000\n"
+"Last-Translator: system user <>\n"
 "Language-Team: none\n"
 "Language: ur\n"
 "MIME-Version: 1.0\n"
 "Content-Type: text/plain; charset=UTF-8\n"
 "Content-Transfer-Encoding: 8bit\n"
-"X-Generator: LibreOffice\n"
+"Plural-Forms: nplurals=2; plural=(n != 1);\n"
+"X-Generator: Pootle 2.7\n"
 "X-Accelerator-Marker: ~\n"
+"X-POOTLE-MTIME: 1431581243.000000\n"
 
 #: advancedfilterdialog.ui
 msgctxt ""
@@ -1257,7 +1259,7 @@ msgctxt ""
 "0\n"
 "stringlist.text"
 msgid "Automatic"
-msgstr ""
+msgstr "خودکار"
 
 #: databaroptions.ui
 msgctxt ""
@@ -1320,7 +1322,7 @@ msgctxt ""
 "0\n"
 "stringlist.text"
 msgid "Automatic"
-msgstr ""
+msgstr "خودکار"
 
 #: databaroptions.ui
 msgctxt ""
@@ -1464,7 +1466,7 @@ msgctxt ""
 "0\n"
 "stringlist.text"
 msgid "Automatic"
-msgstr ""
+msgstr "خودکار"
 
 #: databaroptions.ui
 msgctxt ""
@@ -3654,22 +3656,24 @@ msgid "Sheet Name"
 msgstr ""
 
 #: headerfootercontent.ui
+#, fuzzy
 msgctxt ""
 "headerfootercontent.ui\n"
 "buttonBTN_PAGE\n"
 "tooltip_markup\n"
 "string.text"
 msgid "Page"
-msgstr ""
+msgstr "صفحات"
 
 #: headerfootercontent.ui
+#, fuzzy
 msgctxt ""
 "headerfootercontent.ui\n"
 "buttonBTN_PAGE\n"
 "tooltip_text\n"
 "string.text"
 msgid "Page"
-msgstr ""
+msgstr "صفحات"
 
 #: headerfootercontent.ui
 msgctxt ""
@@ -3753,13 +3757,14 @@ msgid "(none)"
 msgstr ""
 
 #: headerfootercontent.ui
+#, fuzzy
 msgctxt ""
 "headerfootercontent.ui\n"
 "labelSTR_PAGE\n"
 "label\n"
 "string.text"
 msgid "Page"
-msgstr ""
+msgstr "صفحات"
 
 #: headerfootercontent.ui
 msgctxt ""
@@ -4884,7 +4889,7 @@ msgctxt ""
 "label\n"
 "string.text"
 msgid "Pages"
-msgstr ""
+msgstr "صفحات"
 
 #: optdlg.ui
 msgctxt ""
@@ -5247,13 +5252,14 @@ msgid "Organizer"
 msgstr ""
 
 #: pagetemplatedialog.ui
+#, fuzzy
 msgctxt ""
 "pagetemplatedialog.ui\n"
 "page\n"
 "label\n"
 "string.text"
 msgid "Page"
-msgstr ""
+msgstr "صفحات"
 
 #: pagetemplatedialog.ui
 msgctxt ""
@@ -5742,13 +5748,14 @@ msgid "_None"
 msgstr ""
 
 #: pivotfielddialog.ui
+#, fuzzy
 msgctxt ""
 "pivotfielddialog.ui\n"
 "auto\n"
 "label\n"
 "string.text"
 msgid "_Automatic"
-msgstr ""
+msgstr "خودکار"
 
 #: pivotfielddialog.ui
 msgctxt ""
@@ -7700,7 +7707,7 @@ msgctxt ""
 "leftindentlabel\n"
 "label\n"
 "string.text"
-msgid "Left _indent:"
+msgid "_Indent:"
 msgstr ""
 
 #: sidebaralignment.ui
@@ -7787,33 +7794,6 @@ msgstr ""
 #: sidebaralignment.ui
 msgctxt ""
 "sidebaralignment.ui\n"
-"verticallystacked\n"
-"label\n"
-"string.text"
-msgid "Vertically stacked"
-msgstr ""
-
-#: sidebaralignment.ui
-msgctxt ""
-"sidebaralignment.ui\n"
-"verticallystacked\n"
-"tooltip_markup\n"
-"string.text"
-msgid "Aligns text vertically."
-msgstr ""
-
-#: sidebaralignment.ui
-msgctxt ""
-"sidebaralignment.ui\n"
-"verticallystacked\n"
-"tooltip_text\n"
-"string.text"
-msgid "Aligns text vertically."
-msgstr ""
-
-#: sidebaralignment.ui
-msgctxt ""
-"sidebaralignment.ui\n"
 "orientationdegrees\n"
 "tooltip_markup\n"
 "string.text"
@@ -7835,7 +7815,7 @@ msgctxt ""
 "cellbackgroundlabel\n"
 "label\n"
 "string.text"
-msgid "_Cell background:"
+msgid "_Background:"
 msgstr ""
 
 #: sidebarcellappearance.ui
@@ -7859,15 +7839,6 @@ msgstr ""
 #: sidebarcellappearance.ui
 msgctxt ""
 "sidebarcellappearance.ui\n"
-"cellborderlabel\n"
-"label\n"
-"string.text"
-msgid "Cell _border:"
-msgstr ""
-
-#: sidebarcellappearance.ui
-msgctxt ""
-"sidebarcellappearance.ui\n"
 "bordertype\n"
 "tooltip_markup\n"
 "string.text"
@@ -7937,33 +7908,6 @@ msgctxt ""
 msgid "Select the line color of the borders."
 msgstr ""
 
-#: sidebarcellappearance.ui
-msgctxt ""
-"sidebarcellappearance.ui\n"
-"cellgridlines\n"
-"label\n"
-"string.text"
-msgid "Show cell _grid lines"
-msgstr ""
-
-#: sidebarcellappearance.ui
-msgctxt ""
-"sidebarcellappearance.ui\n"
-"cellgridlines\n"
-"tooltip_text\n"
-"string.text"
-msgid "Show the grid lines of the cells."
-msgstr ""
-
-#: sidebarnumberformat.ui
-msgctxt ""
-"sidebarnumberformat.ui\n"
-"categorylabel\n"
-"label\n"
-"string.text"
-msgid "_Category:"
-msgstr ""
-
 #: sidebarnumberformat.ui
 msgctxt ""
 "sidebarnumberformat.ui\n"
@@ -8132,7 +8076,7 @@ msgctxt ""
 "negativenumbersred\n"
 "label\n"
 "string.text"
-msgid "_Negative numbers red"
+msgid "_Negative numbers in red"
 msgstr ""
 
 #: sidebarnumberformat.ui