Bug 55159 - Array Formula unable to edit - receive message YOU cannot change only part of an array
Summary: Array Formula unable to edit - receive message YOU cannot change only part of...
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.1.2 release
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-09-20 17:35 UTC by Rod
Modified: 2012-09-21 07:17 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Rod 2012-09-20 17:35:33 UTC 
See the error in both 3.6.1.2 and 3.6.2.1
Trying to edit an array formula, either by F2 or by clicking on the fx box.
Receive message:
You cannot change only part of an array
Comment 1 GerardF 2012-09-21 07:17:29 UTC 
To edit an array formula you need select the entire range.
It works this way will all spreadsheets apps since decades.

You can use Ctrl+/ combinaison key for highlight the array range.