On 2005-11-30, at 15:54 , Stephen Wright wrote:
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]
us.com or [EMAIL PROTECTED] >>
<ex58589.xls>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Greetings,
You have responded to an automatically generated message from the
Issue Tracker. You cannot respond directly to these messages. Please
log onto the website, go to the issue, and enter your comments in the
Additional Comments box. When you are finished with your edits to the
issue, click the submit button to update the issue report with your
comments. This is how we keep all notes related to issues organized
and available to all in the community.
To see the Additional Comments box on the issue report, you must be
logged in, and your cookies must be enabled. Type in your user name
and password into fields displayed in the upper right corner, then
click the Login button. If you do this from the Home page, you may
have to click Login again on the Login Page. When you are logged in,
it will show that you are Logged In, and there will be a button
displayed in the upper right corner for you to click when you are
ready to log out.
Once you are logged in, you will be presented with a page called My
Start Page under the My Pages tab, and the left menu will show links
to tools. You can jump directly to your issue, by typing a number in
the input box in the right column of My Start Page, or you can select
My Issues from the Tools menu to see a list of your issues with an
open status. You can show a list of *all* your issues by choosing
'Edit Query' and selecting additional choices in the Status field, by
clicking on them with your Control key pressed down, then click on
'Submit Query'.
To send attachments regarding issues, please attach the file directly
to the issue. Use the link "Create a new attachment" on the issue and
then select Binary file (application/octet-stream) where asked, "What
kind of file is this?" if your file's type does not show in the list.
Thanks,
The OpenOffice.org Team
---------------------------------------------------------------------
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]