Issue 82735 - Macro recorder omits column select
Summary: Macro recorder omits column select
Status: CLOSED DUPLICATE of issue 18339
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOo 2.3
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Depends on:
Reported: 2007-10-17 23:10 UTC by T. J. Frazier
Modified: 2007-10-29 09:30 UTC (History)
1 user (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description T. J. Frazier 2007-10-17 23:10:29 UTC
Column select (clicking on the column letter) is not recorded at the start of a
macro.  The problem this causes is that on subsequent use, the macro will format
whichever column contains the currently-selected cell, rather than the
originally-specified column(s).
To reproduce:
1) Open a new spreadsheet, say from Quickstarter.  Cell A1 will be selected.
2) Begin macro recording.
3) Click on the header letter for Column B.  Column B is selected. [This is not
4) Shift-click on header "D".  Columns B, C, and D are selected. [This is also
not recorded.]
5) Format the selection.  For example, Format > Column > width... > spin the
spin box some > OK [This records just fine.]
6) Stop recording, save macro. Inspection shows no selection information
recorded. The actual formatting is the first thing in the macro.

Workaround: select a dummy range, for instance, click on B1 and shift-click on
D3, instead of using the column headers.  This records and works fine.
Therefore, this probably deserves only P4, but it's a bug, and if somebody's in
the code . . .
Comment 1 T. J. Frazier 2007-10-27 16:34:41 UTC
This is a duplicate of Issue 18339 (sorry), but that issue is moribund.  The
original should be folded into Issue 81537. /tj
Comment 2 frank 2007-10-29 09:29:49 UTC
double to Issue 18339

*** This issue has been marked as a duplicate of 18339 ***
Comment 3 frank 2007-10-29 09:30:15 UTC
closed double