Translation status

1,475 Strings 100% Translate
23,418 Words 100%

Other components

Component Translated Untranslated Untranslated words Checks Suggestions Comments
text/shared/01 This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 93% 366 4,430
text/shared/autokorr This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0
text/shared This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0
text/shared/explorer/database This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0
text/shared/02 This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0
text/shared/guide This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0
text/swriter/04 This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0
text/schart This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0
text/simpress This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0
text/scalc This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0

Translation Information

Project website www.libreoffice.org
Mailing list for translators l10n@global.libreoffice.org
Translation process
  • Translations can be made directly.
  • Translation suggestions can be made.
  • Any authenticated user can contribute.
  • The translation uses bilingual files.
Translation license Mozilla Public License 2.0
Filemask */helpcontent2/source/text/scalc/guide.po
Translation file en-GB/helpcontent2/source/text/scalc/guide.po
Committed changes a year ago
Open a Calc document and enter numbers for the function parameters <literal>a</literal>, <literal>b</literal> and <literal>c</literal> in cells A1, B1, and C1.
Open a Calc document and enter numbers for the function parameters <literal>a</literal>, <literal>b</literal> and <literal>c</literal> in cells A1, B1, and C1.
a year ago
Once you have defined the function <literal>VOL(a; b; c)</literal> in the Basic-IDE, you can apply it the same way as the built-in functions of $[officename] Calc.
Once you have defined the function <literal>VOL(a; b; c)</literal> in the Basic-IDE, you can apply it the same way as the built-in functions of $[officename] Calc.
a year ago
Choose <switchinline select="sys"><caseinline select="MAC"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Basic</menuitem>.
Choose <switchinline select="sys"><caseinline select="MAC"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Basic</menuitem>.
a year ago
Enter the function code. In this example, we define a <literal>VOL(a; b; c)</literal> function that calculates the volume of a rectangular solid with side lengths <literal>a</literal>, <literal>b</literal> and <literal>c</literal>:
Enter the function code. In this example, we define a <literal>VOL(a; b; c)</literal> function that calculates the volume of a rectangular solid with side lengths <literal>a</literal>, <literal>b</literal> and <literal>c</literal>:
a year ago
Choose <switchinline select="sys"><caseinline select="MAC"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Basic</menuitem>.
Choose <switchinline select="sys"><caseinline select="MAC"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Basic</menuitem>.
a year ago
The text to number conversion can be customized in the <embedvar href="text/shared/optionen/detailedcalculation.xhp#detailed_heading" markup="ignore"/> option.
The text to number conversion can be customized in the <embedvar href="text/shared/optionen/detailedcalculation.xhp#detailed_heading" markup="ignore"/> option.
a year ago
Changing the default text to number conversion settings
Changing the default text to number conversion settings
a year ago
<literal>=SUM("1E2";1)</literal> returns #VALUE! because SUM() and some others that iterate over number sequences explicitly check the argument type.
<literal>=SUM("1E2";1)</literal> returns #VALUE! because SUM() and some others that iterate over number sequences explicitly check the argument type.
a year ago
The formula <literal>=SUM(A1:A2)</literal>, returns 101 instead of 201 because the conversion does not occur in a range, only for single scalar values. Here, '1e2 is treated as string which has value 0 for the SUM function.
The formula <literal>=SUM(A1:A2)</literal>, returns 101 instead of 201 because the conversion does not occur in a range, only for single scalar values. Here, '1e2 is treated as string which has value 0 for the SUM function.
a year ago
Browse all translation changes

Statistics

Percent Strings Words Chars
Total 1,475 23,418 187,297
Translated 100% 1,475 23,418 187,297
Needs editing 0% 0 0 0
Failing checks 0% 0 0 0

Last activity

Last change Feb. 10, 2020, 5:29 p.m.
Last author Stuart Swales

Daily activity

Daily activity

Weekly activity

Weekly activity