How to find out screen resolution in Calc macro?

shma_lo1 · August 19, 2025, 2:29am

How to find out screen resolution in Calc macro ?
Version: 25.2.5.2 (X86_64) / LibreOffice Community
Build ID: 03d19516eb2e1dd5d4ccd751a0d6f35f35e08022
CPU threads: 8; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Vulkan; VCL: win
Locale: fr-FR (en_US); UI: en-US
Calc: threaded

fpy · August 19, 2025, 7:24am

→ Development Tools
→ LibreOffice: XWindow Interface Reference

→ LibreOffice: DeviceInfo Struct Reference

 with ThisComponent.CurrentController.ComponentWindow.Info 
   print .Width & " x " & .Height
 end with

shma_lo1 · August 19, 2025, 1:07pm

Merci beaucoup !

shma_lo1 · August 19, 2025, 4:51pm

@fpy
Macro result: 1366 x 465
Settings result: 1366 x 768
Any idea ?

karolus · August 19, 2025, 5:14pm

size of your document.CurrentController.ComponentWindow !?

fpy · August 19, 2025, 5:19pm

indeed, for screen :

   With  ThisComponent.CurrentController.ComponentWindow.Toolkit.Workarea 
  ...

it’s said to be the primary display (current I guess)
→ LibreOffice: XToolkit Interface Reference