Find the answer to your Linux question:
Results 1 to 3 of 3
I'm using KOffice 1.42 / KDE 3.5RC1 / SUSE Linux 10.0 I entered the date 2005-November-26 as 2005-11-26 (ISO standard format) in a new empty spreadsheet in KSpread. Selecting that ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Aug 2005
    Location
    13 N 80 E
    Posts
    77

    Weird behaviour of KSpread 1.42 with dates


    I'm using KOffice 1.42 / KDE 3.5RC1 / SUSE Linux 10.0

    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?

  2. #2
    Linux Engineer
    Join Date
    Jan 2005
    Location
    Chicago (USA)
    Posts
    1,028
    I think it's a lack of considering that someone would try to do that. Report it as a bug at http://bugs.kde.org/

  3. #3
    Just Joined!
    Join Date
    Aug 2005
    Location
    13 N 80 E
    Posts
    77
    Reported as bug 117252.

  4. $spacer_open
    $spacer_close

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •