You are not logged in.

Weird behaviour of KSpread 1.42 with dates

Dear visitor, welcome to KDE-Forum.org. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

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