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 [email protected] Fri Jan 14 00:34:25 +0000 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: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
