update translations

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

Change-Id: Ia5f050e72d6aa24ae5ec73898e7c05ca2d4103cb

5 files changed, 400 insertions, 168 deletions

diff --git a/source/oc/sc/source/ui/StatisticsDialogs.po b/source/oc/sc/source/ui/StatisticsDialogs.po
index 110d2579321..9ec5f33d200 100644
--- a/source/oc/sc/source/ui/StatisticsDialogs.po
+++ b/source/oc/sc/source/ui/StatisticsDialogs.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: 2014-11-22 15:16+0100\n"
-"PO-Revision-Date: 2015-04-18 07:26+0000\n"
-"Last-Translator: Cédric <cvalmary@yahoo.fr>\n"
+"POT-Creation-Date: 2015-04-22 23:40+0200\n"
+"PO-Revision-Date: 2015-05-26 17:14+0000\n"
+"Last-Translator: Cédric Valmary <cvalmary@yahoo.fr>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
 "Language: oc\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: Pootle 2.5.1\n"
+"X-Generator: Pootle 2.7\n"
 "X-Accelerator-Marker: ~\n"
-"X-POOTLE-MTIME: 1429341973.000000\n"
+"X-POOTLE-MTIME: 1432660498.000000\n"
 
 #: StatisticsDialogs.src
 msgctxt ""
@@ -113,7 +113,7 @@ msgctxt ""
 "STR_ANOVA_LABEL_DF\n"
 "string.text"
 msgid "df"
-msgstr ""
+msgstr "df"
 
 #: StatisticsDialogs.src
 msgctxt ""
@@ -122,7 +122,7 @@ msgctxt ""
 "STR_ANOVA_LABEL_MS\n"
 "string.text"
 msgid "MS"
-msgstr ""
+msgstr "MS"
 
 #: StatisticsDialogs.src
 msgctxt ""
@@ -293,7 +293,7 @@ msgctxt ""
 "STRID_CALC_MIN\n"
 "string.text"
 msgid "Minimum"
-msgstr ""
+msgstr "Minimum"
 
 #: StatisticsDialogs.src
 msgctxt ""
@@ -302,7 +302,7 @@ msgctxt ""
 "STRID_CALC_MAX\n"
 "string.text"
 msgid "Maximum"
-msgstr ""
+msgstr "Maximum"
 
 #: StatisticsDialogs.src
 msgctxt ""
diff --git a/source/oc/sc/source/ui/drawfunc.po b/source/oc/sc/source/ui/drawfunc.po
index 2d10e13c07d..6c9f3ec6d60 100644
--- a/source/oc/sc/source/ui/drawfunc.po
+++ b/source/oc/sc/source/ui/drawfunc.po
@@ -4,17 +4,17 @@ 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: 2014-03-18 17:57+0000\n"
-"Last-Translator: Cédric <cvalmary@yahoo.fr>\n"
+"PO-Revision-Date: 2015-05-26 05:31+0000\n"
+"Last-Translator: Cédric Valmary <cvalmary@yahoo.fr>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
 "Language: oc\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: 1395165445.000000\n"
+"X-POOTLE-MTIME: 1432618319.000000\n"
 
 #: drformsh.src
 msgctxt ""
@@ -282,7 +282,7 @@ msgctxt ""
 "RID_IMAGE_SUBMENU\n"
 "menuitem.text"
 msgid "Image"
-msgstr ""
+msgstr "Imatge"
 
 #: objdraw.src
 msgctxt ""
diff --git a/source/oc/sc/source/ui/sidebar.po b/source/oc/sc/source/ui/sidebar.po
index c5fb2656e83..1830fa59491 100644
--- a/source/oc/sc/source/ui/sidebar.po
+++ b/source/oc/sc/source/ui/sidebar.po
@@ -4,17 +4,17 @@ 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: 2013-10-12 07:58+0000\n"
-"Last-Translator: Cédric <cvalmary@yahoo.fr>\n"
+"PO-Revision-Date: 2015-05-26 05:32+0000\n"
+"Last-Translator: Cédric Valmary <cvalmary@yahoo.fr>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
 "Language: oc\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: 1381564687.0\n"
