Re: Strings in gnumeric: implementing a gawk pipeline

[Priit Laes <amd store20 com>]

Ühel kenal päeval, T, 2007-01-16 kell 20:06, kirjutas Morten Welinder:
> Changing the behaviour of search functions is not a good idea as
> some spreadsheets surely depend on the existing, hopefully Excel
> compatible, behaviour.
>
> That leaves you pretty much four options:
>
> 1. Write your own plugin with search functions that do what you
>     want.  That's actually not too hard, but is not a generally
>     useful option.
>
> 2. Wait for us to implement scripting.  That's basically what you
>     need here.
>
> 3. Write a plugin that allows you to feed a range to a script and read
>     the converted range from the output.  The best way for that
>     probably is to file an enhancement request at bugzilla.gnome.org
>     as the details probably should be spec'd out with some care.
>
> 4. Write a script that reads and produces Gnumeric's xml format.
>     That's not too hard either.
Yeah.. reading and write'ing structured data in formatted in XML isn't
hard... Last week I did some quick stuff using PHPs SimpleXML API. So
take this API, parse the file, then use the proc_open() function to
communicate with gawk, read the output and done you are...

...or...

5. Hire someone to write it for you - propose the bounty.
    If it really is that important for your job and even gets lots of
your work done, then do something about it. Most of the people in this
list aren't interested interested in implementing niche features unless
it is useful for them too.

Cheers,
Priit