Bug 144957 - Deletion of array formula not explained
Summary: Deletion of array formula not explained
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
Version:
(earliest affected)
3.3.0 release
Hardware: All All
: medium normal
Assignee: Olivier Hallot
URL:
Whiteboard: target:7.3.0
Keywords:
Depends on:
Blocks: HelpGaps-NewFeatures
  Show dependency treegraph
 
Reported: 2021-10-06 03:14 UTC by Alex Sims
Modified: 2021-10-06 11:15 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Alex Sims 2021-10-06 03:14:49 UTC
Description:
If I want to delete an array formula, e.g. change back to normal or delete entirely, I look in the help. I can't find anything. The section about array functions explains how to create an array formula, modify an array formula, but not how to delete it.

Steps to Reproduce:
1. Open Libreoffice Calc
2. Create an array formula using instructions in Array Functions in Help
3. Try to delete it using instructions in Help

Actual Results:
There is nothing in help. 

Expected Results:
A readable explanation is provided in the Array Functions in Help


Reproducible: Always


User Profile Reset: No



Additional Info:
I have to look externally in forums, search engines and so on. It seems as though you select the Array formula then press Delete and select "Formula" or "Delete all".
Comment 1 Alex Sims 2021-10-06 03:20:12 UTC
An explanation might be:

Deleting Array Formulae
-----------------------

1. 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 Command + /, where / is the Division key on the numeric keypad.
2. Press Delete and this brings up the "Delete Content" dialog box
3. Select "Formula" or "Delete All"
4. Press OK
Comment 3 Commit Notification 2021-10-06 11:13:31 UTC
Olivier Hallot committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/help/commit/8589981a5f5dbe83cff6bdc86db01e54779a4255

tdf#144957 Help on deleting array formulas