Bug 151101

Summary: Listbox shrinks if border color is set by macro
Product: LibreOffice Reporter: Ilhan Yesil <ilhanyesil>
Component: BASICAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: normal CC: rafael.palma.lima
Priority: medium    
Version: 7.5.0.0 alpha0+   
Hardware: All   
OS: Linux (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: Demonstrates the effect

Description Ilhan Yesil 2022-09-21 10:26:23 UTC
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
Comment 1 Ilhan Yesil 2022-09-21 10:27:24 UTC
Created attachment 182594 [details]
Demonstrates the effect
Comment 3 Rafael Lima 2022-09-21 14:03:23 UTC
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.
Comment 4 Rafael Lima 2022-09-21 14:05:08 UTC
@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.