To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102902 Issue #|102902 Summary|recorded macro for sort not working Component|framework Version|OOo 3.1 Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|tm Reported by|npower
------- Additional comments from [email protected] Thu Jun 18 11:22:23 +0000 2009 ------- create a document with a column of data ( e.g. col f ) 1. enable macro recording 2. select col F 3. data | sort ( sort by the defaults ) 4. stop macro recorder 5. save recorded macro somewhere you will get a macro ( see below ), however if undo the sorting and run the macro you will notice that no sorting occurs :-/ sub Main rem ---------------------------------------------------------------------- rem define variables dim document as object dim dispatcher as object rem ---------------------------------------------------------------------- rem get access to the document document = ThisComponent.CurrentController.Frame dispatcher = createUnoService("com.sun.star.frame.DispatchHelper") rem ---------------------------------------------------------------------- dim args1(6) as new com.sun.star.beans.PropertyValue args1(0).Name = "ByRows" args1(0).Value = true args1(1).Name = "HasHeader" args1(1).Value = false args1(2).Name = "CaseSensitive" args1(2).Value = false args1(3).Name = "IncludeAttribs" args1(3).Value = true args1(4).Name = "UserDefIndex" args1(4).Value = 0 args1(5).Name = "Col1" args1(5).Value = 6 args1(6).Name = "Ascending1" args1(6).Value = true dispatcher.executeDispatch(document, ".uno:DataSort", "", 0, args1()) rem ------------------------------------------------------------------ --------------------------------------------------------------------- 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]
