update translations

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

Change-Id: Ia5f050e72d6aa24ae5ec73898e7c05ca2d4103cb

2 files changed, 290 insertions, 134 deletions

diff --git a/source/ca-valencia/sc/source/ui/src.po b/source/ca-valencia/sc/source/ui/src.po
index 4e548e26236..62692d31dd9 100644
--- a/source/ca-valencia/sc/source/ui/src.po
+++ b/source/ca-valencia/sc/source/ui/src.po
@@ -3,18 +3,18 @@ msgid ""
 msgstr ""
 "Project-Id-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-01-10 21:25+0000\n"
-"Last-Translator: Joan <joan@montane.cat>\n"
+"POT-Creation-Date: 2015-06-24 17:05+0200\n"
+"PO-Revision-Date: 2015-05-12 03:23+0000\n"
+"Last-Translator: system user <>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
 "Language: ca-valencia\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: 1420925158.000000\n"
+"X-POOTLE-MTIME: 1431401035.000000\n"
 
 #: condformatdlg.src
 msgctxt ""
@@ -539,13 +539,14 @@ msgid "Enter a value!"
 msgstr ""
 
 #: condformatdlg.src
+#, fuzzy
 msgctxt ""
 "condformatdlg.src\n"
 "RID_COND_ENTRY\n"
 "BTN_OPTIONS\n"
 "pushbutton.text"
 msgid "More Options..."
-msgstr ""
+msgstr "Més opcions..."
 
 #: condformatdlg.src
 msgctxt ""
@@ -737,21 +738,41 @@ msgid "3 Symbols 2"
 msgstr "3 símbols 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 emoticones"
 
 #: 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 emoticones de colors"
 
 #: condformatdlg.src
@@ -838,6 +859,15 @@ msgstr "5 quarts"
 #: 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"
@@ -4315,13 +4345,14 @@ msgid "#1 inserted"
 msgstr "#1 inserit"
 
 #: globstr.src
+#, fuzzy
 msgctxt ""
 "globstr.src\n"
 "RID_GLOBSTR\n"
 "STR_CHANGED_DELETE\n"
 "string.text"
 msgid "#1 deleted"
-msgstr ""
+msgstr "#1suprimit"
 
 #: globstr.src
 msgctxt ""
@@ -5956,6 +5987,16 @@ msgid "Insert Co~mment"
 msgstr "Insereix 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 "Edita el comentari"
+
+#: popup.src
 msgctxt ""
 "popup.src\n"
 "RID_POPUP_CELLS\n"
@@ -7742,7 +7783,7 @@ msgctxt ""
 "2\n"
 "string.text"
 msgid "Start Date"
-msgstr ""
+msgstr "Data inicial"
 
 #: scfuncs.src
 msgctxt ""
@@ -7751,7 +7792,7 @@ msgctxt ""
 "3\n"
 "string.text"
 msgid "Start date for calculation."
-msgstr ""
+msgstr "Data d'inici per al càlcul."
 
 #: scfuncs.src
 msgctxt ""
@@ -7760,7 +7801,7 @@ msgctxt ""
 "4\n"
 "string.text"
 msgid "End Date"
-msgstr ""
+msgstr "Data final"
 
 #: scfuncs.src
 msgctxt ""
@@ -7769,7 +7810,7 @@ msgctxt ""
 "5\n"
 "string.text"
 msgid "End date for calculation."
-msgstr ""
+msgstr "Data de finalització del càlcul."
 
 #: scfuncs.src
 msgctxt ""
@@ -7778,7 +7819,7 @@ msgctxt ""
 "6\n"
 "string.text"
 msgid "array"
-msgstr ""
+msgstr "matriu"
 
 #: scfuncs.src
 msgctxt ""
@@ -8186,12 +8227,13 @@ msgid "Determines the current date of the computer."
 msgstr "Determina la data actual de l'ordinador."
 
 #: 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 "Retorna el dia de la setmana per al valor de la data com a enter (1-7)."
 
 #: scfuncs.src
@@ -8984,7 +9026,7 @@ msgctxt ""
 "4\n"
 "string.text"
 msgid "Period"
-msgstr ""
+msgstr "Període"
 
 #: scfuncs.src
 msgctxt ""
@@ -9434,7 +9476,7 @@ msgctxt ""
 "2\n"
 "string.text"
 msgid "Cost"
