Jack D. Lewis wrote:
Bruce Reed wrote the following on 5/9/2008 1:47 PM:
JOE Conner wrote:
I confirm what he is reporting. My installed EXCEL viewer does show
115 so Excel seems to be happy with the =DAYS(C4;B4) function. When
opened back by Calc, the D4 reads #MACRO? but the input line still
shows =DAYS(B4;C4), which is correct, so I think Walter has
uncovered a bug. If I place the cursor in the input line, make no
changes, and press enter, the cell D4 now reads 115. I am attaching
a test spreadsheet, "TAGE.XLS" which probably won't make it through
the mail list stripper process.
Using Excel 2003 - I got a #NAME? error on the macro. and 115 as the
answer doing +B5-C5
Excel 2007 shows same results as Bruce's. The closest formula that I
can find to match in Excel is Days360.
DAYS360(start_date,end_date,method) where method is a logical value
that specifies whether to use the U.S. or European method in the
calculation.
M$oft upgrade lock-in at work I suppose. However, the real issue is not
M$oft Excell here. As I see it the issue is that I made no changes to
the OOo saved .XLS file, and Calc opens it with the problem When opened
back by Calc, the D4 reads #MACRO? but the input line still shows
=DAYS(B4;C4), which is what it is supposed to contain. Why is it
necessary to perform ENTER on the input line for the equasion to behave?
Joe Conner, Poulsbo, WA USA (WinXP Pro and Oxygen Office 2.4.0)
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
