From koffice-devel  Fri Dec 22 10:47:46 2006
From: Brad Hards <bradh () frogmouth ! net>
Date: Fri, 22 Dec 2006 10:47:46 +0000
To: koffice-devel
Subject: Re: Fwd: [office-comment] [formula] Comments on SUBSTITUTE()
Message-Id: <200612222147.53481.bradh () frogmouth ! net>
X-MARC-Message: https://marc.info/?l=koffice-devel&m=116678452617180
MIME-Version: 1
Content-Type: multipart/mixed; boundary="--===============1605321826=="

--===============1605321826==
Content-Type: multipart/signed;
  boundary="nextPart4947772.alIb854vdE";
  protocol="application/pgp-signature";
  micalg=pgp-sha1
Content-Transfer-Encoding: 7bit

--nextPart4947772.alIb854vdE
Content-Type: text/plain;
  charset="iso-8859-15"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

On Friday 22 December 2006 19:31, Boudewijn Rempt wrote:
> On Friday 22 December 2006 07:20, Brad Hards wrote:
> > This is a somewhat difficult situation: same formula name used by
> > different spreadsheets, same number of arguments, different semantics,
> > different outcome.
> >
> > Either we keep the current behaviour (which breaks things when we import
> > from openoffice or gnumeric) or switch to using the openformula behavio=
ur
> > (which will prevent us importing from excel, and will break compatibili=
ty
> > with the previous versions of kspread).
> >
> > Any thoughts on how to work forward?
>
> Would it be possible to make the OpenFormula way the default and convert =
to
> that from Excel in the import filter? Or is that even a silly suggestion?
Actually, maybe this could be made to work, if combined with Inge's idea.
We need two functions:
LEGACY.SUBSTITUTE() which works like kspread 1.6 and Excel, and SUBSTITUTE(=
)=20
which works like openoffice and gnumeric. We just need to get=20
LEGACY.SUBSTITUTE() into the openformula spec, and then handle the coversio=
n=20
in the import filters.

Brad

--nextPart4947772.alIb854vdE
Content-Type: application/pgp-signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)

iD8DBQBFi7fZGwwszQ/PZzgRAjYIAJ942T1mywIgWo0WwsFHgezARbjs2gCgoL0V
3Egf6GptPv2DIWc3vwKbfqg=
=VC6N
-----END PGP SIGNATURE-----

--nextPart4947772.alIb854vdE--

--===============1605321826==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
koffice-devel mailing list
koffice-devel@kde.org
https://mail.kde.org/mailman/listinfo/koffice-devel

--===============1605321826==--