https://bugs.documentfoundation.org/show_bug.cgi?id=105468
Paolo Benvenuto <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Component|BASIC |Calc --- Comment #9 from Paolo Benvenuto <[email protected]> --- Changed component to calc, because in it it's easier to see and reproduce: Still present in 26.8 alpha Reproduce this way: - new spreadsheet - fill a given rectangle (e.g. 6x6) with any value - Tool / Macro / Record macro - select all the rectangle - Data / Sort - make a 4 key sort: key1 column A, key2 column B, key3 column C, key4 column D; enter OK - stop macro recording and give it a name - go and see the macro code: ------------------------------------------ begin code -------- REM ***** BASIC ***** Sub Main End Sub sub sortProva 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(0) as new com.sun.star.beans.PropertyValue args1(0).Name = "ToPoint" args1(0).Value = "$A$1:$I$5" dispatcher.executeDispatch(document, ".uno:GoToCell", "", 0, args1()) rem ---------------------------------------------------------------------- rem dispatcher.executeDispatch(document, ".uno:DataSort", "", 0, Array()) rem ---------------------------------------------------------------------- dim args3(12) as new com.sun.star.beans.PropertyValue args3(0).Name = "IncludeComments" args3(0).Value = false args3(1).Name = "Col3" args3(1).Value = 3 args3(2).Name = "Ascending2" args3(2).Value = true args3(3).Name = "Ascending1" args3(3).Value = true args3(4).Name = "UserDefIndex" args3(4).Value = 0 args3(5).Name = "IncludeAttribs" args3(5).Value = true args3(6).Name = "CaseSensitive" args3(6).Value = false args3(7).Name = "IncludeImages" args3(7).Value = true args3(8).Name = "Col2" args3(8).Value = 2 args3(9).Name = "HasHeader" args3(9).Value = false args3(10).Name = "Ascending3" args3(10).Value = true args3(11).Name = "Col1" args3(11).Value = 1 args3(12).Name = "ByRows" args3(12).Value = true dispatcher.executeDispatch(document, ".uno:DataSort", "", 0, args3()) end sub ------------------------------------------ end code -------- Only column1-3 keys are recorded as sort options. -- You are receiving this mail because: You are the assignee for the bug.
