Link Import Broken
Sugar <[email protected]> Fri, 23 Dec 2011 09:38:02 -0800
| Newsgroups | gmane.comp.openoffice.questions |
|---|---|
| Message-ID | <[email protected]> |
I just upgraded to OO 3.3.0 and when opening a spreadsheet that contains a link to a CSV file, the old version would correctly parse datetimes and dollar fields to the correct types. In this new version it's parsing everything to strings, making my spreadsheet useless, as I do a lot of calculations and crosstabs based on the data. The top of the CSV looks like this Date,Payment From,Payment to,Description,Amount 10/27/2011 1:08:03 AM,Eureka,Resident,Rental started,$1.00 In the old version, the dates in column A and the dollars in column E would come in as a date and as a number. -- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help