[Bug 62057] New: isDisplayZeros does not apply when get value

[bu...@apache.org]

https://bz.apache.org/bugzilla/show_bug.cgi?id=62057

            Bug ID: 62057
           Summary: isDisplayZeros does not apply when get value
           Product: POI
           Version: 3.16-FINAL
          Hardware: PC
                OS: Mac OS X 10.1
            Status: NEW
          Severity: normal
          Priority: P2
         Component: SS Common
          Assignee: dev@poi.apache.org
          Reporter: shamsul.saleh@gmail.com
  Target Milestone: ---

Created attachment 35705
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=35705&action=edit
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.

-- 
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