https://bugs.documentfoundation.org/show_bug.cgi?id=158622
--- Comment #7 from QA Administrators ---
Dear polyester,
This bug has been in NEEDINFO status with no change for at least
6 months. Please provide the requested information as soon as
possible and mark the bug as UNCONFIRMED. Due to
https://bugs.documentfoundation.org/show_bug.cgi?id=158622
--- Comment #6 from Mike Kaganski ---
(In reply to polyester from comment #3)
MS Excel is not an authority in CSV (if it was XLSX, this argument would be
sound).
--
You are receiving this mail because:
You are the assignee for the
https://bugs.documentfoundation.org/show_bug.cgi?id=158622
--- Comment #5 from ady ---
@polyester,
You don't seem to answer the prior comments / questions. Am I missing
something?
--
You are receiving this mail because:
You are the assignee for the bug.
https://bugs.documentfoundation.org/show_bug.cgi?id=158622
--- Comment #4 from polyester ---
Sorry(typo) :
- =NA(),=na(),=Na(),=nA(),#N/A,#n/a,#N/a,#n/a
+ =NA(),=na(),=Na(),=nA(),#N/A,#n/a,#N/a,#n/A
--
You are receiving this mail because:
You are the assignee for the bug.
https://bugs.documentfoundation.org/show_bug.cgi?id=158622
--- Comment #3 from polyester ---
And... Microsoft Excel can reproduce #N/A from CSV in these forms(case
insensitive):
=NA(),=na(),=Na(),=nA(),#N/A,#n/a,#N/a,#n/a
So, for compatibility, it's better to interpret #N/A in CSV as #N/A(not
https://bugs.documentfoundation.org/show_bug.cgi?id=158622
--- Comment #2 from Mike Kaganski ---
Note that #N/A! (e.g., returned by NA()) is *not* "NaN" ("not a number"), but
"not available" (see
https://help.libreoffice.org/latest/en-US/text/scalc/05/0214.html?DbPAR=CALC
).
Also note that
https://bugs.documentfoundation.org/show_bug.cgi?id=158622
ady changed:
What|Removed |Added
Ever confirmed|0 |1
Status|UNCONFIRMED