https://bugs.documentfoundation.org/show_bug.cgi?id=158622
--- Comment #2 from Mike Kaganski <[email protected]> --- 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/02140000.html?DbPAR=CALC ). Also note that indeed, a literal text "#N/A!" in a CSV is not any kind of error - CSV has *no* notion of data type, and it can't store errors at all. Unless you follow comment 1, and store formulas instead of values, this is NOTABUG. File format limitations must be taken into account; one can't similarly expect to store font formatting and images in TXT files. -- You are receiving this mail because: You are the assignee for the bug.
