Ask Your Question

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

asked 2015-08-25 17:03:01 +0200

I'm using LO 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 ....

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2015-08-29 23:30:59 +0200

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 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 :(

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-08-25 17:03:01 +0200

Seen: 26 times

Last updated: Aug 25 '15