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

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

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.

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

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/

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