+"X-POOTLE-MTIME: 1432618324.000000\n"
 
 #: CellAppearancePropertyPanel.src
 msgctxt ""
@@ -211,7 +211,7 @@ msgctxt ""
 "RID_SFX_STR_THOUSAND_SEP\n"
 "string.text"
 msgid "Thousands separator"
-msgstr ""
+msgstr "Separador dels milierats"
 
 #: NumberFormatPropertyPanel.src
 msgctxt ""
diff --git a/source/oc/sc/source/ui/src.po b/source/oc/sc/source/ui/src.po
index 101d570207f..7784d8ef164 100644
--- a/source/oc/sc/source/ui/src.po
+++ b/source/oc/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: 2015-05-09 11:18+0000\n"
-"Last-Translator: Cédric <cvalmary@yahoo.fr>\n"
+"POT-Creation-Date: 2015-06-24 17:05+0200\n"
+"PO-Revision-Date: 2015-05-26 17:14+0000\n"
+"Last-Translator: Cédric Valmary <cvalmary@yahoo.fr>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
 "Language: oc\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: 1431170305.000000\n"
+"X-POOTLE-MTIME: 1432660472.000000\n"
 
 #: condformatdlg.src
 msgctxt ""
@@ -737,21 +737,41 @@ msgid "3 Symbols 2"
 msgstr "3 simbòls 2"
 
 #: condformatdlg.src
+#, fuzzy
 msgctxt ""
 "condformatdlg.src\n"
 "RID_COND_ENTRY.LB_ICONSET_TYPE\n"
-"3 Smilies\n"
+"3 Smileys\n"
 "stringlist.text"
-msgid "3 Smilies"
+msgid "3 Smileys"
 msgstr "3 emoticònas"
 
 #: condformatdlg.src
 msgctxt ""
 "condformatdlg.src\n"
 "RID_COND_ENTRY.LB_ICONSET_TYPE\n"
-"3 Colored Smilies\n"
+"3 Stars\n"
 "stringlist.text"
-msgid "3 Colored Smilies"
+msgid "3 Stars"
+msgstr ""
+
+#: condformatdlg.src
+msgctxt ""
+"condformatdlg.src\n"
+"RID_COND_ENTRY.LB_ICONSET_TYPE\n"
+"3 Triangles\n"
+"stringlist.text"
+msgid "3 Triangles"
+msgstr ""
+
+#: condformatdlg.src
+#, fuzzy
+msgctxt ""
+"condformatdlg.src\n"
+"RID_COND_ENTRY.LB_ICONSET_TYPE\n"
+"3 Colored Smileys\n"
+"stringlist.text"
+msgid "3 Colored Smileys"
 msgstr "3 emoticònas coloradas"
 
 #: condformatdlg.src
@@ -838,6 +858,15 @@ msgstr "5 quartièrs"
 #: 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"
@@ -5957,6 +5986,16 @@ msgid "Insert Co~mment"
 msgstr "Inserir un co~mentari"
 
 #: popup.src
+#, fuzzy
+msgctxt ""
+"popup.src\n"
+"RID_POPUP_CELLS\n"
+"SID_EDIT_POSTIT\n"
+"menuitem.text"
+msgid "Edit Co~mment"
+msgstr "Editar lo comentari"
+
+#: popup.src
 msgctxt ""
 "popup.src\n"
 "RID_POPUP_CELLS\n"
@@ -7742,7 +7781,7 @@ msgctxt ""
 "2\n"
 "string.text"
 msgid "Start Date"
-msgstr ""
+msgstr "Data iniciala"
 
 #: scfuncs.src
 msgctxt ""
@@ -7751,7 +7790,7 @@ msgctxt ""
 "3\n"
 "string.text"
 msgid "Start date for calculation."
-msgstr ""
+msgstr "Data iniciala pel calcul."
 
 #: scfuncs.src
 msgctxt ""
@@ -7760,7 +7799,7 @@ msgctxt ""
 "4\n"
 "string.text"
 msgid "End Date"
-msgstr ""
+msgstr "Data finala"
 
 #: scfuncs.src
 msgctxt ""
