Le 01.04.2010 12:48, Harold Fuchs a écrit : > OOo 3.1.1 on Win XP Pro. > > I have a column of dates in a text (.txt) file and want to copy them into a > column of a Calc sheet. I can't because Calc insists on changing the values. > > The first few lines of the .txt file look like this: > Fri Apr 30 > Fri Apr 30 > Sat May 1 > Sat May 1 > Sun May 2 > Sun May 2 > Mon May 3 > > All the dates are *this* year. > > If I simply copy/paste those values into Calc I get > 01/04/30 > 01/04/30 > 01/05/01 > 01/05/01 > 01/05/02 > 01/05/02 > 01/05/03 > > If I format the column "DDD MM DD" which should show e.g. Mon 18 May, then I > get > Tue Apr 01 > Tue Apr 01 > Tue May 01 > Tue May 01 > Wed May 01 > Wed May 01 > Thu May 01 > > Right format but wrong values. > > Note that in each case, the first date shows on the Input line as > 01/04/1930, the last as 01/05/2003. The "dd/mm" style is right from me > because I use European format as opposed to the US style "mm/dd". > > Help. Please. > > > Hi,
I tried to import your data in OOo 3.2.0 FR under Ubuntu 8.04 and it works without problem. Steps to reproduce : - copy & paste your data from your to a text file (for others only, you, you already have this text file) - select all in the text file and copy using ctrl+C - open a new speadsheet - clic on A1 and past using ctrl+V => the dialog to import csv data opens with one column - select column type "english US" and click Ok button - you get serial numbers => format the cells as Dates as you want. If I choose "NNNNJ MMMM AAAA" format, I get (in French) : vendredi 30 avril 2010 vendredi 30 avril 2010 samedi 1 mai 2010 samedi 1 mai 2010 dimanche 2 mai 2010 dimanche 2 mai 2010 lundi 3 mai 2010 Regards. JBF -- Jean-Baptiste Faure French N-L project Lead http://fr.openoffice.org Seuls des formats ouverts peuvent assurer la pérennité de vos documents. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
