On 07/13/2009 10:20 PM, Tamblyne wrote: > On Tue, 14 Jul 2009 00:13:43 -0500, Tamblyne <[email protected]> > wrote: > >>I've taken a break from trying to do these cemetery transcriptions in >>a spreadsheet. The date formatting tricks worked great, but it was >>too clunky otherwise. So I switched to a Writer using a table. There >>was a bit of tweaking there, too, but it looks a lot better. >> >>So I have my table cells for the dates formatted "D MMM YYYY." All >>night long, I've been typing 10/11/1901 and it reformats to 11 Oct >>1901 -- just as I expect it to. If I type in only a year, it accepts >>that just fine, but then the next row that has a full date in it, I >>have to "re-set" the date formatting back to "D MMM YYYY" and it's >>fine, again, until the next time I have only a year. No problem. It's >>working fine, doing what I expect. >> >>Then, all of a sudden, I type "10/11/1901" and I start getting "10 Nov >>1901" instead of "11 Oct 1901." I check my date formatting, and it's >>still the way it's supposed to be -- but I reset it anyway. No good. >>*Now* I'm getting "10/11/01" when I type "10/11/1901" -- even though >>the date format is still showing as "D MMM YYYY" :-/ If I type "10 >>Oct 1901" it's switching it to "10/10/01" ARGH! >> >>I have no idea what I'm doing to trigger these surprises and >>inconsistancies (v.3.1.0). I'm doing the same thing all the time, but >>never know when different results are going to show up. I'm recalling >>now that this is why I didn't use OOo to do these transcripts way back >>with v.2 -- so it's not a new problem with v.3. I've had to shut down >>and restart v.3 a lot for some reason, but that doesn't seem to help >>this particular problem. >> >>I tried one more thing before sending this -- I deleted my >>user-defined format code and entered it again -- and now it's working >>again. Does anyone have any idea what I did to make it stop working >>in the first place? >> >>Tam > > Well, that didn't last long -- two more rows and it's reversing the > month and the day again.
Would you mind sending me both the calc and writer documents so that I can look at them? I'll be happy to try to assist off-list & then report back here what we've found. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
