Description: I run "record macro". When I use sort, it does not record it as it did a year ago. Steps to Reproduce: 1.record macro, use "sort" 2.run macro, 3.does not sort Actual Results: 1.record macro, use "sort" 2.run macro, 3.does not sort Expected Results: to copy what I did in sort. As it worked years before. and as I have macros in other files that do work with sort. Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: en-US Module: SpreadsheetDocument [Information guessed from browser] OS: Windows (All) OS is 64bit: no
Created attachment 178653 [details] Try to record a macro to sort a column.
Record a macro while sorting a column. then run that recorded macro.
There are only one instruction to sort and is preceded with rem: "rem dispatcher.executeDispatch(document, ".uno:DataSort", "", 0, Array())" Are you invoking the sort fuction with the mouse or with the keyboard?
I only use "Run macro". I do not write them. I have recorded the same a year ago, it still works good. Thanks for your time. Not a must to fix but I thought it should be know
[Automated Action] NeedInfo-To-Unconfirmed
keyboard
Not key board but touchpad
Confirm with Version: 7.4.0.0.alpha0+ / LibreOffice Community Build ID: c97a3592c78ce276a353f95ce68c70a8a39174a0 CPU threads: 4; OS: Linux 5.13; UI render: default; VCL: gtk3 Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US Calc: threaded Jumbo works in Version: 6.3.0.0.alpha1+ Build ID: c98b1f1cd43b3e109bcaf6324ef2d1f449b34099 CPU threads: 4; OS: Linux 5.13; UI render: default; VCL: gtk3; Locale: cs-CZ (cs_CZ.UTF-8); UI-Language: en-US Calc: threaded
This seems to have begun at the below commit. Adding Cc: to Szymon Kłos; Could you possibly take a look at this one? Thanks linux-64-7.1$ 72426d44584b2277ddf78d3e438f4fd8c989d9d4 is the first bad commit commit 72426d44584b2277ddf78d3e438f4fd8c989d9d4 Author: Jenkins Build User <tdf@pollux.tdf> Date: Tue Jul 28 17:57:28 2020 +0200 source 70b81e74d2a14308e1897d840c681404225d328a https://git.libreoffice.org/core/+/70b81e74d2a14308e1897d840c681404225d328a Make Sort dialog async
I will try to check that this week
Szymon Kłos committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/eca978841816f833616b4c2334e65aa976a9fb61 tdf#147761 record sort command in macros It will be available in 7.4.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
*** Bug 145622 has been marked as a duplicate of this bug. ***
Thanks Szymon. Please backport.
I see backport for 7.3 but 7.2 would also be nice if possible.
Szymon Kłos committed a patch related to this issue. It has been pushed to "libreoffice-7-3": https://git.libreoffice.org/core/commit/db61167cdfdde69d115338be7d50447e81b43616 tdf#147761 record sort command in macros It will be available in 7.3.3. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.