[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: Re: [office-comment] [formula] Comments on SUBSTITUTE()
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
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]