Bug 59433

Summary: Account special format not processed when value is 0 (zero)
Product: POI Reporter: GuoHui Chen <cgh_chen>
Component: XSSFAssignee: POI Developers List <dev>
Status: NEEDINFO ---    
Severity: normal    
Priority: P2    
Version: 3.14-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: All   

Description GuoHui Chen 2016-05-06 07:15:59 UTC
<c r="D7" s="25">
				<f>SUBTOTAL(9,D8:D14)</f>
				<v>0</v>
			</c>

<xf numFmtId="43" fontId="5" fillId="2" borderId="2" xfId="1" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1">
			<alignment vertical="center"/>
		</xf>

<numFmt numFmtId="43" formatCode="_ * #,##0.00_ ;_ * \-#,##0.00_ ;_ * &quot;-&quot;??_ ;_ @_ "/>

java:
sval = formatter.formatCellValue(cell, eval);
// sval = - 0  ver 3.14
// sval = 0.0  ver 3.13
Comment 1 GuoHui Chen 2016-05-06 07:23:08 UTC
correct value should be:
 sval = - (Excel show)
Comment 2 Dominik Stadler 2016-05-17 09:07:29 UTC
Can you provide a more self-contained code for reproducing this. Or the Excel-file if you are working off of one built in another application. 

With only the pieces you provided it is quite hard to reproduce the problem.