To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=75876
Issue #|75876
Summary|New Conditional Formatting
Component|Spreadsheet
Version|OOo 2.2
Platform|PC
URL|
OS/Version|Windows XP
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|FEATURE
Priority|P3
Subcomponent|editing
Assigned to|spreadsheet
Reported by|patwwh
------- Additional comments from [EMAIL PROTECTED] Thu Mar 29 18:06:36 +0000
2007 -------
Normal conditional formatting just change the color & effect.
To make a revolution, conditional formatting should also be able to change
"value" VIRTUALLY"
i.e. There will be 2 layer of values, real inputted value and virtual output
value.
e.g. I can set a formula for conditional formatting like:
If C1<10, then show C1=10
Notice that it is "show", but not change!
Surely, after introduce 2 layer of data, we need 3 layer of tools to handle
them.
e.g.
a) A2's actual value is 8
b) Conditional Formula is:
If A2<10, then show A2=10
3 Equal Tools
"A1=A2" A1=Actual value of A2 checked by its conditional formula.
"If A2<10 then show A2=10" =10
"A1==A2" A1=Actual Value of A2=8
c) If Conditional Formula is changed to
If A2<5, then show A2=10
"A1===A2" A1= Virtual value of A2 only = Null, since A2>5 is not defined in
that conditional formula.
---------------------------------------------------------------------
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]