@@ -7769,7 +7808,7 @@ msgctxt ""
 "5\n"
 "string.text"
 msgid "End date for calculation."
-msgstr ""
+msgstr "Data finala pel calcul."
 
 #: scfuncs.src
 msgctxt ""
@@ -7778,7 +7817,7 @@ msgctxt ""
 "6\n"
 "string.text"
 msgid "array"
-msgstr ""
+msgstr "matritz"
 
 #: scfuncs.src
 msgctxt ""
@@ -7796,7 +7835,7 @@ msgctxt ""
 "8\n"
 "string.text"
 msgid "list of numbers"
-msgstr ""
+msgstr "lista de nombres"
 
 #: scfuncs.src
 msgctxt ""
@@ -8186,12 +8225,13 @@ msgid "Determines the current date of the computer."
 msgstr "Determina la data correnta de l'ordenador."
 
 #: scfuncs.src
+#, fuzzy
 msgctxt ""
 "scfuncs.src\n"
 "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 "Renvia lo jorn de la setmana (comprés entre 1 e 7) que correspond a l'argument numèro_seria."
 
 #: scfuncs.src
@@ -9254,7 +9294,7 @@ msgctxt ""
 "8\n"
 "string.text"
 msgid "S"
-msgstr ""
+msgstr "S"
 
 #: scfuncs.src
 msgctxt ""
@@ -13061,7 +13101,7 @@ msgctxt ""
 "2\n"
 "string.text"
 msgid "Number"
-msgstr ""
+msgstr "Numèro_seria"
 
 #: scfuncs.src
 msgctxt ""
@@ -13070,7 +13110,7 @@ msgctxt ""
 "3\n"
 "string.text"
 msgid "The number to be rounded up."
-msgstr ""
+msgstr "La valor d'arredondir en s'alunhant de zèro."
 
 #: scfuncs.src
 msgctxt ""
@@ -13079,7 +13119,7 @@ msgctxt ""
 "4\n"
 "string.text"
 msgid "Significance"
-msgstr ""
+msgstr "Precision"
 
 #: scfuncs.src
 msgctxt ""
@@ -13088,7 +13128,7 @@ msgctxt ""
 "5\n"
 "string.text"
 msgid "The number to whose multiple the value is rounded."
-msgstr ""
+msgstr "Lo multiple al qual cal arredondir lo nombre."
 
 #: scfuncs.src
 msgctxt ""
@@ -13214,7 +13254,7 @@ msgctxt ""
 "2\n"
 "string.text"
 msgid "Number"
-msgstr ""
+msgstr "Numèro_seria"
 
 #: scfuncs.src
 msgctxt ""
@@ -13223,7 +13263,7 @@ msgctxt ""
 "3\n"
 "string.text"
 msgid "The number to be rounded up."
-msgstr ""
+msgstr "La valor d'arredondir en s'alunhant de zèro."
 
 #: scfuncs.src
 msgctxt ""
@@ -13232,7 +13272,7 @@ msgctxt ""
 "4\n"
 "string.text"
 msgid "Significance"
-msgstr ""
+msgstr "Precision"
 
 #: scfuncs.src
 msgctxt ""
@@ -13250,7 +13290,7 @@ msgctxt ""
 "6\n"
 "string.text"
 msgid "Mode"
-msgstr ""
+msgstr "Mòde"
 
 #: scfuncs.src
 msgctxt ""
@@ -13321,7 +13361,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
@@ -13330,7 +13370,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
@@ -13372,6 +13412,122 @@ msgstr "Lo multiple al qual cal arredondir lo nombre."
 #: 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
