To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=39749
User masato12610 changed the following:
What |Old value |New value
================================================================================
Status|CLOSED |UNCONFIRMED
--------------------------------------------------------------------------------
Resolution|WONTFIX |
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Mon Jan 17 05:12:47 -0800
2005 -------
It is designer privledge on whether to fix or not. However, IMHO, not fixing
is not the correct decision. My understanding of "Validation..." in Excel
or "Data Validity..." in Calc is to catch user *input* errors. If a user is
not allowed to type in a formula in a cell that has "Data Validity..."
specification, how is the user allowed to enter a rational number with an
infinite repeating sequence, such as 1/3. In decimal representation 1/3 =
0.33333.... with the 3 repeating an infinite number of times. The best the
user can do under this situation is enter a finite number of "3"s in the cell
(B2, for example) such as 0.3333333333, however, then then the formula "=3*B2"
will result in 0.9999999999 instead of the mathematically correct answer of
1.0. While this may be a trivial issue, if Calc is to be used for more
sophisticated numerical analysis purposes, I believe this issue needs to be
addressed.
In regards to whether this is a bug in Excel or not, I don't know. In
Excel/XP if I try the example of B4=SUM(b5:b7) with B5=0.1, B6=0.2 and B7=1.0,
and B4 is allowed to only have values in the range (0,1), I get an error
message when I type in the formula =SUM(B5:B7) in the cell B4. If B7 is
initally 0.1, then I can successfully enter the formula and display the value
0.4. Subsequently if I enter into B7 1.0, I do not get a warning as you
indicated but at this time I believe this is another issue. It is not an
issue of validating user input into a cell but a potential logic error in the
worksheet structure.
Just to close this comment...if I cannot enter a formula, such as "=1/3" into
a cell with "Data Validity..." turned on, how do I enter rational number with
a repeating sequence?
---------------------------------------------------------------------
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]
