Bug 71071 - Other: VBA macro: string tables: dimension error
Summary: Other: VBA macro: string tables: dimension error
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: BASIC (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: Other Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords: possibleRegression
Depends on:
Blocks:
 
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:

Attachments
The example file descriped. (1.17 MB, application/vnd.ms-excel)
2013-10-31 00:52 UTC, Jani Saarenpää 		Details
View All Add an attachment (proposed patch, testcase, etc.)

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.

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]