+#, fuzzy
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_FLOOR_MATH\n"
+"2\n"
+"string.text"
+msgid "Number"
+msgstr "Numèro_seria"
+
+#: scfuncs.src
+#, fuzzy
+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 "La valor d'arredondir en tendent cap a zèro."
+
+#: scfuncs.src
+#, fuzzy
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_FLOOR_MATH\n"
+"4\n"
+"string.text"
+msgid "Significance"
+msgstr "Precision"
+
+#: scfuncs.src
+#, fuzzy
+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 "Lo multiple al qual cal arredondir lo nombre."
+
+#: scfuncs.src
+#, fuzzy
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_FLOOR_MATH\n"
+"6\n"
+"string.text"
+msgid "Mode"
+msgstr "Mòde"
+
+#: 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
+#, fuzzy
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_FLOOR_PRECISE\n"
+"2\n"
+"string.text"
+msgid "Number"
+msgstr "Numèro_seria"
+
+#: scfuncs.src
+#, fuzzy
+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 "La valor d'arredondir en tendent cap a zèro."
+
+#: scfuncs.src
+#, fuzzy
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_FLOOR_PRECISE\n"
+"4\n"
+"string.text"
+msgid "Significance"
+msgstr "Precision"
+
+#: 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"
@@ -15941,7 +16097,7 @@ msgctxt ""
 "3\n"
 "string.text"
 msgid "The value for which the integral value of the standard normal distribution is to be calculated."
-msgstr ""
+msgstr "La valor per la quala volètz calcular la distribucion normala estandarda."
 
 #: scfuncs.src
 msgctxt ""
@@ -16094,7 +16250,7 @@ msgctxt ""
 "2\n"
 "string.text"
 msgid "X"
-msgstr ""
+msgstr "X"
 
 #: scfuncs.src
 msgctxt ""
@@ -16148,7 +16304,7 @@ msgctxt ""
 "8\n"
 "string.text"
 msgid "C"
-msgstr ""
+msgstr "C"
 
 #: scfuncs.src
 msgctxt ""
@@ -16238,7 +16394,7 @@ msgctxt ""
 "2\n"
 "string.text"
 msgid "X"
-msgstr ""
+msgstr "X"
 
 #: scfuncs.src
 msgctxt ""
@@ -16256,7 +16412,7 @@ msgctxt ""
 "4\n"
 "string.text"
 msgid "R"
-msgstr ""
+msgstr "R"
 
 #: scfuncs.src
 msgctxt ""
@@ -22405,7 +22561,7 @@ msgctxt ""
 "3\n"
 "string.text"
 msgid "The text to be found."
-msgstr ""
+msgstr "Lo tèxte que recercatz."
 
 #: scfuncs.src
 msgctxt ""
@@ -22459,7 +22615,7 @@ msgctxt ""
 "2\n"
 "string.text"
 msgid "find_text"
-msgstr ""
+msgstr "tèxte_cercat"
 
 #: scfuncs.src
 msgctxt ""
@@ -22468,7 +22624,7 @@ msgctxt ""
 "3\n"
 "string.text"
 msgid "The text to be found."
-msgstr ""
+msgstr "Lo tèxte que recercatz."
 
 #: scfuncs.src
 msgctxt ""
@@ -23485,7 +23641,7 @@ msgctxt ""
 "3\n"
 "string.text"
 msgid "The code value for the character."
-msgstr ""
+msgstr "La valor encodada pel caractèr."
 
 #: scfuncs.src
 msgctxt ""
@@ -23594,7 +23750,7 @@ msgctxt ""
 "1\n"
 "string.text"
 msgid "Converts text to a number, in a locale-independent way."
-msgstr ""
+msgstr "Convertís un tèxte en nombre, sens tenir compte dels paramètres locals."
 
 #: scfuncs.src
 msgctxt ""
@@ -23630,7 +23786,7 @@ msgctxt ""
 "5\n"
 "string.text"
 msgid "Defines the character used as the decimal separator."
-msgstr ""
+msgstr "Definís lo caractèr d'utilizar coma separador decimal."
 
 #: scfuncs.src
 msgctxt ""
@@ -23648,7 +23804,7 @@ msgctxt ""
 "7\n"
 "string.text"
 msgid "Defines the character(s) used as the group separator."
-msgstr ""
+msgstr "Definís lo o los caractèrs utilizats coma separador de grop."
 
 #: scfuncs.src
 msgctxt ""
@@ -23909,7 +24065,7 @@ msgctxt ""
 "1\n"
 "string.text"
 msgid "Returns the last character or characters of a text,with DBCS"
-msgstr ""
+msgstr "Renvia lo o los darrièrs caractèrs d'un tèxte, amb DBCS"
 
 #: scfuncs.src
 msgctxt ""
