• Do not register here on develop.twiki.org, login with your twiki.org account.
• Use View topic Item7848 for generic doc work for TWiki-6.1.1. Use View topic Item7851 for doc work on extensions that are not part of a release. More... Close
• Anything you create or change in standard webs (Main, TWiki, Sandbox etc) will be automatically reverted on every SVN update.
Does this site look broken?. Use the LitterTray web for test cases.

Item5471: SpreadSheetPlugin: The character 0 cannot be replaced using the REPLACE-funtion

Item Form Data

AppliesTo: Component: Priority: CurrentState: WaitingFor: TargetRelease ReleasedIn
Extension SpreadSheetPlugin Normal Closed   patch 4.3.0

Edit Form Data

Reported By:
Applies To:
Current State:
Waiting For:
Target Release:
Released In:


Replace Function does not work properly in SpreadSheetPlugin.

Trying to replace the character 0 within a text string, using the replace funtion of the SpreadSheetPlugin does not work.

For example:

 %CALC{"$REPLACE(Sebastian, 2, 1, .)"}% 

results in:

So this works fine.

2nd example:

 %CALC{"$REPLACE(11xxx, 2, 1, .)"}% 

results in:

So this works fine, too.


 %CALC{"$REPLACE(10xxx, 2, 1, .)"}% 

results in:

So here it does not work.

-- TWiki:Main/SebastianKlus - 24 Mar 2008

Sebastian is right. The 0 doesn't get replaced if the num parameter is 1. Strange effect. I don't understand why the substr( ) code in SpreadSheetPlugin/Calc.pm does even work. Peter will know.

-- TWiki:Main.FranzJosefGigler - 25 Mar 2008

Found the support topic TWiki:Support.UnableToForceLinkNameTo0 which shows similar effect in totally different context. 0 seems to be somehow problematic.

-- TWiki:Main.FranzJosefGigler - 14 Apr 2008

Bug confirmed, needs to be fixed. $FIND, $SEARCH and $SUBSTITUTE seem to have the same bug.

-- TWiki:Main.PeterThoeny - 16 Apr 2008

Fixed in TWikirev:17894 and TWikirev:17895

-- TWiki:Main.PeterThoeny - 25 Mar 2009

Closing this after TWiki 4.3.0 release

-- TWiki:Main.SopanShewale - 06 Apr 2009

Summary SpreadSheetPlugin: The character 0 cannot be replaced using the REPLACE-funtion
ReportedBy TWiki:Main.SebastianKlus
Codebase 4.2.0
SVN Range

AppliesTo Extension
Component SpreadSheetPlugin
Priority Normal
CurrentState Closed

Checkins TWikirev:17894 TWikirev:17895
TargetRelease patch
ReleasedIn 4.3.0
Edit | Attach | Watch | Print version | History: r10 < r9 < r8 < r7 < r6 | Backlinks | Raw View |  Raw edit | More topic actions
Topic revision: r10 - 2009-04-06 - SopanShewale
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2021 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback