Created attachment 34280 [details] 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
Version 3.9
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?
Thanks. I will try to do that and let you know
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.