Issue 90084

Summary:

Value #N/A cannot be entered into a cell

Product:

Calc

Reporter:

chucknewman <chuck.newman>

Component:

editing

Assignee:

spreadsheet <spreadsheet>

Status:

CLOSED DUPLICATE

QA Contact:

issues@sc <issues>

Severity:

Trivial

Priority:

CC:

issues, rb.henschel

Version:

OOo 3.0 Beta

Keywords:

needmoreinfo, oooqa

Target Milestone:

---

Hardware:

Unknown

OS:

Windows XP

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
enter #N/A	none
text of macro to reproce Err:509 for "=#N/A" macro	none

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 
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.

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.