Bug 89207 - Cannot change only part of an array
Summary: Cannot change only part of an array
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Formula
  Show dependency treegraph
 
Reported: 2015-02-07 16:31 UTC by andis.lazdins
Modified: 2020-04-26 15:51 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:
Regression By:


Attachments
Problems expanding array formulas (19.44 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-02-07 16:31 UTC, andis.lazdins
Details

Note You need to log in before you can comment on or make changes to this bug.
Description andis.lazdins 2015-02-07 16:31:35 UTC
Created attachment 113208 [details]
Problems expanding array formulas

I'm not sure if it is bug or new feature, but was introduced already in previous versions. I can only expand array formulas through deleting and rewriting the formula.

Steps to repeat:
1. open attached file.
2. select array formula in B7:AF7 by "Ctrl" and "/"
3. change "AF2" in formula to "AP2" (=B2:AF2*B4 to =B2:AP2*B4)
4. enter formula by "Ctrl", "Shift" and "Enter"

The first issue - formula didn't expanded to area between AG7 and AP7. Second issue:
1. try now select the array formula by "Ctrl" and "/"
2. try select formula in formula bar
3. Error message "Cannot change only part of an array" appears

The only way to get rid of the formula is to press "Undo" until the initial stage is reached. The only way to change array formula is to delete it and to write again with new parameters. Normally (and in previous versions) there should not be any problems to expand this formula by replacing parameters, in ideal case using simple find and replace function.

Ubuntu 14.04, 32 bit, Libreoffice 4.4.0 and 4.3.6
Comment 1 Buovjaga 2015-02-08 13:25:25 UTC
Apparently this feature has never existed, so changing this to enhancement.

Tested on:
Win 7 Pro 64-bit, LibO Version: 4.4.0.3
Build ID: de093506bcdc5fafd9023ee680b8c60e3e0645d7
Locale: fi_FI

Ubuntu 14.10 64-bit
LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4
Comment 2 andis.lazdins 2015-02-08 14:39:02 UTC
Hi!

Expanding of array formulas in the proposed way will be really new feature, but the reported bug is a message saying that array cannot be selected, if it is edited without complete rewrite of the formula. Some time ago it was possible to select and delete manually edited array formulas, now it is possible only through undo operation.

There is a way to expand array formulas using ranges, but it is not very convenient way, if there are thousands of array formulas.
Comment 3 Buovjaga 2015-02-09 06:03:39 UTC
(In reply to andis.lazdins from comment #2)
> Expanding of array formulas in the proposed way will be really new feature,
> but the reported bug is a message saying that array cannot be selected, if
> it is edited without complete rewrite of the formula. Some time ago it was
> possible to select and delete manually edited array formulas, now it is
> possible only through undo operation.

You should create a new report for your second issue. We keep it one issue per report. Thanks.
Comment 4 russell 2019-01-25 07:30:43 UTC
I just had this problem (expand an array formula) and found this enhancement request.

I made a selection over an existing array plus new rows, F2, ctrl-shift-enter, and the array was not expanded to the new rows. They remained empty. Although the previous array was updated to reflect the new range; Actually when the new rows were inserted the array formula range changed.

Before: {=C1:C12*D1:D12}   Rows: 1-12

After: {=C1:C14*D1:D14}    Rows: 1-12, 13-14 Empty

Only way to expand an array formula seems to be to delete it and reenter it.

LO 6.1.4.2
Comment 5 russell 2019-01-25 09:26:16 UTC
From the doc: Array Functions - https://help.libreoffice.org/6.0/he/text/scalc/01/04060107.html

======================
Editing Array Formulas

    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 Ctrl+/, where / is the Division key on the numeric keypad.

    Either press F2 or position the cursor in the input line. Both of these actions let you edit the formula.

    After you have made changes, press Ctrl+Shift+Enter.

Adjusting an Array Range

    If you want to edit the output array, do the following:

    Select the cell range or array containing the array formula.

    Below the selection, to the right, you will see a small icon with which you can zoom in or out on the range using your mouse.

Note Icon 	

When you adjust the array range, the array formula will not automatically be adjusted. You are only changing the range in which the result will appear.
======================