-msgstr ""
+msgstr "Cost"
 
 #: scfuncs.src
 msgctxt ""
@@ -9452,7 +9494,7 @@ msgctxt ""
 "4\n"
 "string.text"
 msgid "Salvage"
-msgstr ""
+msgstr "Valor residual"
 
 #: scfuncs.src
 msgctxt ""
@@ -9470,7 +9512,7 @@ msgctxt ""
 "6\n"
 "string.text"
 msgid "Life"
-msgstr ""
+msgstr "Vida"
 
 #: scfuncs.src
 msgctxt ""
@@ -9479,7 +9521,7 @@ msgctxt ""
 "7\n"
 "string.text"
 msgid "Useful life. The number of periods in the useful life of the asset."
-msgstr ""
+msgstr "Vida útil. El nombre de períodes de la vida útil de l'actiu."
 
 #: scfuncs.src
 msgctxt ""
@@ -9650,7 +9692,7 @@ msgctxt ""
 "10\n"
 "string.text"
 msgid "Factor"
-msgstr ""
+msgstr "Factor"
 
 #: scfuncs.src
 msgctxt ""
@@ -10019,7 +10061,7 @@ msgctxt ""
 "4\n"
 "string.text"
 msgid "value "
-msgstr ""
+msgstr "valor "
 
 #: scfuncs.src
 msgctxt ""
@@ -10046,7 +10088,7 @@ msgctxt ""
 "2\n"
 "string.text"
 msgid "Values"
-msgstr ""
+msgstr "Valors"
 
 #: scfuncs.src
 msgctxt ""
@@ -13007,7 +13049,7 @@ msgctxt ""
 "1\n"
 "string.text"
 msgid "Rounds a number up to the nearest multiple of significance."
-msgstr ""
+msgstr "Arrodoneix un nombre al múltiple significatiu superior més pròxim."
 
 #: scfuncs.src
 msgctxt ""
@@ -13061,7 +13103,7 @@ msgctxt ""
 "2\n"
 "string.text"
 msgid "Number"
-msgstr ""
+msgstr "Nombre"
 
 #: scfuncs.src
 msgctxt ""
@@ -13070,7 +13112,7 @@ msgctxt ""
 "3\n"
 "string.text"
 msgid "The number to be rounded up."
-msgstr ""
+msgstr "Nombre que s'ha d'arrodonir a l'alça."
 
 #: scfuncs.src
 msgctxt ""
@@ -13079,7 +13121,7 @@ msgctxt ""
 "4\n"
 "string.text"
 msgid "Significance"
-msgstr ""
+msgstr "Importància"
 
 #: scfuncs.src
 msgctxt ""
@@ -13088,7 +13130,7 @@ msgctxt ""
 "5\n"
 "string.text"
 msgid "The number to whose multiple the value is rounded."
-msgstr ""
+msgstr "Nombre al múltiple del qual s'arrodoneix el valor."
 
 #: scfuncs.src
 msgctxt ""
@@ -13205,7 +13247,7 @@ msgctxt ""
 "1\n"
 "string.text"
 msgid "Rounds a number up to the nearest multiple of significance."
-msgstr ""
+msgstr "Arrodoneix un nombre al múltiple significatiu superior més pròxim."
 
 #: scfuncs.src
 msgctxt ""
@@ -13214,7 +13256,7 @@ msgctxt ""
 "2\n"
 "string.text"
 msgid "Number"
-msgstr ""
+msgstr "Nombre"
 
 #: scfuncs.src
 msgctxt ""
@@ -13223,7 +13265,7 @@ msgctxt ""
 "3\n"
 "string.text"
 msgid "The number to be rounded up."
-msgstr ""
+msgstr "Nombre que s'ha d'arrodonir a l'alça."
 
 #: scfuncs.src
 msgctxt ""
@@ -13232,7 +13274,7 @@ msgctxt ""
 "4\n"
 "string.text"
 msgid "Significance"
-msgstr ""
+msgstr "Importància"
 
 #: scfuncs.src
 msgctxt ""
@@ -13250,7 +13292,7 @@ msgctxt ""
 "6\n"
 "string.text"
 msgid "Mode"
-msgstr ""
+msgstr "Mode"
 
 #: scfuncs.src
 msgctxt ""
@@ -13316,12 +13358,13 @@ msgid "Mode"
 msgstr "Mode"
 
 #: scfuncs.src
