To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=93277 Issue #|93277 Summary|wrong automatically calculated sum of marked cells for | times > 24h in status bar Component|Spreadsheet Version|1.0.0 Platform|Unknown URL| OS/Version|Windows Vista Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P2 Subcomponent|code Assigned to|spreadsheet Reported by|matthiasthullner
------- Additional comments from [EMAIL PROTECTED] Sat Aug 30 09:36:57 +0000 2008 ------- if several cells are marked in calc, the status bar shows a sum of the data if possible. this also works for times with the format hh:mm:ss The format of the sum in the status bar is also hh:mm:ss, but it seems like it also is aware of days, i.e. there is an overflow after 24 hours. example: A B C 1 Effort 1 [h] 08:12:01 2 Effort 2 [h] 20:15:08 3 all efforts 28:27:09 '<- =SUM(B2:B3) the status bar shows Sum=04:27:09 so the sum is 28hours 27minutes and 9 seconds but the sum in the status bar shows 4hours 27minutes and 9seconds what looks like it is calculating 1day 4hours 27minutes and 9seconds but is not showind the days (maybe wrong outputformat???) I think this is cruicial, cos not everybody will calc sll sums in a new cell, but might use the feature of automatic generated sums in the status bar! My system: OpenOffice 2.4.1 Vista SP1 --------------------------------------------------------------------- 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]