@@ -24071,7 +24227,7 @@ msgctxt ""
 "2\n"
 "string.text"
 msgid "XML Document"
-msgstr ""
+msgstr "Document XML"
 
 #: scfuncs.src
 msgctxt ""
@@ -24232,7 +24388,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
@@ -25819,3 +25975,57 @@ msgctxt ""
 "string.text"
 msgid "Collapse Formula Bar"
 msgstr "Redusir la barra Formula"
+
+#: condformatdlg.src
+msgctxt ""
+"condformatdlg.src\n"
+"RID_COND_ENTRY.LB_ICONSET_TYPE\n"
+"3 Smilies\n"
+"stringlist.text"
+msgid "3 Smilies"
+msgstr "3 emoticònas"
+
+#: condformatdlg.src
+msgctxt ""
+"condformatdlg.src\n"
+"RID_COND_ENTRY.LB_ICONSET_TYPE\n"
+"3 Colored Smilies\n"
+"stringlist.text"
+msgid "3 Colored Smilies"
+msgstr "3 emoticònas coloradas"
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"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)."
+msgstr "Renvia lo jorn de la setmana (comprés entre 1 e 7) que correspond a l'argument numèro_seria."
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"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."
+msgstr ""
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"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."
+msgstr ""
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_ENCODEURL\n"
+"3\n"
+"string.text"
+msgid "A string to be URL encoded"
+msgstr ""
diff --git a/source/oc/sc/uiconfig/scalc/ui.po b/source/oc/sc/uiconfig/scalc/ui.po
index 71d0f316b84..1f7f2637510 100644
--- a/source/oc/sc/uiconfig/scalc/ui.po
+++ b/source/oc/sc/uiconfig/scalc/ui.po
@@ -3,18 +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: 2015-04-26 07:38+0000\n"
-"Last-Translator: Cédric <cvalmary@yahoo.fr>\n"
+"POT-Creation-Date: 2015-06-24 17:05+0200\n"
+"PO-Revision-Date: 2015-08-04 06:12+0000\n"
+"Last-Translator: Cédric Valmary <cvalmary@yahoo.fr>\n"
 "Language-Team: none\n"
 "Language: oc\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: 1430033884.000000\n"
+"X-POOTLE-MTIME: 1438668734.000000\n"
 
 #: advancedfilterdialog.ui
 msgctxt ""
@@ -167,7 +167,7 @@ msgctxt ""
 "title\n"
 "string.text"
 msgid "Analysis of Variance (ANOVA)"
-msgstr ""
+msgstr "Analisi de variança (ANOVA)"
 
 #: analysisofvariancedialog.ui
 msgctxt ""
@@ -275,7 +275,7 @@ msgctxt ""
 "label\n"
 "string.text"
 msgid "Rows per sample:"
-msgstr ""
+msgstr "Linhas per escandalhatge :"
 
 #: analysisofvariancedialog.ui
 msgctxt ""
@@ -533,7 +533,7 @@ msgctxt ""
 "title\n"
 "string.text"
 msgid "Chi Square Test"
-msgstr ""
+msgstr "Tèst Khi-dos"
 
 #: chisquaretestdialog.ui
 msgctxt ""
@@ -866,7 +866,7 @@ msgctxt ""
 "5\n"
 "stringlist.text"
 msgid "Product"
-msgstr ""
+msgstr "Produch"
 
 #: consolidatedialog.ui
 msgctxt ""
@@ -920,7 +920,7 @@ msgctxt ""
 "label\n"
 "string.text"
 msgid "_Source data ranges:"
-msgstr ""
+msgstr "Plaja de donadas _font :"
 
 #: consolidatedialog.ui
 msgctxt ""
@@ -1415,7 +1415,7 @@ msgctxt ""
 "label\n"
 "string.text"
 msgid "Fill:"
-msgstr ""
+msgstr "Emplenar :"
 
 #: databaroptions.ui
 msgctxt ""
@@ -1424,7 +1424,7 @@ msgctxt ""
 "0\n"
 "stringlist.text"
 msgid "Color"
-msgstr ""
+msgstr "Color"
 
 #: databaroptions.ui
 msgctxt ""
