Issue 85984

Summary:	Relative reference shortcut not working in function wizard
Product:	Calc	Reporter:	aliby <aliby>
Component:	ui	Assignee:	AOO issues mailing list <issues>
Status:	CONFIRMED ---	QA Contact:
Severity:	Trivial
Priority:	P4	CC:	elish, issues, rainerbielefeld_ooo_qa
Version:	OOo 2.3.1	Keywords:	oooqa
Target Milestone:	---
Hardware:	PC
OS:	All
Issue Type:	ENHANCEMENT	Latest Confirmation in:	4.1.0-dev
Developer Difficulty:	---

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
disabled.

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 
   '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?

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 requirements@openoffice.org 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
Debian