You are not logged in.

Weird behaviour of KSpread 1.42 with dates

jamadagni

Beginner

  • "jamadagni" started this thread

Posts: 4

Location: 13 N 80 E

  • Send private message

1

Saturday, November 26th 2005, 4:04pm

Weird behaviour of KSpread 1.42 with dates

I entered the date 2005-November-26 as 2005-11-26 (ISO standard format) in a new empty spreadsheet in KSpread. Selecting that cell with a single-left-click, I clicked and dragged down the handle at the bottom-right corner of the cell selection border. This is what I got:

2005-11-26
2006-2006-2006
2007-2007-2007
2008-2008-2008
2009-2009-2009
2010-2010-2010

and so on.

A similar experiment gave me:

10-05-2005
38,483
38,484
38,485
38,486
38,487

Doing the same with OOo Calc would give me a list of dates like so:

2005-11-26
2005-11-27
2005-11-28
2005-11-29
2005-11-30
2005-12-01
2005-12-02

So why is KSpread behaving like this? Shall I report this as a bug?

[Thanks - this is my first post on this forum. :)]

This post has been edited 1 times, last edit by "jamadagni" (Nov 26th 2005, 4:05pm)

bram85

Professional

Posts: 948

Location: Eindhoven

Occupation: Software Engineer

  • Send private message

2

Saturday, December 10th 2005, 10:57am

RE: Weird behaviour of KSpread 1.42 with dates

Date handling has been improved after KOffice 1.4. Even dragging them should be fixed if I remember correctly. So for now there's no sollution but waiting for KOffice 1.5 (is scheduled for spring 2006)
Bram Schoenmakers
KDE Netherlands (www.kde.nl)

jamadagni

Beginner

  • "jamadagni" started this thread

Posts: 4

Location: 13 N 80 E

  • Send private message

3

Monday, December 12th 2005, 3:05am

RE: Weird behaviour of KSpread 1.42 with dates