To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=88569
------- Additional comments from j...@openoffice.org Sat May 29 18:20:42 +0000
2010 -------
Nice idea!
But if there's only one useful outcome, why bother asking the question?
If the user tries to edit an array formula, Calc should just select the array
range and edit the formula.
If the user edits the formula and presses "Enter" in the array formula context,
then there may be a useful question:
Do you want to
a) modify the array range, or
b) replace the array range with a single array formula
c) replace the array range with a single non-array formula
Currently, if you just press Enter, you get the "You cannot change only part of
an array" error and you _lose your edits_ entirely.
The a) choice should be the default--it's the case where the user simply forgot
to press Ctrl+Shift+Enter.
The b) and c) options are probably much less common, but useful, and very
inconvenient at present. You have to:
1) select the array range
2) edit the formula (F2)
3) select the formula text
4) copy the formula text to the clipboard
5) leave edit mode (Escape)
6) clear the array range
7) edit the cell
8) paste the formula text
9) press Ctrl+Shift+Enter (for b), or Enter (for c)
I run into b/c when working out formulas that use array ranges but return a
single result. I start with the simple array formula where I need to see the
entire range, then add a function that processes the array range to get one
value. Making such an edit requires all the steps above, in that precise order,
and is a big nuisance.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
