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

[Eike Rathke <erack@sun.com>]

Hi Brad,

On Saturday, 2007-01-13 10:35:48 +1100, Brad Hards wrote:

> > > =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.

Please note that the 'all' in "all except KSpread" includes Excel.
Kspread is the only application that does not produce "121ab12".

> 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.

Kspread could be modified to match the spec, but the spec doesn't need
to be changed for this ;-)

  Eike

-- 
 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS