Translation status
| 1,475 | Strings | 100% | Translate |
|---|---|---|---|
| 23,418 | Words | 100% |
Other components
| Component | Translated | Untranslated | Untranslated words | Checks | Suggestions | Comments | |
|---|---|---|---|---|---|---|---|
text/shared/01
MPL-2.0
|
93% | 366 | 4,430 | ||||
|
|
|||||||
|
text/shared/autokorr
MPL-2.0
|
|||||||
|
|
|||||||
|
text/shared
MPL-2.0
|
|||||||
|
|
|||||||
|
text/shared/explorer/database
MPL-2.0
|
|||||||
|
|
|||||||
|
text/shared/02
MPL-2.0
|
|||||||
|
|
|||||||
|
text/shared/guide
MPL-2.0
|
|||||||
|
|
|||||||
|
text/swriter/04
MPL-2.0
|
|||||||
|
|
|||||||
|
text/schart
MPL-2.0
|
|||||||
|
|
|||||||
|
text/simpress
MPL-2.0
|
|||||||
|
|
|||||||
|
text/scalc
MPL-2.0
|
|||||||
|
|
|||||||
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
|
cloph
sswales
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 | |||