| View previous topic :: View next topic |
| Author |
Message |
stewartc
Newbie
Joined: 13 May 2008
Posts: 1
|
 Posted: Tue May 13, 2008 11:42 pm Post subject: Anyway to preserve date fromat when importing from CSV? |
 |
|
Hi All,
I'm trying to manipulate a CSV file by importing it into OOCalc. A real pain in the butt is that it converts my ISO8601 dates into 14/05/08 type formats. Not a show stopper by any means but annoying never the less.
Anyone know how I can import 'as-is' without having my dates reformated.
Regards
Stew
_________________
--
ooo 2.4.0
Ubuntu 8.04 |
|
| Back to top |
|
 |
jrkrideau
Super User
Joined: 08 Aug 2005
Posts: 6733
Location: Kingston ON Canada
|
| Posted: Wed May 14, 2008 6:13 am Post subject: Re: Anyway to preserve date fromat when importing from CSV? |
|
|
| stewartc wrote: | Hi All,
I'm trying to manipulate a CSV file by importing it into OOCalc. A real pain in the butt is that it converts my ISO8601 dates into 14/05/08 type formats. Not a show stopper by any means but annoying never the less.
Anyone know how I can import 'as-is' without having my dates reformated.
Regards
Stew |
I don't see any obvious way at the moment. If you're importing a lot of data rather than material with dates scattered arouind why not just set up a template with an ISO date style that you can apply once the data is imported. Annoying but fairly fast if you have complete columns or rows of dates.
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2 |
|
| Back to top |
|
|
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Wed May 14, 2008 9:06 am Post subject: |
|
|
In the import wizard right-click the date column and choose "Date(YMD)".
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
|
