| 04060107.xhp (82a98929) | 04060107.xhp (f773ab65) |
|---|---|
| 1<?xml version="1.0" encoding="UTF-8"?> 2 3<!--*********************************************************** 4 * 5 * Licensed to the Apache Software Foundation (ASF) under one 6 * or more contributor license agreements. See the NOTICE file 7 * distributed with this work for additional information 8 * regarding copyright ownership. The ASF licenses this file --- 132 unchanged lines hidden (view full) --- 141<paragraph role="heading" id="hd_id3151271" xml-lang="en-US" level="3" l10n="U" oldref="313">Creating Array Formulas</paragraph> 142<section id="somatrixformel"> 143<paragraph role="paragraph" id="par_id3149102" xml-lang="en-US" l10n="U" oldref="314">If you create an array formula using the <emph>Function Wizard</emph>, you must mark the <emph>Array</emph> check box each time so that the results are returned in an array. Otherwise, only the value in the upper-left cell of the array being calculated is returned.</paragraph> 144<paragraph role="paragraph" id="par_id3153392" xml-lang="en-US" l10n="U" oldref="4">If you enter the array formula directly into the cell, you must use the key combination Shift+<switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Enter instead of the Enter key. Only then does the formula become an array formula.</paragraph> 145<paragraph role="note" id="par_id3151120" xml-lang="en-US" l10n="U" oldref="315">Array formulas appear in braces in $[officename] Calc. You cannot create array formulas by manually entering the braces.</paragraph> 146</section> 147<paragraph role="paragraph" id="par_id3154342" xml-lang="en-US" l10n="U" oldref="5">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> 148<paragraph role="heading" id="hd_id8834803" xml-lang="en-US" level="3" l10n="NEW">Using Inline Array Constants in Formulas</paragraph> | 1<?xml version="1.0" encoding="UTF-8"?> 2 3<!--*********************************************************** 4 * 5 * Licensed to the Apache Software Foundation (ASF) under one 6 * or more contributor license agreements. See the NOTICE file 7 * distributed with this work for additional information 8 * regarding copyright ownership. The ASF licenses this file --- 132 unchanged lines hidden (view full) --- 141<paragraph role="heading" id="hd_id3151271" xml-lang="en-US" level="3" l10n="U" oldref="313">Creating Array Formulas</paragraph> 142<section id="somatrixformel"> 143<paragraph role="paragraph" id="par_id3149102" xml-lang="en-US" l10n="U" oldref="314">If you create an array formula using the <emph>Function Wizard</emph>, you must mark the <emph>Array</emph> check box each time so that the results are returned in an array. Otherwise, only the value in the upper-left cell of the array being calculated is returned.</paragraph> 144<paragraph role="paragraph" id="par_id3153392" xml-lang="en-US" l10n="U" oldref="4">If you enter the array formula directly into the cell, you must use the key combination Shift+<switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Enter instead of the Enter key. Only then does the formula become an array formula.</paragraph> 145<paragraph role="note" id="par_id3151120" xml-lang="en-US" l10n="U" oldref="315">Array formulas appear in braces in $[officename] Calc. You cannot create array formulas by manually entering the braces.</paragraph> 146</section> 147<paragraph role="paragraph" id="par_id3154342" xml-lang="en-US" l10n="U" oldref="5">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> 148<paragraph role="heading" id="hd_id8834803" xml-lang="en-US" level="3" l10n="NEW">Using Inline Array Constants in Formulas</paragraph> |
| 149<paragraph role="paragraph" id="par_id985747" xml-lang="en-US" l10n="NEW">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> 150<paragraph role="paragraph" id="par_id936613" xml-lang="en-US" l10n="NEW">The column separator (separating elements in one row) is the ';' semicolon. The row separator is a '|' pipe symbol. The separators are not language and locale dependent. </paragraph> | 149<paragraph role="paragraph" id="par_id985747" xml-lang="en-US" l10n="NEW">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> 150<paragraph role="paragraph" id="par_id936613" xml-lang="en-US" l10n="NEW">The column separator (separating elements in one row) is the ';' semicolon. The row separator is a '|' pipe symbol. The separators are not language and locale dependent.</paragraph> |
| 151<paragraph role="paragraph" id="par_id1877498" xml-lang="en-US" l10n="NEW">Arrays can not be nested.</paragraph> 152<paragraph role="paragraph" id="par_id4262520" xml-lang="en-US" l10n="NEW"> 153<emph>Examples:</emph> 154</paragraph> 155<paragraph role="code" id="par_id9387493" xml-lang="en-US" l10n="NEW">={1;2;3}</paragraph> 156<paragraph role="paragraph" id="par_id8207037" xml-lang="en-US" l10n="NEW">An array with one row consisting of the three numbers 1, 2, and 3.</paragraph> 157<paragraph role="paragraph" id="par_id6757103" xml-lang="en-US" l10n="NEW">To enter this array constant, you select three cells in a row, then you type the formula <item type="input">={1;2;3}</item> using the curly braces and the semicolons, then press <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Enter.</paragraph> 158<paragraph role="code" id="par_id8868068" xml-lang="en-US" l10n="NEW">={1;2;3|4;5;6}</paragraph> --- 1125 unchanged lines hidden --- | 151<paragraph role="paragraph" id="par_id1877498" xml-lang="en-US" l10n="NEW">Arrays can not be nested.</paragraph> 152<paragraph role="paragraph" id="par_id4262520" xml-lang="en-US" l10n="NEW"> 153<emph>Examples:</emph> 154</paragraph> 155<paragraph role="code" id="par_id9387493" xml-lang="en-US" l10n="NEW">={1;2;3}</paragraph> 156<paragraph role="paragraph" id="par_id8207037" xml-lang="en-US" l10n="NEW">An array with one row consisting of the three numbers 1, 2, and 3.</paragraph> 157<paragraph role="paragraph" id="par_id6757103" xml-lang="en-US" l10n="NEW">To enter this array constant, you select three cells in a row, then you type the formula <item type="input">={1;2;3}</item> using the curly braces and the semicolons, then press <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Enter.</paragraph> 158<paragraph role="code" id="par_id8868068" xml-lang="en-US" l10n="NEW">={1;2;3|4;5;6}</paragraph> --- 1125 unchanged lines hidden --- |