Dotan Cohen wrote:
I've opened some spreadsheets today that I haven't open in quite a
while. I see that a lot of my data has been replaced with the date
30-12-1899. This is in cells where <something> was before, and I don't
remember what. This seems to be some sort of data corruption. Is
anybody familiar with it? Is it recoverable? I'm certain that I have
backups somewhere, but I'd like to understand the root of this
condition.
The date 30-12-1899 is one of the epoch dates in OOo represented
internally by a floating point value of 0.0 (zero).
[All dates/times are floating point values internally, where the integer
part is the number of days since the epoch, and the fraction part is the
time given as a fraction of 24 hours. You can also choose different
epoch dates, e.g. this one or 01-01-1900 etc.]
So you just need to work out if 0.0, or 0, is a reasonable value for
these cells, and why they have a date format (if they were originally
something else). E.g. Do they contain formulae? If so, do they reference
blank cells or text cells (possibly even text cells that look like
dates), because these cells will probably have a value of 0 (zero)?
Ross
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
