Setting a Calc Document to Open in Full Screen

edit

A few years ago, @RoryOF wrote one line: "When OpenOffice opens at the Splash screen, maximise it and close it. It should now remember the window size"

It still works with OpenOffice and LibreOffice

Update. In order for the program to switch to the Full Screen mode each time you open an individual spreadsheet or all of them, create the Utils module in the Standard library and write a short macro there:

Sub setFullScreen
Dim args(0) As New com.sun.star.beans.PropertyValue
args(0).Name = "FullScreen": args(0).Value = True
On Error Resume Next 
If ThisComponent.SupportsService("com.sun.star.sheet.SpreadsheetDocument") Then _
    createUnoService("com.sun.star.frame.DispatchHelper").executeDispatch( _
    ThisComponent.getCurrentController().getFrame(), _
    ".uno:FullScreen", "", 0, args())
End Sub

To do this, follow these steps:

Choose Tools - Macros - Organize Macros - LibreOffice Basic, or press Alt+F11 (if not assigned by your system).

Click Organizer... button - this is the fourth button at the top on the right side of the Organize Macros window

In the tab Modules select library Standard in My Macros and click New button

Enter name of new module Utils and click OK, then click Edit

In the window that opens, replace the text of the Main procedure template with the macro code from my answer - use the usual copy-paste from the browser.

Close this window

Then choose Tools - Customize - Events tab and set this macro to event as shown in the picture

Depending on what you specify in the drop-down list of the Save In field, the macro will be executed for each document or only for the specified one.

So, first step here - select Save In and choose LibreOffice or name of your spreadsheet.

Then select row with event Open Document and click Macro button

In next window in the left field Library expand and select My Macros - Standard - Utils

After that in the right field Macro Name select row setFullScreen and click OK

In the Open Document line, the string Standard.Utils.setFullScreen should appear - this means that the macro is assigned to this event.

When this behavior of the program you get bored, open this window again and click Remove.