Apache OpenOffice (AOO) Bugzilla – Issue 82735
Macro recorder omits column select
Last modified: 2007-10-29 09:30:15 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 recorded.] 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 . . .
This is a duplicate of Issue 18339 (sorry), but that issue is moribund. The original should be folded into Issue 81537. /tj
double to Issue 18339 *** This issue has been marked as a duplicate of 18339 ***
closed double