+#, fuzzy
 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."
+msgid "If given and not equal to zero then rounded towards zero with negative number and significance."
 msgstr "Si s'indica, i no és igual a zero, s'arrodoneix cap avall segons la quantitat quan és un valor negatiu significatiu."
 
 #: scfuncs.src
@@ -13330,7 +13373,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 +13415,123 @@ msgstr "Nombre al múltiple del qual s'arrodoneix el valor a la baixa."
 #: 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 "Nombre"
+
+#: 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 "Nombre que s'ha d'arrodonir a la baixa."
+
+#: scfuncs.src
+#, fuzzy
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_FLOOR_MATH\n"
+"4\n"
+"string.text"
+msgid "Significance"
+msgstr "Importància"
+
+#: 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 "Nombre al múltiple del qual s'arrodoneix el valor a la baixa."
+
+#: scfuncs.src
+#, fuzzy
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_FLOOR_MATH\n"
+"6\n"
+"string.text"
+msgid "Mode"
+msgstr "Mode"
+
+#: 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
+#, fuzzy
+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 "Arrodoneix un nombre al múltiple significatiu inferior més pròxim."
+
+#: scfuncs.src
+#, fuzzy
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_FLOOR_PRECISE\n"
+"2\n"
+"string.text"
+msgid "Number"
+msgstr "Nombre"
+
+#: 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 "Nombre que s'ha d'arrodonir a la baixa."
+
+#: scfuncs.src
+#, fuzzy
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_FLOOR_PRECISE\n"
+"4\n"
+"string.text"
+msgid "Significance"
+msgstr "Importància"
+
+#: 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"
@@ -13799,7 +13959,7 @@ msgctxt ""
 "2\n"
 "string.text"
 msgid "data_Y"
-msgstr ""
+msgstr "dades_Y"
 
 #: scfuncs.src
 msgctxt ""
@@ -13808,7 +13968,7 @@ msgctxt ""
 "3\n"
 "string.text"
 msgid "The Y data array."
-msgstr ""
+msgstr "Matriu de dades Y."
 
 #: scfuncs.src
 msgctxt ""
@@ -13817,7 +13977,7 @@ msgctxt ""
 "4\n"
 "string.text"
 msgid "data_X"
-msgstr ""
+msgstr "dades_X"
 
 #: scfuncs.src
 msgctxt ""
@@ -13826,7 +13986,7 @@ msgctxt ""
 "5\n"
 "string.text"
 msgid "The X data array."
-msgstr ""
+msgstr "Matriu de dades X."
 
 #: scfuncs.src
 msgctxt ""
@@ -13835,7 +13995,7 @@ msgctxt ""
 "6\n"
 "string.text"
 msgid "Linear_type"
-msgstr ""
+msgstr "Linear_type"
 
 #: scfuncs.src
 msgctxt ""
@@ -13916,7 +14076,7 @@ msgctxt ""
 "6\n"
 "string.text"
 msgid "Function_type"
-msgstr ""
+msgstr "Function_type"
 
 #: scfuncs.src
 msgctxt ""
@@ -16358,7 +16518,7 @@ msgctxt ""
 "6\n"
 "string.text"
 msgid "alpha"
-msgstr ""
+msgstr "alfa"
 
 #: scfuncs.src
 msgctxt ""
@@ -16367,7 +16527,7 @@ msgctxt ""
 "7\n"
 "string.text"
 msgid "The border probability that is attained or exceeded."
-msgstr ""
+msgstr "La probabilitat llindar que s'aconsegueix o se supera."
 
 #: scfuncs.src
 msgctxt ""
@@ -21100,7 +21260,7 @@ msgctxt ""
 "2\n"
 "string.text"
 msgid "Index"
-msgstr ""
+msgstr "Índex"
 
 #: scfuncs.src
 msgctxt ""
@@ -24233,7 +24393,7 @@ msgctxt ""
 "2\n"
 "string.text"
 msgid "Text"
-msgstr ""
+msgstr "Text"
 
 #: scfuncs.src
 msgctxt ""
@@ -24241,7 +24401,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
@@ -25830,3 +25990,57 @@ msgctxt ""
 "string.text"
 msgid "Collapse Formula Bar"
 msgstr "Redueix la barra de fórmules"
