Possible Bug or issue

[JZA <ac...@gmail.com>]

So a user working with CSV face the dificulty that it seems that AOO by
default manage dates with a 2 digit year format. This causes havok on his
data. Having a regular field with 2/20/2015 changed to 2/20/15.

The issue is that by default (might be the locale) AOO assigns a 2-digit
year format, and not even the tempalte can be change to address that.

I think shortcutting information is never a good idea, the opposite wouldnt
be a problem and wonder if this can be patched somehow by editing the
source defaults for the US locale (and others).

To reproduce:
1 . Create a date column with xx/yy/xxxx
​2.  Save it as CSV
3. Open it in Calc
4. Check 'Detect special numbers' (if you dont do this, the dates are
displayed as a string text)
5. See the format of the date change from xx/yy/xxxx to xx/yy/xx​

-- 
Alexandro Colorado
Apache OpenOffice Contributor
9060 55AB FFD2 2F02 0E1A  3409 599C 14FC 9450 D3CF

Re: Possible Bug or issue

[Marcus <ma...@wtnet.de>]

Am 10/12/2015 11:23 PM, schrieb JZA:
> So a user working with CSV face the dificulty that it seems that AOO by
> default manage dates with a 2 digit year format. This causes havok on his
> data. Having a regular field with 2/20/2015 changed to 2/20/15.
>
> The issue is that by default (might be the locale) AOO assigns a 2-digit
> year format, and not even the tempalte can be change to address that.
>
> I think shortcutting information is never a good idea, the opposite wouldnt
> be a problem and wonder if this can be patched somehow by editing the
> source defaults for the US locale (and others).
>
> To reproduce:
> 1 . Create a date column with xx/yy/xxxx
> ​2.  Save it as CSV
> 3. Open it in Calc
> 4. Check 'Detect special numbers' (if you dont do this, the dates are
> displayed as a string text)
> 5. See the format of the date change from xx/yy/xxxx to xx/yy/xx​
>

this is what I've done:

- created an own CSV file with the following content:

'12/10/2015'

- opened the CSV file

- right click on the column with the date (in the preview area) and 
choose a date format you want

- right click on the cell with the date value, choose "Format Cells" tab 
"Numbers" and choose a date format with a 4-digit-year

That's it.

Please remember that the date and time values are (normally) not the 
ones that are shown. Calc calculates internally with integer values. 
Just for us humans a more appropriate number format can be chosen - 
either with 2 or 4 digits as year or whatever the user prefers.

I don't see a problem or bug here.

Marcus

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
For additional commands, e-mail: dev-help@openoffice.apache.org