To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90084
User regina changed the following: What |Old value |New value ================================================================================ CC|'' |'regina' -------------------------------------------------------------------------------- Keywords| |needmoreinfo, oooqa -------------------------------------------------------------------------------- ------- Additional comments from [EMAIL PROTECTED] Mon Jul 7 17:36:33 +0000 2008 ------- #N/A is the result of a calculation, therefore you must use a calculation which has this result, to see it in the cell. The function to force it, is NA(). If you want to know, whether a cell contains the value #N/A, you cannot compare it with a string, but must use one of the ISxxx functions. Of cause you can use a string "#N/A", if you mark it as string or format the cell to text before entering the string. I don't understand you error description. Please write exactly, what do you do, what do you expect as result, and what do you really get as result of your doing. --------------------------------------------------------------------- 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]