To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=104583
User cloph changed the following:
What |Old value |New value
================================================================================
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Keywords| |oooqa
--------------------------------------------------------------------------------
Resolution| |WONTFIX
--------------------------------------------------------------------------------
Summary|Date/time subtraction resu|Date/time subtraction resu
|lts wrong |lts wrong
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Wed Mar 10 01:15:43 +0000
2010 -------
wontfix/invalid
This is not how you're supposed to calculate elapsed time in a spreadsheet
application. Dates are represented as fractin of days since a special
start-date.
The major difference is that date "0" is the non-existing "January 0 1900"
wheras in OOo date "0" is 30.12.1899 - that is why you get a day-count of 0 for
your difference, the value of 0.5 (the difference between the first two date
values) is the non-existing "January *0* 1900 *12:00*" in Excel.
In OOo, 0,5 corresponds to "December *30* 1899 *12:00*"
OOo will not introduce all of Excels date-related bugs and quirks, and will not
change the funamentals of calculating with dates, so there's no chance for your
sample to work like in OOo ever.
Use proper date&time related functions to compute differences between two dates.
See also issue 53409
Also see the TEXT function, the CONCATENATE function (or the "&" equivalent),
the DAYS function and INT/TRUNC for various function on how to assemble a string
that represents the desired result. (For assistance on this, please use the
[email protected] mailing lists, the forums, or IRC,...
http://support.openoffice.org/
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
