big bug in OpenOffice (date format)? - Ubuntu

This is a discussion on big bug in OpenOffice (date format)? - Ubuntu ; greets! I have run across this bug for several versions now - it slowly crept up on me since it involves an operation I only do infrequently but finally tonight I have figured out when it occurs. I am wondering ...

+ Reply to Thread
Results 1 to 7 of 7

Thread: big bug in OpenOffice (date format)?

  1. big bug in OpenOffice (date format)?

    greets!

    I have run across this bug for several versions now - it slowly crept up
    on me since it involves an operation I only do infrequently but finally
    tonight I have figured out when it occurs.

    I am wondering if anyone else has experienced it? I will visit the
    OpenOffice site later when I have more time to rummage.

    take a row of dates in document A such as

    09-10 09-12 09-17 09-19 09-24 09-26

    paste them into document B (or using the spreadsheet, copy/move the sheet
    to A). the dates will be off in this way:

    9-11 9-13 9-16 9-18 9-23 9-25

    now maybe this is not a bug but is by design? the copy/paste/move
    operation took place on the following day but the dates don't always
    increment.

    but I also notice if I expand the field, the year is way off (2003).

    maybe there is some setting I am missing in OO. if so, I have missed it
    for yrs.

    I am on OOv2.2 right now. right now I am using Kubuntu 7.04 but my
    experience is mostly SuSE 10.2 and 10.1 where it also occurs and in
    earlier versions of OO.

    just wondered if anyone knows of this?

    inserting a table in Kubuntu also makes for a big blank area but that's a
    different, equally annoying and more frequently encountered problem. maybe
    a graphics card issue.

    Felmon




  2. Re: big bug in OpenOffice (date format)?

    On Fri, 19 Oct 2007 03:22:49 -0400 in
    pan.2007.10.19.07.22.45.331102@union.edu, felmon davis
    wrote:

    > greets!
    >
    > I have run across this bug for several versions now - it slowly crept up
    > on me since it involves an operation I only do infrequently but finally
    > tonight I have figured out when it occurs.
    >
    > I am wondering if anyone else has experienced it? I will visit the
    > OpenOffice site later when I have more time to rummage.
    >
    > take a row of dates in document A such as
    >
    > 09-10 09-12 09-17 09-19 09-24 09-26
    >
    > paste them into document B (or using the spreadsheet, copy/move the sheet
    > to A). the dates will be off in this way:
    >
    > 9-11 9-13 9-16 9-18 9-23 9-25
    >
    > now maybe this is not a bug but is by design? the copy/paste/move
    > operation took place on the following day but the dates don't always
    > increment.
    >
    > but I also notice if I expand the field, the year is way off (2003).
    >
    > maybe there is some setting I am missing in OO. if so, I have missed it
    > for yrs.
    >
    > I am on OOv2.2 right now. right now I am using Kubuntu 7.04 but my
    > experience is mostly SuSE 10.2 and 10.1 where it also occurs and in
    > earlier versions of OO.
    >
    > just wondered if anyone knows of this?


    I can't replicate such behaviour (using 2.3.0 (UK), and OpenSuSE 10.2), but
    then again, I'm not sure that my dates are being interpreted the same way
    as yours.

    Copying your dates as written, I get (converted to try and avoid
    ambiguities)

    9th Oct 2007, 9th Dec 2007, 1st Sep 2017, 1st Sep 2019, 1st Sep 2024 and
    1st Sep 2026 in both initial typed cells and the copies.

    What do you have set-up in Tools -> Options -> Language Settings ->
    Languages (or whatever the equivalent is in 2.2)?

    Stephan
    --
    Stephan Bird MChem(Hons) AMRSC
    Currently in Caernarfon, Wales

  3. Re: big bug in OpenOffice (date format)?

    On Fri, 19 Oct 2007 10:43:47 -0500, Stephan Bird wrote:

    > 9th Oct 2007, 9th Dec 2007, 1st Sep 2017, 1st Sep 2019, 1st Sep 2024 and
    > 1st Sep 2026 in both initial typed cells and the copies.


    this behavior seems oddball to me. why does the yr suddenly change? so my
    OO setup usually defaults 2003 on copy/paste/move.

    > What do you have set-up in Tools -> Options -> Language Settings ->
    > Languages (or whatever the equivalent is in 2.2)?


    nothing exotic: US English.

    it bothers me now you cannot reproduce the effect I first reported though
    the behavior of your setup has similarities.

    Felmon




  4. Re: big bug in OpenOffice (date format)?

    felmon davis wrote:

    > take a row of dates in document A such as


    > 09-10 09-12 09-17 09-19 09-24 09-26


    > paste them into document B (or using the spreadsheet, copy/move the
    > sheet to A). the dates will be off in this way:


    > 9-11 9-13 9-16 9-18 9-23 9-25


    This works flawlessly for me using Writer, totally replicating the top
    line without any alterations.

    If I open a spreadsheet instead and type 09-10 into a cell, it
    automatically converts it to 09/10/07.

    To fix this, right-click the cell(s) and select Format Cells from the
    menu. In the Numbers tab, choose Text instead of Date, or select a type
    of date display you'd like from the choices in the center window,
    although the 09-10 format isn't available on that list and I don't see
    a way to add it.

    If I right-click the cell and change the format to Text and then open a
    brand new spreadsheet to paste the info from the original one, it
    copies it identically including the Text formatting. All other cells in
    the new spreadsheet are at default, though, and will reformat your
    entries unless you manually go in and change their settings.

    > now maybe this is not a bug but is by design? the copy/paste/move
    > operation took place on the following day but the dates don't always
    > increment.


    I think they did it for convenience, making it so the program would
    guess how you intend to use a cell and doing the formatting for you so
    you don't have to. Some of us don't like to have things done for us,
    though. (:

    > but I also notice if I expand the field, the year is way off (2003).


    Now that is just *odd*. What do you see if you type date into a
    terminal window?

    --
    Little Girl
    http://littlergirl.googlepages.com/

    There is no spoon.

  5. Re: big bug in OpenOffice (date format)?

    On Sat, 20 Oct 2007 13:23:03 -0400, Little Girl wrote:

    > felmon davis wrote:
    >
    >> take a row of dates in document A such as

    >
    >> 09-10 09-12 09-17 09-19 09-24 09-26

    >
    >> paste them into document B (or using the spreadsheet, copy/move the
    >> sheet to A). the dates will be off in this way:

    >
    >> 9-11 9-13 9-16 9-18 9-23 9-25

    >
    > This works flawlessly for me using Writer, totally replicating the top
    > line without any alterations.
    >
    > If I open a spreadsheet instead and type 09-10 into a cell, it
    > automatically converts it to 09/10/07.
    >
    > To fix this, right-click the cell(s) and select Format Cells from the
    > menu. In the Numbers tab, choose Text instead of Date, or select a type
    > of date display you'd like from the choices in the center window,
    > although the 09-10 format isn't available on that list and I don't see a
    > way to add it.
    >
    > If I right-click the cell and change the format to Text


    heh, if I do _that_, I get machine-code representation of the dates. don't
    actually know if it is called that but I get the numbers the code then
    translates into specific formats, thus

    09-10 09-12 09-17

    becomes

    37873 37875 37880

    > and then open a brand new spreadsheet to paste the info from the
    > original one, it copies it identically including the Text formatting.
    > All other cells in the new spreadsheet are at default, though, and will
    > reformat your entries unless you manually go in and change their
    > settings.
    >
    >> now maybe this is not a bug but is by design? the copy/paste/move
    >> operation took place on the following day but the dates don't always
    >> increment.

    >
    > I think they did it for convenience, making it so the program would
    > guess how you intend to use a cell and doing the formatting for you so
    > you don't have to. Some of us don't like to have things done for us,
    > though. (:


    if I paste this representation of the dates into a new spreadsheet and
    reconvert, I get the yr '2003'! (and the day dates are shifted again
    also.)

    I also notice that if I copy A to B, I get the date distortion. if I then
    copy from B to C, then B == C.

    >> but I also notice if I expand the field, the year is way off (2003).

    >
    > Now that is just *odd*. What do you see if you type date into a terminal
    > window?


    date is fine.

    as far as I can see, this phenomenon only affects OO. I wonder if there is
    some internal time-setting? I cannot find anything under 'Options' like
    that.

    Felmon

  6. Re: big bug in OpenOffice (date format)?

    felmon davis wrote:

    > Little Girl wrote:
    > > felmon davis wrote:


    > > This works flawlessly for me using Writer, totally replicating the
    > > top line without any alterations.
    > >
    > > If I open a spreadsheet instead and type 09-10 into a cell, it
    > > automatically converts it to 09/10/07.
    > >
    > > To fix this, right-click the cell(s) and select Format Cells from
    > > the menu. In the Numbers tab, choose Text instead of Date, or
    > > select a type of date display you'd like from the choices in the
    > > center window, although the 09-10 format isn't available on that
    > > list and I don't see a way to add it.
    > >
    > > If I right-click the cell and change the format to Text


    > heh, if I do _that_, I get machine-code representation of the dates.
    > don't actually know if it is called that but I get the numbers the
    > code then translates into specific formats, thus


    > 09-10 09-12 09-17


    > becomes


    > 37873 37875 37880


    Yep, sorry, I forgot to mention that. You have to do that to the cells
    before putting the information in. Once they're formatted, they'll
    behave the way you'd like them to.

    > if I paste this representation of the dates into a new spreadsheet and
    > reconvert, I get the yr '2003'! (and the day dates are shifted again
    > also.)


    > I also notice that if I copy A to B, I get the date distortion. if I
    > then copy from B to C, then B == C.


    That's even stranger. You mean your first copy is distorted, but
    another copy from that to yet another spreadsheet is fine?

    > >> but I also notice if I expand the field, the year is way off
    > >> (2003).


    > > Now that is just *odd*. What do you see if you type date into a
    > > terminal window?


    > date is fine.


    > as far as I can see, this phenomenon only affects OO. I wonder if
    > there is some internal time-setting? I cannot find anything under
    > 'Options' like that.


    I don't see anything in the settings that would do that either. Have
    you uninstalled (purged) and reinstalled it?

    --
    Little Girl
    There is no spoon.

    http://littlergirl.googlepages.com/

  7. Re: big bug in OpenOffice (date format)?

    On Sat, 20 Oct 2007 01:31:14 -0400 in
    pan.2007.10.20.05.31.14.121668@union.edu, felmon davis
    wrote:

    > On Fri, 19 Oct 2007 10:43:47 -0500, Stephan Bird wrote:
    >
    >> 9th Oct 2007, 9th Dec 2007, 1st Sep 2017, 1st Sep 2019, 1st Sep 2024 and
    >> 1st Sep 2026 in both initial typed cells and the copies.

    >
    > this behavior seems oddball to me. why does the yr suddenly change? so my
    > OO setup usually defaults 2003 on copy/paste/move.


    Sorry for not getting back sooner, have been having hard drive problems
    and only just about back up to speed wrt backups etc.

    Don't forget, over here in the UK 9/10 means 9th October, not 10th
    September - that's my my take on the first part of the problem, so 9/17
    doesn't formally exist in that format (there is no 17th month). so I
    assume the software thinks I meant September 2017. I still can't replicate
    the change in data from copy to paste though.

    Stephan

+ Reply to Thread