Tuesday, April 18, 2006, 6:05:52 PM, Barrie Backhurst wrote:
BB> On Wed, 2006-04-19 at 00:21 +1000, Ross Johnson wrote: >> On Mon, 2006-04-17 at 15:10 -0400, Charles Sardeson wrote: >> > I have an OOo Calc spreadsheet of ~60K rows in which there are at least >> > a couple of dates in the MM/DD/YY format. I am able to convert them in >> > the spreadsheet to YYYY-MM-DD, which is what I want to save into a CSV [snip] >> I believe that Calc's CSV export filter formats dates according to your >> locale setting (hence the US locale MM/DD/YYYY format), and this can't >> be changed, except by changing locale. But I don't know of any locale >> that would give you YYYY-MM-DD in CSV. >> BB> MySQL's country of origin is Sweden and.setting this as language in cell BB> styles works. BB> Open the stylist(F11), right click the default cell style and select BB> New. It should open a dialog with the Organize tab visible. Enter a BB> suitable name(mysqldate) in place of "untitled". Switch to the Number BB> tab and set Category = Date, Language = Swedish and Format = YYYY-MM-DD. BB> Click OK to save the new cell style. BB> Now select the cells with the dates that need formatting and double left BB> click on the new mysqldate cell style. The selected cells should adopt BB> the mysql format and retain it when exported to CSV. BB> Barrie Thank you ever so much! I got lost somewhere in the left-clicking, but managed to apply enough of your advice to solve my problem. Thanks also to the others who responded. I made the mistake of getting answers before I subscribed, and couldn't figure out how to acknowledge them from the archive viewer on the web site. I'll be looking forward, nonetheless, to the day when the "do what I told you" check box is available; I couldn't find any hints in the "announce" list. Thanks again, Chuck Sardeson --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
