Bug 144957 - Deletion of array formula not explained
Summary: Deletion of array formula not explained
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
(earliest affected)
3.3.0 release
Hardware: All All
: medium normal
Assignee: Olivier Hallot
Whiteboard: target:7.3.0
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:


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
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":


tdf#144957 Help on deleting array formulas