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

List:       koffice
Subject:    Re: Kspread: Date 00 = 1900 ?
From:       montel laurent <montell () club-internet ! fr>
Date:       2000-09-18 19:51:15
[Download RAW message or body]

Le lun, 18 sep 2000, Marko Mikulicic a écrit :
> Laurent montel wrote:
> > hi,
> >
> > Marko Mikulicic wrote:
> > > 1. datum 00 is mapped to 1900. Maybe it should be added a "swich" year,
> > >     like in win98, wich tells after wich two digit year number to use
> >
> > It's not me who implement date, it's qt.
> > In qdate when you have just 2 digits it's 1900.
>
> That's bad, IMHO.
> Too bad that the trolls have released 2.2 final, I don't think
> they fix this soon :-(
>
> > > 19xx and below
> > >     use 20xx.
> > > 2. Is it possible to use a more flexibile date parser ?
> > >     For example I use the hr date format %d.%m.%Y.  (note the period at
> > > the end)
> > >     When writing a date in the cell without that dot it will not
> > > reckognize it as a date,
> > >     even when selecting it manually from the "cell format" menu.
> >
> > For the moment kspread recognize just dates which are in local format.
> > For exemple in France it's 2/2/99
> > But I don't know deutch date format.
>
> 2.2.99

Ok

>
> > But if you read into kcontrol->format you can see date format.
>
> Croatian locale are "2.2.99. "
> but it will not accept it if the last period is missing.
> Croatian, and maybe some east european nations, dates are a problem,
> because of the dot at the end: it must be displayed, but I could be avoided
> to enter.

Yes but for kspread I used klocale::readDate()
This function used information in kcontrol.
So I can't change it.

>
> (this would be a common mistake).
> In kcontrol the date format for croatia is wrong (as I maybe for
> serbia,makedonia,...)
> it should have a "." at the end. ( where should I address this bug?)

Send a mail to:
bieker@stud.ntnu.no

(Sorry I don't remember his name)


>
> > > 3. Add an action and a toolbar item for the action "datum format"
> >
> > I don't understand .
>
> In the toolbar there's an button that sets the cell format to Percent,
> Money,...
> but there isn't a button that forces the cell to be a date.
> Usually there is no need for this because the date is recognized
> automagically,
> but, in the case it is not, it could be forced to a date

Ok, but I can't force a cell to be a date.
In kspread it's an automatic detection.

>
> > > 5. The conditional cell attributes operates only on integers, but it
> > > would be
> > >     nice if it could operate also on date types (or strings). I see
> > > that there are only
> > >     relational operation wich are already implemented somewhere for all
> > > datatypes, since
> > >     sorting works. Also a "contains" string operation would be great.
> > >     This little thing boosts productivity incredibly, especially if one
> > > is used to work.
> > >     on printed pages.
> > >     (One step further, but not really critical, would be have a list of
> > > saved "conditions"
> > >     which can be applied fast)
> >
> > It's a good idea, but after kde2.0.
>
> Sure.
>
>
> Marko

bye

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