Bug 62057

Summary: isDisplayZeros does not apply when get value
Product: POI Reporter: shamsulsaleh <shamsul.saleh>
Component: SS CommonAssignee: POI Developers List <dev>
Status: NEW ---    
Severity: normal    
Priority: P2    
Version: 3.16-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: Mac OS X 10.1   
Attachments: javaFile and sample excel doc

Description shamsulsaleh 2018-01-30 04:40:31 UTC 
Created attachment 35705 [details]
javaFile and sample excel doc

The excel sheet setting is set DisplayZero = False (Unchecked). When i try to retrieve the value, i still received the zero (0) instead of blank.

according this docs, https://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/Sheet.html#isDisplayZeros--

"When false, cells with zero value appear blank instead of showing the number zero"

I attached the java code and the excel sheet.

Please advice.