To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=48920 Issue #:|48920 Summary:|Macro recorder does not format columns completely Component:|Spreadsheet Version:|680m100 Platform:|PC URL:| OS/Version:|Windows 2000 Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|programming Assigned to:|spreadsheet Reported by:|nostabo
------- Additional comments from [EMAIL PROTECTED] Sun May 8 22:27:31 -0700 2005 ------- The Macro Recorder of Calc, version 1.9.100, fails to format columns. This appears to be a general failure of the recorder to following a lengthy string of keystrokes. To verify this problem download the csv file from this Yahoo link and open it under Calc: http://www.finance.yahoo.com/d/quotes.csv?s=^dji ^ixk ^ixic ^gspc qqqq ^n225 ^hsi ^ftse msft ibm aapl sunw hpq sgi csco dell goog amzn&f=snl1d1t1c1ov&e=.csv Then start the Macro Recorder and record the following actions: 1) Insert a row a the top of the spreadsheet and enter names for each column; Symbol, Company, Last, Date, Time, Change, Open, and Volume (now all the columns should have headers). 2) Format the Name column (#2) to all Lowercase letters 3) Format the Last column (#3) to US currency 4) Format the Open column (#7) to US currency 5) Format the Volume column (#8) to use a thousands separator 6) Save the macro and close the file without saving it, now reopen the CSV file (the undedited version) and run the macro. Everything up to #2 above is completed, but the columns are not formatted (#3-5) Hmmm...OOo 1.1.4 performs well with this task. --------------------------------------------------------------------- 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]
