Description: I have created a macro to sort columns of numbers or letters many times with no issues. Now when I create the same macro and assign it to a button, it does not work. When I look at the code for the macro I notice it is missing a large number of args() lines. Example of missings lines: args3(0).Name="Byrows" args3(0).value=true ETC.. Completely mystified. Steps to Reproduce: In Calc create a short list of Letters and Numbers in columns. Maybe 6 rows. Now RECORD a Macro to sort the LETTERS in ASCENDING order. And RECORD a macro to sort the NUMBERS in DECSENDING order. Create 2 buttons and assign the macros to the proper buttons. Once done, click the buttons and the letters or numbers should be sorted in proper order, basedon the assigned macro. Actual Results: THE MACROS DO NOT SORT THE ROWS. Expected Results: SORTED THE ROWS Reproducible: Always User Profile Reset: Yes Additional Info: Version: 7.1.6.2 IF YOU EDIT THE MACRO, YOU WILL SEE THE LINES ARGx(0).Name="Byrows" etc.. are missing. Also notice below the REM in front of the DISPATCHER line. ???? below rem ---------------------------------------------------------------------- dim args2(0) as new com.sun.star.beans.PropertyValue args2(0).Name = "ToPoint" args2(0).Value = "$A$4:$B$9" dispatcher.executeDispatch(document, ".uno:GoToCell", "", 0, args2()) rem ---------------------------------------------------------------------- rem dispatcher.executeDispatch(document, ".uno:DataSort", "", 0, Array())
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
Created attachment 176479 [details] sample macro and code
Today Nov 27 I ran the same exercise on my other Dell PC and got the same results Ron G
I uninstalled my Libreoffice 7.1.6.2 on my second computer and Installed version 7.0. The same macro worked FINE! No issues. Something must have been changed, or not activated or perhaps a setting is causing the issue in 7.1.6.2 Thanks for any help...Ron G
I would like to make a comment about this Bug I have reported. This is a SERIOUS problem. Why? Because I designed a complete application for my local 8 ball league in Calc about 3-4 years ago, it worked fine. And this year when the League started up again there was a number of changes due to the League being shutdown for 2 years for COVID. This resulted in me having to adjust and RECREATE some of the macros and that's when I discovered the BUG. Luckily I didn't re-record all the MACROS. If I had this would have resulted in NOT being able to track stats, etc. for the League. It is too big a job to sort figures by hand with over a 100 players. And of course you guys being bogged down with so many reported bugs, that the response time is far too long for this type of issue. I would like this to be reported to the people WHO NEED TO KNOW. Thank you and I do appreciate the work you guys do. Ron G PS I downloaded version 7.1.8.1 and the problem still exists.
Doesn't seem like a bug that should be confirmed like this, as explained. I tested in 7.4+ and 7.1.0 and both are similar. Working macro can be recorded using Data-Sort Ascending, but not using Data-Sort.. if options left unchnaged. And that's why I don't see bug here. Recorded are only actions, not status of dialog. Please retest.
Working macro could be recorded using Data-Sort Ascending, but not using Data-Sort. That should be fixed in master 7.4+ in bug 147761. *** This bug has been marked as a duplicate of bug 147761 ***