Michael Jester wrote:
I am using version 2.0 of open office. In the calc application, I
notice the following problem.
If I type in the following text into a cell:
=SUMD8:D10)
I see a pop-up window correctly telling me that the formula is wrong
(the problem here is that the open parentesis is missing). However, the
correction that the pop-up suggests, is something like =SUMD8:D10.
The end result is, whether I hit yes or no on the pop-up window, the
value of the cell will still show an error (#NAME? is displayed in the
cell).
I would expect the pop-up window to:
a) show SUM(D8:D10) as the proposed change (with both sets of
parenthesis) and
b) correctly reflect a real (non-error) value (something other than
#NAME?) if I select YES to accept the proposed change.
--Michael
P.S. FYI, overall I've had very few problems with this software. I'm
glad I'll never have to pay for excel again :-)
Michael:
Please file a bug report on the web site by creating an account, logging
in and then submitting an issue. That is the best way to get this fixed.
I agree, it should suggest the proper fix as you mentioned.
Crystle
--
Crystle Numan
Administrative Secretary, Immanuel CRC
61 Mohawk Rd. W. Hamilton ON L9C 1V9
905-385-0662
[EMAIL PROTECTED]
http://immanuelministries.ca
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
