https://bugs.freedesktop.org/show_bug.cgi?id=71072
Priority: medium
Bug ID: 71072
Assignee: [email protected]
Summary: Other: VBA macro: ListFillRange not available
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA PossibleRegression
Status: UNCONFIRMED
Version: Inherited From OOo
Component: Spreadsheet
Product: LibreOffice
Created attachment 88387
--> https://bugs.freedesktop.org/attachment.cgi?id=88387&action=edit
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
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
