Apache OpenOffice (AOO) Bugzilla – Issue 102902
recorded macro for sort not working
Last modified: 2013-01-29 21:52:02 UTC
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 ------------------------------------------------------------------
@ jsk: please have look.
20046 is metabug for macro recorder
Assign to new default-assignee