Issue 71603 - Insert rows before array formulae
Summary: Insert rows before array formulae
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 2.0.4
Hardware: PC Windows XP
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2006-11-16 05:48 UTC by drking
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description drking 2006-11-16 05:48:46 UTC
If A1:A2 contain dog, cat
and B1:B2 contain {=A1:A2} as an array formula

Select row A  - it is not possible to insert a row - and there is no apparent reason

MSO does allow the row insertion, and therefore has better and more expected

Possibly this is overzealous protection of the array - 'oh no, someone's
selected only part of an array - let's stop anything from happening'.

User workarounds are:
1. select the whole array
2. cut and paste
Comment 1 gercokees 2007-03-13 13:51:02 UTC
Thanks for your comment.
I tried your procedure, but everything works fine here (i am using OOo 2.1), so
i close this issue now.
you can reopen anytime if the problem still persists...
Comment 2 drking 2007-03-13 14:41:20 UTC
Maybe it was fixed in 2.1. I'll wait for 2.2 before updating, 'cos of the 
massive download needed, and retry - if I remember

Comment 3 frank 2007-03-14 16:22:19 UTC
reopened to re-assign to requirements as this is not possible with array formulas
Comment 4 frank 2007-03-14 16:23:02 UTC
one for the requirements team