Issue 96159 - VBA InStrRev is remembered by OpenOffice Basic
Summary: VBA InStrRev is remembered by OpenOffice Basic
Status: ACCEPTED
Alias: None
Product: App Dev
Classification: Unclassified
Component: scripting (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: PC All
: P3 Trivial
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-11-12 15:16 UTC by bmarcelly
Modified: 2017-05-20 11:29 UTC (History)
2 users (show)

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

Attachments
Use of VBA function InStrRev() (12.66 KB, application/vnd.oasis.opendocument.text)
2008-11-12 15:18 UTC, bmarcelly 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description bmarcelly 2008-11-12 15:16:43 UTC 
The Basic function InStrRev is a VBA instruction, not a OOoBasic instruction.
It has been introduced for VBA compatibility, and it is recognized in a Basic module 
with Option VBASupport 1.
This works.

However, once InStrRev has been executed, Basic accepts its use in any other module, 
even pure OOoBasic modules. This new instruction stays available until OpenOffice is 
closed.
The consequence is a phantom instruction in OOoBasic: an instruction which will be 
supported or not supported, depending on a particular macro which may have been 
executed a long time ago, for example in a document. If a macro developer uses such 
instruction, supposing it is fully supported in OOoBasic, it may work or throw an 
error depending on previous activity.

Next attachment shows the problem.

Please investigate if there are other VBA instructions with the same implementation 
problem.

Issue 27904 (current Milestone OOo Later) can be interpreted as introducing the full 
support of InStrRev by OOBasic (which would be better and would resolve this issue).
Comment 1 bmarcelly 2008-11-12 15:18:08 UTC 
Created attachment 57942 [details]
Use of VBA function InStrRev()
Comment 2 kay.ramme 2008-11-13 08:01:14 UTC 
Andreas, please have a look ...
Comment 3 ab 2008-11-13 10:20:11 UTC 
ab->bmarcelly: I think you are right. I will check if this excluding mechanism
still (or at all) makes sense. If not we should remove it. -> STARTED, 3.x
Comment 4 bmarcelly 2011-04-07 09:00:10 UTC 
Same problem with function StrReverse

Dim s As String
s = "abcdef GHIJK"
MsgBox StrReverse(s)

Here also, this nice function should be plainly supported by OOoBasic.
Comment 5 Marcus 2017-05-20 11:29:30 UTC 
Reset assigne to the default "issues@openoffice.apache.org".