+
+#: condformatdlg.src
+msgctxt ""
+"condformatdlg.src\n"
+"RID_COND_ENTRY.LB_ICONSET_TYPE\n"
+"3 Smilies\n"
+"stringlist.text"
+msgid "3 Smilies"
+msgstr "3 emoticones"
+
+#: 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 emoticones de colors"
+
+#: 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 "Retorna el dia de la setmana per al valor de la data com a enter (1-7)."
+
+#: 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 "Si s'indica, i no és igual a zero, s'arrodoneix cap avall segons la quantitat quan és un valor negatiu significatiu."
+
+#: 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/ca-valencia/sc/uiconfig/scalc/ui.po b/source/ca-valencia/sc/uiconfig/scalc/ui.po
index 1c18c19c824..c64d2ef4624 100644
--- a/source/ca-valencia/sc/uiconfig/scalc/ui.po
+++ b/source/ca-valencia/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-01-10 22:04+0000\n"
-"Last-Translator: Joan <joan@montane.cat>\n"
+"POT-Creation-Date: 2015-06-24 17:05+0200\n"
+"PO-Revision-Date: 2015-05-12 03:25+0000\n"
+"Last-Translator: system user <>\n"
 "Language-Team: none\n"
 "Language: ca-valencia\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: 1420927483.000000\n"
+"X-POOTLE-MTIME: 1431401125.000000\n"
 
 #: advancedfilterdialog.ui
 msgctxt ""
@@ -2020,7 +2020,7 @@ msgctxt ""
 "label\n"
 "string.text"
 msgid "_Browse..."
-msgstr ""
+msgstr "E_xamina..."
 
 #: datastreams.ui
 msgctxt ""
@@ -2769,7 +2769,7 @@ msgctxt ""
 "label\n"
 "string.text"
 msgid "_Browse..."
-msgstr ""
+msgstr "E_xamina..."
 
 #: externaldata.ui
 msgctxt ""
@@ -3096,31 +3096,34 @@ msgid "Detailed Calculation Settings"
 msgstr "Paràmetres de càlcul detallats"
 
 #: formulacalculationoptions.ui
+#, fuzzy
 msgctxt ""
 "formulacalculationoptions.ui\n"
 "labelConvT2N\n"
 "label\n"
 "string.text"
 msgid "Conversion from text to number:"
-msgstr ""
+msgstr "Conversió de text a número"
 
 #: formulacalculationoptions.ui
+#, fuzzy
 msgctxt ""
 "formulacalculationoptions.ui\n"
 "checkEmptyAsZero\n"
 "label\n"
 "string.text"
 msgid "Treat _empty string as zero"
-msgstr ""
+msgstr "Tracta la cadena buida com a zero"
 
 #: formulacalculationoptions.ui
+#, fuzzy
 msgctxt ""
 "formulacalculationoptions.ui\n"
 "labelSyntaxRef\n"
 "label\n"
 "string.text"
 msgid "Reference syntax for string reference:"
-msgstr ""
+msgstr "Sintaxi de referència per a la referència de cadenes"
 
 #: formulacalculationoptions.ui
 msgctxt ""
@@ -3129,7 +3132,7 @@ msgctxt ""
 "0\n"
 "stringlist.text"
 msgid "Use formula syntax"
-msgstr ""
+msgstr "Utilitza la sintaxi de la fórmula"
 
 #: formulacalculationoptions.ui
 msgctxt ""
@@ -3147,7 +3150,7 @@ msgctxt ""
 "1\n"
 "stringlist.text"
 msgid "Treat as zero"
-msgstr ""
+msgstr "Tracta com a zero"
 
 #: formulacalculationoptions.ui
 msgctxt ""
@@ -7714,8 +7717,8 @@ msgctxt ""
 "leftindentlabel\n"
 "label\n"
 "string.text"
-msgid "Left _indent:"
-msgstr "Sagnat _esquerre:"
+msgid "_Indent:"
+msgstr ""
 
 #: sidebaralignment.ui
 msgctxt ""
@@ -7801,33 +7804,6 @@ msgstr "_Orientació del text:"
 #: sidebaralignment.ui
 msgctxt ""
 "sidebaralignment.ui\n"
