Issue 85035 - VBA: replace function is not supported
Summary: VBA: replace function is not supported
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: pflin
QA Contact: Unknown
: 77452 (view as issue list)
Depends on:
Reported: 2008-01-07 05:09 UTC by pflin
Modified: 2017-05-20 09:32 UTC (History)
1 user (show)

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

patch for implementation (3.35 KB, text/plain)
2008-02-28 05:35 UTC, pflin
no flags Details
test document (63.00 KB, text/plain)
2008-02-28 05:35 UTC, pflin
no flags Details
test document for QA (9.87 KB, text/plain)
2008-04-24 03:48 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-01-07 05:09:48 UTC
In VBA, the replace function replaces a sequence of characters in a string with
another set of characters (a number of times). For example:

Dim MyString
' A binary comparison starting at the beginning of the string.
MyString = Replace("XXpXXPXXp", "p", "Y")
' Returns "XXYXXPXXY".
' A textual comparison starting at position 3.
MyString = Replace("XXpXXPXXp", "p", "Y", 3, -1, 1)
' Returns "YXXYXXY".

the replace function is not supported in OOo basic
Comment 1 pflin 2008-01-07 05:10:31 UTC
will add to npower10
Comment 2 pflin 2008-02-28 05:35:00 UTC
Created attachment 51768 [details]
patch for implementation
Comment 3 pflin 2008-02-28 05:35:47 UTC
Created attachment 51769 [details]
test document
Comment 4 noel.power 2008-04-22 13:23:06 UTC
fong mark as fixed if it is so ( which I presume it is )
Comment 5 pflin 2008-04-22 14:33:40 UTC
fixed in npower10
Comment 6 pflin 2008-04-24 03:48:55 UTC
Created attachment 53155 [details]
test document for QA
Comment 7 sled10guy 2008-06-16 22:39:49 UTC
Verified in the following npower10 build:

Comment 8 sled10guy 2008-06-25 00:13:35 UTC
Verified in the following npower10 builds with the updated test document:

Comment 9 ab 2009-01-29 14:02:53 UTC
*** Issue 77452 has been marked as a duplicate of this issue. ***
Comment 10 thorsten.ziehm 2009-07-20 14:55:58 UTC
This issue is closed automatically and wasn't rechecked in a current version of
OOo. The fixed issue should be integrated in OOo since more than half a year. If
you think this issue isn't fixed in a current version (OOo 3.1), please reopen
it and change the field 'Target Milestone' accordingly.

If you want to download a current version of OOo =>
If you want to know more about the handling of fixed/verified issues =>
Comment 11 thorsten.ziehm 2009-07-20 15:36:32 UTC
Sorry this issue was wrongly closed. This issue will be reopened automatically.
And will be set after that back to fixed/verified.
Comment 12 thorsten.ziehm 2009-07-20 15:40:50 UTC
Set to state 'fixed'.
Comment 13 thorsten.ziehm 2009-07-20 15:44:52 UTC
Set back to state 'verified/fixed'.

Again. Sorry for the mass of mails.