How do i stop Calc starting with 'design mode' controls turned on

[brucewatt]

Every time I open Calc, the ‘Design Mode’ under the ‘controls’ icon are turned on. How do I turn this off?
It does not matter if I turn this off and then save and close the file. It turns itself on when opening again.

[mikekaganski]

Uncheck Tools▸Forms▸Open in Design Mode.

[brucewatt]

Brillant! thank you. I know it would be something simple, I just could not find it.
Thank you again

[Hrbrgr]

Close the Form Controls toolbar. Save the file.

[brucewatt]

Thank you for your reply
Sorry, that does not work for me. it always goes into design mode when reopening.

[BarryO]

I’ve got the same issue. Regardless of what I do, the calc sheet opens in design mode.

[thurston]

1st step: place this in your macro "My Macros"

Sub on_ApplicationStart( oEvent As Object )
   REM Should be connected to the "Start Application" event of LibreOffice.
   rem ----------------------------------------------------------------------
   rem define variables
   dim document   as object
   dim dispatcher as object
   rem ----------------------------------------------------------------------
   rem get access to the document
   document   = ThisComponent.CurrentController.Frame
   dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")

   rem ----------------------------------------------------------------------
   dim args1(0) as new com.sun.star.beans.PropertyValue
   args1(0).Name = "SwitchControlDesignMode"
   args1(0).Value = false

   dispatcher.executeDispatch(document, ".uno:SwitchControlDesignMode", "", 0, args1())
End Sub

2nd Step: assigning the macro to a common event
Using the menu customize, assign this macro to the event “Modified Status was changed”. Then, each time you open an ods and make any little modification to the file, the “Design Mode” will be deactivated. (simply place a space in a blank cell, and the trick is done). I apply this macro also to Start application” + “New Document” + “Open Document”.

[Bort]

I had this same thing happening and found the way around it. Here is a video of the solution.

View > Toolbars > Form Design > Click on the icon that looks like an open folder. It displays “open in design mode” when we mouse over it. Turn that option off, save. Design mode will be off next time and every time the document is opened.