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

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

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

Bugzilla from bugzilla@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: [hidden email]
          Reporter: [hidden email]
  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: [hidden email]
For additional commands, e-mail: [hidden email]