Issue 90084 - Value #N/A cannot be entered into a cell
Summary: Value #N/A cannot be entered into a cell
Status: CLOSED DUPLICATE of issue 50829
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.0 Beta
Hardware: Unknown Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Keywords: needmoreinfo, oooqa
Depends on:
Reported: 2008-05-28 21:45 UTC by chucknewman
Modified: 2008-07-14 13:27 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

enter #N/A (6.97 KB, text/plain)
2008-07-07 04:01 UTC, jm38706415
no flags Details
text of macro to reproce Err:509 for "=#N/A" macro (2.64 KB, text/plain)
2008-07-07 15:07 UTC, chucknewman
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description chucknewman 2008-05-28 21:45:51 UTC
The "Value not Available" value #N/A cannot be directly entered into a cell,
e.g., by typing "=#N/A" -- attempting to do so results in Err 509.

N.B., a cell can have the NA() function which will display "#N/A"
Comment 1 jm38706415 2008-07-07 03:59:03 UTC
Hi chucknewman ,

My build is Dev_DEV300_m21_winXP and I can enter the "#N/A" into either cell. 
Comment 2 jm38706415 2008-07-07 04:01:22 UTC
Created attachment 54968 [details]
enter #N/A
Comment 3 chucknewman 2008-07-07 15:05:19 UTC
To be clear, I am entering "=#N/A" into the cell and not just "#N/A"

I determined my build level to be "300m2(Build9301)" by selecting Help -> About and then pressing CTRL/S CTRL/D CTRL/T

How did you determine the build of Dev_DEV300_m21_winXP?

I will include the contents of a macro that reproduces what I see (on my build, 
at least) -- I end up with "Err: 509" displaying in cell B2.
Comment 4 chucknewman 2008-07-07 15:07:14 UTC
Created attachment 54980 [details]
text of macro to reproce Err:509 for "=#N/A" macro
Comment 5 Regina Henschel 2008-07-07 18:36:33 UTC
#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.

Comment 6 ooo 2008-07-14 13:26:18 UTC

*** This issue has been marked as a duplicate of 50829 ***
Comment 7 ooo 2008-07-14 13:27:03 UTC
Closing dup.