Issue 17396 - Macros fail if formula is recorded using arrow-keys to reference cells
Summary: Macros fail if formula is recorded using arrow-keys to reference cells
Status: CLOSED DUPLICATE of issue 9769
Alias: None
Product: General
Classification: Code
Component: ui (show other issues)
Version: OOo 1.1 RC
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: OOo 2.0
Assignee: niklas.nebel
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-07-25 12:29 UTC by magrawal
Modified: 2003-09-16 11:21 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Macro recording problem (5.63 KB, application/octet-stream)
2003-07-25 12:30 UTC, magrawal 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description magrawal 2003-07-25 12:29:50 UTC 
In the attached spreadsheet, I recorded a simple macro to learn about the 
functionality of the recorder.


I inserted some numbers in columns B and C. Then I started the Macro recorder 
and wrote = B3 + C3 in cell D3. Then I copied cell D3 to cells D4 to D8. At this 
point I stopped recording the macro.


However, when I run the Macro, it only produces the result of B3 + C3. Also, the 
result is produced in cell E3 and not D3.
Comment 1 magrawal 2003-07-25 12:30:26 UTC 
Created attachment 8022 [details]
Macro recording problem
Comment 2 frank 2003-07-25 13:22:50 UTC 
Hi Skotti,

one for you I think.

Frank
Comment 3 joerg.skottke 2003-09-15 14:06:01 UTC 
Hi Magrawal,

if you take a look at the BASIC code that has been recorded by the
Macro recorder, you will find that the cell positions are recorded
absolute. This explains why the formula is always the same. We cannot
record formulas with relative cellreferences at this time. However,
when entering the formula by hand (not using the arrow-keys to select
the cells) should work (this means: the selection ends up where you
expect it)

Reproduction (Without qoutes):
1. Type "1" into B2
2. Type "2" into C2
3. Start recording
4. Press "CTRL+HOME" to go to A1
5. Move the selection to D2 using the arrow keys
6. Enter "=C2+B2" using the arrow-keys to select the cells C2 and B2
   (This is important!)
7. Press "Enter"
8. Save the Macro
9. Replay

On replay the Formula ends up in B2, both B2 and D2 show "err:522"
which is caused by the incorrect placement of the formula.
Comment 4 joerg.skottke 2003-09-15 14:06:30 UTC 
NN: Your task?
Comment 5 niklas.nebel 2003-09-16 11:16:45 UTC 
See issue 9769.

*** This issue has been marked as a duplicate of 9769 ***
Comment 6 niklas.nebel 2003-09-16 11:21:52 UTC 
duplicate, closing.