Andy Pepperdine wrote:
I'm just a user, and I've never used time and date functions in a spreadsheet,
but I do know how difficult it is to specify what the results are for time
and date functions, especially when mixed. Perhaps it's time to copy in the
developers list on this one if you think it might help.
If internally the data is held as a UTC time to the second, then it will
depend on how the conversions are defined when using them as operands to
functions, which are subsequently converted back to a format, that could be a
date. But I've no idea whether that is relevant.
All spreadsheets I know (old Lotus1-2-3, Excel, Calc, Gnumeric) have no
"date-values" at all. A cell has a string, floating point number or
error. A number can be formatted as date. Then it counts the days since
a specified null-date (1899-12-30 in this case).
As an example 2.75 -formatted as 'D MMM YYYY HH:MM'- is displayed as '1
Jan 1900 18:00' (Day 2 since null-date + 3/4 of a day). Knowing this,
calculating date/times is very easy unless you apply formats too early.
2.5 -formatted as 'D MMM YYYY' shows 1 Jan 1900, omitting the fractional
part of the real numeric value.
On creation time I set date/times' number formats to '0,00000000' until
everything works as expected.
As I wrote before, I can't reproduce the one-day-off issue with official
build of OOo2.0.2 on pretty old SuSE 9.1. But I prefer a most simple
setup without "integrated desktop environments" nor "specially enhanced
OOo-builds" from the distributors. <rant=OFF_TOPIC>All this KDE/Gnome
crap makes Linux as complicated as Windows, but without using a central
registry. This does not work for me. I can't even use my most basic
preferences with another distribution.</rant>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
