Bug ID: 60157
           Summary: NULL handling when modifying Excel.
           Product: POI
           Version: unspecified
          Hardware: PC
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF

Created attachment 34280

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:
For additional commands, e-mail:

Reply via email to