Issue 85035 - VBA: replace function is not supported
Summary: VBA: replace function is not supported
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: pflin
QA Contact: Unknown
URL:
Keywords:
: 77452 (view as issue list)
Depends on:
Blocks:
 
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: ---

Attachments
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
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 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:

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

O3-build-2457-npower10-install_set
Win-XP2-503-npower10-install_set.zip
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 =>
http://download.openoffice.org/index.html
If you want to know more about the handling of fixed/verified issues =>
http://wiki.services.openoffice.org/wiki/Handle_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.