[kde-doc-english] [calligra/calligra/2.7] doc/sheets: document array formulas

[Boudewijn Rempt]

Git commit c369086e02ea10d099c3186dbd50a749e553135c by Boudewijn Rempt, on behalf of Tomas Mecir.
Committed on 10/11/2013 at 18:10.
Pushed by rempt into branch 'calligra/2.7'.

document array formulas

M  +10   -0    doc/sheets/advanced.docbook

http://commits.kde.org/calligra/c369086e02ea10d099c3186dbd50a749e553135c

diff --git a/doc/sheets/advanced.docbook b/doc/sheets/advanced.docbook
index fad2786..666b0ea 100644
--- a/doc/sheets/advanced.docbook
+++ b/doc/sheets/advanced.docbook
@@ -231,6 +231,16 @@ value. If it is a formula then &sheets; will adjust the cell references as
 for a normal <guimenuitem>Paste</guimenuitem> operation.</para>
 </sect1>
 
+<sect1 id="arrayformulas">
+<title>Array Formulas</title>
+<para>&sheets; allows you to use formulas whose result is a matrix or a range
+of values. Normally, only the first value is displayed in a cell. If you would
+like to display the entire matrix, simply use Ctrl+Alt+Enter when editing
+a formula, and it will be converted into an array formula, occupying neighboring
+cells as needed.</para>
+<para>Cells that are a part of an array formula are locked for editing.</para>
+</sect1>
+
 <sect1 id="goalseek">
 <title>Goal Seeking</title>
 <para>&sheets; can be used to solve algebraic expressions such as <emphasis>