To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=116456
Issue #|116456
Summary|ConditionalFormat refer defect when draging cells
Component|Spreadsheet
Version|OOO320m18
Platform|HP
URL|
OS/Version|Windows 7
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|editing
Assigned to|spreadsheet
Reported by|verhallen
--- Additional comments from verhal...@openoffice.org Fri Jan 14 00:34:25
+ 2011 ---
Hello
open new spreadsheet
put in cell A1 a value, [100]
press CTRL F3
make a name for cell A1, [ape]
select an other cell (B1)
go to conditional format dialogue box true menu format? (in Dutch it is menu
opmaak)
first list-box select formula
second box (condition box) write [ape = 100]
ad new format that makes the background red, and give this format a name [red]
choose this name in the list box
When you change the value of cell A1 from 100 to something else and back again
cell B1 will turn on and of with the colour red. This is good and big fun.
When you move cell A1 with CTRL x and CTRL V everything looks al right but will
not work until you make a little change in the conditional format dialogue box.
for instance get rid of a space [ape= 100] . now it will work again. If you use
a other way to move cell A1 you get the same bad result.
This is my first input in OOo I hope it is clear
regards Verhallen
-
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: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org
-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org