Bug 71072

Summary: Other: VBA macro: ListFillRange not available
Product: LibreOffice Reporter: Jani Saarenpää <jani.saarenpaa>
Component: BASICAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED NOTABUG QA Contact:
Severity: normal    
Priority: medium CC: jmadero.dev
Version: Inherited From OOo   
Hardware: Other   
OS: Linux (All)   
Whiteboard: BSA
i915 platform: i915 features:
Attachments: The example file descriped.

Description Jani Saarenpää 2013-10-31 01:01:41 UTC 
Created attachment 88387 [details]
The example file descriped.

Problem description: 
ListFillRange property not available in Libreoffice.

Example:
http://www.st.com/web/en/catalog/tools/PF257927
STSW-STM32091.zip => STM32F4xx_Clock_Configuration_V1.1.0.xls

Steps to reproduce:
1. Enable macros
2. Open the file described.
3. get bug 71071.
4. bypass this by changing the pointed line:
If (PLLUSB_table(i1, i2, i3) Like "1") Then
to 
If (PLLUSB_table(1, i1, i2, i3) Like "1") Then
5. Change the configuration mode to either "wizard" or "expert"
6. Get the error mentioned in current behaviour and a pointer to the line:
ComboBox15.ListFillRange = "$AL$19:$AL$26"

Current behavior:
"BASIC runtime error.
'423'
ListFillRange"
which is basically saying that:
"423 Property or method not found"

Expected behavior:
The property works as in the other popular office product:
"Returns or sets the worksheet range used to fill the specified list box. Setting this property destroys any existing list in the list box. Read/write String."
http://msdn.microsoft.com/en-us/library/office/aa175677%28v=office.11%29.aspx
Operating System: Ubuntu
Version: Inherited From OOo
Last worked in: 4.1.1.2 release
Comment 1 Joel Madero 2014-06-21 00:07:40 UTC 
This is not a bug - we don't support VBA script. This is known and no need to keep this open to remind us of that. At some point maybe a developer will take on that task but we recommend using LibreOffice Basic or python.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.