@@ -1433,7 +1433,7 @@ msgctxt ""
 "1\n"
 "stringlist.text"
 msgid "Gradient"
-msgstr ""
+msgstr "Degradat"
 
 #: databaroptions.ui
 msgctxt ""
@@ -1496,7 +1496,7 @@ msgctxt ""
 "label\n"
 "string.text"
 msgid "Axis"
-msgstr ""
+msgstr "Axe"
 
 #: databaroptions.ui
 msgctxt ""
@@ -1505,7 +1505,7 @@ msgctxt ""
 "label\n"
 "string.text"
 msgid "Minimum bar length (%):"
-msgstr ""
+msgstr "Longor minimala de barra (%) :"
 
 #: databaroptions.ui
 msgctxt ""
@@ -1514,7 +1514,7 @@ msgctxt ""
 "label\n"
 "string.text"
 msgid "Maximum bar length (%):"
-msgstr ""
+msgstr "Longor maximala de barra (%) :"
 
 #: databaroptions.ui
 msgctxt ""
@@ -1532,7 +1532,7 @@ msgctxt ""
 "label\n"
 "string.text"
 msgid "Display bar only"
-msgstr ""
+msgstr "Longors de barras"
 
 #: databaroptions.ui
 msgctxt ""
@@ -1676,7 +1676,7 @@ msgctxt ""
 "7\n"
 "stringlist.text"
 msgid "% of total"
-msgstr "%d del total"
+msgstr "% del total"
 
 #: datafielddialog.ui
 msgctxt ""
@@ -1721,7 +1721,7 @@ msgctxt ""
 "title\n"
 "string.text"
 msgid "Data Field Options"
-msgstr ""
+msgstr "Opcions dels camps de donadas"
 
 #: datafieldoptionsdialog.ui
 msgctxt ""
@@ -1748,7 +1748,7 @@ msgctxt ""
 "label\n"
 "string.text"
 msgid "_Manual"
-msgstr ""
+msgstr "_Manual"
 
 #: datafieldoptionsdialog.ui
 msgctxt ""
@@ -1856,7 +1856,7 @@ msgctxt ""
 "label\n"
 "string.text"
 msgid "items"
-msgstr ""
+msgstr "elements"
 
 #: datafieldoptionsdialog.ui
 msgctxt ""
@@ -1865,7 +1865,7 @@ msgctxt ""
 "0\n"
 "stringlist.text"
 msgid "Top"
-msgstr ""
+msgstr "Amont"
 
 #: datafieldoptionsdialog.ui
 msgctxt ""
@@ -2045,7 +2045,7 @@ msgctxt ""
 "label\n"
 "string.text"
 msgid "value1,value2,...,valueN, and fill into range:"
-msgstr ""
+msgstr "valor1,valor2,...,valorN e emplenar la plaja :"
 
 #: datastreams.ui
 msgctxt ""
@@ -2063,7 +2063,7 @@ msgctxt ""
 "label\n"
 "string.text"
 msgid "Interpret stream data as"
-msgstr ""
+msgstr "Interpretar las donadas del flux coma"
 
 #: datastreams.ui
 msgctxt ""
@@ -2729,7 +2729,7 @@ msgctxt ""
 "label\n"
 "string.text"
 msgid "Smoothing factor:"
-msgstr ""
+msgstr "Factor de lisatge :"
 
 #: exponentialsmoothingdialog.ui
 msgctxt ""
@@ -3242,7 +3242,7 @@ msgctxt ""
 "label\n"
 "string.text"
 msgid "_Test OpenCL"
-msgstr ""
+msgstr "_Tèst OpenCL"
 
 #: formulacalculationoptions.ui
 msgctxt ""
@@ -3890,7 +3890,7 @@ msgctxt ""
 "label\n"
 "string.text"
 msgid "_Field delimiter:"
-msgstr ""
+msgstr "_Separador de camps :"
 
 #: imoptdialog.ui
 msgctxt ""
@@ -4277,7 +4277,7 @@ msgctxt ""
 "title\n"
 "string.text"
 msgid "column"
