Issue 85984 - Relative reference shortcut not working in function wizard
Summary: Relative reference shortcut not working in function wizard
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 2.3.1
Hardware: PC All
: P4 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2008-02-10 16:09 UTC by aliby
Modified: 2014-01-12 12:36 UTC (History)
3 users (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description aliby 2008-02-10 16:09:51 UTC
In OOoCalc relative references can be quickly defined using the shortcut key
"Shift+F4". However, when in the function wizzard this shortcut key becomes
Comment 1 Rainer Bielefeld 2008-02-11 06:32:01 UTC
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 
   "=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 
    "=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?

Comment 2 aliby 2008-02-18 07:51:56 UTC
With large formulae the Function Wizard enables you to view or access parts of
the formula at a time. Being able to then apply relative reference rules then
ensures that you are doing so to the correct section of the formula.
Comment 3 oc 2008-07-15 10:43:23 UTC
reassigning features and enhancements to user which
will be the default owner for those tasks (was introduced some time ago)
Comment 4 Edwin Sharp 2014-01-12 12:36:33 UTC
Confirmed with
AOO410m1(Build:9750)  -  Rev. 1555399
2014-01-06_04:13:46 - Rev. 1555657