You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2016/09/20 14:22:31 UTC
[Bug 60157] New: NULL handling when modifying Excel.
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: sakolusu@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-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 60157] NULL handling when modifying Excel.
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60157
Nick Burch <ap...@gagravarr.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
--- Comment #2 from Nick Burch <ap...@gagravarr.org> ---
Without any code, it's hard to see what is going wrong, and impossible to tell
if it's a bug in your code or in Apache POI
Can you write a small self-contained junit test case that shows your problem?
And ideally also upgrade to the most recent version of Apache POI too?
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 60157] NULL handling when modifying Excel.
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60157
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |RESOLVED
Resolution|--- |REMIND
--- Comment #4 from Dominik Stadler <do...@gmx.at> ---
No update for some time and too less information to actually work on this,
therefore I am closing this as REMIND for now, please reopen this bug with more
information if this is still an issue for you.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 60157] NULL handling when modifying Excel.
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60157
Sateesh <sa...@in.ibm.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |sakolusu@in.ibm.com
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 60157] NULL handling when modifying Excel.
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60157
Sateesh <sa...@in.ibm.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
OS| |All
--- Comment #1 from Sateesh <sa...@in.ibm.com> ---
Version 3.9
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 60157] NULL handling when modifying Excel.
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60157
--- Comment #3 from Sateesh <sa...@in.ibm.com> ---
Thanks. I will try to do that and let you know
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org