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

List:       koffice-devel
Subject:    Re: kspread formula names
From:       Werner Trobin <trobin () kde ! org>
Date:       2002-02-04 9:45:25
[Download RAW message or body]

Laurent Montel wrote:
> 
> Le Sunday 03 February 2002 05:47, John Dailey a écrit :
> > Does anybody see a problem with me changing all the KSpread function names
> > to lower case and then finding a way to make the formulas case insensative
> > (so existing files will still be fine)?
> 
> Yes me !
> No we must keep compatibility with old file.
> A lot of people were created kspread file with specific kspread function name
> (for example SUM) and if you change to lower they can read their files.
> 
> >  As of now it's confusing in the
> > formula list to have 2 alphabetical lists -- one for upper case and one for
> > lower case and I can see users (including myself) getting frustrated
> > because I typed SUM instead of sum and roundup instead of ROUNDUP.
> >
> > How is internationalization handled with these formula names?

Not at all. Please check the list archieves, we already had a discussion
about that.

> > Also, I'm trying to think how to make the formula names case insensative.

I don't know whether that's a good idea. K(O)Script was designed as
programming language, which is case sensitive (like C, C++,...). The
"primitives" of that language, like if and so on also are lowercase
and I think it should remain that way.

> > What else besides the kspread formulas uses the koscript parsing code?
> > Would it make sense to change the code in the lib/koscript directory to be
> > case insensative for formula names?
> 
> It's a good idea to change koscript to make case insensative for formula name.

Hmm... I don't know, but I would just make everything lowercase.
Else you have a case sensitive if and a case insensitive SUM/sum/Sum/...
Adding iF,If,IF for all keywords doesn't seem like a good idea to
me. Building a case insensitive lexer will introduce bugs as the "language"
wasn't designed to be case insensitive.

> Werner worked on, but he didn't success...

Well, what I worked on was the Unicode bug of KoScript, which prevented
formulas like '=A1+"some non-latin1 string"'.
I still think that having case insensitive functions isn't the way to
go.

We also decided not to translate function names, as it would prevent
exchanging KSpread documents between, say, Greece and France.

Ciao,
Werner
_______________________________________________
koffice-devel mailing list
koffice-devel@mail.kde.org
http://mail.kde.org/mailman/listinfo/koffice-devel
[prev in list] [next in list] [prev in thread] [next in thread]