To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=88569
Issue #|88569
Summary|[RFE] Make existing array formula edit easier for user
Component|Spreadsheet
Version|OOo 2.4.0
Platform|All
URL|
OS/Version|All
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|editing
Assigned to|spreadsheet
Reported by|bijugc
------- Additional comments from [EMAIL PROTECTED] Tue Apr 22 04:37:24 +0000
2008 -------
At present in OOo Calc if you try to edit a cell which is a part of an array.
user get a message "You cannot change only part of an array"
A better feedback would have been giving an option to select the entire array.
Steps:-
1. in OOo Calc goto cell "B3"
2. enter formula "={1;2;3}"
3. press ctrl+shift+enter to enter array data
4. move to cell "B3" again
5. try to edit cell content by
a) either pressing "F2" key,
b) or by double clicking cell "B3"
Result:-
* user get message "You cannot change only part of an array"
* clicking OK goes back to cell "B3" after doing nothing
see: ooo_edit_array_cell.png
Expected:-
* user should get message asking
================= Edit array ? ================
You are trying to edit part of an array.
to edit an array you have to select whole array.
Do you want select whole array?
[Select] [Cancel]
==============================================
* with default as "Select" button
* upon confirming selection, OOo Calc should select whole array.
* pressing "cancel" should do current behaviour
---------------------------------------------------------------------
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]