Bug 139404 - Cannot record Basic macros in Calc
Summary: Cannot record Basic macros in Calc
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.5.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: 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: 2023-08-13 03:40 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:


Attachments

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: 6.4.5.0.0+ (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: 5.4.7.2 (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: 7.4.0.0.alpha0+ (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
Comment 6 Buovjaga 2023-01-24 08:41:27 UTC
Works fine here.

I noticed while testing with 7.4 that the macro recording dialog seemed to steal the focus at the start, so I had to click on a cell before I could use the keyboard. Was this your problem?

Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 1c638b7ac46d8077994c8483e6becc4a33efd12b
CPU threads: 2; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: en-US (en_FI); UI: en-US
Calc: threaded
Comment 7 QA Administrators 2023-07-24 03:13:18 UTC Comment hidden (obsolete)
Comment 8 Regina Henschel 2023-07-24 12:44:52 UTC
(In reply to Buovjaga from comment #6)
> I noticed while testing with 7.4 that the macro recording dialog seemed to
> steal the focus at the start, so I had to click on a cell before I could use
> the keyboard. Was this your problem?

Yes, that is the problem in LO 6.4.

It is OK now in Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 6256d5fe2e7cb1bb002d5fe59527d3a3fbf6963f
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded