diff options
Diffstat (limited to 'source/text/scalc/01/04060107.xhp')
| -rw-r--r-- | source/text/scalc/01/04060107.xhp | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/source/text/scalc/01/04060107.xhp b/source/text/scalc/01/04060107.xhp index 92ec7c4adc..b9cd4e3e11 100644 --- a/source/text/scalc/01/04060107.xhp +++ b/source/text/scalc/01/04060107.xhp @@ -134,11 +134,12 @@ </caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Enter instead of the Enter key. Only then does the formula become an array formula.</paragraph> <paragraph id="par_id3151120" role="note" xml-lang="en-US">Array formulas appear in braces in $[officename] Calc. You cannot create array formulas by manually entering the braces.</paragraph> </section> -<paragraph id="par_id3154342" role="paragraph" xml-lang="en-US">The cells in a results array are automatically protected against changes. However, you can edit or copy the array formula by selecting the entire array cell range.</paragraph> +<paragraph id="par_id3154342" role="warning" xml-lang="en-US">The cells in a results array are automatically protected against changes. However, you can edit or copy the array formula by selecting the entire array cell range.</paragraph> <paragraph id="hd_id8834803" role="heading" level="3" xml-lang="en-US">Using Inline Array Constants in Formulas</paragraph> <paragraph id="par_id985747" role="paragraph" xml-lang="en-US">Calc supports inline matrix/array constants in formulas. An inline array is surrounded by curly braces '{' and '}'. Elements can be each a number (including negatives), a logical constant (TRUE, FALSE), or a literal string. Non-constant expressions are not allowed. Arrays can be entered with one or more rows, and one or more columns. All rows must consist of the same number of elements, all columns must consist of the same number of elements.</paragraph> <paragraph id="par_id936613" role="paragraph" xml-lang="en-US">The column separator (separating elements in one row) and the row separator are language and locale dependent. But in this help content, the ';' semicolon and '|' pipe symbol are used to indicate the column and row separators, respectively. For example, in the English locale, the ',' comma is used as the column separator, while the ';' semicolon is used as the row separator.</paragraph> +<paragraph id="par_id936615" role="tip" xml-lang="en-US">The row and column separator can be seen and altered in <item type="menuitem">Tools - Options - Calc - Formula - Separators</item>.</paragraph> <paragraph id="par_id1877498" role="paragraph" xml-lang="en-US">Arrays can not be nested.</paragraph> <paragraph id="par_id4262520" role="paragraph" xml-lang="en-US"><emph>Examples:</emph></paragraph> <paragraph id="par_id9387493" role="code" xml-lang="en-US">={1;2;3}</paragraph> |