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: dev@poi.apache.org Reporter: sakol...@in.ibm.com 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: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org