Ask Your Question
0

Calc: Array formula output not updated when changing named array size

asked 2016-10-06 19:03:39 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Hi all,

I get a weird behaviour when trying to change the range of a named array referenced in an array formula.

I expect that, when I change the range that a name references, the array formulas that reference the name should change too.

Example:

  1. Write "a1", "a2" and "a3" to A1, A2 and A3;
  2. Set a name to this range. Let it be "test";
  3. In C1, write the formula "=test" and press "ctrl+shift+enter" for an array formula. "a1", "a2" and "a3" are expected to be written to C1, C2 and C3;
  4. Now write "a4" to A4;
  5. Change the range that the name "test" reference to A1:A4;
  6. It is expected that the cell C4 gets the value "a4", but nothing is changed there.

Weirdly, I cannot edit nor delete the created output of the array formula, even if selecting the full range (the seen nor the expected). If I try "ctrl+/", the right size is selected, but the last value is blank. Also, if I enter the formula "=test" and press "enter" at C4, I get the right value ("d").

Is it a bug or is there any way to update this correctly?

I'm using version 5.0.6.3 ID de compilação: 490fc03b25318460cfc54456516ea2519c11d1aa Local: pt-BR (pt_BR)

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2016-10-08 14:38:09 +0200

pierre-yves samyn gravatar image

updated 2016-10-08 18:08:39 +0200

Hi

I reproduce the bug (yes it is...) on windows with 5.2.0.1

I found this bug report...

[EDIT]

I would add that for me the bug is not in the failure to update the C4 display. The cell may optionally contain other data that should not be replaced without user intervention.

IMO the bug is that we can not update the range, either by extending or by retyping.

Regards

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-10-06 19:03:39 +0200

Seen: 66 times

Last updated: Oct 08 '16