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

[Tomas Mecir]

Git commit 5865a20b4a86c3522b167dbfb6497a4768244339 by Tomas Mecir.
Committed on 10/11/2013 at 18:10.
Pushed by mecir into branch 'master'.

document array formulas

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

http://commits.kde.org/calligra/5865a20b4a86c3522b167dbfb6497a4768244339

diff --git a/doc/sheets/advanced.docbook b/doc/sheets/advanced.docbook
index 0b3f72c..12340a8 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>