https://bugs.documentfoundation.org/show_bug.cgi?id=158622
Bug ID: 158622
Summary: CSV which contains #N/A, cannot read as #N/A(NaN, Not
a Number)
Product: LibreOffice
Version: 7.6.4.1 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
CSV file which contains #N/A, cannot read as #N/A(NaN, Not a Number).
Steps to Reproduce:
1.Generate spreadsheet which contains #N/A in a cell. "=NA()" works fine.
2.Save the spreadsheet as CSV.
3.Check the CSV file by text editor(Vim, Emacs, ...).
We can look #N/A in the file.
4.Read the CSV file using Calc.
5.Check the cell(containg #N/A) using ISNA() function.
Actual Results:
#N/A interpreted as string, so ISNA() return FALSE.
Expected Results:
#N/A in CSV should interpret as #N/A(NaN, Not A Number).
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.6.4.1 (X86_64) / LibreOffice Community
Build ID: e19e193f88cd6c0525a17fb7a176ed8e6a3e2aa1
CPU threads: 4; OS: Windows 10.0 Build 22631; UI render: Skia/Vulkan; VCL: win
Locale: ja-JP (ja_JP); UI: ja-JP
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
