Textbox : can create, but not modify

English
#1

Someone kindly can help me how to solve a problem with Textbox ?
I can create and type something in the Textbox, but it’s not possible to modify the backgroundcolor, the framewith, the framecolor. It’s also not possible to make the Textbox a “click to run a macro” Rightmouseclick doesn"t show “Add macro”.
If I select the TextBox and I rightmouseclick copy and paste, then I copy a cell and paste in a cell instead of copy and paste the TextBox. I have the newest version of LibreOffice Calc.

To me, this topic is closed now.
Thanks everybody for the help and suggestions !

20250707ma1940

#2

Try Menu / Tools / Forms, check / uncheck Design Mode.
I added (on my computer) this menu item to the Standard toolbar.

#3
  • This is a bug in 25.2.4
  • Still works in 25.2.3
#5

Thanks for quick reply soko, but it did not resolve the problem.

#6

The form control text boxes work normally.
The boxes from menu:Insert>Text box… don’t show the right context menu.
You can make one in Writer and copy over to Calc.

1 Like
#7

Thanks also PKG for quick reply. That was a good hint !
As you said it’s a bug in 25.2.4 , I installed the béta : LibreOfficeDev_25.8.0.0.beta1_Win_x86-64.msi
This resolved the problem with the TextBox. The TextFrame I don’t see anymore, but I don’t use the latter anyway.

So, the procedure to solve the problem:

  1. Download and install : LibreOfficeDev_25.8.0.0.beta1_Win_x86-64.msi
  2. Restart computer.
  3. Search and start on your Desktop : LibreOfficeDev 25.8

PS : Don’t just start an old LibreOffice Calc document, as it will start in the old version, with the same old problem. Use the desktop-shortcut.
Also after opening (and saving) via the Desktop-shortcut , I still have to use the Desktop-shortcut, that’s not easy. So 1 problem solved, but another problem appears. Or is this normal with béta-versions?

2nd problem with the béta-version is, that it’s not possible to execute a Basic- macro. While a python-macro in a TextBox still executes as normal.

Also organising Basic-micro’s in LibreOffice Calc is just terrible.
I recommend python-macro’s and save it in a map, this way macro’s don’t get lost.

#8

Thanks Villeroy, for quick reply too.
I still can add a TextBox. The problem is that I cannot manipulate the TextBox. I can’t change the color of the background and the frames, I can’t use the TextBox to start a macro. I cannot copy the TextBox with Copy. I can only copy the TextBox with Ctrl RightMouseClick and move the TextBox.

Thanks anyway for the suggestion.

#9

Open a new Writer document.
Add a text box via menu:Insert>Text box… just like you did in Calc.
Format the text box with colors and borders.
Copy the text box from Writer into your Calc document.

#10

tdf#167386 (“copy & pasting text boxes fail”)

Take a look at the Comment 3 therein. If one uses the Select button on the Drawing bar to select the text box, copy and paste seems to work as expected. Line, Area and Assign Macro etc. appear in the context menu.

#11

Thanks cwolan, I tried the Comment 3. The Draw toolbar appears. I tried many draws and it’s possible to connect a macro to the draws,… except… the TextBox.
The TextBox is just the one in which it’s possible to write which macro will start when clicked on. So just a Draw (without explanation) is not practical.

#12

In Calc, the text boxes can also be edited in 25.2.4 via a detour:

  1. create a text box.

  2. then insert any shape (Insert → shape).

Click on the shape and jump from there directly into the text box, which can now be edited.

2025-07-08 08 00 36
2025-07-08 08 00 36898×568 32.8 KB

1 Like
#13

The context menu for the text box is incorrect
https://bugs.documentfoundation.org/show_bug.cgi?id=166633

2 Likes
#14

Fix pushed for 25.2.6 - unfortunately this omission was not noticed in time for 25.2.5.

1 Like

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.