Comment 13 for bug 1854183

Editing ~/.config/libreoffice/4/user/registrymodifications.xcu did the trick for me as well and calc can be openend as ususual.

In my case, ci copied the resolution value from the TextDocument entry to the SpreadsheetDocument entry.

before:

<item oor:path="/org.openoffice.Setup/Office/Factories/org.openoffice.Setup:Factory['com.sun.star.sheet.SpreadsheetDocument']"><prop oor:name="ooSetupFactoryWindowAttributes" oor:op="fuse"><value>1920,40,717,27;5;1920,40,1920,1040;</value></prop></item>
<item oor:path="/org.openoffice.Setup/Office/Factories/org.openoffice.Setup:Factory['com.sun.star.text.TextDocument']"><prop oor:name="ooSetupFactoryWindowAttributes" oor:op="fuse"><value>1184,40,735,83;5;1920,40,1920,1040;</value></prop></item>

after:

<item oor:path="/org.openoffice.Setup/Office/Factories/org.openoffice.Setup:Factory['com.sun.star.sheet.SpreadsheetDocument']"><prop oor:name="ooSetupFactoryWindowAttributes" oor:op="fuse"><value>1184,40,735,83;5;1920,40,1920,1040;</value></prop></item>
<item oor:path="/org.openoffice.Setup/Office/Factories/org.openoffice.Setup:Factory['com.sun.star.text.TextDocument']"><prop oor:name="ooSetupFactoryWindowAttributes" oor:op="fuse"><value>1184,40,735,83;5;1920,40,1920,1040;</value></prop></item>

Thank you for pointing this out. It really helped me.

I assume that this is really a nasty bug. A fix should consider if values smaller than the current screen size are taken when the stored values exceed the screen size.

It does not even make sense to store these value as long as users have multiple monitors with different resolutions. I have 3 monitors whereas 2 of them are via docking station so that they are not there when the laptop is not plugged into the docking station.

It's not just in recent years that screen resolutions can change at any time. This has not been much different 20 years ago.