Bug 71071

Summary: Other: VBA macro: string tables: dimension error
Product: LibreOffice Reporter: Jani Saarenpää <jani.saarenpaa>
Component: BASICAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED NOTABUG    
Severity: normal CC: jmadero.dev
Priority: medium Keywords: possibleRegression
Version: Inherited From OOo   
Hardware: Other   
OS: Linux (All)   
Whiteboard: BSA
Crash report or crash signature: Regression By:
Attachments: The example file descriped.

Description Jani Saarenpää 2013-10-31 00:52:20 UTC 
Created attachment 88386 [details]
The example file descriped.

Problem description: 
Libreoffice does not seem to handle string table dimensions correctly in vba.

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 macross
2. Open the file described
3. get the error mentioned in current behaviour.
4. Pointer complaining the line: 
If (PLLUSB_table(i1, i2, i3) Like "1") Then
where the PLLUSB_table is defined as
Dim PLLUSB_table(0 To 61, 0 To 240, 0 To 3, 0 To 11) As String

Current behavior:
"BASIC syntax error.
Dimension specifications do not match."

Expected behavior:
No error. 
As I'm not an expert on vba I guess that the first dimension (size of 61) should be read as the lenght of the strings that are handled.
Operating System: Ubuntu
Version: Inherited From OOo
Last worked in: 4.1.1.2 release
Comment 1 Joel Madero 2014-06-21 00:08:22 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.
Comment 2 Robinson Tryon (qubit) 2015-12-15 10:53:50 UTC 
Migrating Whiteboard tags to Keywords: (possibleRegression)
[NinjaEdit]