Apache OpenOffice (AOO) Bugzilla – Issue 90084
Value #N/A cannot be entered into a cell
Last modified: 2008-07-14 13:27:03 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"
Hi chucknewman , My build is Dev_DEV300_m21_winXP and I can enter the "#N/A" into either cell.
Created attachment 54968 [details] enter #N/A
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 OpenOffice.org 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.
Created attachment 54980 [details] text of macro to reproce Err:509 for "=#N/A" macro
#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.
. *** This issue has been marked as a duplicate of 50829 ***
Closing dup.