Ask Your Question

Calc macro button problem

asked 2019-09-15 11:42:21 +0200

Kino gravatar image

I have just installed and now my spreadsheet macro buttons all "vibrate" as if being constantly pressed. The normal spreadsheet functions are not enabled while this is happening. I have tried re-installing and re-booting but this does not solve the problem.

edit retag flag offensive close merge delete


I only tested RC versions of V6.3.0 (x64), but I also experienced the mentioned behaviour (with some exceptions). It seems to be a bug.

My OS is Win 10 up to date.
(I didn't find the time yet to file a bug report.)

Lupp gravatar imageLupp ( 2019-09-15 12:03:49 +0200 )edit

A single first test with V6.3.2.1RC did not show the issue for me.
Strange? Might it depend on one the last updates for Win 10 which my system underwent recently?

Lupp gravatar imageLupp ( 2019-09-15 13:20:04 +0200 )edit

I have exactly the same issue (LO calc 6.3.3, macos Catalina). Besides the mouse active cell bold rectangle gets frozen and doesn't update to the actual active cell. I switched to older 6.2.8 and everything seems to be working smoothly there (as indicated by others as well). Will wait for the bug to be fixed to upgrade to later versions

louis109 gravatar imagelouis109 ( 2019-11-06 12:38:34 +0200 )edit

See also bug tdf#128406.

Lupp gravatar imageLupp ( 2019-11-06 17:11:06 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2019-09-18 13:56:48 +0200

Kino gravatar image

The only solution I found was to uninstall 6.3 and re-install 6.2. It should be reported as a bug - I'm not sure how to do that.

edit flag offensive delete link more



Report bugs here -> Bugzilla

Ratslinger gravatar imageRatslinger ( 2019-09-18 18:04:18 +0200 )edit

See bug tdf#121963.

Lupp gravatar imageLupp ( 2019-10-16 23:48:13 +0200 )edit

I have the exactsame problem! I had to install LibreOffice version 6.2.8 since it works, but NOT 6.3.1 or 6.3.2! See my bug report here:

eRCaGuy gravatar imageeRCaGuy ( 2019-10-27 02:25:12 +0200 )edit


Replace the Buttons with geometic figures, drawings or photos, circumvents the problem.

Schiavinatto gravatar imageSchiavinatto ( 2019-10-27 02:31:32 +0200 )edit

@Gilberto Schiavinatto:
"Buttons" are supposed to be controls having lots of properties and supporting functionality editable via a powerful interface. How would you replace them regarding all this with ordinary shapes? Is there an example file?

Lupp gravatar imageLupp ( 2019-10-27 14:01:06 +0200 )edit

@Lupp, Usually buttons are used to trigger macros, which can be done with geometric figures, drawings and photos. With the picture selected, right click.

image description

Schiavinatto gravatar imageSchiavinatto ( 2019-10-27 21:34:27 +0200 )edit

answered 2019-09-15 13:39:33 +0200

updated 2019-09-19 13:10:18 +0200

I have the same problem, since version 6.3.0 (Win10 / x64) and contained until now, the output found was to use version, when the file is not mine, and my file started using geometrical figures or images instead of button.

Descrição da imagem


Tested on 19/09/2019

Em + Win10, problem remains.

edit flag offensive delete link more



I also encountered the "spreadsheet macro buttons all "vibrate" as if being constantly pressed. The normal spreadsheet functions are not enabled while this is happening." with four up-to date-versions of Windows installations after updating to -- My temporary solution was to revert to Ver PS. Your description of problem is perfect for an issue that is hard to describe.

mountainartisan gravatar imagemountainartisan ( 2019-09-17 21:13:17 +0200 )edit

UPDATE: Installed V on Linux Mint 19 Cinnamon. Ran the same spreadsheet that encountered macro button "vibrate" problem on the Windows 10 installations. No macro button "vibrate" problem was encountered.

mountainartisan gravatar imagemountainartisan ( 2019-09-19 04:15:33 +0200 )edit

This "vibrate" (or button "blinking" or "flashing" ) appears to have been reported in Bug Report 121963. Bug report 121963 also references other duplicate reports.

mountainartisan gravatar imagemountainartisan ( 2019-09-29 15:39:29 +0200 )edit

I have the same problem with Windows 10 and V 6.3. Of interest is that the vibration stops when in formcontrols design mode. The normal spreadsheet functions also work then. In fault mode, although the menu dropdown box shows the detail in the box does not show. The cursor also does not show the focus on the selected cell. It must be something wrong with the screen refresh driver. Another point is that there generally is not a problem with the macro button when there are not many entries on the sheet. The problem surfaces when there are more entries on the sheet.

BSNatal gravatar imageBSNatal ( 2019-10-03 12:21:59 +0200 )edit

Tests under Version: (x64) indicate the problem is indeed fixed/solved. Many thanks to Armin Le Grand and the other folks who made the fix happen.

mountainartisan gravatar imagemountainartisan ( 2019-12-12 21:44:41 +0200 )edit
Login/Signup to Answer

Question Tools



Asked: 2019-09-15 11:42:21 +0200

Seen: 688 times

Last updated: Sep 19 '19