To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=114360
Issue #|114360
Summary|Absolute reference error
Component|Spreadsheet
Version|OOo 3.2.1
Platform|PC
URL|
OS/Version|Windows 7
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|programming
Assigned to|spreadsheet
Reported by|jpwatney
------- Additional comments from jpwat...@openoffice.org Tue Sep 7 02:21:22
+0000 2010 -------
I have entered the following in data validity/ text length:
2*N(AND ($D$6<>"Away";$D$6<>"?"))
The following does not help
2*N(AND(CELL("contents";$D$6)<>"Away";CELL("contents";$D$6)<>"?"))
When I insert a row the absolute reference does no change to reflect the new
row.
---------------------------------------------------------------------
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
