To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=82735 Issue #|82735 Summary|Macro recorder omits column select Component|Spreadsheet Version|OOo 2.3 Platform|All URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|programming Assigned to|spreadsheet Reported by|tjfrazier
------- Additional comments from [EMAIL PROTECTED] Wed Oct 17 22:10:29 +0000 2007 ------- 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 . . . --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
