To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=101434


User npower changed the following:

                What    |Old value                 |New value
================================================================================
               Component|vba                       |scripting
--------------------------------------------------------------------------------
              QA contact|iss...@vba                |iss...@scripting
--------------------------------------------------------------------------------
                 Summary|VBA:  CALC finds inexisten|":" not handled when it ap
                        |t syntax issues in VBA - w|pears immediately after "t
                        |orks fine in EXCEL        |hen"
--------------------------------------------------------------------------------




------- Additional comments from [email protected] Wed May  6 08:49:56 
+0000 2009 -------
>The VBA language allows (legally) to write as many statements as the user wants
>on the same line. When doing this, statements must be separated by a colon.
ahem, OpenOffice basic is not VBA, it does have a VBA compatibility mode,
regardless both OpenOffice basic and VBA share many common syntax, in this case
it appears that handling of ':' for appending separate statements could be
improved e.g. openoffice basic seems not to handle a ":" immediately after
"then"  ( as I have changed the bug summary to state )

>I did try the suggested correction before posting this issue on Apr 29.
so, this is exactly the bug that you are reporting, why didn't you state that
initially?

->ab can I pass this one to you ( well I just did ;-) )

>Then, I removed the colons and put the following statements on new lines. The
>initial syntax error on "j" disappeared but things (errors) in general became
>much worse and incomprehensible.
so, as pointed out by rainerbielefeld you need to look at the guidelines for
bugs, you need to help us help you, one bug per problem is the only sensible way
to ensure help to clarify/track/fix/address each individual issue. Furthermore
you can help by trying to breakdown those bugs by providing the smallest
possible example that demonstrates the problem in a reproducible way. You
understand the example that you provide better than we can and you are in a
position to break it down better than us. Please help with that and open
seperate issue for those you find.

---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to