Translation status
1,475 | Strings | 100% | Translate |
---|---|---|---|
23,418 | Words | 100% |
Other components
Component | Translated | Untranslated | Untranslated words | Checks | Suggestions | Comments | |
---|---|---|---|---|---|---|---|
text/shared/01
|
93% | 366 | 4,430 | ||||
|
|||||||
text/shared/autokorr
|
|||||||
|
|||||||
text/shared
|
|||||||
|
|||||||
text/shared/explorer/database
|
|||||||
|
|||||||
text/shared/02
|
|||||||
|
|||||||
text/shared/guide
|
|||||||
|
|||||||
text/swriter/04
|
|||||||
|
|||||||
text/schart
|
|||||||
|
|||||||
text/simpress
|
|||||||
|
|||||||
text/scalc
|
|||||||
|
Translation Information
Project website | www.libreoffice.org |
---|---|
Mailing list for translators | l10n@global.libreoffice.org |
Translation process |
|
Translation license | Mozilla Public License 2.0 |
Filemask | */helpcontent2/source/text/scalc/guide.po |
Translation file |
en-GB/helpcontent2/source/text/scalc/guide.po
|
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.
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.
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>.
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>:
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>.
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.
<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.
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.
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 |