Bug 62057 - isDisplayZeros does not apply when get value
Summary: isDisplayZeros does not apply when get value
Status: NEW
Alias: None
Product: POI
Classification: Unclassified
Component: SS Common (show other bugs)
Version: 3.16-FINAL
Hardware: PC Mac OS X 10.1
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2018-01-30 04:40 UTC by shamsulsaleh
Modified: 2018-01-30 04:40 UTC (History)
0 users

javaFile and sample excel doc (14.23 KB, application/zip)
2018-01-30 04:40 UTC, shamsulsaleh

Note You need to log in before you can comment on or make changes to this bug.
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.