Bug 153599 - No access to the ListSource property of a ListBox
Summary: No access to the ListSource property of a ListBox
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: BASIC (show other bugs)
Version:
(earliest affected)
7.4.5.1 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-02-13 17:33 UTC by Jean-Michel COSTE
Modified: 2023-02-14 11:23 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
A Base file to show the bug (15.12 KB, application/vnd.sun.xml.base)
2023-02-13 17:37 UTC, Jean-Michel COSTE 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Jean-Michel COSTE 2023-02-13 17:33:29 UTC 
Description:
I want to modify the SQL query of a ListBox (to display the list in alphabetical order).
But the ListSource property is not accessible, neither read nor write.
The message is: ""BASIC runtime error. Object variable not set.""

Steps to Reproduce:
1. try to display or modify ListBox.LIstSource
2.
3.

Actual Results:
error message
""BASIC runtime error. Object variable not set.""

Expected Results:
No error


Reproducible: Always


User Profile Reset: Yes

Additional Info:
Version: 7.4.5.1 (x64) / LibreOffice Community
Build ID: 9c0871452b3918c1019dde9bfac75448afc4b57f
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: fr-FR (fr_FR); UI: fr-FR
Calc: threaded

And version 7.5
Comment 1 Jean-Michel COSTE 2023-02-13 17:37:13 UTC 
Created attachment 185357 [details]
A Base file to show the bug

A checkbox activate a macro to modify ListSource.
A button activate a macro to display the ListSource Property.
Work on ComboBox, not on ListBox
Comment 2 Jean-Michel COSTE 2023-02-14 11:23:26 UTC 
Solved.
ListSource of a combobox takes a String or an array but ListSource of a Listbox takes only an array !!!!