Ask Your Question
0

How to exit design mode in Calc (6.2.7.1)

asked 2019-10-24 13:53:32 +0100

Jem777 gravatar image

It seems impossible to get out design mode. I have several buttons that should fire up macro's, but only end up selected when clicked. I looked on this board for a solution, but it seems the buttons used to get out of Design Mode are not present any more or have changed.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2019-10-24 14:03:06 +0100

Opaque gravatar image

updated 2019-10-24 14:24:30 +0100

Hello,

untick Tools -> Forms -> [ ] Design Mode -- or if you want the proper toolbar
View -> Toolbars -> Form Design

Update: Check also in the upper rightmost icon (pencil style) on the Form Controls.
image description

(If that all doesn't work for you, I suspect a problem with your user profile)

Hope that helps.

edit flag offensive delete link more

Comments

Thanks for your response. Unfortunately, it doesn't change the behavior. Still the buttons get selected, as opposed to firing an event.

I also tried the Form Design toolbar (as was suggested for previous versions on this forum), but had no luck there either.

Clearly you must be on a different version as me, as my Form Controls toolbar has no pencil (in fact, it has none of the icons shown above).

Jem777 gravatar imageJem777 ( 2019-10-24 14:10:31 +0100 )edit

I did a reset on my user profile (factory defaults). No change. Buttons always get selected, despite the state of the Design Mode toggle.

Jem777 gravatar imageJem777 ( 2019-10-24 14:55:35 +0100 )edit

Turns out I have the reverse problem as well. I finally got it out of Design Mode by saving to a new (.ods) file. But now I cannot get it INTO Design Mode, whatever I do (i.e. all the options Opaque mentioned above).

I'm beginning to suspect a bug.

I also tried the Open in Design Mode option. Closed the document (saved it), re-opened, but it does not open in Design Mode ...

Jem777 gravatar imageJem777 ( 2019-10-24 15:02:47 +0100 )edit

I don't know the icons @Opaque attached an image of, but I would assume the 'Pencil' doesn't toggle the 'Form Design Mode' but the 'Control Design Mode' (a gear in recent LibO under Win).
Try the Icon with the triangular ruler.
If that icon has a different meaning , Open the 'Customise' tool for your FormDesignjToolbar and make sure it contains all the commands you need.
Beyond the different icons everything works as expected for me in LibO V 6.3.3.1 under Win 10.

Lupp gravatar imageLupp ( 2019-10-24 16:11:25 +0100 )edit

It's an ODF document that was converted from Excel.

@Lupp the Form Design toolbar has no pencil, nor does it have a triangular ruler. These icons are also not available when I open Customise.

Jem777 gravatar imageJem777 ( 2019-10-24 16:43:55 +0100 )edit

Clearly you must be on a different version as me, as my Form Controls toolbar has no pencil (in fact, it has none of the icons shown above).

Yes - I'm on Linux and you never mentioned your OS.

Opaque gravatar imageOpaque ( 2019-10-24 16:44:07 +0100 )edit

It's an ODF document that was converted from Excel.

Sigh ...

Opaque gravatar imageOpaque ( 2019-10-24 16:47:00 +0100 )edit

Did you (@Jem777 ) follow the advice "... Open the 'Customise' tool for your FormDesignjToolbar and make sure it contains all the commands you need."? Customising a toolbar you also see the hints concerning the functionality of any choosable icon/command.
Of course, the "Sigh..." is well justified. A document converted from a former Excel-file containing command buttons (or other controls) will most likely have Excel-VBA code assigned to its events ...
I wouldn't expect that to work.
(Note: A commercial competitor can never accept full compatibiltiy with a free software, of course.)

Lupp gravatar imageLupp ( 2019-10-24 18:42:36 +0100 )edit

@Lupp - the Sigh... is more about that questioners leave off important information so often when asking questions and it takes a bunch of comments back and force to work out the facts.

Opaque gravatar imageOpaque ( 2019-10-24 18:54:59 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-10-24 13:53:32 +0100

Seen: 28 times

Last updated: Oct 24