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>
