Bug 139404 - Cannot record Basic macros in Calc
Summary: Cannot record Basic macros in Calc
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
Keywords: bibisectRequest, regression
: 143217 (view as bug list)
Depends on:
Blocks: Macro-Recording
  Show dependency treegraph
Reported: 2021-01-04 13:52 UTC by Regina Henschel
Modified: 2022-07-14 23:26 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:
Regression By:


Note You need to log in before you can comment on or make changes to this bug.
Description Regina Henschel 2021-01-04 13:52:42 UTC
Start Calc.
Goto Tools > Options > LibreOffice > Advanced. Enable macro recording. OK
In Calc enter some values.
Start Macro recording. That is in Tools > Macros > Record Macro. A little window opens with a 'Stop Recording' icon.
Do something, e.g.
Use Strg+ * (in numpad). That should mark the range with the entered data.
Use Arrow keys. That should move the cell cursor.
Use Arrow keys combined with Shift-key. That should mark a range.
Press some number or character keys. That should fill the current cell.
None of these work.
Click 'Stop Recording'. No macro is recorded.
It acts, as if the keyboard is disabled.

Do the same in LibreOffice 5.4 to see how it should work.

I see the error in Version: (x64)
Build ID: 70a2071ce91b71326659e645dd97996262ea309a
CPU threads: 8; OS: Windows 10.0 Build 19041; UI render: GL; VCL: win; 
Locale: de-DE (en_US); UI-Language: en-US
Calc: threaded

It is OK in Version: (x64)
Build-ID: c838ef25c16710f8838b1faec480ebba495259d0
CPU-Threads: 8; BS: Windows 6.19; UI-Render: Standard; 
Gebietsschema: de-DE (en_US); Calc: CL
Comment 1 Tamas 2021-07-08 18:21:41 UTC
I reported something similar in bug report# 143217. In Windows OS, your keyboard seems to be locked as soon as you click on Record Macro. To start a macro (after you clicked on Record) you must click on a command Icon in the Edit Tool Bar, such as Cut, Paste, Copy, etc. or click on (point to) a cell. You will be able to record the macro. (However, if you clicked on a cell, instead of an Icon, the macro will only aplly to that cell). This problem seems to exist only in the Windows version of Libreoffice.
Comment 2 Timur 2021-07-13 17:59:50 UTC
*** Bug 143217 has been marked as a duplicate of this bug. ***
Comment 3 Timur 2022-03-18 13:06:13 UTC
I don't reproduce this. I see something recored in LO 6.4.0 and 7.4+.
Please retest, also with a clean profile.
Comment 4 Martin Srdoš 2022-05-01 18:33:14 UTC
I don't see any message about that someone can reproduce this bug. So the status should be UNCONFIRMED. There is also question to Regina, if the bug is present in the latest version, so I am setting the status to NEEDINFO. Adding Regina to CC list.
Comment 5 Regina Henschel 2022-05-01 20:01:41 UTC
The locked keyboard still happens in Version: (x64) / LibreOffice Community
Build ID: 3a4a12b3801b0b88d119c6e7aaca1e183f7e470f
CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: de-DE (en_US); UI: en-US
Calc: CL