Issue 20460 - Validation isn't working correctly.
Summary: Validation isn't working correctly.
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC5
Hardware: PC Windows 2000
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-09-30 14:49 UTC by deathstalker
Modified: 2003-09-30 15:35 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description deathstalker 2003-09-30 14:49:19 UTC 
For some reason if you utilize a formula to populate a cell on which you have
placed a "Validation" function it will not be triggered by a changes in the
formula. 

Example:

You have cells A, B, and C.  Cell A contains a value of 2, Cell B contains a
value of 3, and Cell C contains a forumla "=Sum(A:B)".  I set up validation on
Cell C such that if the total of "C>10" it will issue a warning.

If I change the value of cell A to 8 the validation should go off and tell me
that something is wrong.  However, it hasn't for me in the several times that I
have attempted it.  (I would note, that if I overwrite the formula with the
value of 11 I do get the warning I requested.)

/Example
Comment 1 frank 2003-09-30 15:34:45 UTC 
Hi Paul,

this is not a bug.

Such cases are better resolved by using conditional formats.

Validity on cells is just for direct input of values into a cell not
for results of a formula / function. I've checked it with other
spreadsheets including Excel and they do it in the same way as OOo.

So closing this one as invalid.

Frank
Comment 2 frank 2003-09-30 15:35:23 UTC 
closed invalid