https://bz.apache.org/bugzilla/show_bug.cgi?id=60157
Bug ID: 60157
Summary: NULL handling when modifying Excel.
Product: POI
Version: unspecified
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: [email protected]
Reporter: [email protected]
Created attachment 34280
--> https://bz.apache.org/bugzilla/attachment.cgi?id=34280&action=edit
testcase_excel_files
During modifying an existing excel file - If an excel file gets a NULL value as
input the original field value of the excel file is retained. If it gets a
non-NULL value the old value is replaced with this non-NULL value.
Original excel file: test.xlsx
Output excel file: test.out.xslx
The following values are sent as input to modify "test.xslx"
A2:1000 B2:2000
A3:NULL B3:2001
NULL here means no value.
Now in test.out.xlsx - though cell A3 has input of NULL value, the original
value '2' is retained. Instead it should be blank. I see the following output
in "test.out.xlsx"
A2:1000 B2:2000
A3:2 B3:2001
instead it should be
A2:1000 B2:2000
A3:NULL B3:2001
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