-msgstr ""
+msgstr "colomna"
 
 #: movecopysheet.ui
 msgctxt ""
@@ -4376,7 +4376,7 @@ msgctxt ""
 "label\n"
 "string.text"
 msgid "Name is empty."
-msgstr ""
+msgstr "Lo nom es void."
 
 #: movecopysheet.ui
 msgctxt ""
@@ -4385,7 +4385,7 @@ msgctxt ""
 "label\n"
 "string.text"
 msgid "Name contains one or more invalid characters."
-msgstr ""
+msgstr "Lo nom conten un o mantun caractèr incorrèctes."
 
 #: movecopysheet.ui
 msgctxt ""
@@ -5627,7 +5627,7 @@ msgctxt ""
 "label\n"
 "string.text"
 msgid "Multipl_y"
-msgstr ""
+msgstr "M_ultiplicar"
 
 #: pastespecial.ui
 msgctxt ""
@@ -5636,7 +5636,7 @@ msgctxt ""
 "label\n"
 "string.text"
 msgid "Di_vide"
-msgstr ""
+msgstr "_Devesir"
 
 #: pastespecial.ui
 msgctxt ""
@@ -7121,7 +7121,7 @@ msgctxt ""
 "0\n"
 "stringlist.text"
 msgid "Table"
-msgstr ""
+msgstr "Taula"
 
 #: selectdatasource.ui
 msgctxt ""
@@ -7148,7 +7148,7 @@ msgctxt ""
 "3\n"
 "stringlist.text"
 msgid "Sql [Native]"
-msgstr "Sql [natiu]"
+msgstr "Sql [Natiu]"
 
 #: selectdatasource.ui
 msgctxt ""
@@ -7670,7 +7670,7 @@ msgctxt ""
 "label\n"
 "string.text"
 msgid "Hidden Sheets"
-msgstr ""
+msgstr "Fuèlhs amagats"
 
 #: sidebaralignment.ui
 msgctxt ""
@@ -7705,8 +7705,8 @@ msgctxt ""
 "leftindentlabel\n"
 "label\n"
 "string.text"
-msgid "Left _indent:"
-msgstr "Alinhèa a es_quèrra :"
+msgid "_Indent:"
+msgstr ""
 
 #: sidebaralignment.ui
 msgctxt ""
@@ -7792,33 +7792,6 @@ msgstr "_Orientacion del tèxte :"
 #: sidebaralignment.ui
 msgctxt ""
 "sidebaralignment.ui\n"
-"verticallystacked\n"
-"label\n"
-"string.text"
-msgid "Vertically stacked"
-msgstr "Empilat a la verticala"
-
-#: sidebaralignment.ui
-msgctxt ""
-"sidebaralignment.ui\n"
-"verticallystacked\n"
-"tooltip_markup\n"
-"string.text"
-msgid "Aligns text vertically."
-msgstr "Alinha lo tèxte verticalament."
-
-#: sidebaralignment.ui
-msgctxt ""
-"sidebaralignment.ui\n"
-"verticallystacked\n"
-"tooltip_text\n"
-"string.text"
-msgid "Aligns text vertically."
-msgstr "Alinha lo tèxte verticalament."
-
-#: sidebaralignment.ui
-msgctxt ""
-"sidebaralignment.ui\n"
 "orientationdegrees\n"
 "tooltip_markup\n"
 "string.text"
@@ -7835,13 +7808,14 @@ msgid "Select the angle for rotation."
 msgstr "Seleccionatz l'angle de rotacion."
 
 #: sidebarcellappearance.ui
+#, fuzzy
 msgctxt ""
 "sidebarcellappearance.ui\n"
 "cellbackgroundlabel\n"
 "label\n"
 "string.text"
-msgid "_Cell background:"
-msgstr "Rèire plan de _cellula :"
+msgid "_Background:"
+msgstr "Rèire plan"
 
 #: sidebarcellappearance.ui
 msgctxt ""
@@ -7864,15 +7838,6 @@ msgstr "Seleccionatz la color de rèire plan de las cellulas seleccionadas."
 #: sidebarcellappearance.ui
 msgctxt ""
 "sidebarcellappearance.ui\n"
