2. LibreOffice Help – 6.4
  3. text/scalc/guide
  4. English (United Kingdom)

Translation status

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

Strings status

1,475
All strings — 23,418 words
1,475
Translated strings — 23,418 words

Other components

Component Translated Untranslated Untranslated words Checks Suggestions Comments
text/shared/explorer/database This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/shared/02 This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/shared/autokorr This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/sbasic/shared/02 This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/sbasic/guide This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/shared/guide This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/schart/01 This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/swriter/04 This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/sdraw This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/swriter This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/sbasic/shared/03 This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/scalc/04 This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/sdraw/04 This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/scalc/05 This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/schart/02 This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/schart/00 This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/schart/04 This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/smath/02 This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/smath/06 This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/smath/00 This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/smath/01 This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/smath/guide This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/smath/04 This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/sbasic/shared/01 This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/sbasic/python This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/sbasic/shared This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/sdraw/00 This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/sdraw/01 This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/sdraw/guide This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/simpress/01 This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/simpress/guide This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/simpress/04 This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/shared/menu This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/shared/optionen This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/shared/00 This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/shared/help This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/shared/07 This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/shared/05 This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/swriter/menu This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/swriter/00 This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/swriter/librelogo This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/swriter/01 This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 1 Translate
text/swriter/guide This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/schart This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/simpress This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/scalc This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/scalc/06 This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/scalc/00 This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/scalc/01 This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/simpress/02 This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/simpress/00 This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/shared/autopi This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/shared/06 This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/swriter/02 This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/smath This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/shared This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/shared/01 This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 92% 408 5,064 Translate
text/shared/04 This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
text/scalc/02 This component is linked to the LibreOffice Help – 6.4/auxiliary repository. MPL-2.0 Translate
auxiliary MPL-2.0 Translate

Translation Information

Project website https://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
cloph

Committed changes

LibreOffice Help – 6.4 / text/scalc/guide — English (United Kingdom)

Committed changes 7 months ago
sswales

New translation

LibreOffice Help – 6.4 / text/scalc/guide — English (United Kingdom)

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.
7 months ago
sswales

New translation

LibreOffice Help – 6.4 / text/scalc/guide — English (United Kingdom)

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.
7 months ago
sswales

New translation

LibreOffice Help – 6.4 / text/scalc/guide — English (United Kingdom)

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>.
7 months ago
sswales

New translation

LibreOffice Help – 6.4 / text/scalc/guide — English (United Kingdom)

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>:
7 months ago
sswales

New translation

LibreOffice Help – 6.4 / text/scalc/guide — English (United Kingdom)

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>.
7 months ago
sswales

New translation

LibreOffice Help – 6.4 / text/scalc/guide — English (United Kingdom)

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.
7 months ago
sswales

New translation

LibreOffice Help – 6.4 / text/scalc/guide — English (United Kingdom)

Changing the default text to number conversion settings
Changing the default text to number conversion settings
7 months ago
sswales

New translation

LibreOffice Help – 6.4 / text/scalc/guide — English (United Kingdom)

<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.
7 months ago
sswales

New translation

LibreOffice Help – 6.4 / text/scalc/guide — English (United Kingdom)

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.
7 months ago
Browse all translation changes

Customize download

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 check 0% 0 0 0

Last activity

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

Activity in last 30 days

Activity in last year