tdf#144957 Help on deleting array formulas

Special thanks to Alex Sims for excellent bug report.

Change-Id: I15ab6b6b8c86633a779b3f4c55f10665bdb63c62
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/123137
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>

1 files changed, 14 insertions, 2 deletions

diff --git a/source/text/scalc/01/04060107.xhp b/source/text/scalc/01/04060107.xhp
index 3406416967..4a7b7592f7 100644
--- a/source/text/scalc/01/04060107.xhp
+++ b/source/text/scalc/01/04060107.xhp
@@ -34,6 +34,7 @@
 <bookmark_value>functions; array functions</bookmark_value>
 <bookmark_value>editing; array formulas</bookmark_value>
 <bookmark_value>copying; array formulas</bookmark_value>
+<bookmark_value>deleting; array formulas</bookmark_value>
 <bookmark_value>adjusting array ranges</bookmark_value>
 <bookmark_value>calculating; conditional calculations</bookmark_value>
 <bookmark_value>matrices; calculations</bookmark_value>
@@ -121,7 +122,7 @@
   <paragraph id="par_id3153392" role="paragraph" xml-lang="en-US">If you enter the array formula directly into the cell, you must use the key combination <emph>Shift + </emph><switchinline select="sys"><caseinline select="MAC"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + Enter</emph> instead of the <emph>Enter</emph> key. Only then does the formula become an array formula.</paragraph>
   <note id="par_id3151120">Array formulas appear in braces in $[officename] Calc. You cannot create array formulas by manually entering the braces.</note>
 </section>
-  <warning id="par_id3154342">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.</warning>
+  <warning id="par_id3154342">The cells in a results array are automatically protected against changes. However, you can edit, delete or copy the array formula by selecting the entire array cell range.</warning>
 <h3 id="hd_id8834803">Using Inline Array Constants in Formulas</h3>
   <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>
@@ -140,7 +141,7 @@
 <h3 id="hd_id3148660">Editing Array Formulas</h3>
 <list type="ordered">
   <listitem>
-    <paragraph id="par_id3149241" role="listitem" xml-lang="en-US">Select the cell range or array containing the array formula. To select the whole array, position the cell cursor inside the array range, then press <switchinline select="sys"><caseinline select="MAC"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + /</emph>, where <emph>/</emph> is the <emph>Division</emph> key on the numeric keypad.</paragraph>
+    <paragraph id="par_id3149241" role="listitem" xml-lang="en-US">Select the cell range or array containing the array formula. To select the whole array, position the cell cursor inside the array range, then press <switchinline select="sys"><caseinline select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline> + <keycode>/</keycode>, where <keycode>/</keycode> is the division key on the numeric keypad.</paragraph>
   </listitem>
   <listitem>
     <paragraph id="par_id3143274" role="listitem" xml-lang="en-US">Either press <emph>F2</emph> or position the cursor in the input line. Both of these actions let you edit the formula.</paragraph>
@@ -150,6 +151,17 @@
   </listitem>
 </list>
   <tip id="par_id3150628">You can format the separate parts of an array. For example, you can change the font color. Select a cell range and then change the attribute you want.</tip>
+
+<h3 id="hd_id541633516074226">Deleting Array Formulae</h3>
+<list type="ordered">
+    <listitem>
+        <paragraph id="par_id681633516103267"  role="listitem">Select the cell range or array containing the array formula. To select the whole array, position the cell cursor inside the array range, then press <switchinline select="sys"><caseinline select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline> + <keycode>/</keycode>, where <keycode>/</keycode> is the division key on the numeric keypad.</paragraph>
+    </listitem>
+    <listitem>
+        <paragraph id="par_id61633516164519"  role="listitem">Press <keycode>Delete</keycode> to delete the array contents, including the array formula, or press <keycode>Backspace</keycode> and this brings up the <link href="text/scalc/01/02150000.xhp" name="delete contents">Delete Contents</link> dialog box. Select <emph>Formula</emph> or <emph>Delete All</emph> and click <emph>OK</emph>.</paragraph>
+    </listitem>
+</list>
+
 <h3 id="hd_id3145608">Copying Array Formulas</h3>
 <list type="ordered">
   <listitem>