[prev in list] [next in list] [prev in thread] [next in thread] 

List:       koffice
Subject:    Re: removing commas from a cell in kspread
From:       Nicolas Goutte <nicog () snafu ! de>
Date:       2002-06-20 19:54:54
[Download RAW message or body]

On Thursday 20 June 2002 20:34, Sepp Käsbauer wrote:
> Am Dienstag, 18. Juni 2002 09:22 schrieb Bo Thorsen:
> > On Monday 17 June 2002 00:25, John Dailey wrote:
> >
> > Actually this made me think that it would be interesting to have pipes to
> > sed in cells. Something like this:
> >
> > =D13+D14 | sed "s/,//"
> >
> > would solve this problem in a completely generic way instead of adding
> > any number of adhoc solutions to parts of this problem.
>
> This would be of great value to me in another case of calculation.
> I have Date and Time values given like: 2002-06-20T20:23:00
> I have to convert the date and time to another format with a utility called
> convcal included in grace.
> it works like
> convcal 2002-06-20T20:10:05
>  2452446.34033565
>
> and reverse
>
>  convcal 2452446.34033569
> 2002-06-20T20:10:05.004
>
> At the moment i have to export the column to a text file and convert the
> time with a loop in a bash script.
>
> Pipes to external programms would be very appreciated.

... and could be a security problem, unfortunately.

Imagine for example a Trojan horse KSpread document that attacks your files 
with this external program. Not nice, is it?

As KOffice has the "no script in document" policy, I doubt that your wish can 
be done.

>
> > If you don't want to use the shell like approach to this (which would
> > make the parser more, well, interesting) this would also be fine:
> >
> > =SED(D13+D14, "s/,//")
> >
> > If this sounds interesting, I might take a stab at implementing it
> > myself. What do you think?
> >
> > Bo.

Have a nice day/evening/night!


____________________________________
koffice mailing list
koffice@mail.kde.org
To unsubscribe please visit:
http://mail.kde.org/mailman/listinfo/koffice
[prev in list] [next in list] [prev in thread] [next in thread]