To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=85984
User rainerbielefeld changed the following:
What |Old value |New value
================================================================================
CC|'' |'rainerbielefeld'
--------------------------------------------------------------------------------
Issue type|DEFECT |ENHANCEMENT
--------------------------------------------------------------------------------
Keywords| |oooqa
--------------------------------------------------------------------------------
Priority|P3 |P4
--------------------------------------------------------------------------------
Summary|Relative reference shortcu|Relative reference shortcu
|t not working in functin w|t not working in function
|izzard |wizard
--------------------------------------------------------------------------------
Subcomponent|code |ui
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Mon Feb 11 06:32:01 +0000
2008 -------
This can be reproduced easily:
1. open new spreadsheet
2. Insert Numbers "1" ... "3" To 'A1' ... 'A3'
3. Mouseclick 'B4'
4. Press SUM icon beneath the Function Wizard icon
"=SUM()" appears in the input pane
5. Drag mouse pointer (with pushed left mouse button) button from 'A1' to
'A3'
"=SUM(A1:A3)" appears in the input pane
6. Press <Shift>+<F4>
Formula will toggle between several Absolute or relative versions:
"=SUM(A1:A3)", =SUM($A$1:$A$3), ...
Now the same with the Function wizard
11. delete contents of 'B4', then click on 'B4'
12. Click on Function Wizard icon
wizard dialogue will appear
13. Select SUM by double click
14. Drag mouse pointer (with ushed left mouse button) button from 'A1' to
'A3'
"=SUM(A1:A3)" appears in the formula pane
15. Press <Shift>+<F4>
expected: formula will toggle between several absolute or relative versions
actual: nothing happens
User Experience Team might decide whether that feature really is importat. I
believe it would be useful to get a formula (or part of a formula) with absolute
references with a single key press. But because this can be reached for the
domplete formula after the Function Wizard has been closed (now you can toggle
with <Shift>+<F4>) I doubt that this is importat.
This issue might be related to Issue 23098?
---------------------------------------------------------------------
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]
