Issue 76566 - vba compataibilty: syntax error compiling (parsing?) nested IF statements
Summary: vba compataibilty: syntax error compiling (parsing?) nested IF statements
Status: ACCEPTED
Alias: None
Product: App Dev
Classification: Unclassified
Component: scripting (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All All
: P4 Trivial
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-04-21 00:28 UTC by joebyrne
Modified: 2017-05-20 11:27 UTC (History)
3 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description joebyrne 2007-04-21 00:28:16 UTC
Found in NeoOffice 2.1, Patch 1 (which I assume uses OOO 2.1:

The following BASIC code generates syntax errors in Neo, but not in Excel.

If Len(str) > 1 Then If 2 = 1 Then str = Left(str, 2) Else str = Right(str, 2)
Else strTmp = Space(4 - Len(str))
Comment 1 cno 2007-04-24 01:01:21 UTC
interesting code :-)
You may want to use a ':' to separate the staments.
Comment 2 joebyrne 2007-04-24 01:29:56 UTC
But, the : separator does not work properly in IF statements, either. (See my
other bugs.)
Comment 3 cno 2007-04-24 01:44:42 UTC
Then If 2 = 1  ??
Maybe you can place a working example, just to be sure.
Comment 4 joebyrne 2007-04-24 02:55:29 UTC
It's a compile error. How the code executes isn't relevant at this point.
Comment 5 cno 2007-05-06 08:42:53 UTC
Sorry, this is not clear and sound.
Close as invalid
Comment 6 noel.power 2007-09-11 11:54:50 UTC
another one to track as some vba compatible syntax
Comment 7 noel.power 2007-09-11 11:55:12 UTC
.
Comment 8 ab 2007-09-25 09:14:59 UTC
STARTED
Comment 9 Martin Hollmichel 2007-12-07 12:13:37 UTC
set target to 3.x according to http://wiki.services.openoffice.org/wiki/Target_3x
Comment 10 Marcus 2017-05-20 11:27:45 UTC
Reset assigne to the default "issues@openoffice.apache.org".