Description: I've written a VBA macro with a listbox control. If I set the border color with VBA code, the listbox shrinks a bit. Not observed with windows 10, but with debian. Steps to Reproduce: 1. Open attached file and press "Demonstrate BorderColor" 2. In opened dialog with listbox and button, press button "Set border color" Actual Results: The listbox shrinks a bit. Expected Results: The listbox should keep it's size, as border color should not influence the size. Reproducible: Always User Profile Reset: No Additional Info: Version: 7.5.0.0.alpha0+ / LibreOffice Community Build ID: 085a69484e279596e55e678fd8df66dda9e4a4a4 CPU threads: 8; OS: Linux 4.19; UI render: default; VCL: gtk3 Locale: de-DE (de_DE.UTF-8); UI: de-DE Calc: threaded
Created attachment 182594 [details] Demonstrates the effect
See also https://gerrit.libreoffice.org/c/core/+/136691/comments/e2f13f59_92e4102a.
This is repro with Version: 7.5.0.0.alpha0+ / LibreOffice Community Build ID: bdf346830b735aa484fba0df94be71fd1ea5cdfd CPU threads: 16; OS: Linux 5.15; UI render: default; VCL: kf5 (cairo+xcb) Locale: pt-BR (pt_BR.UTF-8); UI: en-US Calc: CL threaded The weird thing is that if you inspect the listbox before and after the change, its reported height/width is the same. I'm setting this to NEW.
@Ilhan, note that this is not a VBA macro, but instead a Basic macro. The code you provided is pure StarBasic code. VBA macros are only possible using MS VBA in compatibility mode.