-"cellborderlabel\n"
-"label\n"
-"string.text"
-msgid "Cell _border:"
-msgstr "_Bordadura de cellula :"
-
-#: sidebarcellappearance.ui
-msgctxt ""
-"sidebarcellappearance.ui\n"
 "bordertype\n"
 "tooltip_markup\n"
 "string.text"
@@ -7942,33 +7907,6 @@ msgctxt ""
 msgid "Select the line color of the borders."
 msgstr "Seleccionatz la color de linha de las bordaduras."
 
-#: 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 "_Categoria :"
-
 #: sidebarnumberformat.ui
 msgctxt ""
 "sidebarnumberformat.ui\n"
@@ -8132,12 +8070,13 @@ msgid "Enter the maximum number of zeroes to display before the decimal point."
 msgstr ""
 
 #: sidebarnumberformat.ui
+#, fuzzy
 msgctxt ""
 "sidebarnumberformat.ui\n"
 "negativenumbersred\n"
 "label\n"
 "string.text"
-msgid "_Negative numbers red"
+msgid "_Negative numbers in red"
 msgstr "_Nombres negatius en roge"
 
 #: sidebarnumberformat.ui
@@ -8174,7 +8113,7 @@ msgctxt ""
 "tooltip_markup\n"
 "string.text"
 msgid "Inserts a separator between thousands."
-msgstr ""
+msgstr "Inserís un separador entre los milierats."
 
 #: sidebarnumberformat.ui
 msgctxt ""
@@ -8183,7 +8122,7 @@ msgctxt ""
 "tooltip_text\n"
 "string.text"
 msgid "Inserts a separator between thousands."
-msgstr ""
+msgstr "Inserís un separador entre los milierats."
 
 #: simplerefdialog.ui
 msgctxt ""
@@ -9623,7 +9562,7 @@ msgctxt ""
 "5\n"
 "stringlist.text"
 msgid "Product"
-msgstr ""
+msgstr "Produch"
 
 #: subtotalgrppage.ui
 msgctxt ""
@@ -10298,7 +10237,7 @@ msgctxt ""
 "label\n"
 "string.text"
 msgid "Zoom"
-msgstr ""
+msgstr "Zoom"
 
 #: ttestdialog.ui
 msgctxt ""
@@ -10812,3 +10751,86 @@ msgctxt ""
 "string.text"
 msgid "Grouped by"
 msgstr "Gropat per"
+
+msgctxt ""
+"sidebaralignment.ui\n"
+"leftindentlabel\n"
+"label\n"
+"string.text"
+msgid "Left _indent:"
+msgstr "Alinhèa a es_quèrra :"
+
+msgctxt ""
+"sidebaralignment.ui\n"
+"verticallystacked\n"
+"label\n"
+"string.text"
+msgid "Vertically stacked"
+msgstr "Empilat a la verticala"
+
+msgctxt ""
+"sidebaralignment.ui\n"
+"verticallystacked\n"
+"tooltip_markup\n"
+"string.text"
+msgid "Aligns text vertically."
+msgstr "Alinha lo tèxte verticalament."
+
+msgctxt ""
+"sidebaralignment.ui\n"
+"verticallystacked\n"
+"tooltip_text\n"
+"string.text"
+msgid "Aligns text vertically."
+msgstr "Alinha lo tèxte verticalament."
+
+msgctxt ""
+"sidebarcellappearance.ui\n"
+"cellbackgroundlabel\n"
+"label\n"
+"string.text"
+msgid "_Cell background:"
+msgstr "Rèire plan de _cellula :"
+
+msgctxt ""
+"sidebarcellappearance.ui\n"
+"cellborderlabel\n"
+"label\n"
+"string.text"
+msgid "Cell _border:"
+msgstr "_Bordadura de cellula :"
+
+msgctxt ""
+"sidebarnumberformat.ui\n"
+"categorylabel\n"
+"label\n"
+"string.text"
+msgid "_Category:"
+msgstr "_Categoria :"
+
+#: 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"
+"negativenumbersred\n"
+"label\n"
+"string.text"
+msgid "_Negative numbers red"
+msgstr "_Nombres negatius en roge"