On Thursday 07 June 2007 22:40:30 Leonard Mada wrote:
The current Formula Specification and OOo implementation thereof have a
very weak support for strings. Even fundamental string functions are
lacking This makes the use of ODF a poor choice for many research
fields, where a lot of the data is in text format.
This is not really an ODF fileformat problem, this is more a problem that
the implementations of the format should address.
In particular, I know that KSpread is implementing the full spec and is
also combining it with a scripting language to access the cells from a
available in the development version.
This and your post about distinct values seem to be much easier
implemented using such a script.