-"verticallystacked\n"
-"label\n"
-"string.text"
-msgid "Vertically stacked"
-msgstr "Apilat verticalment"
-
-#: sidebaralignment.ui
-msgctxt ""
-"sidebaralignment.ui\n"
-"verticallystacked\n"
-"tooltip_markup\n"
-"string.text"
-msgid "Aligns text vertically."
-msgstr "Alinea el text verticalment."
-
-#: sidebaralignment.ui
-msgctxt ""
-"sidebaralignment.ui\n"
-"verticallystacked\n"
-"tooltip_text\n"
-"string.text"
-msgid "Aligns text vertically."
-msgstr "Alinea el text verticalment."
-
-#: sidebaralignment.ui
-msgctxt ""
-"sidebaralignment.ui\n"
 "orientationdegrees\n"
 "tooltip_markup\n"
 "string.text"
@@ -7844,13 +7820,14 @@ msgid "Select the angle for rotation."
 msgstr "Seleccioneu l'angle de la rotació."
 
 #: sidebarcellappearance.ui
+#, fuzzy
 msgctxt ""
 "sidebarcellappearance.ui\n"
 "cellbackgroundlabel\n"
 "label\n"
 "string.text"
-msgid "_Cell background:"
-msgstr "Fons de la _cel·la:"
+msgid "_Background:"
+msgstr "Fons"
 
 #: sidebarcellappearance.ui
 msgctxt ""
@@ -7873,15 +7850,6 @@ msgstr "Seleccioneu el color de fons de les cel·les seleccionades."
 #: sidebarcellappearance.ui
 msgctxt ""
 "sidebarcellappearance.ui\n"
-"cellborderlabel\n"
-"label\n"
-"string.text"
-msgid "Cell _border:"
-msgstr "_Vora de la cel·la:"
-
-#: sidebarcellappearance.ui
-msgctxt ""
-"sidebarcellappearance.ui\n"
 "bordertype\n"
 "tooltip_markup\n"
 "string.text"
@@ -7951,33 +7919,6 @@ msgctxt ""
 msgid "Select the line color of the borders."
 msgstr "Permet seleccionar el color de línia de les vores."
 
-#: sidebarcellappearance.ui
-msgctxt ""
-"sidebarcellappearance.ui\n"
-"cellgridlines\n"
-"label\n"
-"string.text"
-msgid "Show cell _grid lines"
-msgstr "Mostra les línies de la _graella"
-
-#: 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"
@@ -8141,12 +8082,13 @@ msgid "Enter the maximum number of zeroes to display before the decimal point."
 msgstr "Introduïu el nombre màxim de zeros que cal mostrar abans del separador decimal."
 
 #: sidebarnumberformat.ui
+#, fuzzy
 msgctxt ""
 "sidebarnumberformat.ui\n"
 "negativenumbersred\n"
 "label\n"
 "string.text"
-msgid "_Negative numbers red"
+msgid "_Negative numbers in red"
 msgstr "_Negatiu en roig"
 
 #: sidebarnumberformat.ui
@@ -9632,7 +9574,7 @@ msgctxt ""
 "5\n"
 "stringlist.text"
 msgid "Product"
-msgstr ""
+msgstr "Producte"
 
 #: subtotalgrppage.ui
 msgctxt ""
@@ -9641,7 +9583,7 @@ msgctxt ""
 "6\n"
 "stringlist.text"
 msgid "Count (numbers only)"
-msgstr ""
+msgstr "Compta (només els nombres)"
 
 #: subtotalgrppage.ui
 msgctxt ""
@@ -9650,7 +9592,7 @@ msgctxt ""
 "7\n"
 "stringlist.text"
 msgid "StDev (Sample)"
-msgstr ""
+msgstr "DesvEst (mostra)"
 
 #: subtotalgrppage.ui
 msgctxt ""
@@ -9659,7 +9601,7 @@ msgctxt ""
 "8\n"
 "stringlist.text"
 msgid "StDevP (Population)"
-msgstr ""
+msgstr "DesvEstP (població)"
 
 #: subtotalgrppage.ui
 msgctxt ""
@@ -9668,7 +9610,7 @@ msgctxt ""
 "9\n"
 "stringlist.text"
 msgid "Var (Sample)"
-msgstr ""
+msgstr "Var (mostra)"
 
 #: subtotalgrppage.ui
 msgctxt ""
@@ -9677,7 +9619,7 @@ msgctxt ""
 "10\n"
 "stringlist.text"
 msgid "VarP (Population)"
-msgstr ""
+msgstr "VarP (població)"
 
 #: subtotaloptionspage.ui
 msgctxt ""