Issue 90541 - function call with "Not" parameter without brackets fails
Summary: function call with "Not" parameter without brackets fails
Status: CLOSED FIXED
Alias: None
Product: App Dev
Classification: Unclassified
Component: scripting (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All All
: P3 Trivial
Target Milestone: ---
Assignee: ab
QA Contact: Unknown
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-06-10 04:28 UTC by pflin
Modified: 2013-02-24 21:01 UTC (History)
1 user (show)

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


Attachments
patch for fixing this defect (487 bytes, text/plain)
2008-06-10 04:30 UTC, pflin
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description pflin 2008-06-10 04:28:13 UTC
When attempting to run the attached excel macro in OOo, a message box appears:
"Basic syntax error: Unexpected symbol: Not". But it runs OK in MS Office.

The attached macro:

Sub main()
    Dim aBool As Boolean
    aBool = True
    myFunction Not aBool ' fail in OOo
End Sub

Function myFunction(aBool As Boolean)
    If aBool Then
        MsgBox "True"
     Else
        MsgBox "False"
     End If
End Function
Comment 1 pflin 2008-06-10 04:30:48 UTC
Created attachment 54348 [details]
patch for fixing this defect
Comment 2 pflin 2008-06-10 04:32:40 UTC
pflin -> ab, please have a look. This patch is based on your
vba-brackets-params-fix.diff.
Comment 3 ab 2008-07-03 13:28:17 UTC
DEFECT -> PATCH, STARTED, 3.x
Comment 4 ab 2008-08-01 07:00:33 UTC
Obviously setting this to STARTED failed and I didn't see it, next try...
Comment 5 ab 2008-08-29 15:00:42 UTC
ab: Patch looks ok and makes sense.
Comment 6 pflin 2008-09-01 10:36:40 UTC
added in cws pflin10
Comment 7 kenyu 2008-09-22 08:18:43 UTC
Verified
Comment 8 kenyu 2008-10-13 07:25:42 UTC
Verified
Comment 9 vladimir_hitekschool 2009-04-03 18:36:08 UTC
Issue 90541 has been fixed in master version OOo-dev 3.1 .0 (OOO310m8 
Build:9395) for Windows XP and can be closed.
Comment 10 oleghitekschool 2009-04-05 20:31:08 UTC
The Issue checked and closed by HitekSchool interns, Group 1 - as part of an 
Issue Hunting Party.