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

Reply via email to