The SUBSTITUTE function doesn't return the correct result when text = old and replace is empty.
For example, I expect the following to produce an empty result:
This topic: Tasks > Item1072 > SpreadSheetPlugin > Item4835
Topic revision: 08 Jan 2009, KwangErnLiew
%CALC{"$SUBSTITUTE(Public,Public)"}%
Instead it produces the string
Note thatPublic
%CALC{"$SUBSTITUTE(Public,Public,Foo)"}% -- TWiki:Main/DiabJerius - 16 Oct 2007 yes this has also annoyed me And there is similar problem with REPLACE which cannot return a number 0 or an empty string either even though there can be good use for both in applications. Fixing. -- KennethLavrsen - 06 Jan 2009Foo
| ItemTemplate edit | |
|---|---|
| Summary | SpreadSheetPlugin functions SUBSTITUTE and REPLACE cannot return number 0 or empty string |
| ReportedBy | TWiki:Main.DiabJerius |
| Codebase | trunk |
| SVN Range | TWiki-4.3.0, Fri, 12 Oct 2007, build 15261 |
| AppliesTo | Extension |
| Component | SpreadSheetPlugin |
| Priority | Normal |
| CurrentState | Closed |
| WaitingFor | |
| Checkins | Foswikirev:1774 |
| TargetRelease | patch |
| ReleasedIn | 1.0.0 |
This topic: Tasks > Item1072 > SpreadSheetPlugin > Item4835
Topic revision: 08 Jan 2009, KwangErnLiew
The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. see CopyrightStatement. 
