Bug 71071 - Other: VBA macro: string tables: dimension error
Summary: Other: VBA macro: string tables: dimension error
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: BASIC (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: Other Linux (All)
: medium normal
Assignee: Not Assigned
Whiteboard: BSA
Keywords: possibleRegression
Depends on:
Reported: 2013-10-31 00:52 UTC by Jani Saarenpää
Modified: 2015-12-15 10:53 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

The example file descriped. (1.17 MB, application/vnd.ms-excel)
2013-10-31 00:52 UTC, Jani Saarenpää

Note You need to log in before you can comment on or make changes to this bug.
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.

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: 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)