Issue 128558 - No access to the ListSource property of a ListBox
Summary: No access to the ListSource property of a ListBox
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: 4.1.13
Hardware: All All
: P5 (lowest) Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-02-13 17:44 UTC by Jean-Michel COSTE
Modified: 2023-02-15 02:04 UTC (History)
4 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

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

Note You need to log in before you can comment on or make changes to this issue.
Description Jean-Michel COSTE 2023-02-13 17:44:38 UTC 
Created attachment 87170 [details]
A Base file to show the bug

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.""
It works on a ComboBox.
Comment 1 oooforum (fr) 2023-02-14 07:43:57 UTC 
You are in wrong place here. This is a bug tracking system and not a help desk.

If you have some difficulties to use OpenOffice, the best way is to go on our
mailing list or community forum:
https://www.openoffice.org/support/


You should read the API documentation or Devguide. ListSource property for a Listbox control wait an array.
Comment 2 Jean-Michel COSTE 2023-02-14 10:38:41 UTC 
You didn't understand my message?
I have no difficulty with OpenOffice, and I'm not new to macros and the API.
The process I describe worked with Ooo 4.1.12, but no longer works with version 4.1.13.
At least take the time to test my example instead of making childish reflections...
Comment 3 Czesław Wolański 2023-02-14 11:37:46 UTC 
You weren't kind enough to mention in your report
that the "process worked with Ooo 4.1.12".
With my installations of AOO 4.1.12 I get the runtime error
("Object variable not set").

The suggestion by oooforum's (fr)
solves the problem (checkbox & command button).

BTW:
your file "ListSource-EN.odb" appears be created by LibreOffice.
I assume the same file is attached to the report
filed with LibreOffice Bugzilla i.e. tdf#153599
("No access to the ListSource property of a ListBox").
https://bugs.documentfoundation.org/show_bug.cgi?id=153599
Comment 4 Matthias Seidel 2023-02-14 12:40:29 UTC 
So this is not a regression, not a bug in AOO, but a mistake in the BASIC macro.

Closing this issue now...