Re: [office-comment] [formula] Comments on SUBSTITUTE()

[Brad Hards <bradh@frogmouth.net>]

On Saturday 13 January 2007 05:29, Eike Rathke wrote:
> Hi Brad,
>
> On Friday, 2006-12-22 16:58:34 +1100, Brad Hards wrote:
> > I am concerned that the optional argument (Which) reflects oocalc and
> > gnumeric, but not excel or kspread (which say "number of replacements")
>
> In the function description all say the 4th parameter specifies which
> occurence/instance is to be replaced. I must admit I have an older
> version of Kspread, so maybe the wording there changed to reflect
> reality..
>
> > As an example, the test case from the spec that looks like:
> > =SUBSTITUTE("121212";"2";"ab";2)
> > produces 121ab12 with oocalc and gnumeric, but 1ab1ab12 with kspread.
>
> All except Kspread produce "121ab12", this seems to be an error of
> KSpread.
I am concerned about being able to import from excel.

Might it be possible to have a SUBSTITUTE variant (LEGACY.SUBSTITUTE or 
something like that) that works the way excel does? Then kspread could just 
be modified to match the spec.

Brad