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

List:       kde-commits
Subject:    Re: koffice/filters/olefilters/excel97
From:       Laurent Montel <lmontel () mandrakesoft ! com>
Date:       2001-05-18 8:50:02
[Download RAW message or body]

Le Vendredi 18 Mai 2001 10:32, Malte Starostik a écrit :
> On Friday 18 May 2001 10:23, Laurent Montel wrote:
> > Le Jeudi 17 Mai 2001 23:55, CVS by wildfox a écrit :
> > > koffice/filters/olefilters/excel97 xmltree.cc,1.48,1.49
> > > Author: wildfox
> > > Thu May 17 21:54:44 UTC 2001
> > > In directory cvs.kde.org:/var/tmp/cvs-serv25442/excel97
> > >
> > > Modified Files:
> > > 	xmltree.cc
> > > Log Message:
> > > hmmm i'm at the second file of malte's _BIG_ testcase
> > > and already found sth. easy, interessting:
> > >
> > > +                   case 221:  // today
> > > +                       parsedFormula.append("currentDate()");
> > > +                       parsedFormula.append("");
> > > +                       break;
> > >
> > > laurent: i don't want 17 May 2001, but 17.05.2001
> > > How to do that via formulas?
> >
> > Hi,
> > you can't for the moment get this format via formulas.
> > You can have 17 May 2001, but not 17.05.2001 .
> > I will add this function in kspread.
>
> BTW, I noticed that in one doc (I think it was this one),
> there were situations like:
> 	A	B	C
> 1	caption
> 2	1
> 3	2
> 4	3
> 5	=sum(A1:A5)
>
> and A5 showed #### because the text cell containing the caption was
> included in the sum range. Did this happen during the import from .xls
> format or is that just a thing where excel ignores the caption but kspread
> makes the expression fail?


If you write this formula, kspread expression fail.
For the moment I don't have time to fix problem when you try to insert a type 
different of formula parameter.
I will try before koffice1.1



> -Malte

bye

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