Calc amends dates I've entered, every time I save, close and re-open the file

[sarahfish]

I’m using LO 4.2.2.1 on Win XP SP3. I’ve created a spreadsheet to keep track of transactions that occur periodically, but not regularly, so it’s important to me to know the date of each transaction. I enter the dates in a ‘date’ column; each transaction is on a separate row. Simple, I thought. Then I started to notice, after a few times of using the file, the dates looked a bit odd. Did a little test by putting in a dummy date, saved and closed the file, opened again, and not only the dummy date but also all the previous dates have been altered to a date two days earlier than the one I entered.

If I close the file without saving any alterations, the dates are unchanged when I open it again.

I’ve looked to see if there is a formula operating that I hadn’t noticed but can’t see anything like that. Please can anyone help me sort this? (Maybe I should be using the latest version of LO ?! - but I don’t recall ever having this problem before.) Thanks …

[sarahfish]

I see that I am not the only person to have had this problem. There is a thread on an Open Office forum (2012) that is helpful, at [Solved] Calc changing my dates (View topic) • Apache OpenOffice Community Forum I don’t understand all the advice there, but two significant points seem to be (1) this problem can arise if the user profile gets corrupted, e.g. by the computer crashing (mine has crashed a few times lately), and (2) because it arises in several different circumstances, it may be a problem in the source code and needs to be reported as a bug. So I will try that, and meanwhile will re-enter my corrupted dates as text from the paper info, assuming I still have it. Frustrating