Hello,If conformance with Excel is desired, then perhaps it should (work with text)?
I have included an Excel spreadsheet, "ex58589.xls" which, under Excel,returns incremented times of day in the A col when B is a duration value and C is a concatenate formula. Under Open Office calc, (Open Office 2.0) it does not. The times of day remain unchanged.
the real sheet looks something like this (C is not visible)
A B D
4 9:30 5 Meeting Agenda
5 9:35 10 Functional Overview
6 9:45 20 Tech Overview
and the sample sheet I sent you looks like this.
A B C
........
4 9:30 5 CONCATENATE("00:", B3,":00")
5 9:35 (=A4+C4) 10 CONCATENATE("00:", B4,":00")
6 9:46 (=A5+C5) 15 CONCATENATE("00:", B5,":00")
thanks
Steve Wright
[EMAIL PROTECTED] wrote:
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=58589 ------- Additional comments from [EMAIL PROTECTED] Wed Nov 30 04:29:46 -0800 2005 ------- Hi, Calc does not calculate with text, as you've told us, you use the CONCATENATE function to get the result. This function produces text and therefore it seems to me that the calculation you want to do fails. It would be fine if you can attach a document showing the problem.Thanks Frank--------------------------------------------------------------------- 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
-- Stephen Wright Software Architect GL TRADE - New York 261 Madison Ave New York, NY 10016 212 458 0337 www.gltrade.com <<This email communication is confidential and is intended solely for whom it is addressed. Copying, or re-using in any way by anyone else is unauthorised. Any views or opinions expressed are those of the author and do not necessarily represent those of GL TRADE or any of its affiliates. If you have received this mail in error, please destroy the copy in your possession and notify [EMAIL PROTECTED] or [EMAIL PROTECTED] >>
ex58589.xls
Description: Binary data
--------------------------------------------------------------------- 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]
